Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.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 | 71b17f731762 |
comparison
equal
deleted
inserted
replaced
| 8686:9cbbaedc6cba | 8687:3912da70736b |
|---|---|
| 6 id int PRIMARY KEY NOT NULL, | 6 id int PRIMARY KEY NOT NULL, |
| 7 name VARCHAR(32) NOT NULL UNIQUE | 7 name VARCHAR(32) NOT NULL UNIQUE |
| 8 ); | 8 ); |
| 9 | 9 |
| 10 -- SEDDB_NAME | 10 -- SEDDB_NAME |
| 11 -- Lookup table for seddb river names | 11 -- Lookup table for optional matching with differing river names in SedDB |
| 12 | 12 -- Add name here and set rivers.seddb_name_id to id |
| 13 CREATE TABLE seddb_name ( | 13 CREATE TABLE seddb_name ( |
| 14 id int PRIMARY KEY NOT NULL, | 14 id int PRIMARY KEY NOT NULL, |
| 15 name VARCHAR(256) NOT NULL | 15 name VARCHAR(256) NOT NULL |
| 16 ); | 16 ); |
| 17 INSERT INTO seddb_name (id, name) VALUES (0, 'Rhein'); | |
| 18 | 17 |
| 19 -- Gewaesser | 18 -- Gewaesser |
| 20 CREATE SEQUENCE RIVERS_ID_SEQ; | 19 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 21 | 20 |
| 22 CREATE TABLE rivers ( | 21 CREATE TABLE rivers ( |