summaryrefslogtreecommitdiffstats
path: root/config/sql/playlists.sql
diff options
context:
space:
mode:
Diffstat (limited to 'config/sql/playlists.sql')
-rw-r--r--config/sql/playlists.sql18
1 files changed, 18 insertions, 0 deletions
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;