Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6410:df867072d003 double-precision
merge changes from default into double-precision branch
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Mon, 24 Jun 2013 15:24:07 +0200 |
parents | a8b065038c0c |
children | 3b93f439e954 |
comparison
equal
deleted
inserted
replaced
6387:b95504c34060 | 6410:df867072d003 |
---|---|
349 | 349 |
350 CREATE TABLE official_lines ( | 350 CREATE TABLE official_lines ( |
351 id NUMBER(38,0) NOT NULL, | 351 id NUMBER(38,0) NOT NULL, |
352 wst_column_id NUMBER(38,0) NOT NULL, | 352 wst_column_id NUMBER(38,0) NOT NULL, |
353 named_main_value_id NUMBER(38,0) NOT NULL, | 353 named_main_value_id NUMBER(38,0) NOT NULL, |
354 | 354 UNIQUE (wst_column_id, named_main_value_id), |
355 PRIMARY KEY (id), | 355 PRIMARY KEY (id) |
356 UNIQUE (wst_column_id, named_main_value_id) | |
357 ); | 356 ); |
358 | 357 |
359 -- WSTS | 358 -- WSTS |
360 --lookup table for wst kinds | 359 --lookup table for wst kinds |
361 CREATE TABLE wst_kinds ( | 360 CREATE TABLE wst_kinds ( |