From: Steinar H. Gunderson <sesse@debian.org>
Date: Mon, 4 Aug 2008 21:37:11 +0000 (+0200)
Subject: Actually add the SQL upgrade.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=8de1aceb10809dd7d546bbef0ecb9c6f42f5fff9;ds=sidebyside

Actually add the SQL upgrade.
---

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