"date" character varying NOT NULL,
name character varying NOT NULL,
vhost character varying NOT NULL,
- last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (vhost, event)
);
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) REFERNECES events(vhost,event)
+ FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)
);
CREATE TABLE images (
CREATE TABLE users (
username character varying NOT NULL,
sha1password character(28) NOT NULL,
- vhost character varying NOT NULL
+ vhost character varying NOT NULL,
+ digest_ha1_hex character(32)
);
-- Mainly used for manual queries -- usually too slow to be very useful