Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Fri May 03 13:06:14 2013 +0200 +++ b/backend/doc/schema/oracle.sql Fri May 03 13:15:28 2013 +0200 @@ -78,7 +78,7 @@ CREATE TABLE discharge_table_values ( id NUMBER(38,0) NOT NULL, - q NUMBER(38,2) NOT NULL, + q NUMBER(38,4) NOT NULL, w NUMBER(38,2) NOT NULL, table_id NUMBER(38,0) NOT NULL, UNIQUE (table_id, q, w),