diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-03-24 22:44:17 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-03-24 22:44:17 -0500 |
| commit | 908543dd620a8fb8f5a2d1a58ce82b83e3aafe12 (patch) | |
| tree | f9435f538a6ccc5101749e70279f0046d16810c3 /config/sql/channels.sql | |
| parent | 253ea8113bd3afc210e78a56b57e2371c8695dd8 (diff) | |
| download | invidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.tar.gz invidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.tar.bz2 invidious-908543dd620a8fb8f5a2d1a58ce82b83e3aafe12.zip | |
Add channel sql
Diffstat (limited to 'config/sql/channels.sql')
| -rw-r--r-- | config/sql/channels.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/config/sql/channels.sql b/config/sql/channels.sql new file mode 100644 index 00000000..a908c785 --- /dev/null +++ b/config/sql/channels.sql @@ -0,0 +1,26 @@ +-- Table: public.channels + +-- DROP TABLE public.channels; + +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" +) +WITH ( + OIDS = FALSE +) +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 |