diff options
Diffstat (limited to 'config')
| -rw-r--r-- | config/migrate-scripts/migrate-db-e1aa1ce.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-e1aa1ce.sh b/config/migrate-scripts/migrate-db-e1aa1ce.sh new file mode 100644 index 00000000..259862df --- /dev/null +++ b/config/migrate-scripts/migrate-db-e1aa1ce.sh @@ -0,0 +1,4 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channels ADD COLUMN deleted bool;" +psql invidious -c "UPDATE channels SET deleted = false;" diff --git a/config/sql/channels.sql b/config/sql/channels.sql index c4259c12..cecd04ed 100644 --- a/config/sql/channels.sql +++ b/config/sql/channels.sql @@ -7,6 +7,7 @@ CREATE TABLE public.channels id text NOT NULL, author text, updated timestamp with time zone, + deleted boolean, CONSTRAINT channels_id_key UNIQUE (id) ); |