| 1 | ALTER TABLE auth_user_quick |
| 2 | ADD profile_mobile VARCHAR(20) NOT NULL, |
| 3 | ADD profile_mobile_pub ENUM('private', 'ax', 'public') DEFAULT 'private' NOT NULL, |
| 4 | ADD profile_web VARCHAR(255) NOT NULL, |
| 5 | ADD profile_web_pub ENUM('private', 'public') DEFAULT 'private' NOT NULL, |
| 6 | ADD profile_freetext VARCHAR(255) NOT NULL, |
| 7 | ADD profile_freetext_pub ENUM('private', 'public') DEFAULT 'private' NOT NULL, |
| 8 | ADD profile_medals_pub ENUM('private', 'public') DEFAULT 'private' NOT NULL; |
| 9 | UPDATE auth_user_quick AS q INNER JOIN auth_user_md5 AS u USING(user_id) SET |
| 10 | q.profile_mobile = u.mobile, |
| 11 | q.profile_mobile_pub = IF(FIND_IN_SET('mobile_public', u.bits), 'public', IF(FIND_IN_SET('mobile_ax', u.bits), 'ax', 'private')), |
| 12 | q.profile_web = u.web, |
| 13 | q.profile_web_pub = IF(FIND_IN_SET('web_public', u.bits), 'public', 'private'), |
| 14 | q.profile_freetext = u.libre, |
| 15 | q.profile_freetext_pub = IF(FIND_IN_SET('libre_public', u.bits), 'public', 'private'); |
| 16 | ALTER TABLE auth_user_md5 DROP mobile, DROP web, DROP libre, CHANGE bits bits SET('mail_ax') NOT NULL; |