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,7556,1,-1,1800000,1800000,'false','true'),
(2,8092,1,-1,60,0,'false','false'),
(3,8092,1,-1,60,0,'false','false'),
(4,8092,1,-1,60,0,'false','false'),
(5,8092,1,-1,60,0,'false','false'),
(6,8092,1,-1,60,0,'false','false'),
(7,8092,1,-1,60,0,'false','false'),
(8,8092,1,-1,60,0,'false','false'),
(9,8111,1,-1,60,0,'false','false'),
(10,8112,1,-1,60,0,'false','false'),
(11,8113,1,-1,-1,-1,'true','true'),
(12,8126,1,-1,-1,-1,'true','true'),
(13,8094,1,-1,60,0,'false','false'),
(14,8094,1,-1,60,0,'false','false'),
(15,8094,1,-1,60,0,'false','false'),
(16,8094,1,-1,60,0,'false','false'),
(17,8094,1,-1,60,0,'false','false'),
(18,8094,1,-1,60,0,'false','false'),
(19,8094,1,-1,60,0,'false','false'),
(20,8094,1,-1,60,0,'false','false'),
(21,8094,1,-1,60,0,'false','false'),
(22,8094,1,-1,60,0,'false','false'),
(23,8094,1,-1,60,0,'false','false'),
(24,8094,1,-1,60,0,'false','false'),
(25,8094,1,-1,60,0,'false','false'),
(26,8094,1,-1,60,0,'false','false'),
(27,8094,1,-1,60,0,'false','false'),
(28,8094,1,-1,60,0,'false','false'),
(29,8094,1,-1,60,0,'false','false'),
(30,8094,1,-1,60,0,'false','false'),
(31,8094,1,-1,60,0,'false','false'),
(32,8094,1,-1,60,0,'false','false'),
(33,8094,1,-1,60,0,'false','false'),
(34,8094,1,-1,60,0,'false','false'),
(35,8094,1,-1,60,0,'false','false'),
(36,8094,1,-1,60,0,'false','false'),
(37,8094,1,-1,60,0,'false','false'),
(38,8094,1,-1,60,0,'false','false'),
(39,8094,1,-1,60,0,'false','false'),
(40,8094,1,-1,60,0,'false','false'),
(41,8093,1,-1,60,0,'false','false'),
(42,8093,1,-1,60,0,'false','false'),
(43,8093,1,-1,60,0,'false','false'),
(44,8093,1,-1,60,0,'false','false'),
(45,8093,1,-1,60,0,'false','false'),
(46,8093,1,-1,60,0,'false','false'),
(47,8093,1,-1,60,0,'false','false'),
(48,8093,1,-1,60,0,'false','false'),
(49,8093,1,-1,60,0,'false','false'),
(50,8093,1,-1,60,0,'false','false'),
(51,8093,1,-1,60,0,'false','false'),
(52,8093,1,-1,60,0,'false','false'),
(53,8093,1,-1,60,0,'false','false'),
(54,8093,1,-1,60,0,'false','false'),
(55,8093,1,-1,60,0,'false','false'),
(56,8093,1,-1,60,0,'false','false'),
(57,8093,1,-1,60,0,'false','false'),
(58,8093,1,-1,60,0,'false','false'),
(59,8093,1,-1,60,0,'false','false'),
(60,8093,1,-1,60,0,'false','false'),
(61,8093,1,-1,60,0,'false','false'),
(62,8093,1,-1,60,0,'false','false'),
(63,8093,1,-1,60,0,'false','false'),
(64,8093,1,-1,60,0,'false','false'),
(65,8093,1,-1,60,0,'false','false'),
(66,8093,1,-1,60,0,'false','false'),
(67,8093,1,-1,60,0,'false','false'),
(68,8093,1,-1,60,0,'false','false'),
(69,8093,1,-1,60,0,'false','false'),
(70,8093,1,-1,60,0,'false','false'),
(71,8093,1,-1,60,0,'false','false'),
(72,8093,1,-1,60,0,'false','false'),
(73,8093,1,-1,60,0,'false','false'),
(74,8093,1,-1,60,0,'false','false'),
(75,8093,1,-1,60,0,'false','false'),
(76,8093,1,-1,60,0,'false','false'),
(77,8093,1,-1,60,0,'false','false'),
(78,8093,1,-1,60,0,'false','false'),
(79,8093,1,-1,60,0,'false','false'),
(80,8093,1,-1,60,0,'false','false'),
(81,8093,1,-1,60,0,'false','false'),
(82,10283,1,-1,86400,0,'false','false'),
(83,10286,1,-1,86400,0,'false','false');