diff options
Diffstat (limited to 'config')
| -rwxr-xr-x | config/migrate-scripts/migrate-db-3864cbf.sh | 3 | ||||
| -rwxr-xr-x | config/migrate-scripts/migrate-db-6e51189.sh | 2 | ||||
| -rwxr-xr-x | config/migrate-scripts/migrate-db-88b7097.sh (renamed from config/migrate-scripts/migrate-db-3646395.sh) | 0 | ||||
| -rw-r--r-- | config/sql/channel_videos.sql | 2 |
4 files changed, 6 insertions, 1 deletions
diff --git a/config/migrate-scripts/migrate-db-3864cbf.sh b/config/migrate-scripts/migrate-db-3864cbf.sh new file mode 100755 index 00000000..c63d37f0 --- /dev/null +++ b/config/migrate-scripts/migrate-db-3864cbf.sh @@ -0,0 +1,3 @@ +#!/bin/sh + +psql invidious -c "ALTER TABLE channel_videos ADD COLUMN premiere_timestamp timestamptz;" diff --git a/config/migrate-scripts/migrate-db-6e51189.sh b/config/migrate-scripts/migrate-db-6e51189.sh index 80f222bb..adadc109 100755 --- a/config/migrate-scripts/migrate-db-6e51189.sh +++ b/config/migrate-scripts/migrate-db-6e51189.sh @@ -1,4 +1,4 @@ #!/bin/sh psql invidious -c "ALTER TABLE channel_videos ADD COLUMN live_now bool;" -psql invidious -c "UPDATE channel_videos SET live_now = false;"
\ No newline at end of file +psql invidious -c "UPDATE channel_videos SET live_now = false;" diff --git a/config/migrate-scripts/migrate-db-3646395.sh b/config/migrate-scripts/migrate-db-88b7097.sh index 38a4f665..38a4f665 100755 --- a/config/migrate-scripts/migrate-db-3646395.sh +++ b/config/migrate-scripts/migrate-db-88b7097.sh diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql index 279fad29..2fae636e 100644 --- a/config/sql/channel_videos.sql +++ b/config/sql/channel_videos.sql @@ -11,6 +11,8 @@ CREATE TABLE public.channel_videos ucid text, author text, length_seconds integer, + live_now boolean, + premiere_timestamp timestamp with time zone, CONSTRAINT channel_videos_id_key UNIQUE (id) ); |