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/channels.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/channels.sql')
| -rw-r--r-- | config/sql/channels.sql | 14 |
1 files changed, 2 insertions, 12 deletions
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 |