Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1202:44581b40b968
Schema: Added description column to the cross section table
flys-backend/trunk@2307 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 07 Jul 2011 15:20:19 +0000 |
| parents | 4e1b475a8cba |
| children | 3c01bef43a98 |
comparison
equal
deleted
inserted
replaced
| 1201:4e1b475a8cba | 1202:44581b40b968 |
|---|---|
| 267 CREATE TABLE cross_sections ( | 267 CREATE TABLE cross_sections ( |
| 268 id int PRIMARY KEY NOT NULL, | 268 id int PRIMARY KEY NOT NULL, |
| 269 km NUMERIC NOT NULL, | 269 km NUMERIC NOT NULL, |
| 270 river_id int NOT NULL REFERENCES rivers(id), | 270 river_id int NOT NULL REFERENCES rivers(id), |
| 271 time_interval_id int REFERENCES time_intervals(id), | 271 time_interval_id int REFERENCES time_intervals(id), |
| 272 UNIQUE (km, river_id) -- XXX: Maybe too hard? | 272 description VARCHAR(256) |
| 273 ); | 273 ); |
| 274 | 274 |
| 275 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; | 275 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; |
| 276 | 276 |
| 277 CREATE TABLE cross_section_points ( | 277 CREATE TABLE cross_section_points ( |