Add support for custom playlists

3 files changed, 47 insertions, 0 deletions

diff --git a/config/sql/playlist_videos.sql b/config/sql/playlist_videos.sql
new file mode 100644
index 00000000..b2b8d5c4
--- /dev/null
+++ b/config/sql/playlist_videos.sql
@@ -0,0 +1,19 @@
+-- Table: public.playlist_videos
+
+-- DROP TABLE public.playlist_videos;
+
+CREATE TABLE playlist_videos
+(
+    title text,
+    id text,
+    author text,
+    ucid text,
+    length_seconds integer,
+    published timestamptz,
+    plid text references playlists(id),
+    index int8,
+    live_now boolean,
+    PRIMARY KEY (index,plid)
+);
+
+GRANT ALL ON TABLE public.playlist_videos TO kemal;
diff --git a/config/sql/playlists.sql b/config/sql/playlists.sql
new file mode 100644
index 00000000..46ff30ec
--- /dev/null
+++ b/config/sql/playlists.sql
@@ -0,0 +1,18 @@
+-- Table: public.playlists
+
+-- DROP TABLE public.playlists;
+
+CREATE TABLE 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 kemal;
diff --git a/config/sql/privacy.sql b/config/sql/privacy.sql
new file mode 100644
index 00000000..4356813e
--- /dev/null
+++ b/config/sql/privacy.sql
@@ -0,0 +1,10 @@
+-- Type: public.privacy
+
+-- DROP TYPE public.privacy;
+
+CREATE TYPE public.privacy AS ENUM
+(
+    'Public',
+    'Unlisted',
+    'Private'
+);