Discuz!新增 允许用户浏览个人资料页需要升级的数据库语句
Discuz!新增 允许用户浏览个人资料页需要升级的数据库语句:ALTER TABLE `pre_common_usergroup_field` ADD `allowviewprofile` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `allowviewprofile`;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 1;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 2;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 3;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 4;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 5;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 6;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 7;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 8;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '0' WHERE `pre_common_usergroup_field`.`groupid` = 9;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 10;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 11;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 12;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 13;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 14;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 15;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 16;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 17;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 18;
UPDATE `pre_common_usergroup_field` SET `allowviewprofile` = '1' WHERE `pre_common_usergroup_field`.`groupid` = 19;
页:
[1]