X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v2.50.sql;h=51bd75753bfceb82212434f4483d2956bff13508;hp=6f740febde0a5aa1e87dc424a866a9976527c339;hb=25a2e68cdf9eb1773b68c908b6afc9ff8081478b;hpb=42d4fc8288f205794e964cacb04871ef04f01043 diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql index 6f740fe..51bd757 100644 --- a/sql/upgrade-v2.50.sql +++ b/sql/upgrade-v2.50.sql @@ -1,6 +1,8 @@ -- -- Upgrades pre-v2.50 databases to 2.50 format -- not many changes, though. -- +SET work_mem=131072; + ALTER TABLE exif_info RENAME COLUMN tag TO key; CREATE INDEX exif_info_key ON exif_info ( key ); CLUSTER exif_info_key ON exif_info;