KamoCRM

Migration for KB_ARTICLE_RELATIONS

FeatureInitializerService
Shipped
2 செப்டம்பர், 2026 அன்று 1:35 AM UTC
Author
Kamo
Commit
b04034f

Mirrors KbArticleRelation in kamo-shared-library. Written explicitly rather than left to ddl-auto so the UID and DATE_CREATED defaults live in the database, which is what lets a plain SQL insert work without naming them. The unique index is on the ordered pair, not the unordered one: (A,B) and (B,A) are both expected to exist, and constraining the unordered pair would reject the mirror row the service writes on every link. Already applied to production by running these statements as the kamo app user; they are idempotent, so a later full KI run is a no-op.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing