X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fupgrade-v3.11.sql;h=94884d8dcc64eef373b78101f5e7076f1f97f0ea;hb=aeda5c873bbb0b0492cea8bf308c95927ef530ec;hp=8f066aa1752b0ff98945d61212846d9e0c8414e1;hpb=12e2d43c7d68a328e9c6e3ff2f3810d3b6799b47;p=pr0n 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 );