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

http://dive4elements.wald.intevation.org