Mercurial > hg > rc1

comparison plugins/calendar/drivers/kolab/SQL/mysql/2012080600.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 DROP TABLE IF EXISTS `kolab_alarms`;
2
3 CREATE TABLE `kolab_alarms` (
4 `event_id` VARCHAR(255) NOT NULL,
5 `user_id` int(10) UNSIGNED NOT NULL,
6 `notifyat` DATETIME DEFAULT NULL,
7 `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
8 PRIMARY KEY(`event_id`),
9 CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`)
10 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
11 ) /*!40000 ENGINE=INNODB */;