Actually add the SQL upgrade.
authorSteinar H. Gunderson <sesse@debian.org>
Mon, 4 Aug 2008 21:37:11 +0000 (23:37 +0200)
committerSteinar H. Gunderson <sesse@debian.org>
Mon, 4 Aug 2008 21:37:11 +0000 (23:37 +0200)
sql/upgrade-v2.71.sql [new file with mode: 0644]

diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql
new file mode 100644 (file)
index 0000000..70b9108
--- /dev/null
@@ -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;
+