diff options
Diffstat (limited to 'config/migrate-scripts/migrate-db-8e884fe.sh')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-8e884fe.sh | 5 |
1 files changed, 5 insertions, 0 deletions
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'" |