diff options
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"); + |
