ALTER TABLE `mm_TradeShowAttendee` ADD `email` VARCHAR(255) NOT NULL AFTER `lastName`;
ALTER TABLE `mm_TradeShowAttendee` CHANGE `email` `email` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

UPDATE `mm_TradeShowAttendee` AS `tsa`
JOIN `mm_User` AS `u` ON `u`.`id` = `tsa`.`userId`
SET `tsa`.`email` = `u`.`email`;