diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-03-28 22:29:54 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-03-28 22:29:54 -0500 |
| commit | 239a6c892cf58a0d85184f5eda05437743b8c8b7 (patch) | |
| tree | 1930e81b329c4705dec0ea6f62b8a8404caa7a8d /config/sql | |
| parent | e89f15a65c23af68de70e3305691484654c7f479 (diff) | |
| download | invidious-239a6c892cf58a0d85184f5eda05437743b8c8b7.tar.gz invidious-239a6c892cf58a0d85184f5eda05437743b8c8b7.tar.bz2 invidious-239a6c892cf58a0d85184f5eda05437743b8c8b7.zip | |
Use seperate table for videos pulled from RSS
Diffstat (limited to 'config/sql')
| -rw-r--r-- | config/sql/channel_videos.sql | 20 | ||||
| -rw-r--r-- | config/sql/channels.sql | 14 |
2 files changed, 22 insertions, 12 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql new file mode 100644 index 00000000..e6cb3c8f --- /dev/null +++ b/config/sql/channel_videos.sql @@ -0,0 +1,20 @@ +-- Table: public.channel_videos + +-- DROP TABLE public.channel_videos; + +CREATE TABLE public.channel_videos +( + id text COLLATE pg_catalog."default" NOT NULL, + title text COLLATE pg_catalog."default", + published timestamp with time zone, + updated timestamp with time zone, + ucid text COLLATE pg_catalog."default", + author text COLLATE pg_catalog."default", + CONSTRAINT channel_videos_id_key UNIQUE (id) +) +WITH ( + OIDS = FALSE +) +TABLESPACE pg_default; + +GRANT ALL ON TABLE public.channel_videos TO kemal; diff --git a/config/sql/channels.sql b/config/sql/channels.sql index a908c785..d24329f3 100644 --- a/config/sql/channels.sql +++ b/config/sql/channels.sql @@ -5,9 +5,8 @@ CREATE TABLE public.channels ( id text COLLATE pg_catalog."default" NOT NULL, - rss text COLLATE pg_catalog."default", - updated timestamp with time zone, - author text COLLATE pg_catalog."default" + author text COLLATE pg_catalog."default", + updated timestamp with time zone ) WITH ( OIDS = FALSE @@ -15,12 +14,3 @@ WITH ( TABLESPACE pg_default; GRANT ALL ON TABLE public.channels TO kemal; - --- Index: channel_id_idx - --- DROP INDEX public.channel_id_idx; - -CREATE UNIQUE INDEX channel_id_idx - ON public.channels USING btree - (id COLLATE pg_catalog."default") - TABLESPACE pg_default;
\ No newline at end of file |