# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1429111827 -7200
# Node ID 3912da70736b0f83c7f94aba84e181d66753be67
# Parent  9cbbaedc6cba57e77d3fc4985c756e9303129b1e
(issue1796) We don't necessarily need the river Rhine. SedDB river names are purely optional.

diff -r 9cbbaedc6cba -r 3912da70736b backend/doc/schema/oracle.sql
--- 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;
diff -r 9cbbaedc6cba -r 3912da70736b backend/doc/schema/postgresql.sql
--- 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;