date character varying NOT NULL,
name character varying NOT NULL,
vhost character varying NOT NULL,
- last_picture timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
+ last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+-- In a separate table to avoid deadlocks.
+CREATE TABLE last_picture_cache (
+ event varchar PRIMARY KEY references events ( id ),
+ last_picture timestamp without time zone
);
CREATE TABLE images (
- id integer serial NOT NULL PRIMARY KEY REFERENCES events(id),
+ id serial NOT NULL PRIMARY KEY REFERENCES events(id),
event character varying NOT NULL,
filename character varying NOT NULL,
width integer DEFAULT -1 NOT NULL,