[Discuz]清空主題操作記錄

[NINJA]

當版主對主題進行 置頂/精華..etc 的操作後,首篇最下方會出現操作記錄
清空方式:清空 cdb_threadsmod ,重建統計,更新緩存

有2種方式

TRUNCATE TABLE `cdb_threadsmod`

DELETE FROM `cdb_threadsmod`

註:
1.重建統計後,即使還原備份的cdb_threadsmod也不會再產生關聯,操作記錄不會再還原
2.建議保留合併記錄

DELETE FROM "表格名" WHERE {條件}
直接由資料庫中去除一些資料
TRUNCATE TABLE "表格名"
表格中的資料會完全消失，可是表格本身會繼續存在

刪除單一資料

DELETE FROM `discuz`.`cdb_threadsmod` WHERE `cdb_threadsmod`.`tid` = 1 AND `cdb_threadsmod`.`uid` = 1 AND `cdb_threadsmod`.`username` = 'NINJA' AND `cdb_threadsmod`.`dateline` = 1271261753 AND `cdb_threadsmod`.`expiration` = 0 AND `cdb_threadsmod`.`action` = 'UDG' AND `cdb_threadsmod`.`status` = 1 AND `cdb_threadsmod`.`magicid` = 0 AND `cdb_threadsmod`.`stamp` = 0 LIMIT 1;
DELETE FROM `discuz`.`cdb_threadsmod` WHERE `cdb_threadsmod`.`tid` = 1 AND `cdb_threadsmod`.`uid` = 1 AND `cdb_threadsmod`.`username` = 'NINJA' AND `cdb_threadsmod`.`dateline` = 1271261827 AND `cdb_threadsmod`.`expiration` = 0 AND `cdb_threadsmod`.`action` = 'UHL' AND `cdb_threadsmod`.`status` = 1 AND `cdb_threadsmod`.`magicid` = 0 AND `cdb_threadsmod`.`stamp` = 0 LIMIT 1;