Open Bug 462066 Opened 16 years ago Updated 15 years ago

Add FK constraints to the bugs table

Categories

(Bugzilla :: Database, enhancement)

Product:
Bugzilla
Component:
Database
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

People

(Reporter: LpSolit, Unassigned)

References

(Depends on 1 open bug, Blocks 1 open bug)

Details

Most fields in the 'bugs' table are refering to other tables and so FK constraints should be added to them.

Currently, we can easily add these dependencies for the following columns: assigned_to, reporter, qa_contact (all three pointing to profiles.userid), component_id (pointing to components.id), and product_id (pointing to products.id).

Those columns should first be converted to integers before adding FK constraints, see bug 287311: bug_severity, bug_status, op_sys, priority, rep_platform, version, resolution, and target_milestone. This probably better to fix bug 287311 to avoid having to fix FK constraints later.

I will file a separate bug to fix the first columns mentioned above.
Depends on: 462067
You need to log in before you can comment on or make changes to this bug.