diff --git a/plugins/calendar/drivers/caldav/SQL/mysql.initial.sql b/plugins/calendar/drivers/caldav/SQL/mysql.initial.sql index 569c5e62..a8504848 100644 --- a/plugins/calendar/drivers/caldav/SQL/mysql.initial.sql +++ b/plugins/calendar/drivers/caldav/SQL/mysql.initial.sql @@ -1,28 +1,28 @@ -DROP TABLE `kolab_alarms` IF EXISTS; +DROP TABLE IF EXISTS `kolab_alarms`; -CREATE TABLE IF NOT EXISTS `kolab_alarms` ( +CREATE TABLE `kolab_alarms` ( `alarm_id` VARCHAR(255) NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `notifyat` DATETIME DEFAULT NULL, `dismissed` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`alarm_id`,`user_id`), CONSTRAINT `fk_kolab_alarms_user_id` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -DROP TABLE `itipinvitations` IF EXISTS; +DROP TABLE IF EXISTS `itipinvitations`; -CREATE TABLE IF NOT EXISTS `itipinvitations` ( +CREATE TABLE `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` (`event_uid`,`user_id`), CONSTRAINT `fk_itipinvitations_user_id` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; REPLACE INTO `system` (`name`, `value`) VALUES ('calendar-caldav-version', '2021102600');