diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-03-23 11:28:24 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-03-23 11:34:16 -0500 |
| commit | a1f49b279f3313e9edf3a65f45ce75115c484dab (patch) | |
| tree | 7930a8616cb6ace7b7382479128158a63967c84f /config/migrate-scripts/migrate-db-1c8075c.sh | |
| parent | 1c8075ca40639c889446dae2e8644ecf9114ff8f (diff) | |
| download | invidious-a1f49b279f3313e9edf3a65f45ce75115c484dab.tar.gz invidious-a1f49b279f3313e9edf3a65f45ce75115c484dab.tar.bz2 invidious-a1f49b279f3313e9edf3a65f45ce75115c484dab.zip | |
Rename migrate scripts
Diffstat (limited to 'config/migrate-scripts/migrate-db-1c8075c.sh')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-1c8075c.sh | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-1c8075c.sh b/config/migrate-scripts/migrate-db-1c8075c.sh new file mode 100755 index 00000000..92ad1c7b --- /dev/null +++ b/config/migrate-scripts/migrate-db-1c8075c.sh @@ -0,0 +1,7 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channel_videos DROP COLUMN live_now CASCADE" +psql invidious -c "ALTER TABLE channel_videos DROP COLUMN premiere_timestamp CASCADE" + +psql invidious -c "ALTER TABLE channel_videos ADD COLUMN live_now bool" +psql invidious -c "ALTER TABLE channel_videos ADD COLUMN premiere_timestamp timestamptz" |