From a1f49b279f3313e9edf3a65f45ce75115c484dab Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Sat, 23 Mar 2019 11:28:24 -0500
Subject: Rename migrate scripts

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

(limited to 'config/migrate-scripts/migrate-db-3646395.sh')

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