diff flys-backend/doc/schema/sqlite.sql @ 164:324e12ab7a05

Converted schema to be PostgreSQL compatible. flys-backend/trunk@1441 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Mar 2011 14:07:15 +0000
parents 4a3b2912a0cd
children 15d515fe15f5
line wrap: on
line diff
--- a/flys-backend/doc/schema/sqlite.sql	Wed Mar 09 09:41:01 2011 +0000
+++ b/flys-backend/doc/schema/sqlite.sql	Wed Mar 09 14:07:15 2011 +0000
@@ -15,7 +15,7 @@
 -- segments from/to at a river
 CREATE TABLE ranges (
     id       INTEGER PRIMARY KEY NOT NULL,
-    river_id INTEGER NOT NULL REFERENCES river(id),
+    river_id INTEGER NOT NULL REFERENCES rivers(id),
     a        NUMERIC NOT NULL,
     b        NUMERIC,
     UNIQUE (river_id, a, b)
@@ -40,7 +40,7 @@
 CREATE TABLE gauges (
     id           INTEGER PRIMARY KEY NOT NULL,
     name         VARCHAR(256)        NOT NULL,
-    river_id     INTEGER             NOT NULL REFERENCES river(id),
+    river_id     INTEGER             NOT NULL REFERENCES rivers(id),
     station      NUMERIC             NOT NULL UNIQUE,
     aeo          NUMERIC             NOT NULL,
 
@@ -111,7 +111,7 @@
 -- WST files
 CREATE TABLE wst (
     id             INTEGER PRIMARY KEY NOT NULL,
-    river_id       INTEGER NOT NULL REFERENCES river(id),
+    river_id       INTEGER NOT NULL REFERENCES rivers(id),
     description    VARCHAR(256) NOT NULL,
     -- TODO: more meta infos
     UNIQUE (river_id, description)

http://dive4elements.wald.intevation.org