1 files changed, 34 insertions, 0 deletions
diff --git a/config/sql/videos.sql b/config/sql/videos.sql
new file mode 100644
index 00000000..2fb52946
--- /dev/null
+++ b/config/sql/videos.sql
@@ -0,0 +1,34 @@
+-- Table: public.videos
+
+-- DROP TABLE public.videos;
+
+CREATE TABLE public.videos
+(
+    id text COLLATE pg_catalog."default" NOT NULL,
+    info text COLLATE pg_catalog."default",
+    updated timestamp with time zone,
+    title text COLLATE pg_catalog."default",
+    views bigint,
+    likes integer,
+    dislikes integer,
+    wilson_score double precision,
+    published timestamp with time zone,
+    description text COLLATE pg_catalog."default",
+    language text COLLATE pg_catalog."default",
+    CONSTRAINT videos_pkey PRIMARY KEY (id)
+)
+WITH (
+    OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+GRANT ALL ON TABLE public.videos TO kemal;
+
+-- Index: id_idx
+
+-- DROP INDEX public.id_idx;
+
+CREATE UNIQUE INDEX id_idx
+    ON public.videos USING btree
+    (id COLLATE pg_catalog."default")
+    TABLESPACE pg_default;
+\ No newline at end of file