Skip to content

Fix the on delete option for namespace_id FK on work_item_dates_sources

Alexandru Croitor requested to merge fix_work_item_source_dates_cascade_option_on_fk_to_namespace_id into master

What does this MR do and why?

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.

re #449048 (closed)

MR acceptance checklist

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 or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

This description was generated for revision 09dc977c using AI

Edited by Alexandru Croitor

Merge request reports