Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 5298:eaa630838705
trigger sequence of time_interval IDs in DB as it is not used by hibernate only anymore
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 13:39:54 +0100 |
| parents | 4f3cc1aebcc0 |
| children | 6dd354e7abfc |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Thu Mar 14 13:32:02 2013 +0100 +++ b/flys-backend/doc/schema/postgresql.sql Thu Mar 14 13:39:54 2013 +0100 @@ -125,6 +125,8 @@ stop_time TIMESTAMP, CHECK (start_time <= stop_time) ); +ALTER TABLE time_intervals ALTER COLUMN id SET DEFAULT NEXTVAL('TIME_INTERVALS_ID_SEQ'); + -- Stammdaten CREATE SEQUENCE MAIN_VALUES_ID_SEQ;