From a1f49b279f3313e9edf3a65f45ce75115c484dab Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Sat, 23 Mar 2019 11:28:24 -0500 Subject: Rename migrate scripts --- config/migrate-scripts/migrate-db-1c8075c.sh | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100755 config/migrate-scripts/migrate-db-1c8075c.sh (limited to 'config/migrate-scripts/migrate-db-1c8075c.sh') 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" -- cgit v1.2.3