Mercurial > dive4elements > river
diff flys-artifacts/doc/conf/datacage.sql @ 992:5b467bc27eda
Datacage: Store
facets of outs into datacage db at initial scan.
flys-artifacts/trunk@2424 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 29 Jul 2011 13:29:29 +0000 |
| parents | e573c4715d81 |
| children | aabcca7aeb6c |
line wrap: on
line diff
--- a/flys-artifacts/doc/conf/datacage.sql Fri Jul 29 11:24:41 2011 +0000 +++ b/flys-artifacts/doc/conf/datacage.sql Fri Jul 29 13:29:29 2011 +0000 @@ -57,11 +57,10 @@ CREATE TABLE facets ( id INT PRIMARY KEY NOT NULL, - artifact_id INT NOT NULL REFERENCES artifacts(id) ON DELETE CASCADE, - out_id INT NOT NULL REFERENCES outs(id) ON DELETE CASCADE, + out_id INT NOT NULL REFERENCES outs(id) ON DELETE CASCADE, name VARCHAR(256) NOT NULL, - num INT NOT NULL, - state VARCHAR(256) NOT NULL, + num INT NOT NULL, + state VARCHAR(256) NOT NULL, description VARCHAR(256), UNIQUE (artifact_id, out_id, num, name) );