Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6502:3b93f439e954 double-precision
Schema change: add new field 'source' to wst_columns, currently only for official lines
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 28 Jun 2013 16:58:46 +0200 |
| parents | 0711ce5ca701 |
| children | 63a24b4fbebf |
comparison
equal
deleted
inserted
replaced
| 6481:5910ada51a9f | 6502:3b93f439e954 |
|---|---|
| 199 CREATE TABLE wst_columns ( | 199 CREATE TABLE wst_columns ( |
| 200 id int PRIMARY KEY NOT NULL, | 200 id int PRIMARY KEY NOT NULL, |
| 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 source VARCHAR(256), | |
| 204 position int NOT NULL DEFAULT 0, | 205 position int NOT NULL DEFAULT 0, |
| 205 | 206 |
| 206 time_interval_id int REFERENCES time_intervals(id), | 207 time_interval_id int REFERENCES time_intervals(id), |
| 207 | 208 |
| 208 UNIQUE (wst_id, name), | 209 UNIQUE (wst_id, name), |