summaryrefslogtreecommitdiffstats
path: root/config
diff options
context:
space:
mode:
authorOmar Roth <omarroth@protonmail.com>2019-06-01 10:19:18 -0500
committerOmar Roth <omarroth@protonmail.com>2019-06-01 10:19:18 -0500
commit18d66dddedb4c6c14975a0ab47377258fea59e2e (patch)
tree85a9e7928ae8c08e1daa9bbf432132f3a4b6ed73 /config
parent701b5ea56134f2c8d8e8f54036b9f6467095b47b (diff)
downloadinvidious-18d66dddedb4c6c14975a0ab47377258fea59e2e.tar.gz
invidious-18d66dddedb4c6c14975a0ab47377258fea59e2e.tar.bz2
invidious-18d66dddedb4c6c14975a0ab47377258fea59e2e.zip
Add 'needs_update' column for scheduling feed refresh
Diffstat (limited to 'config')
-rwxr-xr-xconfig/migrate-scripts/migrate-db-701b5ea.sh3
-rw-r--r--config/sql/users.sql1
2 files changed, 4 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-701b5ea.sh b/config/migrate-scripts/migrate-db-701b5ea.sh
new file mode 100755
index 00000000..429531a2
--- /dev/null
+++ b/config/migrate-scripts/migrate-db-701b5ea.sh
@@ -0,0 +1,3 @@
+#!/bin/sh
+
+psql invidious kemal -c "ALTER TABLE users ADD COLUMN feed_needs_update boolean"
diff --git a/config/sql/users.sql b/config/sql/users.sql
index 536508a4..0f2cdba2 100644
--- a/config/sql/users.sql
+++ b/config/sql/users.sql
@@ -12,6 +12,7 @@ CREATE TABLE public.users
password text,
token text,
watched text[],
+ feed_needs_update boolean,
CONSTRAINT users_email_key UNIQUE (email)
);