Mercurial > dive4elements > river
comparison artifacts/doc/conf/datacage.sql @ 6616:03cc3bc74964
Merged.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Fri, 19 Jul 2013 06:56:30 +0200 |
| parents | 6d55614d6f87 |
| children |
comparison
equal
deleted
inserted
replaced
| 6615:61dc90b2fbe2 | 6616:03cc3bc74964 |
|---|---|
| 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 |