98304908e011ec7d766f75738cf759991719289f
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;