File indexing completed on 2024-04-28 17:16:10 

0001 ALTER TABLE `member_email`
0002     ADD COLUMN `email_hash` VARCHAR(255) NOT NULL AFTER `email_verification_value`;
0003 
0004 ALTER TABLE `member_email`
0005     ADD INDEX `idx_hash` (`email_hash`);
0006 
0007 UPDATE `member_email` `me`
0008 SET `me`.`email_hash` = MD5(`me`.`email_address`)
0009 ;