[wp-hackers] Taxonomy Schema Proposal

[Robin Adrianse]

I believe Lloyd is correct, and the only places I would use an ENUM field
would be a field where I know for certain that now and down the road it's
always going to be a set number of possible values, such as a true/false
field.

On Nov 19, 2007 5:40 PM, Lloyd Budd <lloydomattic at gmail.com> wrote:

> On Nov 18, 2007 4:17 AM, Gali <galeenet at gmail.com> wrote:
> > (up up up)
> > I'm working on the term_taxonomy table... here is one thought
> >
> >
> > Isn't the description of the "taxonomy" field a definition for a "ENUM"
> field ?
> > Optimisation of disk usage, consistency, and still allows a plugin to
> > add a permitted value to the ENUM list.
> > And not as normalized as an external table.
>
> I don't know what I'm talking about, but smart sounding people seem
> generally afraid of ENUMs because to change them you have to alter
> table, which triggers a table rebuild.
>
> Hope that helps,
> --
> Lloyd Budd | Digital Entomologist | | Skype:foolswisdom
> WordPress.com | WordPress.org | Automattic.com
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>