Support for multiple "Locations" in bugzilla

[Bradley Baetz]

On Fri, Feb 28, 2003 at 10:47:58PM +0000, Gervase Markham wrote:
> 
> A Google for 'database "mapping tables"' doesn't define the term. Do you 
> mean lots of tables like:

No, I mean tables like:

bug_id, field_id, value

We will need several of those, however - one for string types, and one
for number types, so that indexes work optimally. For stuff like os's,
(field_id, value) is an FK [Foreign Key] to another table which has the
name<-> number mapping.

(If we ever support email types that way, then wed need a third one, to
fk to the profiles table)

> 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?

1->1 vs 1->many is only how many entries there are. We may want
(another) separate table for that to add the UNIQUE constraint - I
haven't thought too much about that.

> 
> >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.
> 

I want mysql to go away :) But yeah, its not happening in the short
term.

> Gerv
> 

Bradley