Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6642:b1fa193fa5db double-precision
Schema change: droped NOT NULL constraint from attributes.value because empty string is silently converted to NULL in Oracle but needed here.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 23 Jul 2013 18:05:11 +0200 |
| parents | 97145ec4e33c |
| children | 839f1a889c4a |
comparison
equal
deleted
inserted
replaced
| 6636:45e6635ef7f5 | 6642:b1fa193fa5db |
|---|---|
| 25 -- ATTRIBUTES | 25 -- ATTRIBUTES |
| 26 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; | 26 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; |
| 27 | 27 |
| 28 CREATE TABLE attributes ( | 28 CREATE TABLE attributes ( |
| 29 id NUMBER(38,0) NOT NULL, | 29 id NUMBER(38,0) NOT NULL, |
| 30 value VARCHAR2(255) NOT NULL UNIQUE, | 30 value VARCHAR2(255) UNIQUE, |
| 31 primary key (id) | 31 primary key (id) |
| 32 ); | 32 ); |
| 33 | 33 -- value can not be NOT NULL in Oracle: |
| 34 -- '' is needed here and silently converted to NULL in Oracle | |
| 34 | 35 |
| 35 -- CROSS_SECTION_LINES | 36 -- CROSS_SECTION_LINES |
| 36 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; | 37 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; |
| 37 | 38 |
| 38 CREATE TABLE cross_section_lines ( | 39 CREATE TABLE cross_section_lines ( |