Rename "tag" to "key" in exif_info table, and make a small SQL script to do

[pr0n] / sql / upgrade-v2.50.sql

diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql
new file mode 100644 (file)
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;
+