Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle.sql @ 2855:9c2424073be0
Made SQL instructions upper case.
flys-backend/trunk@4315 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 27 Apr 2012 07:18:45 +0000 |
| parents | fe89d6cf55fb |
| children | c3e049961685 |
comparison
equal
deleted
inserted
replaced
| 2854:89b097c8ebd7 | 2855:9c2424073be0 |
|---|---|
| 55 PRIMARY KEY (id) | 55 PRIMARY KEY (id) |
| 56 ); | 56 ); |
| 57 | 57 |
| 58 | 58 |
| 59 -- CROSS_SECTIONS | 59 -- CROSS_SECTIONS |
| 60 create sequence CROSS_SECTIONS_ID_SEQ; | 60 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ; |
| 61 | 61 |
| 62 create table cross_sections ( | 62 CREATE TABLE cross_sections ( |
| 63 id NUMBER(38,0) NOT NULL, | 63 id NUMBER(38,0) NOT NULL, |
| 64 description VARCHAR2(255), | 64 description VARCHAR2(255), |
| 65 river_id NUMBER(38,0), | 65 river_id NUMBER(38,0), |
| 66 time_interval_id NUMBER(38,0), | 66 time_interval_id NUMBER(38,0), |
| 67 PRIMARY KEY (id) | 67 PRIMARY KEY (id) |