diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-04-06 07:38:33 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-04-06 07:38:33 -0500 |
| commit | c5001f3620d6a9d4d24ce63afdf892a690b16440 (patch) | |
| tree | 39f34e178887209851bd2b0aba73a80412e0ea1d /config/migrate-scripts/migrate-db-3646395.sh | |
| parent | 8d5f9418297ac8b43540c571b466da82dd9fac0f (diff) | |
| download | invidious-c5001f3620d6a9d4d24ce63afdf892a690b16440.tar.gz invidious-c5001f3620d6a9d4d24ce63afdf892a690b16440.tar.bz2 invidious-c5001f3620d6a9d4d24ce63afdf892a690b16440.zip | |
Add role to psql scripts
Diffstat (limited to 'config/migrate-scripts/migrate-db-3646395.sh')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-3646395.sh | 4 |
1 files changed, 2 insertions, 2 deletions
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" |