diff flys-backend/doc/schema/oracle.sql @ 5684:88cbe798cbab

Schema change: fixed constraints
author Tom Gottfried <tom@intevation.de>
date Fri, 12 Apr 2013 16:13:23 +0200
parents 6dd354e7abfc
children 153456f84602
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle.sql	Fri Apr 12 15:08:14 2013 +0200
+++ b/flys-backend/doc/schema/oracle.sql	Fri Apr 12 16:13:23 2013 +0200
@@ -220,7 +220,7 @@
 
 CREATE TABLE named_main_values (
     id                  NUMBER(38,0) NOT NULL,
-    name                VARCHAR2(255),
+    name                VARCHAR2(256) NOT NULL UNIQUE,
     type_id             NUMBER(38,0),
     PRIMARY KEY (id)
 );

http://dive4elements.wald.intevation.org