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