id character varying NOT NULL PRIMARY KEY,
date character varying NOT NULL,
name character varying NOT NULL,
- vhost character varying NOT NULL
+ vhost character varying NOT NULL,
+ last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);
-- In a separate table to avoid deadlocks.
);
CREATE TABLE images (
- id serial NOT NULL PRIMARY KEY REFERENCES events(id),
- event character varying NOT NULL,
+ id serial NOT NULL PRIMARY KEY,
+ event character varying NOT NULL REFERENCES events(id),
filename character varying NOT NULL,
width integer DEFAULT -1 NOT NULL,
height integer DEFAULT -1 NOT NULL,