X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fpr0n.sql;h=371e05cf4fdfef765c35318276fef867dad6ac57;hp=860fd475bf55fd9f2004bd535213907cacbb8b3e;hb=e0e1d562e8e5a686c1fcd29d31b491ee6e74777f;hpb=6c8c4bf3f1e3109523f9ec6117abfdf0e04a0d99 diff --git a/sql/pr0n.sql b/sql/pr0n.sql index 860fd47..371e05c 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -80,8 +80,7 @@ CREATE TABLE exif_info ( PRIMARY KEY ( image, key ) ); -CREATE INDEX exif_info_key ON exif_info ( key ); -CLUSTER exif_info_key ON exif_info; +CLUSTER exif_info_pkey ON exif_info; GRANT INSERT ON TABLE deleted_images TO pr0n; GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE events TO pr0n;