Mercurial > dive4elements > river
changeset 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 | 9cbbaedc6cba |
| children | e1186c5ab169 |
| files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 4 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Tue Apr 14 17:57:09 2015 +0200 +++ b/backend/doc/schema/oracle.sql Wed Apr 15 17:30:27 2015 +0200 @@ -256,14 +256,13 @@ ); -- SEDDB_NAME --- Lookup table for seddb river names +-- Lookup table for optional matching with differing river names in SedDB +-- Add name here and set rivers.seddb_name_id to id CREATE TABLE seddb_name ( id NUMBER(38,0) NOT NULL, name VARCHAR2(255) NOT NULL, PRIMARY KEY (id) ); -INSERT INTO seddb_name (id, name) VALUES (0, 'Rhein'); - -- RIVERS CREATE SEQUENCE RIVERS_ID_SEQ;
--- a/backend/doc/schema/postgresql.sql Tue Apr 14 17:57:09 2015 +0200 +++ b/backend/doc/schema/postgresql.sql Wed Apr 15 17:30:27 2015 +0200 @@ -8,13 +8,12 @@ ); -- SEDDB_NAME --- Lookup table for seddb river names - +-- Lookup table for optional matching with differing river names in SedDB +-- Add name here and set rivers.seddb_name_id to id CREATE TABLE seddb_name ( id int PRIMARY KEY NOT NULL, name VARCHAR(256) NOT NULL ); -INSERT INTO seddb_name (id, name) VALUES (0, 'Rhein'); -- Gewaesser CREATE SEQUENCE RIVERS_ID_SEQ;