Ticket #1037 (closed enhancement: wontfix)
Refactor builds/build_requests tables to remove duplicate rows in builds table.
|Reported by:||catlee||Owned by:|
If you have a build that has merged more than one build request, you'll have one row in the builds table per build request. Each row will be identical, except for the column linking back to the build request.
This makes writing tools a bit complicated since you have to cope with the fact that more than one row in builds can correspond to the same single build on a slave.
I think we need another table that maps builds to build requests, e.g. a list of (build request id, build id) tuples. We could then drop the 'brid' column from the builds table.