Mercurial > dive4elements > framework
view artifact-database/doc/schema-pg.sql @ 65:82f62ef25a8f
Create namespace aware documents for 'create' and 'out' targets. Adapted XPath expressions for this.
artifacts/trunk@529 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Tue, 12 Jan 2010 08:42:49 +0000 |
parents | 5e4bc24ea438 |
children | 720d65bbba13 |
line wrap: on
line source
-- -- schema to store artifacts in PostgreSQL databases. -- BEGIN; -- not using AUTO_INCREMENT to be more compatible with -- other dbms. CREATE SEQUENCE ARTIFACTS_ID_SEQ; CREATE TABLE artifacts ( id int PRIMARY KEY NOT NULL, gid uuid NOT NULL UNIQUE, creation timestamp NOT NULL, last_access timestamp NOT NULL, ttl bigint, -- NULL means eternal factory VARCHAR(256) NOT NULL, data bytea ); COMMIT;