diff flys-backend/doc/schema/postgresql-minfo.sql @ 5684:88cbe798cbab

Schema change: fixed constraints
author Tom Gottfried <tom@intevation.de>
date Fri, 12 Apr 2013 16:13:23 +0200
parents db6c7268b08e
children e89d922df8ae
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Fri Apr 12 15:08:14 2013 +0200
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Fri Apr 12 16:13:23 2013 +0200
@@ -331,6 +331,6 @@
     cduan                  NUMERIC,
     PRIMARY KEY (id),
     CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE,
-    CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id)
+    CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) ON DELETE CASCADE
 );
 COMMIT;

http://dive4elements.wald.intevation.org