From f0658bbd092af23e097ac52a1587688ec9ee17df Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Fri, 22 Mar 2019 10:32:42 -0500 Subject: Add 'liveNow' to subscription feed --- config/migrate-scripts/migrate-db-8e884fe.sh | 5 +++++ 1 file changed, 5 insertions(+) create mode 100755 config/migrate-scripts/migrate-db-8e884fe.sh (limited to 'config/migrate-scripts/migrate-db-8e884fe.sh') diff --git a/config/migrate-scripts/migrate-db-8e884fe.sh b/config/migrate-scripts/migrate-db-8e884fe.sh new file mode 100755 index 00000000..095c7632 --- /dev/null +++ b/config/migrate-scripts/migrate-db-8e884fe.sh @@ -0,0 +1,5 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channels DROP COLUMN subscribed" +psql invidious -c "ALTER TABLE channels ADD COLUMN subscribed timestamptz" +psql invidious -c "UPDATE channels SET subscribed = '2019-01-01 00:00:00+00'" -- cgit v1.2.3