Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14968 -r14973 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14968) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14973) @@ -2509,4 +2509,13 @@ UPDATE PortalUser SET FrontLanguage = 1 -WHERE UserType = 0; \ No newline at end of file +WHERE UserType = 0; + +ALTER TABLE PortalUser + ADD PrevEmails TEXT NULL AFTER Email, + ADD EmailVerified TINYINT NOT NULL AFTER `Status`; + +UPDATE PortalUser SET EmailVerified = 1; + +INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, Module, Description, Type, AllowChangingSender, AllowChangingRecipient) VALUES(DEFAULT, 'USER.EMAIL.CHANGE.VERIFY', NULL, 1, 0, 'Core', 'Changed E-mail Verification', 0, 1, 1); +INSERT INTO Events (EventId, Event, ReplacementTags, Enabled, FrontEndOnly, Module, Description, Type, AllowChangingSender, AllowChangingRecipient) VALUES(DEFAULT, 'USER.EMAIL.CHANGE.UNDO', NULL, 1, 0, 'Core', 'Changed E-mail Rollback', 0, 1, 1);