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),

http://dive4elements.wald.intevation.org