Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5683:545a6ace9a19 | 5684:88cbe798cbab |
|---|---|
| 218 -- NAMED_MAIN_VALUES | 218 -- NAMED_MAIN_VALUES |
| 219 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; | 219 CREATE SEQUENCE NAMED_MAIN_VALUES_ID_SEQ; |
| 220 | 220 |
| 221 CREATE TABLE named_main_values ( | 221 CREATE TABLE named_main_values ( |
| 222 id NUMBER(38,0) NOT NULL, | 222 id NUMBER(38,0) NOT NULL, |
| 223 name VARCHAR2(255), | 223 name VARCHAR2(256) NOT NULL UNIQUE, |
| 224 type_id NUMBER(38,0), | 224 type_id NUMBER(38,0), |
| 225 PRIMARY KEY (id) | 225 PRIMARY KEY (id) |
| 226 ); | 226 ); |
| 227 | 227 |
| 228 | 228 |