mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-16 22:59:04 +02:00
f1d81cdfaa
Projects are now searchable alongside issues in the Cmd+K search dialog. Results are grouped by type (Projects / Issues) with project icon, status, and description snippet highlighting. Co-authored-by: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
10 lines
397 B
SQL
10 lines
397 B
SQL
-- Add GIN bigram indexes on project title and description for search.
|
|
DO $$
|
|
BEGIN
|
|
CREATE INDEX idx_project_title_bigm ON project USING gin (LOWER(title) gin_bigm_ops);
|
|
CREATE INDEX idx_project_description_bigm ON project USING gin (LOWER(COALESCE(description, '')) gin_bigm_ops);
|
|
EXCEPTION WHEN OTHERS THEN
|
|
RAISE NOTICE 'skipping bigram indexes on project (pg_bigm not installed)';
|
|
END
|
|
$$;
|