Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6009:6ea171b6d8d2
Schema change because WST-columns without time interval are useless
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 13 May 2013 17:48:32 +0200 |
| parents | 131f5f58ff7d |
| children | d9a1cf0438a5 |
comparison
equal
deleted
inserted
replaced
| 6008:a45da06797c7 | 6009:6ea171b6d8d2 |
|---|---|
| 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 REFERENCES time_intervals(id), | 206 time_interval_id int NOT NULL 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 |