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)

http://dive4elements.wald.intevation.org