From 1d043702ef136e8f2e516c5304a57be5718f1f6f Mon Sep 17 00:00:00 2001
From: Tyler Hoang <tyler@tylerhoang.xyz>
Date: Thu, 9 Jul 2026 21:49:56 -0700
Subject: Initial commit: docker compose files for all self-hosted services

12 services: adguard, ampache, azuracast, flood, glance, glances,
grafana, immich, invidious, jellyfin, openwebui, watchtower

Each service includes a docker-compose.yml, README.md with setup
instructions, and .env.example where applicable.
---
 invidious/config/sql/playlists.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 invidious/config/sql/playlists.sql

(limited to 'invidious/config/sql/playlists.sql')

diff --git a/invidious/config/sql/playlists.sql b/invidious/config/sql/playlists.sql
new file mode 100644
index 0000000..83efce4
--- /dev/null
+++ b/invidious/config/sql/playlists.sql
@@ -0,0 +1,29 @@
+-- Type: public.privacy
+
+-- DROP TYPE public.privacy;
+
+CREATE TYPE public.privacy AS ENUM
+(
+    'Public',
+    'Unlisted',
+    'Private'
+);
+
+-- Table: public.playlists
+
+-- DROP TABLE public.playlists;
+
+CREATE TABLE IF NOT EXISTS public.playlists
+(
+    title text,
+    id text primary key,
+    author text,
+    description text,
+    video_count integer,
+    created timestamptz,
+    updated timestamptz,
+    privacy privacy,
+    index int8[]
+);
+
+GRANT ALL ON public.playlists TO current_user;
-- 
cgit v1.3-2-g0d8e

