diff options
| author | Omar Roth <omarroth@protonmail.com> | 2019-05-30 15:09:39 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@protonmail.com> | 2019-05-30 18:59:13 -0500 |
| commit | 64464f23aed3b7b3331db686c85926c72f0ef7e5 (patch) | |
| tree | b4bb14486d690b323f40fd4454ca96cadc4d1edc /config | |
| parent | 52cb2391949cb06763bab1d52b93ca2210860683 (diff) | |
| download | invidious-64464f23aed3b7b3331db686c85926c72f0ef7e5.tar.gz invidious-64464f23aed3b7b3331db686c85926c72f0ef7e5.tar.bz2 invidious-64464f23aed3b7b3331db686c85926c72f0ef7e5.zip | |
Add 'views' to channel_videos
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) ); |