summaryrefslogtreecommitdiffstats
path: root/videos.sql
diff options
context:
space:
mode:
Diffstat (limited to 'videos.sql')
-rw-r--r--videos.sql30
1 files changed, 0 insertions, 30 deletions
diff --git a/videos.sql b/videos.sql
deleted file mode 100644
index 444de280..00000000
--- a/videos.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- 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
-
-CREATE UNIQUE INDEX id_idx
- ON public.videos USING btree
- (id COLLATE pg_catalog."default")
- TABLESPACE pg_default; \ No newline at end of file