Files
multica/server/migrations/247_comment_parent_index.up.sql
Bohan Jiang 9daa291d00 fix(migrations): resolve duplicate migration number (#6239)
Co-authored-by: Bohan-J <bohan@devv.ai>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-31 16:23:24 +08:00

4 lines
121 B
SQL

CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_comment_parent_id
ON comment(parent_id)
WHERE parent_id IS NOT NULL;