Page MenuHomePhorge
Files F174712

No OneTemporary
Actions

View Options

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

File Metadata

Mime Type
text/x-diff
Expires
Sun, Jan 19, 3:49 AM (16 h, 43 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
120064
Default Alt Text
(1 KB)

Event Timeline