Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 8687:3912da70736b
(issue1796) We don't necessarily need the river Rhine. SedDB river names are purely optional.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 15 Apr 2015 17:30:27 +0200 |
| parents | cfafe5764509 |
| children |
comparison
equal
deleted
inserted
replaced
| 8686:9cbbaedc6cba | 8687:3912da70736b |
|---|---|
| 254 PRIMARY KEY (id), | 254 PRIMARY KEY (id), |
| 255 CHECK (a < b) | 255 CHECK (a < b) |
| 256 ); | 256 ); |
| 257 | 257 |
| 258 -- SEDDB_NAME | 258 -- SEDDB_NAME |
| 259 -- Lookup table for seddb river names | 259 -- Lookup table for optional matching with differing river names in SedDB |
| 260 -- Add name here and set rivers.seddb_name_id to id | |
| 260 CREATE TABLE seddb_name ( | 261 CREATE TABLE seddb_name ( |
| 261 id NUMBER(38,0) NOT NULL, | 262 id NUMBER(38,0) NOT NULL, |
| 262 name VARCHAR2(255) NOT NULL, | 263 name VARCHAR2(255) NOT NULL, |
| 263 PRIMARY KEY (id) | 264 PRIMARY KEY (id) |
| 264 ); | 265 ); |
| 265 INSERT INTO seddb_name (id, name) VALUES (0, 'Rhein'); | |
| 266 | |
| 267 | 266 |
| 268 -- RIVERS | 267 -- RIVERS |
| 269 CREATE SEQUENCE RIVERS_ID_SEQ; | 268 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 270 | 269 |
| 271 CREATE TABLE rivers ( | 270 CREATE TABLE rivers ( |