diff options
Diffstat (limited to 'config')
| -rw-r--r-- | config/migrate-scripts/migrate-db-3646395.sh | 5 | ||||
| -rw-r--r-- | config/sql/session_ids.sql | 1 |
2 files changed, 5 insertions, 1 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" diff --git a/config/sql/session_ids.sql b/config/sql/session_ids.sql index 24491405..aa689577 100644 --- a/config/sql/session_ids.sql +++ b/config/sql/session_ids.sql @@ -21,4 +21,3 @@ CREATE INDEX session_ids_id_idx USING btree (id COLLATE pg_catalog."default"); -
\ No newline at end of file |