Mercurial > dive4elements > river
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 |