From fd26f9f34e6ee9383ae9b9c94f8287c9100c7726 Mon Sep 17 00:00:00 2001
From: Omar Roth <omarroth@hotmail.com>
Date: Fri, 22 Mar 2019 12:24:47 -0500
Subject: Add support for premieres to search and feed

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

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

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