Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 6608:3d23f606512f | 6609:6d55614d6f87 |
|---|---|
| 39 CREATE TABLE artifact_data ( | 39 CREATE TABLE artifact_data ( |
| 40 id INT PRIMARY KEY NOT NULL, | 40 id INT PRIMARY KEY NOT NULL, |
| 41 artifact_id INT NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE, | 41 artifact_id INT NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE, |
| 42 kind VARCHAR(256) NOT NULL, | 42 kind VARCHAR(256) NOT NULL, |
| 43 k VARCHAR(256) NOT NULL, | 43 k VARCHAR(256) NOT NULL, |
| 44 v VARCHAR(256), -- Maybe too short | 44 v TEXT, |
| 45 UNIQUE (artifact_id, k) | 45 UNIQUE (artifact_id, k) |
| 46 ); | 46 ); |
| 47 | 47 |
| 48 CREATE SEQUENCE OUTS_ID_SEQ; | 48 CREATE SEQUENCE OUTS_ID_SEQ; |
| 49 | 49 |