Page MenuHomePhorge
Files F236973

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
new file mode 100644
index 00000000..569c5e62
--- /dev/null
+++ b/plugins/calendar/drivers/caldav/SQL/mysql.initial.sql
@@ -0,0 +1,28 @@
+DROP TABLE `kolab_alarms` IF EXISTS;
+
+CREATE TABLE IF NOT EXISTS `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;
+
+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` (`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');
diff --git a/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql b/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql
new file mode 100644
index 00000000..5c475a6c
--- /dev/null
+++ b/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql
@@ -0,0 +1,24 @@
+CREATE TABLE "kolab_alarms" (
+ "alarm_id" varchar(255) NOT NULL PRIMARY KEY,
+ "user_id" integer NOT NULL
+ REFERENCES "users" ("user_id") ON DELETE CASCADE,
+ "notifyat" timestamp DEFAULT NULL,
+ "dismissed" smallint DEFAULT 0 NOT NULL
+);
+
+CREATE INDEX "kolab_alarms_user_id_idx" ON "kolab_alarms" ("user_id");
+
+
+CREATE TABLE "itipinvitations" (
+ "token" varchar(64) NOT NULL PRIMARY KEY,
+ "event_uid" varchar(255) NOT NULL,
+ "user_id" integer NOT NULL
+ REFERENCES "users" ("user_id") ON DELETE CASCADE,
+ "event" long NOT NULL,
+ "expires" timestamp DEFAULT NULL,
+ "cancelled" smallint DEFAULT 0 NOT NULL
+);
+
+CREATE INDEX "itipinvitations_user_id_idx" ON "itipinvitations" ("user_id", "event_uid");
+
+INSERT INTO "system" ("name", "value") VALUES ('calendar-caldav-version', '2014041700');
diff --git a/plugins/calendar/drivers/caldav/SQL/postgres.initial.sql b/plugins/calendar/drivers/caldav/SQL/postgres.initial.sql
new file mode 100644
index 00000000..1532b5a5
--- /dev/null
+++ b/plugins/calendar/drivers/caldav/SQL/postgres.initial.sql
@@ -0,0 +1,25 @@
+CREATE TABLE IF NOT EXISTS kolab_alarms (
+ alarm_id character varying(255) NOT NULL,
+ user_id integer NOT NULL
+ REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+ notifyat timestamp without time zone DEFAULT NULL,
+ dismissed smallint NOT NULL DEFAULT 0,
+ PRIMARY KEY(alarm_id)
+);
+
+CREATE INDEX kolab_alarms_user_id_idx ON kolab_alarms (user_id);
+
+CREATE TABLE IF NOT EXISTS itipinvitations (
+ token character varying(64) NOT NULL,
+ event_uid character varying(255) NOT NULL,
+ user_id integer NOT NULL
+ REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+ event text NOT NULL,
+ expires timestamp without time zone DEFAULT NULL,
+ cancelled smallint NOT NULL DEFAULT 0,
+ PRIMARY KEY(token)
+);
+
+CREATE INDEX itipinvitations_user_id_event_uid_idx ON itipinvitations (user_id, event_uid);
+
+INSERT INTO system (name, value) VALUES ('calendar-caldav-version', '2014041700');
diff --git a/plugins/calendar/drivers/caldav/SQL/sqlite.initial.sql b/plugins/calendar/drivers/caldav/SQL/sqlite.initial.sql
new file mode 100644
index 00000000..6730e87b
--- /dev/null
+++ b/plugins/calendar/drivers/caldav/SQL/sqlite.initial.sql
@@ -0,0 +1,22 @@
+CREATE TABLE kolab_alarms (
+ alarm_id VARCHAR(255) NOT NULL,
+ user_id INTEGER NOT NULL,
+ notifyat DATETIME DEFAULT NULL,
+ dismissed TINYINT(3) NOT NULL DEFAULT '0',
+ PRIMARY KEY(alarm_id,user_id)
+);
+
+CREATE INDEX ix_kolab_alarms_user_id ON kolab_alarms(user_id);
+
+CREATE TABLE itipinvitations (
+ token VARCHAR(64) NOT NULL PRIMARY KEY,
+ event_uid VARCHAR(255) NOT NULL,
+ user_id INTEGER NOT NULL DEFAULT '0',
+ event TEXT NOT NULL,
+ expires DATETIME DEFAULT NULL,
+ cancelled TINYINT(3) NOT NULL DEFAULT '0'
+);
+
+CREATE INDEX ix_itipinvitations_uid ON itipinvitations(event_uid,user_id);
+
+INSERT INTO system (name, value) VALUES ('calendar-caldav-version', '2014041700');

File Metadata

Mime Type
text/x-diff
Expires
Fri, May 16, 2:27 AM (15 h, 49 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
178344
Default Alt Text
(4 KB)

Event Timeline