diff options
Diffstat (limited to 'main/acf-weblog/acf-weblog.post-upgrade')
| -rw-r--r-- | main/acf-weblog/acf-weblog.post-upgrade | 21 |
1 files changed, 21 insertions, 0 deletions
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 + |