Fix the on delete option for namespace_id FK on work_item_dates_sources
Merged
requested to merge fix_work_item_source_dates_cascade_option_on_fk_to_namespace_id into master
This MR fixes the on delete option for the namespace_id foreign key on the work_item_dates_sources table.
Currently, the work_item_dates_sources table has a not null constraint on namespace_id and a foreign key on namespace_id with on delete nullify. These two constraints are conflicting because there is no reason to have a work_item_dates_sources record with a null namespace_id.
To resolve this conflict, this MR updates the on delete option for the namespace_id foreign key to cascade. This means that when a namespace is deleted, all associated work_item_dates_sources records will also be deleted.
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
| Before | After |
|---|---|
Numbered steps to set up and validate the change are strongly suggested.
This description was generated for revision 09dc977c using AI