diff flys-backend/doc/schema/postgresql.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/postgresql.sql	Fri Mar 15 11:04:13 2013 +0100
+++ b/flys-backend/doc/schema/postgresql.sql	Fri Mar 15 16:43:00 2013 +0100
@@ -36,7 +36,6 @@
     b        NUMERIC,
     UNIQUE (river_id, a, b)
 );
-ALTER TABLE ranges ALTER COLUMN id SET DEFAULT NEXTVAL('RANGES_ID_SEQ');
 
 
 -- Lage 'links', 'rechts', etc.
@@ -125,7 +124,6 @@
     stop_time  TIMESTAMP,
     CHECK (start_time <= stop_time)
 );
-ALTER TABLE time_intervals ALTER COLUMN id SET DEFAULT NEXTVAL('TIME_INTERVALS_ID_SEQ');
 
 
 -- Stammdaten

http://dive4elements.wald.intevation.org