Mercurial > dive4elements > river
comparison flys-artifacts/doc/conf/datacage.sql @ 993:aabcca7aeb6c
Fixed datacage db scheme. add some debug output.
flys-artifacts/trunk@2426 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 31 Jul 2011 16:49:48 +0000 |
| parents | 5b467bc27eda |
| children | 02c327ffbad7 |
comparison
equal
deleted
inserted
replaced
| 992:5b467bc27eda | 993:aabcca7aeb6c |
|---|---|
| 60 out_id INT NOT NULL REFERENCES outs(id) ON DELETE CASCADE, | 60 out_id INT NOT NULL REFERENCES outs(id) ON DELETE CASCADE, |
| 61 name VARCHAR(256) NOT NULL, | 61 name VARCHAR(256) NOT NULL, |
| 62 num INT NOT NULL, | 62 num INT NOT NULL, |
| 63 state VARCHAR(256) NOT NULL, | 63 state VARCHAR(256) NOT NULL, |
| 64 description VARCHAR(256), | 64 description VARCHAR(256), |
| 65 UNIQUE (artifact_id, out_id, num, name) | 65 UNIQUE (out_id, num, name) |
| 66 ); | 66 ); |
| 67 | 67 |
| 68 -- DROP SEQUENCE USERS_ID_SEQ; | 68 -- DROP SEQUENCE USERS_ID_SEQ; |
| 69 -- DROP SEQUENCE COLLECTIONS_ID_SEQ; | 69 -- DROP SEQUENCE COLLECTIONS_ID_SEQ; |
| 70 -- DROP SEQUENCE ARTIFACTS_ID_SEQ; | 70 -- DROP SEQUENCE ARTIFACTS_ID_SEQ; |