|
3
|
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');
|
