diff --git a/sql/upgrades/135.sql b/sql/upgrades/135.sql --- a/sql/upgrades/135.sql +++ b/sql/upgrades/135.sql @@ -8,6 +8,6 @@ create extension if not exists pg_trgm; +create index on origin using gin (url gin_trgm_ops); +create index on origin using hash (url); drop index origin_type_url_idx; -create index concurrently on origin using gin (url gin_trgm_ops); -create index concurrently on origin using hash (url); diff --git a/sql/upgrades/136.sql b/sql/upgrades/136.sql --- a/sql/upgrades/136.sql +++ b/sql/upgrades/136.sql @@ -38,4 +38,4 @@ where origin_visit.origin = origin.id; alter table origin_visit - alter column type text set not null; + alter column type set not null;