changeset 6609:6d55614d6f87

Change artifact database v param to be type TEXT This is neccessary for large theme lists for example in the map. The 256 chars limit could easily be overtaken. I am using this for quite some time now and the upcoming version appears to be a good place to test this.
author Andre Heinecke <aheinecke@intevation.de>
date Thu, 18 Jul 2013 17:53:11 +0200
parents 3d23f606512f
children 8d88db1f5d36
files artifacts/doc/conf/datacage.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/datacage.sql	Thu Jul 18 15:54:48 2013 +0200
+++ b/artifacts/doc/conf/datacage.sql	Thu Jul 18 17:53:11 2013 +0200
@@ -41,7 +41,7 @@
     artifact_id INT             NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE,
     kind        VARCHAR(256)    NOT NULL,
     k           VARCHAR(256)    NOT NULL,
-    v           VARCHAR(256),   -- Maybe too short
+    v           TEXT,
     UNIQUE (artifact_id, k)
 );
 

http://dive4elements.wald.intevation.org