Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.sql @ 271:aa9f2f5ff032
flys/issue75: fixed doc and schema to make H2 work again.
artifacts/trunk@2059 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 06 Jun 2011 14:00:38 +0000 |
parents | 328ef982d768 |
children | 92166f7c3842 |
comparison
equal
deleted
inserted
replaced
270:89f6de49803d | 271:aa9f2f5ff032 |
---|---|
49 attribute BINARY, | 49 attribute BINARY, |
50 UNIQUE (collection_id, artifact_id) | 50 UNIQUE (collection_id, artifact_id) |
51 ); | 51 ); |
52 | 52 |
53 CREATE TRIGGER collections_access_update_trigger AFTER UPDATE | 53 CREATE TRIGGER collections_access_update_trigger AFTER UPDATE |
54 ON TABLE artifacts FOR EACH ROW | 54 ON artifacts FOR EACH ROW |
55 CALL "de.intevation.artifactdatabase.h2.CollectionAccessUpdateTrigger"; | 55 CALL "de.intevation.artifactdatabase.h2.CollectionAccessUpdateTrigger"; |
56 | 56 |
57 COMMIT; | 57 COMMIT; |