diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-01-06 20:39:24 -0600 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-01-06 20:39:24 -0600 |
| commit | 060c4da96dedd51b86fafc8407792942b9362f0f (patch) | |
| tree | eb47f31b86b8f3527fd2702a4016e8f823974323 /videos.sql | |
| parent | d1eb81b6533fd81eac94a64ccc929f4de517f48e (diff) | |
| download | invidious-060c4da96dedd51b86fafc8407792942b9362f0f.tar.gz invidious-060c4da96dedd51b86fafc8407792942b9362f0f.tar.bz2 invidious-060c4da96dedd51b86fafc8407792942b9362f0f.zip | |
Add related videos and clean up video class
Diffstat (limited to 'videos.sql')
| -rw-r--r-- | videos.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/videos.sql b/videos.sql new file mode 100644 index 00000000..1da62660 --- /dev/null +++ b/videos.sql @@ -0,0 +1,32 @@ +-- 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", + html text COLLATE pg_catalog."default", + updated timestamp with time zone, + CONSTRAINT videos_pkey PRIMARY KEY (id) +) +WITH ( + OIDS = FALSE +) +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") + TABLESPACE pg_default;
\ No newline at end of file |