anyone ever play with the bugzilla db?

ShaqDiesel · 11-04-2008, 01:46 PM

sorry if I'm posting in the wrong forum, but the irc channel at bugzilla is pretty quiet.

I'm trying to write a script that will iterate through bug_ids and add a bug number to the blocked field. I looked at the columns in the dependencies table and it contains blocked but no bug_id! How does bugzilla associate a bug and its dependencies without a bug_id column? Is one of the columns a foreign key to another table that contains bug_ids?

paulsm4 · 11-04-2008, 08:49 PM

Hi -

"bug_id" is, of course, the primary key in table "bugs".

"blocked" and "dependson" are both foreign keys in table "dependencies". If one bug depends on another, then "blocked" is the bug ID of the dependent bug, and "dependson" is the bug ID of the bug it depends on.

There is one row in "dependencies" for each "blocked" bug in the system.

'Hope that helps .. PSM