From 19632511d5ed1a38c32929d5dcb01edcd014e291 Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Fri, 2 Nov 2018 09:46:45 -0500 Subject: Update SQL --- config/sql/channels.sql | 23 ++++++++++------------- 1 file changed, 10 insertions(+), 13 deletions(-) (limited to 'config/sql/channels.sql') 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"); + -- cgit v1.2.3