From c03f98fabc089e021d54144b32da5ed94d96dd26 Mon Sep 17 00:00:00 2001 From: Natanael Copa Date: Mon, 7 Sep 2009 12:49:22 +0000 Subject: main/acf-weblog: upgrade to 0.4.0 --- main/acf-weblog/acf-weblog.post-upgrade | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 main/acf-weblog/acf-weblog.post-upgrade (limited to 'main/acf-weblog/acf-weblog.post-upgrade') diff --git a/main/acf-weblog/acf-weblog.post-upgrade b/main/acf-weblog/acf-weblog.post-upgrade new file mode 100644 index 0000000000..325f8cb320 --- /dev/null +++ b/main/acf-weblog/acf-weblog.post-upgrade @@ -0,0 +1,21 @@ +#!/bin/sh + +new=$1 +old=$2 + +if ! [ "$(apk version -t $old 0.4.0)" = "<" ]; then + exit 0 +fi + + +psql -U postgres -c "ALTER TABLE weblog ADD COLUMN shortreason text" \ + webproxylog +psql -U postgres -c "ALTER TABLE pubweblog ADD COLUMN shortreason text" \ + webproxylog +psql -U postgres -c "ALTER TABLE pubblocklog ADD COLUMN shortreason text" \ + webproxylog +psql -U postgres -c "ALTER TABLE blocklog ADD COLUMN shortreason text" \ + webproxylog + +exit 0 + -- cgit v1.2.3