diff options
author | Aleksander Machniak <alec@alec.pl> | 2014-10-27 12:09:47 +0100 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2014-10-27 12:09:47 +0100 |
commit | 9aa55d5a50bd4c219f409dcd1c42c373c7dcfdb8 (patch) | |
tree | 0bf4109168ac7f10ef7036b450d6f47b2551f129 /SQL/oracle.initial.sql | |
parent | 922f30cb4ea4c7250d78144ce798f149e6e1bdb6 (diff) |
Fix so DDL script for Oracle can be executed in SQLPlus
Diffstat (limited to 'SQL/oracle.initial.sql')
-rw-r--r-- | SQL/oracle.initial.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/SQL/oracle.initial.sql b/SQL/oracle.initial.sql index 84f7a1f16..d32cc926f 100644 --- a/SQL/oracle.initial.sql +++ b/SQL/oracle.initial.sql @@ -20,7 +20,7 @@ BEFORE INSERT ON "users" FOR EACH ROW BEGIN :NEW."user_id" := "users_seq".nextval; END; - +/ CREATE TABLE "session" ( "sess_id" varchar(128) NOT NULL PRIMARY KEY, @@ -60,7 +60,7 @@ BEFORE INSERT ON "identities" FOR EACH ROW BEGIN :NEW."identity_id" := "identities_seq".nextval; END; - +/ CREATE TABLE "contacts" ( "contact_id" integer PRIMARY KEY, @@ -86,7 +86,7 @@ BEFORE INSERT ON "contacts" FOR EACH ROW BEGIN :NEW."contact_id" := "contacts_seq".nextval; END; - +/ CREATE TABLE "contactgroups" ( "contactgroup_id" integer PRIMARY KEY, @@ -107,7 +107,7 @@ BEFORE INSERT ON "contactgroups" FOR EACH ROW BEGIN :NEW."contactgroup_id" := "contactgroups_seq".nextval; END; - +/ CREATE TABLE "contactgroupmembers" ( "contactgroup_id" integer NOT NULL @@ -211,7 +211,7 @@ BEFORE INSERT ON "searches" FOR EACH ROW BEGIN :NEW."search_id" := "searches_seq".nextval; END; - +/ CREATE TABLE "system" ( "name" varchar(64) NOT NULL PRIMARY KEY, |