diff 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
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;

http://dive4elements.wald.intevation.org