Support for multiple "Locations" in bugzilla

[Gervase Markham]

Bradley Baetz wrote:
> On Fri, Feb 28, 2003 at 09:53:56PM +0000, Gervase Markham wrote:
> 
>>But, I was rather hoping that bbaetz, as our database guru, would lay 
>>down the law about the right way to do this.
> 
> 'database guru'? :)

Well, if anyone gets that title, you do ;-)

> Anyway, I thought I'd mentioned the correct idea several times before.
> Use mapping tables. This (or any other solution, really) requires most
> of the fielddefs table hacks, such as the mailhead column, to be
> removed.

A Google for 'database "mapping tables"' doesn't define the term. Do you 
mean lots of tables like:

customers
bug_id   value
1        FooCo
2        FooCo
1        Bar Corp.
3        Baz Ltd.
4        Quux, Inc.

with slight variations depending on whether it's a 1->1 or 1->many or 
enum-style mapping? And doing joins everywhere to connect it all up?

> Hows postgres support coming along? :)

However it's coming along, MySQL support isn't going away... so any 
solution has to work sensibly in both.

Gerv