文件操作 - 2018122700.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/Desktop/tmp/roundcubemail-plugins-kolab/plugins/libkolab/SQL/mysql/2018122700.sql
编辑文件内容
-- remove xml column, and change data format (clear cache needed) DELETE FROM `kolab_folders`; ALTER TABLE `kolab_cache_contact` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_event` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_task` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_journal` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_note` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_file` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_configuration` DROP COLUMN `xml`; ALTER TABLE `kolab_cache_freebusy` DROP COLUMN `xml`;
修改文件时间
将文件时间修改为当前时间的前一年
删除文件