upgrade/0.9.5/10_auth_user_quick.sql

   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;