comparison 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
comparison
equal deleted inserted replaced
5914:1058b3436dad 5915:4fafe8d147b2
224 -- NAMED_MAIN_VALUES 224 -- NAMED_MAIN_VALUES
225 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; 225 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
226 226
227 CREATE TABLE named_main_values ( 227 CREATE TABLE named_main_values (
228 id NUMBER(38,0) NOT NULL, 228 id NUMBER(38,0) NOT NULL,
229 name VARCHAR2(256) NOT NULL UNIQUE, 229 name VARCHAR2(256) NOT NULL,
230 type_id NUMBER(38,0) NOT NULL, 230 type_id NUMBER(38,0) NOT NULL,
231 PRIMARY KEY (id) 231 PRIMARY KEY (id)
232 ); 232 );
233 233
234 234

http://dive4elements.wald.intevation.org