Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 7741:69c8d33a05e8
SCHEMA CHANGE: renamed uuid-column to avoid collision with data type.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 06 Feb 2014 15:04:29 +0100 |
| parents | 44a9233c62eb |
| children | a67bd7744827 |
comparison
equal
deleted
inserted
replaced
| 7739:44a9233c62eb | 7741:69c8d33a05e8 |
|---|---|
| 260 -- RIVERS | 260 -- RIVERS |
| 261 CREATE SEQUENCE RIVERS_ID_SEQ; | 261 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 262 | 262 |
| 263 CREATE TABLE rivers ( | 263 CREATE TABLE rivers ( |
| 264 id NUMBER(38,0) NOT NULL, | 264 id NUMBER(38,0) NOT NULL, |
| 265 uuid CHAR(37 CHAR), | 265 model_uuid CHAR(37 CHAR), |
| 266 official_number NUMBER(38,0), | 266 official_number NUMBER(38,0), |
| 267 km_up NUMBER(38,0) DEFAULT 0 NOT NULL, | 267 km_up NUMBER(38,0) DEFAULT 0 NOT NULL, |
| 268 name VARCHAR2(255) NOT NULL UNIQUE, | 268 name VARCHAR2(255) NOT NULL UNIQUE, |
| 269 wst_unit_id NUMBER(38,0) NOT NULL, | 269 wst_unit_id NUMBER(38,0) NOT NULL, |
| 270 PRIMARY KEY (id) | 270 PRIMARY KEY (id) |