summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <machniak@kolabsys.com>2014-09-15 11:02:29 (GMT)
committerAleksander Machniak <machniak@kolabsys.com>2014-09-15 11:02:29 (GMT)
commit4be34e128e8ec1d5273e4b4fda5ba708b7c24727 (patch)
tree250d797c8e1930a64028a731664adcfae235f71e
parent9a56649857e8c59f0b2589d8be7c77a6df55adfa (diff)
downloadkolab-chwala-4be34e128e8ec1d5273e4b4fda5ba708b7c24727.tar.gz
Initial DDL file for Oracle
-rw-r--r--doc/SQL/oracle.initial.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/doc/SQL/oracle.initial.sql b/doc/SQL/oracle.initial.sql
new file mode 100644
index 0000000..53adfb5
--- /dev/null
+++ b/doc/SQL/oracle.initial.sql
@@ -0,0 +1,15 @@
+CREATE TABLE IF NOT EXISTS "chwala_locks" (
+ "uri" varchar(512) NOT NULL,
+ "owner" varchar(256),
+ "timeout" integer,
+ "expires" timestamp DEFAULT NULL,
+ "token" varchar(256),
+ "scope" smallint,
+ "depth" smallint
+);
+
+CREATE INDEX "uri_index" ON "chwala_locks" ("uri", "depth");
+CREATE INDEX "expires_index" ON "chwala_locks" ("expires");
+CREATE INDEX "token_index" ON "chwala_locks" ("token");
+
+INSERT INTO "system" ("name", "value") VALUES ('chwala-version', '2013111300');