Actually add the SQL upgrade.

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

diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql
new file mode 100644 (file)
index 0000000..70b9108
--- /dev/null
+++ b/sql/upgrade-v2.71.sql
@@ -0,0 +1,6 @@
+--
+-- Upgrades pre-v2.71 databases to 2.71 format.
+--
+ALTER TABLE last_picture_cache ADD COLUMN last_update TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now();
+ALTER TABLE events DROP COLUMN last_update;
+