20080917update.sql 299 B

1234
  1. ALTER TABLE `castle` DROP COLUMN `siegeDayOfWeek`;
  2. ALTER TABLE `castle` DROP COLUMN `siegeHourOfDay`;
  3. ALTER TABLE `castle` ADD `regTimeOver` enum('true','false') DEFAULT 'true' NOT NULL AFTER `siegeDate`;
  4. ALTER TABLE `castle` ADD `regTimeEnd` DECIMAL(20,0) NOT NULL DEFAULT 0 AFTER `regTimeOver`;