changeset 5623:0aaed46a88be

Schema change: Allow longer strings in fixpoints.hpgp
author Tom Gottfried <tom@intevation.de>
date Tue, 09 Apr 2013 19:07:20 +0200
parents b28a6d05e969
children c0ff14d03f1f
files flys-backend/doc/schema/oracle-spatial.sql flys-backend/doc/schema/postgresql-spatial.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Tue Apr 09 19:04:32 2013 +0200
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Tue Apr 09 19:07:20 2013 +0200
@@ -117,7 +117,7 @@
     x NUMBER(38,11),
     y NUMBER(38,11),
     km NUMBER(38,11) NOT NULL,
-    HPGP VARCHAR2(255),
+    HPGP VARCHAR(64),
     name VARCHAR(64),
     path     VARCHAR(256),
     ID NUMBER PRIMARY KEY NOT NULL
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Tue Apr 09 19:04:32 2013 +0200
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Tue Apr 09 19:07:20 2013 +0200
@@ -88,7 +88,7 @@
     x        FLOAT8,
     y        FLOAT8,
     km       FLOAT8 NOT NULL,
-    HPGP     VARCHAR(2),
+    HPGP     VARCHAR(64),
     name     VARCHAR(64),
     path     VARCHAR(256)
 );

http://dive4elements.wald.intevation.org