Mercurial > dive4elements > framework
comparison artifact-database/doc/schema.sql @ 10:e8626caac353
* Made Artifact life cycle symmetric: setup/endOfLife.
* Implement defaults for Artifact and ArtifactFactory.
* Added connection pooling from apache commons dbcp
* Made sql schema of artifact database more compatible.
* Improve example config.
* Made artifactdb start with 'mvn exec:exec'
* minor fixes.
artifacts/trunk@25 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 06 Sep 2009 12:00:56 +0000 |
| parents | 13a12b607baf |
| children |
comparison
equal
deleted
inserted
replaced
| 9:a5a279a0ee35 | 10:e8626caac353 |
|---|---|
| 2 -- schema to store artifacts in H2 databases. | 2 -- schema to store artifacts in H2 databases. |
| 3 -- | 3 -- |
| 4 | 4 |
| 5 BEGIN; | 5 BEGIN; |
| 6 | 6 |
| 7 -- not using AUTO_INCREMENT to be more compatible with | |
| 8 -- other dbms. | |
| 9 CREATE SEQUENCE ARTIFACTS_ID_SEQ; | |
| 10 | |
| 7 CREATE TABLE artifacts ( | 11 CREATE TABLE artifacts ( |
| 8 id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, | 12 id INT PRIMARY KEY NOT NULL, |
| 9 gid UUID NOT NULL UNIQUE, | 13 gid UUID NOT NULL UNIQUE, |
| 10 creation TIMESTAMP NOT NULL, | 14 creation TIMESTAMP NOT NULL, |
| 11 last_access TIMESTAMP NOT NULL, | 15 last_access TIMESTAMP NOT NULL, |
| 12 ttl TIME, -- NULL means eternal | 16 ttl BIGINT, -- NULL means eternal |
| 13 data BINARY | 17 data BINARY |
| 14 ); | 18 ); |
| 15 | 19 |
| 16 COMMIT; | 20 COMMIT; |