X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fpr0n.sql;h=4729a37cdd9e9b71dbf2b922bd19fee46e66469e;hp=860fd475bf55fd9f2004bd535213907cacbb8b3e;hb=12e2d43c7d68a328e9c6e3ff2f3810d3b6799b47;hpb=6c8c4bf3f1e3109523f9ec6117abfdf0e04a0d99

diff --git a/sql/pr0n.sql b/sql/pr0n.sql
index 860fd47..4729a37 100644
--- a/sql/pr0n.sql
+++ b/sql/pr0n.sql
@@ -77,11 +77,10 @@ CREATE TABLE exif_info (
     key varchar NOT NULL,
     value varchar NOT NULL,
 
-    PRIMARY KEY ( image, key )
+    PRIMARY KEY ( key, image )
 );
 
-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;