Mercurial > hg > rc1
diff plugins/calendar/drivers/kolab/SQL/mysql/2012080600.sql @ 3:f6fe4b6ae66a
calendar plugin nearly as distributed
| author | Charlie Root |
|---|---|
| date | Sat, 13 Jan 2018 08:56:12 -0500 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/plugins/calendar/drivers/kolab/SQL/mysql/2012080600.sql Sat Jan 13 08:56:12 2018 -0500 @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `kolab_alarms`; + +CREATE TABLE `kolab_alarms` ( + `event_id` VARCHAR(255) NOT NULL, + `user_id` int(10) UNSIGNED NOT NULL, + `notifyat` DATETIME DEFAULT NULL, + `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY(`event_id`), + CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`) + REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE +) /*!40000 ENGINE=INNODB */;