File indexing completed on 2024-03-24 06:03:44
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 ;