diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-03-22 12:24:47 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-03-22 14:54:35 -0500 |
| commit | fd26f9f34e6ee9383ae9b9c94f8287c9100c7726 (patch) | |
| tree | 1d908271550b1d8251f3f21fcf433c038cf5e32f /config/migrate-scripts/migrate-db-88b7097.sh | |
| parent | 88b70973ccbb0f0e7c7ddc623e47a6c3f02a6917 (diff) | |
| download | invidious-fd26f9f34e6ee9383ae9b9c94f8287c9100c7726.tar.gz invidious-fd26f9f34e6ee9383ae9b9c94f8287c9100c7726.tar.bz2 invidious-fd26f9f34e6ee9383ae9b9c94f8287c9100c7726.zip | |
Add support for premieres to search and feed
Diffstat (limited to 'config/migrate-scripts/migrate-db-88b7097.sh')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-88b7097.sh | 5 |
1 files changed, 5 insertions, 0 deletions
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" |