X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v2.50.sql;fp=sql%2Fupgrade-v2.50.sql;h=6f740febde0a5aa1e87dc424a866a9976527c339;hp=0000000000000000000000000000000000000000;hb=42d4fc8288f205794e964cacb04871ef04f01043;hpb=fd3c349c460ea23bff2f27ce30917df591b9c498

diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql
new file mode 100644
index 0000000..6f740fe
--- /dev/null
+++ b/sql/upgrade-v2.50.sql
@@ -0,0 +1,7 @@
+--
+-- Upgrades pre-v2.50 databases to 2.50 format -- not many changes, though.
+--
+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;
+