Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1205:5f1506fc7636
Made import of cross sections work.
flys-backend/trunk@2313 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 08 Jul 2011 09:45:48 +0000 |
| parents | 3c01bef43a98 |
| children | c12b5fbd33e8 |
comparison
equal
deleted
inserted
replaced
| 1204:22858e7cca79 | 1205:5f1506fc7636 |
|---|---|
| 269 river_id int NOT NULL REFERENCES rivers(id), | 269 river_id int NOT NULL REFERENCES rivers(id), |
| 270 time_interval_id int REFERENCES time_intervals(id), | 270 time_interval_id int REFERENCES time_intervals(id), |
| 271 description VARCHAR(256) | 271 description VARCHAR(256) |
| 272 ); | 272 ); |
| 273 | 273 |
| 274 CREATE SEQUENCE CROSS_SECTION_LINES_SEQ; | 274 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; |
| 275 | 275 |
| 276 CREATE TABLE cross_section_lines ( | 276 CREATE TABLE cross_section_lines ( |
| 277 id int PRIMARY KEY NOT NULL, | 277 id int PRIMARY KEY NOT NULL, |
| 278 km NUMERIC NOT NULL, | 278 km NUMERIC NOT NULL, |
| 279 cross_section_id int NOT NULL REFERENCES cross_sections(id), | 279 cross_section_id int NOT NULL REFERENCES cross_sections(id), |