Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6011:d9a1cf0438a5
backout 6009:6ea171b6d8d2 because this was only really valid for fixations
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 13 May 2013 18:21:55 +0200 |
| parents | 6ea171b6d8d2 |
| children | d12f920bbf00 |
comparison
equal
deleted
inserted
replaced
| 6009:6ea171b6d8d2 | 6011:d9a1cf0438a5 |
|---|---|
| 201 wst_id int NOT NULL REFERENCES wsts(id) ON DELETE CASCADE, | 201 wst_id int NOT NULL REFERENCES wsts(id) ON DELETE CASCADE, |
| 202 name VARCHAR(256) NOT NULL, | 202 name VARCHAR(256) NOT NULL, |
| 203 description VARCHAR(256), | 203 description VARCHAR(256), |
| 204 position int NOT NULL DEFAULT 0, | 204 position int NOT NULL DEFAULT 0, |
| 205 | 205 |
| 206 time_interval_id int NOT NULL REFERENCES time_intervals(id), | 206 time_interval_id int REFERENCES time_intervals(id), |
| 207 | 207 |
| 208 UNIQUE (wst_id, name), | 208 UNIQUE (wst_id, name), |
| 209 UNIQUE (wst_id, position) | 209 UNIQUE (wst_id, position) |
| 210 ); | 210 ); |
| 211 | 211 |