Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql.sql Thu May 16 12:34:23 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Thu May 16 16:14:28 2013 +0200 @@ -293,8 +293,8 @@ CREATE TABLE cross_sections ( id int PRIMARY KEY NOT NULL, - river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, - time_interval_id int REFERENCES time_intervals(id), + river_id int NOT NULL REFERENCES rivers(id) ON DELETE CASCADE, + time_interval_id int REFERENCES time_intervals(id), description VARCHAR(256) );