diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-02-16 09:57:09 -0600 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-02-16 09:57:09 -0600 |
| commit | 6a8a49d8efec065d7d2745d6bc66a4319546798e (patch) | |
| tree | bcc1806159e28ba6d7ddd8fdd8ecf492a39d11e4 /config/migrate-scripts/migrate-db-3646395.sh | |
| parent | 7e2954c325d7ee0303de3197cdfebd616bf0a9d5 (diff) | |
| parent | 27663b10a256cd3ddb31b3b5e013daeaf577155f (diff) | |
| download | invidious-6a8a49d8efec065d7d2745d6bc66a4319546798e.tar.gz invidious-6a8a49d8efec065d7d2745d6bc66a4319546798e.tar.bz2 invidious-6a8a49d8efec065d7d2745d6bc66a4319546798e.zip | |
Merge branch 'master' into 347-screenshots
Diffstat (limited to 'config/migrate-scripts/migrate-db-3646395.sh')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-3646395.sh | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-3646395.sh b/config/migrate-scripts/migrate-db-3646395.sh new file mode 100755 index 00000000..38a4f665 --- /dev/null +++ b/config/migrate-scripts/migrate-db-3646395.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" |