ALTER TABLE `md_Dealer`
    ADD `madaMember` ENUM('n', 'y') NOT NULL DEFAULT 'y' AFTER `centerType`,
    DROP `type`;

UPDATE `md_Dealer` SET `madaMember` = 'n' WHERE `centerType` > 0;
