changeset 2353:67e0371f6f40

Adjusted NUMBER format for units, positions and cross_section_points tables. flys-backend/trunk@2986 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Schilberg <bjoern@intevation.de>
date Mon, 17 Oct 2011 12:10:12 +0000 (2011-10-17)
parents 8126ccb58f28
children 40093215061b
files flys-backend/ChangeLog flys-backend/doc/schema/oracle.sql
diffstat 2 files changed, 8 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Tue Oct 11 07:29:53 2011 +0000
+++ b/flys-backend/ChangeLog	Mon Oct 17 12:10:12 2011 +0000
@@ -1,3 +1,8 @@
+2011-10-17  Bjoern Schilberg <bjoern.schilberg@intevation.de>
+
+	* doc/schema/oracle.sql:
+	  Adjusted NUMBER format for units, positions and cross_section_points tables.
+
 2011-10-10  Bjoern Schilberg <bjoern.schilberg@intevation.de>
 
 	* doc/schema/oracle.sql:
--- a/flys-backend/doc/schema/oracle.sql	Tue Oct 11 07:29:53 2011 +0000
+++ b/flys-backend/doc/schema/oracle.sql	Mon Oct 17 12:10:12 2011 +0000
@@ -73,7 +73,7 @@
     col_pos                 NUMBER(38,0),
     x                       NUMBER(38,2),
     y                       NUMBER(38,2),
-    cross_section_line_id   NUMBER(10,0),
+    cross_section_line_id   NUMBER(38,0),
     PRIMARY KEY             (id)
 );
 
@@ -323,7 +323,7 @@
 CREATE SEQUENCE POSITIONS_ID_SEQ;
 
 CREATE TABLE positions (
-    id                  NUMBER(10,0) NOT NULL,
+    id                  NUMBER(38,0) NOT NULL,
     value               VARCHAR2(255 char),
     PRIMARY KEY         (id)
 );
@@ -390,7 +390,7 @@
 CREATE SEQUENCE UNITS_ID_SEQ;
 
 CREATE TABLE units (
-    id                  NUMBER(10,0) NOT NULL,
+    id                  NUMBER(38,0) NOT NULL,
     name                VARCHAR2(255),
     PRIMARY KEY         (id)
 );

http://dive4elements.wald.intevation.org