The old_status and new_status columns of the status_workflow table should point to bug_status.id. Not that old_status can be NULL. I hope this doesn't prevent to add the constraint to it.
I can work on this. For MySQL and Oracle, the foreign keys in the referencing table can have nulls in them, so keeping old_status NULL in any row should not be a problem.
Created attachment 379655 [details] [diff] [review] Added the foreign key constraint
Attachment #379655 - Flags: review?(LpSolit)
Attachment #379655 - Flags: review?(LpSolit) → review?(mkanat)
Assignee: vipinhegde → nbezzala
Whiteboard: [Good Intro Bug]
Target Milestone: --- → Bugzilla 3.6
Checking in Bugzilla/DB/Schema.pm; /cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema.pm,v <-- Schema.pm new revision: 1.119; previous revision: 1.118 done
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.