Differential D3908 Diff 11132 plugins/libkolab/SQL/mysql.initial.sql

Changeset 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');