comparison artifact-database/doc/schema-pg.sql @ 41:5e4bc24ea438

Made serilization more flexible. DB update required!!! Fixed problem with touching artifacts in database. artifacts/trunk@119 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 23 Sep 2009 16:55:12 +0000
parents 93edc04f3a10
children 720d65bbba13
comparison
equal deleted inserted replaced
40:af22d4de275c 41:5e4bc24ea438
12 id int PRIMARY KEY NOT NULL, 12 id int PRIMARY KEY NOT NULL,
13 gid uuid NOT NULL UNIQUE, 13 gid uuid NOT NULL UNIQUE,
14 creation timestamp NOT NULL, 14 creation timestamp NOT NULL,
15 last_access timestamp NOT NULL, 15 last_access timestamp NOT NULL,
16 ttl bigint, -- NULL means eternal 16 ttl bigint, -- NULL means eternal
17 factory VARCHAR(256) NOT NULL,
17 data bytea 18 data bytea
18 ); 19 );
19 20
20 COMMIT; 21 COMMIT;

http://dive4elements.wald.intevation.org