Custom fields schema

[Shane H. W. Travis]

On Fri, 24 Dec 2004, Maxwell Kanat-Alexander wrote:

> ----- Original Message -----
> From: Sean McAfee <etzwane at schwag.org>
> > As an aside, my own intuition is against the notion of modifying the
> > database schema as part of routine system administration.
>
>   Indeed. I also recall justdave pointing out (somewhere in the
> userprefs-table bug, that I don't recall the number of) that for the
> "Bugzilla plugins" idea, we should stick to "columns-as-table-rows,"
> because that makes a drop-in plugin for Bugzilla much easier to write.

I was just about to say the exact same thing, Max.

Reference: https://bugzilla.mozilla.org/show_bug.cgi?id=98123#c23

The comment was made in the User Preferences bug, but the implications are
far-reaching. I cannot help but think that if it matters here, then it would
matter even more for something as large and far-reaching as customized
fields.

(For the record, I started off designing new tables for bug 98123 with
each-pref-is-a-column category firmly fixed in my mind as 'the only/best way
to go'. After Dave's comment I started considering other ideas; the latest
schema abandons that line of thought, and IMHO is better for having done
so.)

Shane H.W. Travis       | The greatest of all mistakes is to do nothing
travis at sedsystems.ca    |  because you can only do a little.
Saskatoon, Saskatchewan |   Do what you can.  -- Sydney Smith