Mercurial > hg > rc1

comparison plugins/calendar/drivers/database/SQL/mysql/2015022700.sql @ 3:f6fe4b6ae66a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
calendar plugin nearly as distributed
author Charlie Root
date Sat, 13 Jan 2018 08:56:12 -0500
parents
children
comparison
equal deleted inserted replaced
2:c828b0fd4a6e 3:f6fe4b6ae66a
1 -- add identifier for recurring instances and exceptions
2
3 ALTER TABLE `events` ADD `instance` varchar(16) NOT NULL DEFAULT '' AFTER `uid`;
4 ALTER TABLE `events` ADD `isexception` tinyint(1) NOT NULL DEFAULT '0' AFTER `instance`;
5
6 UPDATE `events` SET `instance` = DATE_FORMAT(`start`, '%Y%m%d')
7 WHERE `recurrence_id` != 0 AND `instance` = '' AND `all_day` = 1;
8
9 UPDATE `events` SET `instance` = DATE_FORMAT(`start`, '%Y%m%dT%k%i%s')
10 WHERE `recurrence_id` != 0 AND `instance` = '' AND `all_day` = 0;
11
12 -- extend alarms columns for multiple values
13
14 ALTER TABLE `events` CHANGE `alarms` `alarms` TEXT NULL DEFAULT NULL;
15