Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 5897:39cf5d4acf5d
Schema change: increased precision of discharge_table_values.q to allow unique import of higher precision values
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 03 May 2013 13:15:28 +0200 |
| parents | 62e6598a2c4b |
| children | 4fafe8d147b2 |
comparison
equal
deleted
inserted
replaced
| 5896:45871a108aae | 5897:39cf5d4acf5d |
|---|---|
| 76 -- DISCHARGE_TABLE_VALUES | 76 -- DISCHARGE_TABLE_VALUES |
| 77 CREATE SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; | 77 CREATE SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ; |
| 78 | 78 |
| 79 CREATE TABLE discharge_table_values ( | 79 CREATE TABLE discharge_table_values ( |
| 80 id NUMBER(38,0) NOT NULL, | 80 id NUMBER(38,0) NOT NULL, |
| 81 q NUMBER(38,2) NOT NULL, | 81 q NUMBER(38,4) NOT NULL, |
| 82 w NUMBER(38,2) NOT NULL, | 82 w NUMBER(38,2) NOT NULL, |
| 83 table_id NUMBER(38,0) NOT NULL, | 83 table_id NUMBER(38,0) NOT NULL, |
| 84 UNIQUE (table_id, q, w), | 84 UNIQUE (table_id, q, w), |
| 85 PRIMARY KEY (id) | 85 PRIMARY KEY (id) |
| 86 ); | 86 ); |