diff flys-backend/doc/schema/postgresql-spatial.sql @ 3961:f5912365619c

Adapted the spatial schema for DEMs and the DgmSqlConverter. flys-backend/trunk@5632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 28 Sep 2012 08:37:08 +0000
parents 89ada0b9083f
children 28f992c0f937
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Sep 27 17:45:49 2012 +0000
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Fri Sep 28 08:37:08 2012 +0000
@@ -107,9 +107,9 @@
     name            VARCHAR(64),
     lower           NUMERIC,
     upper           NUMERIC,
-    year_from       int,
-    year_to         int,
-    projection      VARCHAR(32),
+    year_from       VARCHAR(32) NOT NULL,
+    year_to         VARCHAR(32) NOT NULL,
+    projection      VARCHAR(32) NOT NULL,
     elevation_state VARCHAR(32),
     format          VARCHAR(32),
     border_break    BOOLEAN NOT NULL DEFAULT FALSE,

http://dive4elements.wald.intevation.org