diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-11-02 09:46:45 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-11-02 09:46:45 -0500 |
| commit | 19632511d5ed1a38c32929d5dcb01edcd014e291 (patch) | |
| tree | a689a0559bcc8f54647024d3d64118ea6c0dbf99 /config/sql/channels.sql | |
| parent | d739ef8fd340149a0b1a2371ffd419c9723ce4f4 (diff) | |
| download | invidious-19632511d5ed1a38c32929d5dcb01edcd014e291.tar.gz invidious-19632511d5ed1a38c32929d5dcb01edcd014e291.tar.bz2 invidious-19632511d5ed1a38c32929d5dcb01edcd014e291.zip | |
Update SQL
Diffstat (limited to 'config/sql/channels.sql')
| -rw-r--r-- | config/sql/channels.sql | 23 |
1 files changed, 10 insertions, 13 deletions
diff --git a/config/sql/channels.sql b/config/sql/channels.sql index a328bcad..c4259c12 100644 --- a/config/sql/channels.sql +++ b/config/sql/channels.sql @@ -4,23 +4,20 @@ CREATE TABLE public.channels ( - id text COLLATE pg_catalog."default" NOT NULL, - author text COLLATE pg_catalog."default", - updated timestamp with time zone, - CONSTRAINT channels_id_key UNIQUE (id) -) -WITH ( - OIDS = FALSE -) -TABLESPACE pg_default; + id text NOT NULL, + author text, + updated timestamp with time zone, + CONSTRAINT channels_id_key UNIQUE (id) +); GRANT ALL ON TABLE public.channels TO kemal; --- Index: channels_id_idx +-- Index: public.channels_id_idx -- DROP INDEX public.channels_id_idx; CREATE INDEX channels_id_idx - ON public.channels USING btree - (id COLLATE pg_catalog."default") - TABLESPACE pg_default;
\ No newline at end of file + ON public.channels + USING btree + (id COLLATE pg_catalog."default"); + |