From a384f6e5fd11824f0227f51b53a6bdbd815d60a9 Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Sun, 10 Feb 2019 12:46:58 -0600
Subject: Add migrate script and update README

---
 config/migrate-scripts/migrate-db-3646395.sh | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 config/migrate-scripts/migrate-db-3646395.sh

(limited to 'config/migrate-scripts')

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"
-- 
cgit v1.2.3