Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.sql @ 156:a76de72ad6d1
Added stubs for the collection handling in db backend.
Added missing attribute column to the collection item table.
artifacts/trunk@1381 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 03 Mar 2011 09:53:02 +0000 |
| parents | caf9f456f7e3 |
| children | a85d889a1b0d |
comparison
equal
deleted
inserted
replaced
| 155:f797093c60bd | 156:a76de72ad6d1 |
|---|---|
| 43 | 43 |
| 44 CREATE TABLE collection_items ( | 44 CREATE TABLE collection_items ( |
| 45 id INT PRIMARY KEY NOT NULL, | 45 id INT PRIMARY KEY NOT NULL, |
| 46 collection_id INT NOT NULL REFERENCES collections(id), | 46 collection_id INT NOT NULL REFERENCES collections(id), |
| 47 artifact_id INT NOT NULL REFERENCES artifacts(id), | 47 artifact_id INT NOT NULL REFERENCES artifacts(id), |
| 48 attribute BINARY, | |
| 48 UNIQUE (collection_id, artifact_id) | 49 UNIQUE (collection_id, artifact_id) |
| 49 ); | 50 ); |
| 50 | 51 |
| 51 COMMIT; | 52 COMMIT; |