Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6367:a8b065038c0c
Backend: Fixed Oracle scheme for official lines.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 18 Jun 2013 17:28:27 +0200 |
| parents | 0711ce5ca701 |
| children | 3b93f439e954 |
comparison
equal
deleted
inserted
replaced
| 6356:4c791a458305 | 6367:a8b065038c0c |
|---|---|
| 349 | 349 |
| 350 CREATE TABLE official_lines ( | 350 CREATE TABLE official_lines ( |
| 351 id NUMBER(38,0) NOT NULL, | 351 id NUMBER(38,0) NOT NULL, |
| 352 wst_column_id NUMBER(38,0) NOT NULL, | 352 wst_column_id NUMBER(38,0) NOT NULL, |
| 353 named_main_value_id NUMBER(38,0) NOT NULL, | 353 named_main_value_id NUMBER(38,0) NOT NULL, |
| 354 | 354 UNIQUE (wst_column_id, named_main_value_id), |
| 355 PRIMARY KEY (id), | 355 PRIMARY KEY (id) |
| 356 UNIQUE (wst_column_id, named_main_value_id) | |
| 357 ); | 356 ); |
| 358 | 357 |
| 359 -- WSTS | 358 -- WSTS |
| 360 --lookup table for wst kinds | 359 --lookup table for wst kinds |
| 361 CREATE TABLE wst_kinds ( | 360 CREATE TABLE wst_kinds ( |