From 8e5ec72d5a96e0828d61cd74d27cfa3725d337db Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 5 Feb 2016 12:00:34 +0100 Subject: [PATCH] Flip the order of the fields in the exif_info primary key again; we need to delete based on image sometimes. Sadly reduces the usefulness of the clustering. --- sql/pr0n.sql | 2 +- sql/upgrade-v3.11.sql | 3 +-- 2 files changed, 2 insertions(+), 3 deletions(-) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index 4729a37..371e05c 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -77,7 +77,7 @@ CREATE TABLE exif_info ( key varchar NOT NULL, value varchar NOT NULL, - PRIMARY KEY ( key, image ) + PRIMARY KEY ( image, key ) ); CLUSTER exif_info_pkey ON exif_info; diff --git a/sql/upgrade-v3.11.sql b/sql/upgrade-v3.11.sql index 8f066aa..94884d8 100644 --- a/sql/upgrade-v3.11.sql +++ b/sql/upgrade-v3.11.sql @@ -11,5 +11,4 @@ alter table deleted_images add column render_id integer; drop index exif_info_key; alter table exif_info drop constraint exif_info_pkey; -alter table exif_info create primary key ( key, image ); -cluster exif_info_pkey on exif_info; +alter table exif_info add primary key ( image, key ); -- 2.39.2