Discuz!X3.5新增 允许用户上传头像功能需要升级的数据库语句
Discuz!X3.5新增 允许用户上传头像功能需要升级的数据库语句:
- ALTER TABLE `pre_common_usergroup_field` ADD `allowavatarupload` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `allowimgcontent`;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 1;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 2;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 3;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 4;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 5;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 6;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 7;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 8;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 9;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 10;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 11;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 12;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 13;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 14;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 15;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 16;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 17;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 18;
- UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 19;