20120806update.sql 977 B

12345678910111213
  1. ALTER TABLE `grandboss_data` MODIFY `boss_id` smallint(5) unsigned NOT NULL;
  2. ALTER TABLE `grandboss_data` MODIFY `loc_x` mediumint(6) NOT NULL;
  3. ALTER TABLE `grandboss_data` MODIFY `loc_y` mediumint(6) NOT NULL;
  4. ALTER TABLE `grandboss_data` MODIFY `loc_z` mediumint(6) NOT NULL;
  5. ALTER TABLE `raidboss_spawnlist` MODIFY `boss_id` smallint(5) unsigned NOT NULL;
  6. ALTER TABLE `raidboss_spawnlist` MODIFY `amount` tinyint(1) unsigned NOT NULL DEFAULT '1';
  7. ALTER TABLE `raidboss_spawnlist` MODIFY `loc_x` mediumint(6) NOT NULL;
  8. ALTER TABLE `raidboss_spawnlist` MODIFY `loc_y` mediumint(6) NOT NULL;
  9. ALTER TABLE `raidboss_spawnlist` MODIFY `loc_z` mediumint(6) NOT NULL;
  10. ALTER TABLE `raidboss_spawnlist` MODIFY `heading` mediumint(6) NOT NULL DEFAULT '0';
  11. ALTER TABLE `raidboss_spawnlist` MODIFY `respawn_min_delay` mediumint(6) unsigned NOT NULL DEFAULT '43200';
  12. ALTER TABLE `raidboss_spawnlist` MODIFY `respawn_max_delay` mediumint(6) unsigned NOT NULL DEFAULT '129600';