Update setup instructions

1 files changed, 6 insertions, 8 deletions

diff --git a/videos.sql b/videos.sql
index 1da62660..797a99be 100644
--- a/videos.sql
+++ b/videos.sql
@@ -1,6 +1,6 @@
 -- Table: public.videos
 
--- DROP TABLE public.videos;
+DROP TABLE videos;
 
 CREATE TABLE public.videos
 (
@@ -8,6 +8,11 @@ CREATE TABLE public.videos
     info text COLLATE pg_catalog."default",
     html 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,
     CONSTRAINT videos_pkey PRIMARY KEY (id)
 )
 WITH (
@@ -15,17 +20,10 @@ WITH (
 )
 TABLESPACE pg_default;
 
-ALTER TABLE public.videos
-    OWNER to omar;
-
 GRANT ALL ON TABLE public.videos TO kemal;
 
-GRANT ALL ON TABLE public.videos TO omar;
-
 -- Index: id_idx
 
--- DROP INDEX public.id_idx;
-
 CREATE UNIQUE INDEX id_idx
     ON public.videos USING btree
     (id COLLATE pg_catalog."default")