From 8de1aceb10809dd7d546bbef0ecb9c6f42f5fff9 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sesse@debian.org>
Date: Mon, 4 Aug 2008 23:37:11 +0200
Subject: [PATCH] Actually add the SQL upgrade.

---
 sql/upgrade-v2.71.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/upgrade-v2.71.sql

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;
+
-- 
2.39.2