diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-02-10 12:46:58 -0600 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-02-10 12:46:58 -0600 |
| commit | a384f6e5fd11824f0227f51b53a6bdbd815d60a9 (patch) | |
| tree | 3233595eb4b6359f994caaa9f1ead68a879c1bbe /config/migrate-scripts/migrate-db-3646395.sh | |
| parent | 3646395f1d8b200ebd33f3c0b65ad6bbaf0c7156 (diff) | |
| download | invidious-a384f6e5fd11824f0227f51b53a6bdbd815d60a9.tar.gz invidious-a384f6e5fd11824f0227f51b53a6bdbd815d60a9.tar.bz2 invidious-a384f6e5fd11824f0227f51b53a6bdbd815d60a9.zip | |
Add migrate script and update README
Diffstat (limited to 'config/migrate-scripts/migrate-db-3646395.sh')
| -rw-r--r-- | 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 100644 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" |