Add foreign key constraint on projects.namespaces_id with namespaces
As seen in #198593 (comment 276245548), projects can be orphaned when their namespaces entries get removed. Currently namespaces
is a STI table that supports both Namespace
and Group
, but I think we can still add a foreign constraint key constraint between projects.namespaces_id
and namespaces
.