+ vhost character varying NOT NULL,
+ digest_ha1_hex character(32)
+);
+
+-- 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,
+ value varchar NOT NULL,
+
+ PRIMARY KEY ( image, key )
+);
+
+CREATE INDEX exif_info_key ON exif_info ( key );
+CLUSTER exif_info_key ON exif_info;
+
+CREATE TABLE tags (
+ image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE,
+ tag varchar NOT NULL,
+
+ PRIMARY KEY ( image, tag )