Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5297:4f3cc1aebcc0 | 5298:eaa630838705 |
|---|---|
| 123 id int PRIMARY KEY NOT NULL, | 123 id int PRIMARY KEY NOT NULL, |
| 124 start_time TIMESTAMP NOT NULL, | 124 start_time TIMESTAMP NOT NULL, |
| 125 stop_time TIMESTAMP, | 125 stop_time TIMESTAMP, |
| 126 CHECK (start_time <= stop_time) | 126 CHECK (start_time <= stop_time) |
| 127 ); | 127 ); |
| 128 ALTER TABLE time_intervals ALTER COLUMN id SET DEFAULT NEXTVAL('TIME_INTERVALS_ID_SEQ'); | |
| 129 | |
| 128 | 130 |
| 129 -- Stammdaten | 131 -- Stammdaten |
| 130 CREATE SEQUENCE MAIN_VALUES_ID_SEQ; | 132 CREATE SEQUENCE MAIN_VALUES_ID_SEQ; |
| 131 | 133 |
| 132 CREATE TABLE main_values ( | 134 CREATE TABLE main_values ( |