view artifact-database/doc/schema.sql @ 5:8f2de197bce2

Added config to artifact database and modelled bootstap of artifact factories on top of this. artifacts/trunk@15 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 04 Sep 2009 12:04:12 +0000
parents 13a12b607baf
children e8626caac353
line wrap: on
line source
--
-- schema to store artifacts in H2 databases.
--

BEGIN;

CREATE TABLE artifacts (
    id          INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
    gid         UUID      NOT NULL UNIQUE,
    creation    TIMESTAMP NOT NULL,
    last_access TIMESTAMP NOT NULL,
    ttl         TIME, -- NULL means eternal
    data        BINARY
);

COMMIT;

http://dive4elements.wald.intevation.org