X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v2.71.sql;fp=sql%2Fupgrade-v2.71.sql;h=70b910878684cf7e92b9d7a64ce623278de91b63;hp=0000000000000000000000000000000000000000;hb=8de1aceb10809dd7d546bbef0ecb9c6f42f5fff9;hpb=4522cf8bd8c20a0afd1605196422ab51a3901e95

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