[wp-trac] [WordPress Trac] #10233: Add generic metadata table

[WordPress Trac]

#10233: Add generic metadata table
-----------------------------+----------------------------------------------
 Reporter:  scribu           |       Owner:             
     Type:  feature request  |      Status:  new        
 Priority:  normal           |   Milestone:  2.9        
Component:  General          |     Version:             
 Severity:  normal           |    Keywords:  needs-patch
-----------------------------+----------------------------------------------
 Over time, there have been requests for category metadata, comment
 metadata and even link metadata.

 In one of the more [http://comox.textdrive.com/pipermail/wp-
 hackers/2009-June/026584.html 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.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10233>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software