From c5001f3620d6a9d4d24ce63afdf892a690b16440 Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Sat, 6 Apr 2019 07:38:33 -0500 Subject: Add role to psql scripts --- config/migrate-scripts/migrate-db-3646395.sh | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'config/migrate-scripts/migrate-db-3646395.sh') diff --git a/config/migrate-scripts/migrate-db-3646395.sh b/config/migrate-scripts/migrate-db-3646395.sh index 38a4f665..915f364e 100755 --- a/config/migrate-scripts/migrate-db-3646395.sh +++ b/config/migrate-scripts/migrate-db-3646395.sh @@ -1,5 +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" +psql invidious kemal -c "INSERT INTO session_ids (SELECT unnest(id), email, CURRENT_TIMESTAMP FROM users) ON CONFLICT (id) DO NOTHING" +psql invidious kemal -c "ALTER TABLE users DROP COLUMN id" -- cgit v1.2.3