← back to Homesonspec

packages/database/prisma/migrations/20260722181700_trgm_search_index/migration.sql

6 lines

-- pg_trgm GIN index for fuzzy location search on Community.searchText.
-- The extension itself is created at DB provision time (createdb + CREATE EXTENSION).
CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE INDEX IF NOT EXISTS "Community_searchText_trgm_idx"
  ON "Community" USING GIN ("searchText" gin_trgm_ops);