去评论
dz插件网

Discuz!X3.5新增 允许用户上传头像功能需要升级的数据库语句

admin
2021/06/30 10:56:31
Discuz!X3.5新增 允许用户上传头像功能需要升级的数据库语句:

  1. ALTER TABLE `pre_common_usergroup_field` ADD `allowavatarupload` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `allowimgcontent`;

  2. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 1;
  3. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 2;
  4. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 3;
  5. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 4;
  6. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 5;
  7. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 6;
  8. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 7;
  9. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 8;
  10. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 9;
  11. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 10;
  12. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 11;
  13. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 12;
  14. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 13;
  15. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 14;
  16. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 15;
  17. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 16;
  18. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 17;
  19. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 18;
  20. UPDATE `pre_common_usergroup_field` SET `allowavatarupload` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 19;