ALTER TABLE `mm_Event` ADD `hasEbDeadline` ENUM('n','y') NULL DEFAULT 'n' AFTER `nonmemberPrice`, ADD INDEX (`hasEbDeadline`) ; UPDATE `mm_Event` SET `hasEbDeadline` = 'y' WHERE `ebDeadline` IS NOT NULL;