ALTER TABLE `castle` DROP COLUMN `siegeDayOfWeek`;
ALTER TABLE `castle` DROP COLUMN `siegeHourOfDay`;
ALTER TABLE `castle` ADD `regTimeOver` enum('true','false') DEFAULT 'true' NOT NULL AFTER `siegeDate`;
ALTER TABLE `castle` ADD `regTimeEnd` DECIMAL(20,0) NOT NULL default 0 AFTER `regTimeOver`;