From 50569114acdc64e7c7cae1498635d3f821517c30 Mon Sep 17 00:00:00 2001 From: Daniel Lange Date: Mon, 7 Mar 2016 15:53:16 +0100 Subject: Initial commit of the Faster IT roundcube_calendar plugin distribution This includes: * Kolab plugins 3.2.9 (calendar and libcalendaring) * CalDAV driver 3.2.8 * .htaccess files for at least some security * SabreDAV updated to 1.8.12 (Jan 2015 release) * Support for CURLOPT_SSL_* settings to allow self-signed certificates * Small fixes & improved documentation --- calendar/drivers/caldav/SQL/mysql/2015022700.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 calendar/drivers/caldav/SQL/mysql/2015022700.sql (limited to 'calendar/drivers/caldav/SQL/mysql/2015022700.sql') diff --git a/calendar/drivers/caldav/SQL/mysql/2015022700.sql b/calendar/drivers/caldav/SQL/mysql/2015022700.sql new file mode 100644 index 0000000..f44b49e --- /dev/null +++ b/calendar/drivers/caldav/SQL/mysql/2015022700.sql @@ -0,0 +1,14 @@ +-- add identifier for recurring instances and exceptions + +ALTER TABLE `caldav_events` ADD `instance` varchar(16) NOT NULL DEFAULT '' AFTER `uid`; +ALTER TABLE `caldav_events` ADD `isexception` tinyint(1) NOT NULL DEFAULT '0' AFTER `instance`; + +UPDATE `caldav_events` SET `instance` = DATE_FORMAT(`start`, '%Y%m%d') + WHERE `recurrence_id` != 0 AND `instance` = '' AND `all_day` = 1; + +UPDATE `caldav_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 `caldav_events` CHANGE `alarms` `alarms` TEXT NULL DEFAULT NULL; \ No newline at end of file -- cgit v1.2.3