summaryrefslogtreecommitdiffstats
path: root/config/sql/channel_videos.sql
diff options
context:
space:
mode:
Diffstat (limited to 'config/sql/channel_videos.sql')
-rw-r--r--config/sql/channel_videos.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql
index e6cb3c8f..98d4d7de 100644
--- a/config/sql/channel_videos.sql
+++ b/config/sql/channel_videos.sql
@@ -18,3 +18,12 @@ WITH (
TABLESPACE pg_default;
GRANT ALL ON TABLE public.channel_videos TO kemal;
+
+-- Index: 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; \ No newline at end of file