Mercurial > dive4elements > river
diff artifacts/doc/conf/datacage.sql @ 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 | 5aa05a7a34b7 |
children |
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) );