diff options
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) ); |