Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 2346:f834b411ca57
Added db table, model class and importer stuff for units.
flys-backend/trunk@2877 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 04 Oct 2011 06:47:00 +0000 |
| parents | 1dbafbba50ea |
| children | 0acf28a3d28a |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Tue Oct 04 05:06:10 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Tue Oct 04 06:47:00 2011 +0000 @@ -17,6 +17,13 @@ value VARCHAR(256) NOT NULL UNIQUE ); +CREATE SEQUENCE UNITS_ID_SEQ; + +CREATE TABLE units ( + id int PRIMARY KEY NOT NULL, + name VARCHAR(32) NOT NULL UNIQUE +); + -- segments from/to at a river CREATE SEQUENCE RANGES_ID_SEQ; @@ -162,6 +169,7 @@ river_id int NOT NULL REFERENCES rivers(id), description VARCHAR(256) NOT NULL, kind int NOT NULL DEFAULT 0, + unit_id int NOT NULL REFERENCES units(id), -- TODO: more meta infos UNIQUE (river_id, description) );