Changeset View
Changeset View
Standalone View
Standalone View
plugins/libkolab/SQL/mysql.initial.sql
/** | |||||
* libkolab database schema | |||||
* | |||||
* @author Thomas Bruederli | |||||
* @licence GNU AGPL | |||||
*/ | |||||
SET FOREIGN_KEY_CHECKS=0; | SET FOREIGN_KEY_CHECKS=0; | ||||
DROP TABLE IF EXISTS `kolab_folders`; | DROP TABLE IF EXISTS `kolab_folders`; | ||||
CREATE TABLE `kolab_folders` ( | CREATE TABLE `kolab_folders` ( | ||||
`folder_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, | `folder_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, | ||||
`resource` VARCHAR(255) BINARY NOT NULL, | `resource` VARCHAR(255) BINARY NOT NULL, | ||||
`type` VARCHAR(32) NOT NULL, | `type` VARCHAR(32) NOT NULL, | ||||
▲ Show 20 Lines • Show All 156 Lines • ▼ Show 20 Lines | CREATE TABLE `kolab_cache_freebusy` ( | ||||
`dtstart` DATETIME, | `dtstart` DATETIME, | ||||
`dtend` DATETIME, | `dtend` DATETIME, | ||||
CONSTRAINT `fk_kolab_cache_freebusy_folder` FOREIGN KEY (`folder_id`) | CONSTRAINT `fk_kolab_cache_freebusy_folder` FOREIGN KEY (`folder_id`) | ||||
REFERENCES `kolab_folders`(`folder_id`) ON DELETE CASCADE ON UPDATE CASCADE, | REFERENCES `kolab_folders`(`folder_id`) ON DELETE CASCADE ON UPDATE CASCADE, | ||||
PRIMARY KEY(`folder_id`,`msguid`), | PRIMARY KEY(`folder_id`,`msguid`), | ||||
INDEX `freebusy_uid2msguid` (`folder_id`,`uid`,`msguid`) | INDEX `freebusy_uid2msguid` (`folder_id`,`uid`,`msguid`) | ||||
) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | ) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | ||||
DROP TABLE IF EXISTS `kolab_cache_dav_contact`; | |||||
CREATE TABLE `kolab_cache_dav_contact` ( | |||||
`folder_id` BIGINT UNSIGNED NOT NULL, | |||||
`uid` VARCHAR(512) NOT NULL, | |||||
`etag` VARCHAR(128) DEFAULT NULL, | |||||
`created` DATETIME DEFAULT NULL, | |||||
`changed` DATETIME DEFAULT NULL, | |||||
`data` LONGTEXT NOT NULL, | |||||
`tags` TEXT NOT NULL, | |||||
`words` TEXT NOT NULL, | |||||
`type` VARCHAR(32) CHARACTER SET ascii NOT NULL, | |||||
`name` VARCHAR(255) NOT NULL, | |||||
`firstname` VARCHAR(255) NOT NULL, | |||||
`surname` VARCHAR(255) NOT NULL, | |||||
`email` VARCHAR(255) NOT NULL, | |||||
CONSTRAINT `fk_kolab_cache_dav_contact_folder` FOREIGN KEY (`folder_id`) | |||||
REFERENCES `kolab_folders`(`folder_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |||||
PRIMARY KEY(`folder_id`,`uid`), | |||||
INDEX `contact_type` (`folder_id`,`type`) | |||||
) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | |||||
DROP TABLE IF EXISTS `kolab_cache_dav_event`; | |||||
CREATE TABLE `kolab_cache_dav_event` ( | |||||
`folder_id` BIGINT UNSIGNED NOT NULL, | |||||
`uid` VARCHAR(512) NOT NULL, | |||||
`etag` VARCHAR(128) DEFAULT NULL, | |||||
`created` DATETIME DEFAULT NULL, | |||||
`changed` DATETIME DEFAULT NULL, | |||||
`data` LONGTEXT NOT NULL, | |||||
`tags` TEXT NOT NULL, | |||||
`words` TEXT NOT NULL, | |||||
`dtstart` DATETIME, | |||||
`dtend` DATETIME, | |||||
CONSTRAINT `fk_kolab_cache_dav_event_folder` FOREIGN KEY (`folder_id`) | |||||
REFERENCES `kolab_folders`(`folder_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |||||
PRIMARY KEY(`folder_id`,`uid`) | |||||
) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | |||||
SET FOREIGN_KEY_CHECKS=1; | SET FOREIGN_KEY_CHECKS=1; | ||||
REPLACE INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2021101100'); | REPLACE INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2022100500'); |