# HG changeset patch
# User Bjoern Schilberg <bjoern@intevation.de>
# Date 1318853412 0
# Node ID 67e0371f6f4047facee52b75037a6f30a24c881b
# Parent  8126ccb58f28ddb0bfd9baac07e9c683600df555
Adjusted NUMBER format for units, positions and cross_section_points tables.


flys-backend/trunk@2986 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 8126ccb58f28 -r 67e0371f6f40 flys-backend/ChangeLog
--- 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:
diff -r 8126ccb58f28 -r 67e0371f6f40 flys-backend/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)
 );