20101004update.sql 1.1 KB

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