From fd26f9f34e6ee9383ae9b9c94f8287c9100c7726 Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Fri, 22 Mar 2019 12:24:47 -0500 Subject: Add support for premieres to search and feed --- config/migrate-scripts/migrate-db-3646395.sh | 5 ----- config/migrate-scripts/migrate-db-3864cbf.sh | 3 +++ config/migrate-scripts/migrate-db-6e51189.sh | 2 +- config/migrate-scripts/migrate-db-88b7097.sh | 5 +++++ 4 files changed, 9 insertions(+), 6 deletions(-) delete mode 100755 config/migrate-scripts/migrate-db-3646395.sh create mode 100755 config/migrate-scripts/migrate-db-3864cbf.sh create mode 100755 config/migrate-scripts/migrate-db-88b7097.sh (limited to 'config/migrate-scripts') diff --git a/config/migrate-scripts/migrate-db-3646395.sh b/config/migrate-scripts/migrate-db-3646395.sh deleted file mode 100755 index 38a4f665..00000000 --- a/config/migrate-scripts/migrate-db-3646395.sh +++ /dev/null @@ -1,5 +0,0 @@ -#!/bin/sh - -psql invidious < config/sql/session_ids.sql -psql invidious -c "INSERT INTO session_ids (SELECT unnest(id), email, CURRENT_TIMESTAMP FROM users) ON CONFLICT (id) DO NOTHING" -psql invidious -c "ALTER TABLE users DROP COLUMN id" diff --git a/config/migrate-scripts/migrate-db-3864cbf.sh b/config/migrate-scripts/migrate-db-3864cbf.sh new file mode 100755 index 00000000..c63d37f0 --- /dev/null +++ b/config/migrate-scripts/migrate-db-3864cbf.sh @@ -0,0 +1,3 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channel_videos ADD COLUMN premiere_timestamp timestamptz;" diff --git a/config/migrate-scripts/migrate-db-6e51189.sh b/config/migrate-scripts/migrate-db-6e51189.sh index 80f222bb..adadc109 100755 --- a/config/migrate-scripts/migrate-db-6e51189.sh +++ b/config/migrate-scripts/migrate-db-6e51189.sh @@ -1,4 +1,4 @@ #!/bin/sh psql invidious -c "ALTER TABLE channel_videos ADD COLUMN live_now bool;" -psql invidious -c "UPDATE channel_videos SET live_now = false;" \ No newline at end of file +psql invidious -c "UPDATE channel_videos SET live_now = false;" diff --git a/config/migrate-scripts/migrate-db-88b7097.sh b/config/migrate-scripts/migrate-db-88b7097.sh new file mode 100755 index 00000000..38a4f665 --- /dev/null +++ b/config/migrate-scripts/migrate-db-88b7097.sh @@ -0,0 +1,5 @@ +#!/bin/sh + +psql invidious < config/sql/session_ids.sql +psql invidious -c "INSERT INTO session_ids (SELECT unnest(id), email, CURRENT_TIMESTAMP FROM users) ON CONFLICT (id) DO NOTHING" +psql invidious -c "ALTER TABLE users DROP COLUMN id" -- cgit v1.2.3