[wp-hackers] Meta tables: Take 5

[scribu]

> There are two downsides to this (that I know of):
>
> 1.) Using ENUMs makes synchronization between two databases more fragile
> because ENUMs could be listed in different orders. Having routines that
> encapsulate this handling would resolve most of this.



I don't think this is a concern for regular users. And the pros ought to
know what they're doing.

2.) A core function to register the new type would need to be able to ALTER
> the table and I don't know if this will be an issue on "highly secure"
> environments, i.e.



dbDelta uses ALTER when updating Core. Some plugins also use ALTER
statements to add columns to existing table, so it's nothing out of the
ordinary.

In conclusion, I think using enum is a good ideea.


-- 
http://scribu.net