summaryrefslogtreecommitdiffstats
path: root/config/migrate-scripts
diff options
context:
space:
mode:
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"