KamoCRM

Pin ServiceJob's join columns to INT8

Fixkamo-shared-library
Ya
26 Agosti 2026, 08:03 UTC
Mwandishi
Kamo
Ahadi ya
0df24f4

Exporting the table's DDL showed org_id, engagement_id and customer_uid each emitted as INT8 DEFAULT unique_rowid() — inherited from the referenced key. Three foreign keys that, left unset, would invent a random id pointing at nothing instead of staying null. A job saved without a customer would silently claim one. Same mechanism CalendarEvent.member already pins against, and QuoteLineItem documents the UUID variant of.

Mabadiliko yote

Je, unaona nini kuhusu usafiri?

Kila kitu kinaingia kwenye tovuti yako mwenyewe. Anza kwenye mpango wa bure na usome ukurasa huu tena katika mwezi mmoja.

Kuwa Huru MileleMtazamo wa bei