1DROP TABLE IF EXISTS `kolab_alarms`;
2
3CREATE 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 */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
12