Support for multiple "Locations" in bugzilla
gerv at mozilla.org
Fri Feb 28 22:47:58 UTC 2003
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
A Google for 'database "mapping tables"' doesn't define the term. Do you
mean lots of tables like:
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.
More information about the developers