ALTER TABLE `md_Manufacturer` ADD `url` VARCHAR( 255 ) NOT NULL AFTER `image`; ALTER TABLE `md_Dealer` ADD `autoshowMember` ENUM( 'y', 'n' ) NOT NULL DEFAULT 'y' AFTER `gmadaMember`; ALTER TABLE `md_Manufacturer` ADD `autoshowMember` ENUM( 'y', 'n' ) NOT NULL DEFAULT 'y' AFTER `show`; UPDATE `md_Dealer` SET `autoshowMember` = 'y';