summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--config/sql/channel_videos.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql
index 4e48c70b..9e84092c 100644
--- a/config/sql/channel_videos.sql
+++ b/config/sql/channel_videos.sql
@@ -33,6 +33,6 @@ CREATE INDEX channel_videos_published_idx
-- DROP INDEX public.channel_videos_ucid_idx;
CREATE INDEX channel_videos_ucid_idx
- ON public.channel_videos USING btree
+ ON public.channel_videos USING hash
(ucid COLLATE pg_catalog."default")
TABLESPACE pg_default; \ No newline at end of file