Mercurial > dive4elements > framework
comparison artifact-database/doc/schema-h2.sql @ 199:face2302387c
Insert collection attribute into database, too.
Fixed broken SQL schema.
artifacts/trunk@1437 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 09 Mar 2011 11:14:21 +0000 |
| parents | a85d889a1b0d |
| children | 328ef982d768 |
comparison
equal
deleted
inserted
replaced
| 198:6370369412e9 | 199:face2302387c |
|---|---|
| 35 name VARCHAR(256) NOT NULL, | 35 name VARCHAR(256) NOT NULL, |
| 36 owner_id INT NOT NULL REFERENCES users(id), | 36 owner_id INT NOT NULL REFERENCES users(id), |
| 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 attribute BINARY | |
| 40 ); | 41 ); |
| 41 | 42 |
| 42 CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ; | 43 CREATE SEQUENCE COLLECTION_ITEMS_ID_SEQ; |
| 43 | 44 |
| 44 CREATE TABLE collection_items ( | 45 CREATE TABLE collection_items ( |