some missing foreign key constraints in Bugzilla/DB/Schema.pm
Tony Fu
tfu at redhat.com
Tue Jan 22 05:16:20 UTC 2008
It seems that some foreign key constraints are not included in
Bugzilla/DB/Schema.pm. For example,
bugs.product_id: it can be
product_id => {TYPE => 'INT2', NOTNULL => 1,
REFERENCES => {TABLE => 'products',
COLUMN => 'id'}}
longdescs.bug.id: it can be
bug_id => {TYPE => 'INT3', NOTNULL => 1,
REFERENCES => {TABLE => 'bugs',
COLUMN => 'bug_id'}}
Did those missing foreign key constraints be taken out from db schema
for specific reasons?
Regards,
Tony
More information about the developers
mailing list