diff options
Diffstat (limited to 'config')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-52cb239.sh | 3 | ||||
| -rw-r--r-- | config/sql/channel_videos.sql | 1 |
2 files changed, 4 insertions, 0 deletions
diff --git a/config/migrate-scripts/migrate-db-52cb239.sh b/config/migrate-scripts/migrate-db-52cb239.sh new file mode 100755 index 00000000..db8efeab --- /dev/null +++ b/config/migrate-scripts/migrate-db-52cb239.sh @@ -0,0 +1,3 @@ +#!/bin/sh + +psql invidious kemal -c "ALTER TABLE channel_videos ADD COLUMN views bigint;" diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql index ba354adf..cec57cd4 100644 --- a/config/sql/channel_videos.sql +++ b/config/sql/channel_videos.sql @@ -13,6 +13,7 @@ CREATE TABLE public.channel_videos length_seconds integer, live_now boolean, premiere_timestamp timestamp with time zone, + views bigint, CONSTRAINT channel_videos_id_key UNIQUE (id) ); |