diff backend/doc/schema/oracle.sql @ 5915:4fafe8d147b2

Schema change: named_main_values.name is not unique, as we can have the same name for different types
author Tom Gottfried <tom@intevation.de>
date Tue, 07 May 2013 18:19:57 +0200
parents 39cf5d4acf5d
children 131f5f58ff7d
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Tue May 07 17:32:33 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Tue May 07 18:19:57 2013 +0200
@@ -226,7 +226,7 @@
 
 CREATE TABLE named_main_values (
     id                  NUMBER(38,0) NOT NULL,
-    name                VARCHAR2(256) NOT NULL UNIQUE,
+    name                VARCHAR2(256) NOT NULL,
     type_id             NUMBER(38,0) NOT NULL,
     PRIMARY KEY (id)
 );

http://dive4elements.wald.intevation.org