"date" character varying NOT NULL,
name character varying NOT NULL,
vhost character varying NOT NULL,
"date" character varying NOT NULL,
name character varying NOT NULL,
vhost character varying NOT NULL,
vhost character varying NOT NULL,
event character varying NOT NULL,
filename character varying NOT NULL,
vhost character varying NOT NULL,
event character varying NOT NULL,
filename character varying NOT NULL,
uploadedby character varying NOT NULL,
"date" timestamp without time zone,
takenby character varying NOT NULL,
selected boolean DEFAULT false,
uploadedby character varying NOT NULL,
"date" timestamp without time zone,
takenby character varying NOT NULL,
selected boolean DEFAULT false,
vhost character varying,
event character varying NOT NULL,
filename character varying NOT NULL,
vhost character varying,
event character varying NOT NULL,
filename character varying NOT NULL,
uploadedby character varying,
"date" timestamp without time zone,
takenby character varying NOT NULL,
uploadedby character varying,
"date" timestamp without time zone,
takenby character varying 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,
+
GRANT INSERT ON TABLE deleted_images TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE events TO pr0n;
GRANT INSERT ON TABLE deleted_images TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE events TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE shadow_files TO pr0n;
GRANT SELECT ON TABLE users TO pr0n;
GRANT SELECT,INSERT,DELETE ON TABLE exif_info TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE shadow_files TO pr0n;
GRANT SELECT ON TABLE users TO pr0n;
GRANT SELECT,INSERT,DELETE ON TABLE exif_info TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE last_picture_cache TO pr0n;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE last_picture_cache TO pr0n;