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