Mercurial > hg > rc1

annotate plugins/calendar/drivers/kolab/SQL/mysql/2012080600.sql @ 10:9f4e3a3141ca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
x
author Charlie Root
date Sat, 13 Jan 2018 09:37:52 -0500
parents f6fe4b6ae66a
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
1 DROP TABLE IF EXISTS `kolab_alarms`;
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
2
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
3 CREATE TABLE `kolab_alarms` (
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
4 `event_id` VARCHAR(255) NOT NULL,
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
5 `user_id` int(10) UNSIGNED NOT NULL,
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
6 `notifyat` DATETIME DEFAULT NULL,
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
7 `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
8 PRIMARY KEY(`event_id`),
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
9 CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`)
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
10 REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
11 ) /*!40000 ENGINE=INNODB */;