summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2014-10-27 11:19:53 (GMT)
committerAleksander Machniak <alec@alec.pl>2014-10-27 11:20:37 (GMT)
commit49a78e8675819c1194b9579f93bb0d5e1c13c99f (patch)
tree06c6b0931c133a2e74c34becff4301bc8e22647b
parent5735a3439dad86af05e6649bc8b42c67a0e119a2 (diff)
downloadkolab-wap-49a78e8675819c1194b9579f93bb0d5e1c13c99f.tar.gz
Fix so sql script for Oracle can be executed in SQLPlus (#3788)
-rw-r--r--doc/kolab_wap.oracle.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/kolab_wap.oracle.sql b/doc/kolab_wap.oracle.sql
index f08d89c..9caca2f 100644
--- a/doc/kolab_wap.oracle.sql
+++ b/doc/kolab_wap.oracle.sql
@@ -20,6 +20,7 @@ BEGIN
:NEW."id" := "group_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "group_types" ("id", "key", "name", "description", "attributes", "is_default")
@@ -69,6 +70,7 @@ BEGIN
:NEW."id" := "ou_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "ou_types" ("id", "key", "name", "description", "attributes", "is_default")
@@ -97,6 +99,7 @@ BEGIN
:NEW."id" := "resource_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "resource_types" ("id", "key", "name", "description", "attributes", "is_default")
@@ -133,6 +136,7 @@ BEGIN
:NEW."id" := "role_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "role_types" ("id", "key", "name", "description", "attributes", "is_default")
@@ -160,6 +164,7 @@ BEGIN
:NEW."id" := "sharedfolder_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "sharedfolder_types" ("id", "key", "name", "description", "attributes", "is_default")
@@ -200,6 +205,7 @@ BEGIN
:NEW."id" := "user_types_seq".nextval;
END IF;
END;
+/
INSERT ALL
INTO "user_types" ("id", "key", "name", "description", "attributes", "used_for", "is_default")