Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle.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 | eaa630838705 |
children | 88cbe798cbab |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle.sql Fri Mar 15 11:04:13 2013 +0100 +++ b/flys-backend/doc/schema/oracle.sql Fri Mar 15 16:43:00 2013 +0100 @@ -246,11 +246,7 @@ river_id NUMBER(38,0), PRIMARY KEY (id) ); -CREATE OR REPLACE TRIGGER ranges_trigger BEFORE INSERT ON ranges FOR EACH ROW - BEGIN - SELECT RANGES_ID_SEQ.nextval INTO :new.id FROM dual; - END; -/ + -- RIVERS @@ -276,11 +272,6 @@ PRIMARY KEY (id), CHECK (start_time <= stop_time) ); -CREATE OR REPLACE TRIGGER time_intervals_trigger BEFORE INSERT ON time_intervals FOR EACH ROW - BEGIN - SELECT TIME_INTERVALS_ID_SEQ.nextval INTO :new.id FROM dual; - END; -/ --- UNITS