Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.sql @ 274:92166f7c3842
#50 Added code on database level to recognize the oldest collection item in a collection (-> master artifact).
artifacts/trunk@2071 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 07 Jun 2011 17:09:25 +0000 |
| parents | aa9f2f5ff032 |
| children | 10aa92f2eca0 |
comparison
equal
deleted
inserted
replaced
| 273:22a90706d32d | 274:92166f7c3842 |
|---|---|
| 45 CREATE TABLE collection_items ( | 45 CREATE TABLE collection_items ( |
| 46 id INT PRIMARY KEY NOT NULL, | 46 id INT PRIMARY KEY NOT NULL, |
| 47 collection_id INT NOT NULL REFERENCES collections(id), | 47 collection_id INT NOT NULL REFERENCES collections(id), |
| 48 artifact_id INT NOT NULL REFERENCES artifacts(id), | 48 artifact_id INT NOT NULL REFERENCES artifacts(id), |
| 49 attribute BINARY, | 49 attribute BINARY, |
| 50 creation TIMESTAMP NOT NULL, | |
| 50 UNIQUE (collection_id, artifact_id) | 51 UNIQUE (collection_id, artifact_id) |
| 51 ); | 52 ); |
| 52 | 53 |
| 53 CREATE TRIGGER collections_access_update_trigger AFTER UPDATE | 54 CREATE TRIGGER collections_access_update_trigger AFTER UPDATE |
| 54 ON artifacts FOR EACH ROW | 55 ON artifacts FOR EACH ROW |