sql语句:Discuz! 的一些快速升级 SQL 语句来操作后台..来源: 发布时间:星期五, 2008年9月5日 浏览:350次 评论:0
使用方法:到后台 “数据库” 的 “数据库升级” 然后把需要升级的语句贴在该空格里,过后按 “提交” 即可。cdb_ 是默认的表名前缀,如果不同大家可以自行修改。 ==================================================== 启用全局置顶 UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'globalstick' LIMIT 1 ; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'gzipcompress' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'rssstatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'rewritestatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '2' WHERE `variable` = 'rewritestatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '3' WHERE `variable` = 'rewritestatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'bdaystatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '2' WHERE `variable` = 'bdaystatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '3' WHERE `variable` = 'bdaystatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'memliststatus' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'subforumsindex' LIMIT 1; UPDATE `cdb_settings` SET `value` = '1' WHERE `variable` = 'stylejump' LIMIT 1; UPDATE `cdb_settings` SET `value` = '0' WHERE `variable` = 'hideprivate' LIMIT 1; UPDATE `cdb_forums` SET `recyclebin` = '1'; UPDATE `cdb_forums` SET `allowblog` = '1'; UPDATE `cdb_forums` SET `allowhtml` = '1'; UPDATE `cdb_forums` SET `allowbbcode` = '1'; UPDATE `cdb_forums` SET `allowimgcode` = '1'; UPDATE `cdb_forums` SET `allowsmilies` = '1'; UPDATE `cdb_forums` SET `jammer` = '1'; UPDATE `cdb_forums` SET `allowanonymous` = '1'; UPDATE `cdb_forums` SET `alloweditrules` = '1'; UPDATE `cdb_forums` SET `alloweditrules` = '2'; 0
相关文章
读者评论
发表评论 |