Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-minfo.sql @ 5321:6dd354e7abfc
SCHEMA CHANGE: removed bad triggers and foreign keys from schema
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 15 Mar 2013 16:43:00 +0100 |
parents | 911f62917753 |
children | e88d55d01cf5 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql Fri Mar 15 11:04:13 2013 +0100 +++ b/flys-backend/doc/schema/oracle-minfo.sql Fri Mar 15 16:43:00 2013 +0100 @@ -192,11 +192,9 @@ CREATE TABLE flow_velocity_model ( id NUMBER(38,0) NOT NULL, - river_id NUMBER(38,0) NOT NULL, discharge_zone_id NUMBER(38,0) NOT NULL, description VARCHAR(256), PRIMARY KEY (id), - CONSTRAINT fk_fvm_river_id FOREIGN KEY (river_id) REFERENCES rivers(id), CONSTRAINT fk_fvm_discharge_zone_id FOREIGN KEY (discharge_zone_id) REFERENCES discharge_zone (id) ); @@ -250,9 +248,7 @@ name VARCHAR(64) NOT NULL, lower NUMBER(38,3), upper NUMBER(38,3), - unit_id NUMBER(38,0), PRIMARY KEY (id), - CONSTRAINT fk_gf_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) );