Mercurial > dive4elements > river
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 |
| 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) );