ALTER TABLE `mn_Member`
  DROP `alternate_contact_name`,
  DROP `alternate_contact_phone`,
  DROP `alternate_contact_phone_title`,
  DROP `alternate_contact_email`;

ALTER TABLE `mn_Member` ADD `use_admin_email` ENUM( 'y', 'n' ) NOT NULL DEFAULT 'n' AFTER `id_market` ,
ADD `admin_email` VARCHAR( 255 ) NULL AFTER `use_admin_email` ;