- username character varying(32) NOT NULL,
- sha1password character(28) NOT NULL,
- vhost character varying(32) NOT NULL
+ username character varying NOT NULL,
+ sha1password character(27),
+ vhost character varying NOT NULL,
+ cryptpassword character varying
+);
+
+-- 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 )