diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-03-22 10:32:42 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-03-22 14:52:57 -0500 |
| commit | f0658bbd092af23e097ac52a1587688ec9ee17df (patch) | |
| tree | a88a692bc58e5b516216f1bcc007321d49624bb8 /config/migrate-scripts/migrate-db-8e884fe.sh | |
| parent | 661e07c8dbe046c2f43849efe7fb24477b547061 (diff) | |
| download | invidious-f0658bbd092af23e097ac52a1587688ec9ee17df.tar.gz invidious-f0658bbd092af23e097ac52a1587688ec9ee17df.tar.bz2 invidious-f0658bbd092af23e097ac52a1587688ec9ee17df.zip | |
Add 'liveNow' to subscription feed
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'" |