comparison backend/doc/schema/oracle.sql @ 6011:d9a1cf0438a5

backout 6009:6ea171b6d8d2 because this was only really valid for fixations
author Tom Gottfried <tom@intevation.de>
date Mon, 13 May 2013 18:21:55 +0200
parents 6ea171b6d8d2
children d12f920bbf00
comparison
equal deleted inserted replaced
6009:6ea171b6d8d2 6011:d9a1cf0438a5
323 CREATE TABLE wst_columns ( 323 CREATE TABLE wst_columns (
324 id NUMBER(38,0) NOT NULL, 324 id NUMBER(38,0) NOT NULL,
325 description VARCHAR2(255), 325 description VARCHAR2(255),
326 name VARCHAR2(255) NOT NULL, 326 name VARCHAR2(255) NOT NULL,
327 position NUMBER(38,0) NOT NULL DEFAULT 0, 327 position NUMBER(38,0) NOT NULL DEFAULT 0,
328 time_interval_id NUMBER(38,0) NOT NULL, 328 time_interval_id NUMBER(38,0),
329 wst_id NUMBER(38,0) NOT NULL, 329 wst_id NUMBER(38,0) NOT NULL,
330 UNIQUE (wst_id, name), 330 UNIQUE (wst_id, name),
331 UNIQUE (wst_id, position), 331 UNIQUE (wst_id, position),
332 PRIMARY KEY (id) 332 PRIMARY KEY (id)
333 ); 333 );

http://dive4elements.wald.intevation.org