l2j-server-datapack/datapack_development/sql/random_spawn.sql

-- ---------------------------
-- Table structure for random_spawn
-- ---------------------------
DROP TABLE IF EXISTS random_spawn;
CREATE TABLE random_spawn (
  groupId INT NOT NULL default 0,
  npcId INT NOT NULL default 0,
  count INT NOT NULL default 0,
  initialDelay BIGINT NOT NULL default -1,
  respawnDelay BIGINT NOT NULL default -1,
  despawnDelay BIGINT NOT NULL default -1,
  broadcastSpawn VARCHAR(5) NOT NULL default 'false',
  randomSpawn VARCHAR(5) NOT NULL default 'true',
  PRIMARY KEY  (groupId)
);

INSERT INTO `random_spawn` VALUES 
(1,30556,1,-1,1800000,1800000,'false','true'),
(2,31092,1,-1,60,0,'false','false'),
(3,31092,1,-1,60,0,'false','false'),
(4,31092,1,-1,60,0,'false','false'),
(5,31092,1,-1,60,0,'false','false'),
(6,31092,1,-1,60,0,'false','false'),
(7,31092,1,-1,60,0,'false','false'),
(8,31092,1,-1,60,0,'false','false'),
(9,31111,1,-1,60,0,'false','false'),
(10,31112,1,-1,60,0,'false','false'),
(11,31113,1,-1,-1,-1,'true','true'),
(12,31126,1,-1,-1,-1,'true','true'),
(13,31094,1,-1,60,0,'false','false'),
(14,31094,1,-1,60,0,'false','false'),
(15,31094,1,-1,60,0,'false','false'),
(16,31094,1,-1,60,0,'false','false'),
(17,31094,1,-1,60,0,'false','false'),
(18,31094,1,-1,60,0,'false','false'),
(19,31094,1,-1,60,0,'false','false'),
(20,31094,1,-1,60,0,'false','false'),
(21,31094,1,-1,60,0,'false','false'),
(22,31094,1,-1,60,0,'false','false'),
(23,31094,1,-1,60,0,'false','false'),
(24,31094,1,-1,60,0,'false','false'),
(25,31094,1,-1,60,0,'false','false'),
(26,31094,1,-1,60,0,'false','false'),
(27,31094,1,-1,60,0,'false','false'),
(28,31094,1,-1,60,0,'false','false'),
(29,31094,1,-1,60,0,'false','false'),
(30,31094,1,-1,60,0,'false','false'),
(31,31094,1,-1,60,0,'false','false'),
(32,31094,1,-1,60,0,'false','false'),
(33,31094,1,-1,60,0,'false','false'),
(34,31094,1,-1,60,0,'false','false'),
(35,31094,1,-1,60,0,'false','false'),
(36,31094,1,-1,60,0,'false','false'),
(37,31094,1,-1,60,0,'false','false'),
(38,31094,1,-1,60,0,'false','false'),
(39,31094,1,-1,60,0,'false','false'),
(40,31094,1,-1,60,0,'false','false'),
(41,31093,1,-1,60,0,'false','false'),
(42,31093,1,-1,60,0,'false','false'),
(43,31093,1,-1,60,0,'false','false'),
(44,31093,1,-1,60,0,'false','false'),
(45,31093,1,-1,60,0,'false','false'),
(46,31093,1,-1,60,0,'false','false'),
(47,31093,1,-1,60,0,'false','false'),
(48,31093,1,-1,60,0,'false','false'),
(49,31093,1,-1,60,0,'false','false'),
(50,31093,1,-1,60,0,'false','false'),
(51,31093,1,-1,60,0,'false','false'),
(52,31093,1,-1,60,0,'false','false'),
(53,31093,1,-1,60,0,'false','false'),
(54,31093,1,-1,60,0,'false','false'),
(55,31093,1,-1,60,0,'false','false'),
(56,31093,1,-1,60,0,'false','false'),
(57,31093,1,-1,60,0,'false','false'),
(58,31093,1,-1,60,0,'false','false'),
(59,31093,1,-1,60,0,'false','false'),
(60,31093,1,-1,60,0,'false','false'),
(61,31093,1,-1,60,0,'false','false'),
(62,31093,1,-1,60,0,'false','false'),
(63,31093,1,-1,60,0,'false','false'),
(64,31093,1,-1,60,0,'false','false'),
(65,31093,1,-1,60,0,'false','false'),
(66,31093,1,-1,60,0,'false','false'),
(67,31093,1,-1,60,0,'false','false'),
(68,31093,1,-1,60,0,'false','false'),
(69,31093,1,-1,60,0,'false','false'),
(70,31093,1,-1,60,0,'false','false'),
(71,31093,1,-1,60,0,'false','false'),
(72,31093,1,-1,60,0,'false','false'),
(73,31093,1,-1,60,0,'false','false'),
(74,31093,1,-1,60,0,'false','false'),
(75,31093,1,-1,60,0,'false','false'),
(76,31093,1,-1,60,0,'false','false'),
(77,31093,1,-1,60,0,'false','false'),
(78,31093,1,-1,60,0,'false','false'),
(79,31093,1,-1,60,0,'false','false'),
(80,31093,1,-1,60,0,'false','false'),
(81,31093,1,-1,60,0,'false','false'),
(82,25283,1,-1,86400,0,'false','false'),
(83,25286,1,-1,86400,0,'false','false');