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