summaryrefslogtreecommitdiff
path: root/invidious/docker/init-invidious-db.sh
diff options
context:
space:
mode:
Diffstat (limited to 'invidious/docker/init-invidious-db.sh')
-rwxr-xr-xinvidious/docker/init-invidious-db.sh12
1 files changed, 12 insertions, 0 deletions
diff --git a/invidious/docker/init-invidious-db.sh b/invidious/docker/init-invidious-db.sh
new file mode 100755
index 0000000..22b4cc5
--- /dev/null
+++ b/invidious/docker/init-invidious-db.sh
@@ -0,0 +1,12 @@
+#!/bin/bash
+set -eou pipefail
+
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channels.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/videos.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/channel_videos.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/users.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/session_ids.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/nonces.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/annotations.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlists.sql
+psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" < config/sql/playlist_videos.sql