web/panettone/src/migrations/3920286378-add-issue-tsv.lisp


1
2
3
4
5

"Add tsvector for full-text search of issues"

(defun up ()
  (query "ALTER TABLE issues ADD COLUMN tsv tsvector GENERATED ALWAYS AS (to_tsvector('english', subject || ' ' || body)) STORED")
  (query "CREATE INDEX issues_tsv_index ON issues USING GIN (tsv);"))