+ hidden boolean NOT NULL DEFAULT false,
+
+ 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,
+ last_update timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+ PRIMARY KEY (vhost,event),
+ FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)