some missing foreign key constraints in Bugzilla/DB/

Tony Fu tfu at
Tue Jan 22 05:16:20 UTC 2008

It seems that some foreign key constraints are not included in
Bugzilla/DB/  For example, 

bugs.product_id: it can be 

product_id          => {TYPE => 'INT2', NOTNULL => 1,
                        REFERENCES => {TABLE => 'products',
                                       COLUMN => '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?


More information about the developers mailing list