Mercurial > dive4elements > river
comparison flys-artifacts/doc/conf/datacage.sql @ 990:e573c4715d81
Add artifacts data into datacage db at initial scan.
flys-artifacts/trunk@2422 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 29 Jul 2011 08:40:11 +0000 |
| parents | dbe39e1fb5e7 |
| children | 5b467bc27eda |
comparison
equal
deleted
inserted
replaced
| 989:f3be883325ce | 990:e573c4715d81 |
|---|---|
| 35 CREATE SEQUENCE ARTIFACT_DATA_ID_SEQ; | 35 CREATE SEQUENCE ARTIFACT_DATA_ID_SEQ; |
| 36 | 36 |
| 37 CREATE TABLE artifact_data ( | 37 CREATE TABLE artifact_data ( |
| 38 id INT PRIMARY KEY NOT NULL, | 38 id INT PRIMARY KEY NOT NULL, |
| 39 artifact_id INT NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE, | 39 artifact_id INT NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE, |
| 40 kind VARCHAR(256) NOT NULL, | |
| 40 k VARCHAR(256) NOT NULL, | 41 k VARCHAR(256) NOT NULL, |
| 41 v VARCHAR(256), -- Maybe too short | 42 v VARCHAR(256), -- Maybe too short |
| 42 UNIQUE (artifact_id, k) | 43 UNIQUE (artifact_id, k) |
| 43 ); | 44 ); |
| 44 | 45 |