+ last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+ PRIMARY KEY (vhost, event)
+);
+
+-- In a separate table to avoid deadlocks.
+CREATE TABLE last_picture_cache (
+ vhost varchar NOT NULL,
+ event varchar NOT NULL,
+ last_picture timestamp without time zone,
+
+ PRIMARY KEY (vhost,event),
+ FOREIGN KEY (vhost,event) REFERNECES events(vhost,event)