Changes between Version 1 and Version 2 of BwUserEmailChange


Ignore:
Timestamp:
Oct 15, 2012, 6:46:12 AM (6 years ago)
Author:
planetcruiser
Comment:

minor edit

Legend:

Unmodified
Added
Removed
Modified

  • BwUserEmailChange

    v1 v2  
    3535 1. Update email address
    3636 {{{
    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;
     37mysql> UPDATE BW_MAIN.user SET email = 'that.user@example.org' WHERE handle = 'ThatUser';
     38mysql> UPDATE BW_CRYPTED.cryptedfields SET AdminCryptedValue = '<admincrypted>that.user%40example.org</admincrypted>' WHERE id = 666;
    3939
    4040# 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;
     41mysql> UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = '<membercrypted>that.user%40example.org</membercrypted>' WHERE id = 666;
     42mysql> UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = NULL WHERE id = 666;
    4343
    4444# 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;
     45mysql> UPDATE BW_CRYPTED.cryptedfields SET MemberCryptedValue = 'that.user@example.org' WHERE id = 666;
     46mysql> UPDATE BW_CRYPTED.cryptedfields SET temporary_uncrypted_buffer = 'that.user@example.org' WHERE id = 666;
    4747}}}