summaryrefslogtreecommitdiffstats
path: root/videos.sql
diff options
context:
space:
mode:
authorOmar Roth <omarroth@hotmail.com>2018-03-24 22:44:17 -0500
committerOmar Roth <omarroth@hotmail.com>2018-03-24 22:44:17 -0500
commit908543dd620a8fb8f5a2d1a58ce82b83e3aafe12 (patch)
treef9435f538a6ccc5101749e70279f0046d16810c3 /videos.sql
parent253ea8113bd3afc210e78a56b57e2371c8695dd8 (diff)
downloadinvidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.tar.gz
invidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.tar.bz2
invidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.zip
Add channel sql
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