Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.sql @ 187:a85d889a1b0d
Fixed some backend specific stuff (sql statements, schema).
artifacts/trunk@1417 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 07 Mar 2011 16:23:27 +0000 |
| parents | a76de72ad6d1 |
| children | face2302387c |
comparison
equal
deleted
inserted
replaced
| 186:15c7638511dc | 187:a85d889a1b0d |
|---|---|
| 37 creation TIMESTAMP NOT NULL, | 37 creation TIMESTAMP NOT NULL, |
| 38 last_access TIMESTAMP NOT NULL, | 38 last_access TIMESTAMP NOT NULL, |
| 39 ttl BIGINT, -- NULL means eternal | 39 ttl BIGINT, -- NULL means eternal |
| 40 ); | 40 ); |
| 41 | 41 |
| 42 CREATE SEQUENCE COLLECTION_ITEMS_SEQ; | 42 CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ; |
| 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), |