discuz运营一些常用sql语句

来自版块: Discuz教程发表于: 2022-4-20 20:13:42

3986

0

如本资源下载地址失效,请点击此处进行反馈

开通本站Svip会员，全站资源免费下

清零所有附件下载次数

UPDATE pre_forum_attachment SET downloads = 0

复制代码

清零所有附件下载用户记录

同：清空所有用户的积分变化的记录

清零所有帖子的访问次数

UPDATE pre_forum_thread SET views = 0

复制代码

清空所有用户的积分变化的记录【不是把所有用户的积分变成0，只是每次积分变化的记录】

DELETE FROM pre_common_credit_log

复制代码

清空所有系统提醒消息

DELETE FROM pre_home_notification

复制代码

清空所有站内短消息

DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ;

复制代码

discuz，运营，常用，sql，语句

回复

全部评论 0

期待你的评论哦~

教程 / CSS+DIV素材

Discuz教程
CSS+DIV素材

返回版块

0

0

0