文件操作 - 2014040900.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/Desktop/tmp/roundcubemail-plugins-kolab/plugins/libkolab/SQL/mysql/2014040900.sql
编辑文件内容
ALTER TABLE `kolab_cache_contact` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_event` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_task` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_journal` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_note` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_file` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_configuration` CHANGE `data` `data` LONGTEXT NOT NULL; ALTER TABLE `kolab_cache_freebusy` CHANGE `data` `data` LONGTEXT NOT NULL; -- rebuild cache entries for xcal objects with alarms DELETE FROM `kolab_cache_event` WHERE tags LIKE '% x-has-alarms %'; DELETE FROM `kolab_cache_task` WHERE tags LIKE '% x-has-alarms %'; -- force cache synchronization UPDATE `kolab_folders` SET ctag='' WHERE `type` IN ('event','task');
修改文件时间
将文件时间修改为当前时间的前一年
删除文件