
sascha@3: --
sascha@3: -- schema to store artifacts in H2 databases.
sascha@3: --
sascha@3: 
sascha@3: BEGIN;
sascha@3: 
sascha@10: -- not using AUTO_INCREMENT to be more compatible with
sascha@10: -- other dbms.
sascha@10: CREATE SEQUENCE ARTIFACTS_ID_SEQ;
sascha@10: 
sascha@3: CREATE TABLE artifacts (
sascha@10:     id          INT PRIMARY KEY NOT NULL,
sascha@10:     gid         UUID            NOT NULL UNIQUE,
sascha@10:     creation    TIMESTAMP       NOT NULL,
sascha@10:     last_access TIMESTAMP       NOT NULL,
sascha@10:     ttl         BIGINT, -- NULL means eternal
sascha@4:     data        BINARY
sascha@3: );
sascha@3: 
sascha@3: COMMIT;




