文件操作 - 2015022700.sql
返回文件管理
返回主菜单
删除本文件
文件: /root/.local/share/Trash/files/roundcube/plugins/calendar/drivers/database/SQL/mysql/2015022700.sql
编辑文件内容
-- add identifier for recurring instances and exceptions ALTER TABLE `events` ADD `instance` varchar(16) NOT NULL DEFAULT '' AFTER `uid`; ALTER TABLE `events` ADD `isexception` tinyint(1) NOT NULL DEFAULT '0' AFTER `instance`; UPDATE `events` SET `instance` = DATE_FORMAT(`start`, '%Y%m%d') WHERE `recurrence_id` != 0 AND `instance` = '' AND `all_day` = 1; UPDATE `events` SET `instance` = DATE_FORMAT(`start`, '%Y%m%dT%k%i%s') WHERE `recurrence_id` != 0 AND `instance` = '' AND `all_day` = 0; -- extend alarms columns for multiple values ALTER TABLE `events` CHANGE `alarms` `alarms` TEXT NULL DEFAULT NULL;
修改文件时间
将文件时间修改为当前时间的前一年
删除文件