Description: Red Hat has added referential integrity checks to the database schema to ensure against any foreign key violations. Upstream Bugzilla code has implemented some initial support for foreign keys as well. Function Requirements: MySQL 5+ redhat/bugs-fk.mysql
It is implemented in bugs-fk.mysql file. I used historical method and the LOC is 640.
Tony, how do you get 640 lines? I would expect that you only have to add the FK constraints. That would be around 100LOC, no?
I used cloc to calculate the LOC of our existing db schema file, which includes FK constraints and all talbes definition as well. For FK constraints only, 100LOC is a reasonable number. Changing LOC to 100.
Added FKs constraints in Bugzilla/DB/Schema.pm file. Please refer to bug #420611.
Submitted a Bugzilla/DB/Schema.pm patch, which included all foreign key constraints, to upstream for review.
Tony please attach the upstream bug link to this bug so we can keep track of it. Either in the External Bugzilla References section or in the URL text field. Thanks
Get review feedback from upstream. Update the schema according to the feedback and submitted new patch for upstream review.
Do we already have this in our 3.2 tree? If not we will need a patch for this bug so hit our first milestone. Dave
(In reply to comment #8) > Do we already have this in our 3.2 tree? If not we will need a patch for this > bug so hit our first milestone. > > Dave It should have been included in Bugzilla/DB/Schema.pm I attached in #420611. Tony
Will create a new bug to track the progress of mergering FKs constraints into upstream code. Close this bug.