Mercurial > dive4elements > river
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)