2 -- Upgrades pre-v2.50 databases to 2.50 format -- not many changes, though.
6 ALTER TABLE exif_info RENAME COLUMN tag TO key;
7 CREATE INDEX exif_info_key ON exif_info ( key );
8 CLUSTER exif_info_key ON exif_info;
11 image integer NOT NULL REFERENCES images (id) ON DELETE CASCADE,
14 PRIMARY KEY ( image, tag )
16 CREATE INDEX tags_tag ON tags ( tag );
18 GRANT SELECT,INSERT,DELETE ON TABLE tags TO pr0n;