Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle.sql @ 5206:8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Comment is a reserved keyword in oracle. This also fixes a typo in the table
name of time_intervals.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Fri, 08 Mar 2013 15:16:00 +0100 |
parents | a9658d43b621 |
children | 2919cdc4e858 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle.sql Fri Mar 08 13:06:40 2013 +0100 +++ b/flys-backend/doc/schema/oracle.sql Fri Mar 08 15:16:00 2013 +0100 @@ -261,7 +261,7 @@ -- TIME_INTERVALS CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; -CREATE TABLE time_intervals_ ( +CREATE TABLE time_intervals ( id NUMBER(38,0) NOT NULL, start_time TIMESTAMP NOT NULL, stop_time TIMESTAMP,