diff db_schema/stammdaten_schema.sql @ 988:5efb32a41b24

Fix CHECK-Constraint definition.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jul 2016 10:32:44 +0200
parents 35878d9b4321
children 302f800ba588 299f4ba86090
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Wed Jun 29 19:23:50 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Fri Jul 01 10:32:44 2016 +0200
@@ -656,9 +656,9 @@
     header character varying(50) NOT NULL,
     width integer,
     flex boolean,
-    index integer
+    index integer,
+    UNIQUE (query_id, data_index)
 );
-ALTER TABLE result ADD CONSTRAINT data_index_query_id UNIQUE (query_id, data_index)
 
 ALTER SEQUENCE result_id_seq OWNED BY result.id;
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)