Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5205:31fd42400c84 | 5206:8667f629d238 |
|---|---|
| 259 | 259 |
| 260 | 260 |
| 261 -- TIME_INTERVALS | 261 -- TIME_INTERVALS |
| 262 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; | 262 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; |
| 263 | 263 |
| 264 CREATE TABLE time_intervals_ ( | 264 CREATE TABLE time_intervals ( |
| 265 id NUMBER(38,0) NOT NULL, | 265 id NUMBER(38,0) NOT NULL, |
| 266 start_time TIMESTAMP NOT NULL, | 266 start_time TIMESTAMP NOT NULL, |
| 267 stop_time TIMESTAMP, | 267 stop_time TIMESTAMP, |
| 268 PRIMARY KEY (id), | 268 PRIMARY KEY (id), |
| 269 CHECK (start_time <= stop_time) | 269 CHECK (start_time <= stop_time) |