changeset 6367:a8b065038c0c

Backend: Fixed Oracle scheme for official lines.
author Sascha L. Teichmann <teichmann@intevation.de>
date Tue, 18 Jun 2013 17:28:27 +0200
parents 4c791a458305
children 791c7492b4ee
files backend/doc/schema/oracle.sql
diffstat 1 files changed, 2 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Mon Jun 17 21:51:04 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Tue Jun 18 17:28:27 2013 +0200
@@ -351,9 +351,8 @@
     id                  NUMBER(38,0) NOT NULL,
     wst_column_id       NUMBER(38,0) NOT NULL,
     named_main_value_id NUMBER(38,0) NOT NULL,
-
-    PRIMARY KEY (id),
-    UNIQUE (wst_column_id, named_main_value_id)
+    UNIQUE (wst_column_id, named_main_value_id),
+    PRIMARY KEY (id)
 );
 
 -- WSTS

http://dive4elements.wald.intevation.org