diff options
Diffstat (limited to 'calendar/drivers/database/SQL/mysql/2015022700.sql')
-rw-r--r-- | calendar/drivers/database/SQL/mysql/2015022700.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/calendar/drivers/database/SQL/mysql/2015022700.sql b/calendar/drivers/database/SQL/mysql/2015022700.sql new file mode 100644 index 0000000..06d30fe --- /dev/null +++ b/calendar/drivers/database/SQL/mysql/2015022700.sql @@ -0,0 +1,15 @@ +-- 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; + |