last_picture timestamp without time zone,
PRIMARY KEY (vhost,event),
- FOREIGN KEY (vhost,event) REFERNECES events(vhost,event)
+ FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)
);
CREATE TABLE images (
"date" timestamp without time zone,
takenby character varying NOT NULL,
selected boolean DEFAULT false,
+ model character varying,
+ lens character varying,
FOREIGN KEY (vhost,event) REFERENCES events (vhost,event)
);
uploadedby character varying,
"date" timestamp without time zone,
takenby character varying NOT NULL,
- selected boolean
+ selected boolean,
+ model character varying,
+ lens character varying
);
CREATE TABLE fake_files (
vhost character varying NOT NULL
);
+-- Mainly used for manual queries -- usually too slow to be very useful
+-- for web views in the long run.
CREATE TABLE exif_info (
image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE,
key varchar NOT NULL,