Add generic metadata table
|Reported by:||scribu||Owned by:|
Over time, there have been requests for category metadata, comment metadata and even link metadata.
In one of the more recent discussions on this topic, a generic metadata table has been proposed.
I also think that this is the way to go forward: instead of having a separate table for each object type, just have a single, generic, plugin friendly table.
This table would have the following columns:
object_id object_type meta_id meta_key meta_value
It's basically the same as the current postmeta and usermeta, except that post_id and user_id are replaced with object_id. Also, a new column 'object_type' would simplify lookups.