summaryrefslogtreecommitdiffstats
path: root/config/migrate-scripts
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2019-03-03 20:40:24 -0600
committerOmar Roth <omarroth@hotmail.com>2019-03-03 20:40:24 -0600
commit7425700009b2e127775ba33b9b9cf661867ecc2e (patch)
tree684379ed75cbc74e3fdc8f7cee49f44b90eaa0ea /config/migrate-scripts
parent8e884fe115839da19977fd3e1005abb21a8883c1 (diff)
downloadinvidious-7425700009b2e127775ba33b9b9cf661867ecc2e.tar.gz
invidious-7425700009b2e127775ba33b9b9cf661867ecc2e.tar.bz2
invidious-7425700009b2e127775ba33b9b9cf661867ecc2e.zip
Update pubsub to support lease_seconds
Diffstat (limited to 'config/migrate-scripts')
-rwxr-xr-xconfig/migrate-scripts/migrate-db-8e884fe1.sh4
1 files changed, 4 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-8e884fe1.sh b/config/migrate-scripts/migrate-db-8e884fe1.sh
new file mode 100755
index 00000000..ca137a5f
--- /dev/null
+++ b/config/migrate-scripts/migrate-db-8e884fe1.sh
@@ -0,0 +1,4 @@
+#!/bin/sh
+
+psql invidious -c "ALTER TABLE channels DROP COLUMN subscribed"
+psql invidious -c "ALTER TABLE channels ADD COLUMN subscribed timestamptz"