Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/roundcube/roundcubemail.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'SQL/oracle/2018021600.sql')
-rw-r--r--SQL/oracle/2018021600.sql19
1 files changed, 0 insertions, 19 deletions
diff --git a/SQL/oracle/2018021600.sql b/SQL/oracle/2018021600.sql
deleted file mode 100644
index 2fe3bcd42..000000000
--- a/SQL/oracle/2018021600.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-CREATE TABLE "filestore" (
- "file_id" integer PRIMARY KEY,
- "user_id" integer NOT NULL
- REFERENCES "users" ("user_id") ON DELETE CASCADE ON UPDATE CASCADE,
- "filename" varchar(128) NOT NULL,
- "mtime" integer NOT NULL,
- "data" long,
- CONSTRAINT "filestore_user_id_key" UNIQUE ("user_id", "filename")
-);
-
-CREATE SEQUENCE "filestore_seq"
- START WITH 1 INCREMENT BY 1 NOMAXVALUE;
-
-CREATE TRIGGER "filestore_seq_trig"
-BEFORE INSERT ON "filestore" FOR EACH ROW
-BEGIN
- :NEW."user_id" := "filestore_seq".nextval;
-END;
-/