Mercurial > dive4elements > river
comparison artifacts/doc/conf/datacage.sql @ 6791:dd5355775ce1 longitudinal-symmetry
merge changes from default into longitudinal-symmetrie branch and make it build
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 07 Aug 2013 18:53:15 +0200 |
| parents | 6d55614d6f87 |
| children |
comparison
equal
deleted
inserted
replaced
| 6518:1a7f5d09b9d8 | 6791:dd5355775ce1 |
|---|---|
| 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 |