Page MenuHomePhorge
Files F1974730

No OneTemporary
Actions

View Options

diff --git a/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql b/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql
deleted file mode 100644
index 5c475a6c..00000000
--- a/plugins/calendar/drivers/caldav/SQL/oracle.initial.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-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/kolab/SQL/oracle.initial.sql b/plugins/calendar/drivers/kolab/SQL/oracle.initial.sql
deleted file mode 100644
index d6d882bd..00000000
--- a/plugins/calendar/drivers/kolab/SQL/oracle.initial.sql
+++ /dev/null
@@ -1,31 +0,0 @@
-/**
- * Roundcube Calendar Kolab backend
- *
- * @author Aleksander Machniak
- * @licence GNU AGPL
- **/
-
-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-kolab-version', '2014041700');
diff --git a/plugins/libkolab/SQL/oracle.initial.sql b/plugins/libkolab/SQL/oracle.initial.sql
deleted file mode 100644
index c3a05d77..00000000
--- a/plugins/libkolab/SQL/oracle.initial.sql
+++ /dev/null
@@ -1,169 +0,0 @@
-CREATE TABLE "kolab_folders" (
- "folder_id" number NOT NULL PRIMARY KEY,
- "resource" VARCHAR(255) NOT NULL,
- "type" VARCHAR(32) NOT NULL,
- "synclock" integer DEFAULT 0 NOT NULL,
- "ctag" VARCHAR(40) DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "objectcount" number DEFAULT NULL
-);
-
-CREATE INDEX "kolab_folders_resource_idx" ON "kolab_folders" ("resource", "type");
-
-CREATE SEQUENCE "kolab_folders_seq"
- START WITH 1 INCREMENT BY 1 NOMAXVALUE;
-
-CREATE TRIGGER "kolab_folders_seq_trig"
-BEFORE INSERT ON "kolab_folders" FOR EACH ROW
-BEGIN
- :NEW."folder_id" := "kolab_folders_seq".nextval;
-END;
-/
-
-CREATE TABLE "kolab_cache_contact" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "type" varchar(32) NOT NULL,
- "name" varchar(255) DEFAULT NULL,
- "firstname" varchar(255) DEFAULT NULL,
- "surname" varchar(255) DEFAULT NULL,
- "email" varchar(255) DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_contact_type_idx" ON "kolab_cache_contact" ("folder_id", "type");
-CREATE INDEX "kolab_cache_contact_uid2msguid" ON "kolab_cache_contact" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_event" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "dtstart" timestamp DEFAULT NULL,
- "dtend" timestamp DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_event_uid2msguid" ON "kolab_cache_event" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_task" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "dtstart" timestamp DEFAULT NULL,
- "dtend" timestamp DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_task_uid2msguid" ON "kolab_cache_task" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_journal" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "dtstart" timestamp DEFAULT NULL,
- "dtend" timestamp DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_journal_uid2msguid" ON "kolab_cache_journal" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_note" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_note_uid2msguid" ON "kolab_cache_note" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_file" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "filename" varchar(255) DEFAULT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_file_filename" ON "kolab_cache_file" ("folder_id", "filename");
-CREATE INDEX "kolab_cache_file_uid2msguid" ON "kolab_cache_file" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_configuration" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "type" varchar(32) NOT NULL,
- PRIMARY KEY ("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_config_type" ON "kolab_cache_configuration" ("folder_id", "type");
-CREATE INDEX "kolab_cache_config_uid2msguid" ON "kolab_cache_configuration" ("folder_id", "uid", "msguid");
-
-
-CREATE TABLE "kolab_cache_freebusy" (
- "folder_id" number NOT NULL
- REFERENCES "kolab_folders" ("folder_id") ON DELETE CASCADE,
- "msguid" number NOT NULL,
- "uid" varchar(512) NOT NULL,
- "created" timestamp DEFAULT NULL,
- "changed" timestamp DEFAULT NULL,
- "data" clob NOT NULL,
- "tags" clob DEFAULT NULL,
- "words" clob DEFAULT NULL,
- "dtstart" timestamp DEFAULT NULL,
- "dtend" timestamp DEFAULT NULL,
- PRIMARY KEY("folder_id", "msguid")
-);
-
-CREATE INDEX "kolab_cache_fb_uid2msguid" ON "kolab_cache_freebusy" ("folder_id", "uid", "msguid");
-
-
-INSERT INTO "system" ("name", "value") VALUES ('libkolab-version', '2021101100');
diff --git a/plugins/libkolab/SQL/oracle/2015011600.sql b/plugins/libkolab/SQL/oracle/2015011600.sql
deleted file mode 100644
index 69f79538..00000000
--- a/plugins/libkolab/SQL/oracle/2015011600.sql
+++ /dev/null
@@ -1,40 +0,0 @@
--- direct change from varchar to clob does not work, need temp column (#4257)
-ALTER TABLE "kolab_cache_contact" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_contact" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_contact" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_contact" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_event" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_event" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_event" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_event" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_task" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_task" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_task" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_task" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_journal" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_journal" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_journal" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_journal" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_note" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_note" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_note" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_note" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_file" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_file" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_file" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_file" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_configuration" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_configuration" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_configuration" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_configuration" RENAME COLUMN "tags1" TO "tags";
-
-ALTER TABLE "kolab_cache_freebusy" ADD "tags1" clob DEFAULT NULL;
-UPDATE "kolab_cache_freebusy" SET "tags1" = "tags";
-ALTER TABLE "kolab_cache_freebusy" DROP COLUMN "tags";
-ALTER TABLE "kolab_cache_freebusy" RENAME COLUMN "tags1" TO "tags";
diff --git a/plugins/libkolab/SQL/oracle/2015020600.sql b/plugins/libkolab/SQL/oracle/2015020600.sql
deleted file mode 100644
index a6056497..00000000
--- a/plugins/libkolab/SQL/oracle/2015020600.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- improve cache synchronization (#3933)
-ALTER TABLE "kolab_folders"
- ADD "changed" timestamp DEFAULT NULL,
- ADD "objectcount" number DEFAULT NULL;
diff --git a/plugins/libkolab/SQL/oracle/2017071900.sql b/plugins/libkolab/SQL/oracle/2017071900.sql
deleted file mode 100644
index fd562669..00000000
--- a/plugins/libkolab/SQL/oracle/2017071900.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- make UID column bigger
-ALTER TABLE "kolab_cache_contact" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_event" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_task" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_journal" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_note" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_file" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_configuration" MODIFY "uid" VARCHAR(512) NOT NULL;
-ALTER TABLE "kolab_cache_freebusy" MODIFY "uid" VARCHAR(512) NOT NULL;
diff --git a/plugins/libkolab/SQL/oracle/2018021300.sql b/plugins/libkolab/SQL/oracle/2018021300.sql
deleted file mode 100644
index fe6741a0..00000000
--- a/plugins/libkolab/SQL/oracle/2018021300.sql
+++ /dev/null
@@ -1 +0,0 @@
--- empty
\ No newline at end of file
diff --git a/plugins/libkolab/SQL/oracle/2018122700.sql b/plugins/libkolab/SQL/oracle/2018122700.sql
deleted file mode 100644
index 45fccb74..00000000
--- a/plugins/libkolab/SQL/oracle/2018122700.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- remove xml column, and change data format (clear cache needed)
-DELETE FROM "kolab_folders";
-ALTER TABLE "kolab_cache_contact" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_event" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_task" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_journal" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_note" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_file" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_configuration" DROP COLUMN "xml";
-ALTER TABLE "kolab_cache_freebusy" DROP COLUMN "xml";
diff --git a/plugins/libkolab/SQL/oracle/2019092900.sql b/plugins/libkolab/SQL/oracle/2019092900.sql
deleted file mode 100644
index fe6741a0..00000000
--- a/plugins/libkolab/SQL/oracle/2019092900.sql
+++ /dev/null
@@ -1 +0,0 @@
--- empty
\ No newline at end of file
diff --git a/plugins/libkolab/SQL/oracle/2021101100.sql b/plugins/libkolab/SQL/oracle/2021101100.sql
deleted file mode 100644
index fe6741a0..00000000
--- a/plugins/libkolab/SQL/oracle/2021101100.sql
+++ /dev/null
@@ -1 +0,0 @@
--- empty
\ No newline at end of file

File Metadata

Mime Type
text/x-diff
Expires
Sun, Sep 14, 8:12 PM (22 h, 15 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
287399
Default Alt Text
(13 KB)

Event Timeline