Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `calendars` (
- `calendar_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `name` varchar(255) NOT NULL,
- `color` varchar(8) NOT NULL,
- `showalarms` tinyint(1) NOT NULL DEFAULT '1',
- PRIMARY KEY(`calendar_id`),
- INDEX `user_name_idx` (`user_id`, `name`),
- CONSTRAINT `fk_calendars_user_id` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
- CREATE TABLE IF NOT EXISTS `events` (
- `event_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `calendar_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
- `recurrence_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
- `uid` varchar(255) NOT NULL DEFAULT '',
- `instance` varchar(16) NOT NULL DEFAULT '',
- `isexception` tinyint(1) NOT NULL DEFAULT '0',
- `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
- `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
- `sequence` int(1) UNSIGNED NOT NULL DEFAULT '0',
- `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
- `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
- `recurrence` varchar(255) DEFAULT NULL,
- `title` varchar(255) NOT NULL,
- `description` text NOT NULL,
- `location` varchar(255) NOT NULL DEFAULT '',
- `categories` varchar(255) NOT NULL DEFAULT '',
- `url` varchar(255) NOT NULL DEFAULT '',
- `all_day` tinyint(1) NOT NULL DEFAULT '0',
- `free_busy` tinyint(1) NOT NULL DEFAULT '0',
- `priority` tinyint(1) NOT NULL DEFAULT '0',
- `sensitivity` tinyint(1) NOT NULL DEFAULT '0',
- `status` varchar(32) NOT NULL DEFAULT '',
- `alarms` text DEFAULT NULL,
- `attendees` text DEFAULT NULL,
- `notifyat` datetime DEFAULT NULL,
- PRIMARY KEY(`event_id`),
- INDEX `uid_idx` (`uid`),
- INDEX `recurrence_idx` (`recurrence_id`),
- INDEX `calendar_notify_idx` (`calendar_id`,`notifyat`),
- CONSTRAINT `fk_events_calendar_id` FOREIGN KEY (`calendar_id`)
- REFERENCES `calendars`(`calendar_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
- CREATE TABLE IF NOT EXISTS `attachments` (
- `attachment_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `event_id` int(11) UNSIGNED NOT NULL DEFAULT '0',
- `filename` varchar(255) NOT NULL DEFAULT '',
- `mimetype` varchar(255) NOT NULL DEFAULT '',
- `size` int(11) NOT NULL DEFAULT '0',
- `data` longtext NOT NULL,
- PRIMARY KEY(`attachment_id`),
- CONSTRAINT `fk_attachments_event_id` FOREIGN KEY (`event_id`)
- REFERENCES `events`(`event_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
- CREATE TABLE IF NOT EXISTS `itipinvitations` (
- `token` VARCHAR(64) NOT NULL,
- `event_uid` VARCHAR(255) NOT NULL,
- `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `event` TEXT NOT NULL,
- `expires` DATETIME DEFAULT NULL,
- `cancelled` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY(`token`),
- INDEX `uid_idx` (`user_id`,`event_uid`),
- CONSTRAINT `fk_itipinvitations_user_id` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement