
sascha@3: --
sascha@3: -- schema to store artifacts in H2 databases.
sascha@3: --
sascha@3: 
sascha@3: BEGIN;
sascha@3: 
sascha@3: CREATE TABLE artifacts (
sascha@3:     id          INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
sascha@3:     gid         UUID      NOT NULL UNIQUE,
sascha@3:     creation    TIMESTAMP NOT NULL,
sascha@3:     last_access TIMESTAMP NOT NULL,
sascha@3:     ttl         TIME, -- NULL means eternal
sascha@4:     data        BINARY
sascha@3: );
sascha@3: 
sascha@3: COMMIT;




