Changes between Version 1 and Version 2 of BwUserEmailChange
- Timestamp:
- Oct 15, 2012 6:46:12 AM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
BwUserEmailChange
v1 v2 35 35 1. Update email address 36 36 {{{ 37 UPDATE BW_MAIN.user SET email = 'that.user@example.org' WHERE handle = 'ThatUser';38 UPDATE BW_CRYPTED.cryptedfields SET AdminCryptedValue = '<admincrypted>that.user%40example.org</admincrypted>' WHERE id = 666;37 mysql> UPDATE BW_MAIN.user SET email = 'that.user@example.org' WHERE handle = 'ThatUser'; 38 mysql> UPDATE BW_CRYPTED.cryptedfields SET AdminCryptedValue = '<admincrypted>that.user%40example.org</admincrypted>' WHERE id = 666; 39 39 40 40 # If isCrypted == "always": 41 UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = '<membercrypted>that.user%40example.org</membercrypted>' WHERE id = 666;42 UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = NULL WHERE id = 666;41 mysql> UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = '<membercrypted>that.user%40example.org</membercrypted>' WHERE id = 666; 42 mysql> UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = NULL WHERE id = 666; 43 43 44 44 # If isCrypted == "not crypted": 45 UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = 'that.user@example.org' WHERE id = 666;46 UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = 'that.user@example.org' WHERE id = 666;45 mysql> UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = 'that.user@example.org' WHERE id = 666; 46 mysql> UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = 'that.user@example.org' WHERE id = 666; 47 47 }}}