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,

http://dive4elements.wald.intevation.org