diff options
Diffstat (limited to 'config/sql/channel_videos.sql')
| -rw-r--r-- | config/sql/channel_videos.sql | 39 |
1 files changed, 18 insertions, 21 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql index 5dfe4650..98567780 100644 --- a/config/sql/channel_videos.sql +++ b/config/sql/channel_videos.sql @@ -4,36 +4,33 @@ CREATE TABLE public.channel_videos ( - id text COLLATE pg_catalog."default" NOT NULL, - title text COLLATE pg_catalog."default", - published timestamp with time zone, - updated timestamp with time zone, - ucid text COLLATE pg_catalog."default", - author text COLLATE pg_catalog."default", - length_seconds integer, - CONSTRAINT channel_videos_id_key UNIQUE (id) -) -WITH ( - OIDS = FALSE -) -TABLESPACE pg_default; + id text NOT NULL, + title text, + published timestamp with time zone, + updated timestamp with time zone, + ucid text, + author text, + length_seconds integer, + CONSTRAINT channel_videos_id_key UNIQUE (id) +); GRANT ALL ON TABLE public.channel_videos TO kemal; --- Index: channel_videos_published_idx +-- Index: public.channel_videos_published_idx -- DROP INDEX public.channel_videos_published_idx; CREATE INDEX channel_videos_published_idx - ON public.channel_videos USING btree - (published) - TABLESPACE pg_default; + ON public.channel_videos + USING btree + (published); --- Index: channel_videos_ucid_idx +-- Index: public.channel_videos_ucid_idx -- DROP INDEX public.channel_videos_ucid_idx; CREATE INDEX channel_videos_ucid_idx - ON public.channel_videos USING hash - (ucid COLLATE pg_catalog."default") - TABLESPACE pg_default;
\ No newline at end of file + ON public.channel_videos + USING hash + (ucid COLLATE pg_catalog."default"); + |