Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6030:d12f920bbf00
Schema change: Add missing constraints to cross sections in Oracle, cosmetics
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 16 May 2013 16:14:28 +0200 |
| parents | d9a1cf0438a5 |
| children | 176664f84d86 |
comparison
equal
deleted
inserted
replaced
| 6029:f9c5e1a8032d | 6030:d12f920bbf00 |
|---|---|
| 291 | 291 |
| 292 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ; | 292 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ; |
| 293 | 293 |
| 294 CREATE TABLE cross_sections ( | 294 CREATE TABLE cross_sections ( |
| 295 id int PRIMARY KEY NOT NULL, | 295 id int PRIMARY KEY NOT NULL, |
| 296 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, | 296 river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, |
| 297 time_interval_id int REFERENCES time_intervals(id), | 297 time_interval_id int REFERENCES time_intervals(id), |
| 298 description VARCHAR(256) | 298 description VARCHAR(256) |
| 299 ); | 299 ); |
| 300 | 300 |
| 301 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; | 301 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; |
| 302 | 302 |