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}}}