Mercurial > hg > rc1

comparison plugins/calendar/drivers/kolab/SQL/mysql.initial.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 /**
2 * Roundcube Calendar Kolab backend
3 *
4 * @version @package_version@
5 * @author Thomas Bruederli
6 * @licence GNU AGPL
7 **/
8
9 CREATE TABLE IF NOT EXISTS `kolab_alarms` (
10 `alarm_id` VARCHAR(255) NOT NULL,
11 `user_id` int(10) UNSIGNED NOT NULL,
12 `notifyat` DATETIME DEFAULT NULL,
13 `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
14 PRIMARY KEY(`alarm_id`,`user_id`),
15 CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`)
16 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
17 ) /*!40000 ENGINE=INNODB */;
18
19 CREATE TABLE IF NOT EXISTS `itipinvitations` (
20 `token` VARCHAR(64) NOT NULL,
21 `event_uid` VARCHAR(255) NOT NULL,
22 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
23 `event` TEXT NOT NULL,
24 `expires` DATETIME DEFAULT NULL,
25 `cancelled` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
26 PRIMARY KEY(`token`),
27 INDEX `uid_idx` (`event_uid`,`user_id`),
28 CONSTRAINT `fk_itipinvitations_user_id` FOREIGN KEY (`user_id`)
29 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
30 ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
31
32 REPLACE INTO system (name, value) VALUES ('calendar-kolab-version', '2014041700');