custom_spawnlist.sql 737 B

123456789101112131415
  1. CREATE TABLE IF NOT EXISTS `custom_spawnlist` (
  2. `location` varchar(40) NOT NULL DEFAULT '',
  3. `count` tinyint(1) unsigned NOT NULL DEFAULT '0',
  4. `npc_templateid` mediumint(7) unsigned NOT NULL DEFAULT '0',
  5. `locx` mediumint(6) NOT NULL DEFAULT '0',
  6. `locy` mediumint(6) NOT NULL DEFAULT '0',
  7. `locz` mediumint(6) NOT NULL DEFAULT '0',
  8. `randomx` mediumint(6) NOT NULL DEFAULT '0',
  9. `randomy` mediumint(6) NOT NULL DEFAULT '0',
  10. `heading` mediumint(6) NOT NULL DEFAULT '0',
  11. `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',
  12. `respawn_random` mediumint(5) NOT NULL DEFAULT '0',
  13. `loc_id` int(9) NOT NULL DEFAULT '0',
  14. `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;