Add trigger for work_item_transitions

What does this MR do and why?

Add trigger for work_item_transitions

As part of decomposing the issues table, we need to sync the values to work_item_transitions before we start backfilling the table and use it as the source of truth.

Changelog: added

References

Part of an effort to decompose these columns out of the issues table, see &18753 for the details.

Issue: #558754 (closed)

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports

Loading