Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 471:3570e4af8cb2
Added 'position' column to wst_columns to allow order them by there column position in the original wst file.
flys-backend/trunk@1710 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2011 16:06:15 +0000 |
| parents | f4afea9b7537 |
| children | 77f337650211 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Apr 15 15:28:35 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Fri Apr 15 16:06:15 2011 +0000 @@ -153,10 +153,12 @@ wst_id int NOT NULL REFERENCES wsts(id), name VARCHAR(256) NOT NULL, description VARCHAR(256), + position int NOT NULL DEFAULT 0, time_interval_id int REFERENCES time_intervals(id), - UNIQUE (wst_id, name) + UNIQUE (wst_id, name), + UNIQUE (wst_id, position) ); -- w values in WST file column