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;

http://dive4elements.wald.intevation.org