20101004update.sql 746 B

1234567891011121314
  1. ALTER TABLE `custom_spawnlist`
  2. MODIFY `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  3. MODIFY `location` varchar(40) NOT NULL DEFAULT '',
  4. MODIFY `count` tinyint(1) unsigned NOT NULL DEFAULT '0',
  5. MODIFY `npc_templateid` mediumint(7) unsigned NOT NULL DEFAULT '0',
  6. MODIFY `locx` mediumint(6) NOT NULL DEFAULT '0',
  7. MODIFY `locy` mediumint(6) NOT NULL DEFAULT '0',
  8. MODIFY `locz` mediumint(6) NOT NULL DEFAULT '0',
  9. MODIFY `randomx` mediumint(6) NOT NULL DEFAULT '0',
  10. MODIFY `randomy` mediumint(6) NOT NULL DEFAULT '0',
  11. MODIFY `heading` mediumint(6) NOT NULL DEFAULT '0',
  12. MODIFY `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',
  13. MODIFY `loc_id` int(9) NOT NULL DEFAULT '0',
  14. MODIFY `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0';