kemono2/db/migrations/20210805_01_riCyY-index-dms-for-search.py
2024-07-04 22:08:17 +02:00

15 lines
295 B
Python

"""
Index DMs for search
"""
from yoyo import step
__depends__ = {"20210729_01_jopn6-add-contributor-id-column-to-dm-table"}
steps = [
step(
"CREATE INDEX IF NOT EXISTS dm_search_idx ON dms USING GIN (to_tsvector('english', content))",
"DROP INDEX dm_search_idx",
)
]