diff options
| author | Omar Roth <omarroth@hotmail.com> | 2019-03-03 20:40:24 -0600 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2019-03-03 20:40:24 -0600 |
| commit | 7425700009b2e127775ba33b9b9cf661867ecc2e (patch) | |
| tree | 684379ed75cbc74e3fdc8f7cee49f44b90eaa0ea /config | |
| parent | 8e884fe115839da19977fd3e1005abb21a8883c1 (diff) | |
| download | invidious-7425700009b2e127775ba33b9b9cf661867ecc2e.tar.gz invidious-7425700009b2e127775ba33b9b9cf661867ecc2e.tar.bz2 invidious-7425700009b2e127775ba33b9b9cf661867ecc2e.zip | |
Update pubsub to support lease_seconds
Diffstat (limited to 'config')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-8e884fe1.sh | 4 | ||||
| -rw-r--r-- | config/sql/channels.sql | 1 |
2 files changed, 5 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-8e884fe1.sh b/config/migrate-scripts/migrate-db-8e884fe1.sh new file mode 100755 index 00000000..ca137a5f --- /dev/null +++ b/config/migrate-scripts/migrate-db-8e884fe1.sh @@ -0,0 +1,4 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channels DROP COLUMN subscribed" +psql invidious -c "ALTER TABLE channels ADD COLUMN subscribed timestamptz" diff --git a/config/sql/channels.sql b/config/sql/channels.sql index cecd04ed..b5a29b8f 100644 --- a/config/sql/channels.sql +++ b/config/sql/channels.sql @@ -8,6 +8,7 @@ CREATE TABLE public.channels author text, updated timestamp with time zone, deleted boolean, + subscribed timestamp with time zone, CONSTRAINT channels_id_key UNIQUE (id) ); |