ALTER TABLE `mn_Member` DROP `is_data_feeds`; ALTER TABLE `mn_Location` ADD `data_feeds_office` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n' AFTER `datafeeds` , ADD `data_feeds_individual` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n' AFTER `data_feeds_office` ; --- attention! only if client wants to set data_feeds_office at this values UPDATE `mn_Location` SET `data_feeds_office` = `datafeeds`; ALTER TABLE `mn_Location` DROP `datafeeds`;