文件操作 - 2018122700.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/Desktop/tmp/roundcubemail-plugins-kolab/plugins/libkolab/SQL/oracle/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";
修改文件时间
将文件时间修改为当前时间的前一年
删除文件