Support for multiple "Locations" in bugzilla
bbaetz at acm.org
Sat Mar 1 00:25:26 UTC 2003
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
More information about the developers