[wp-trac] Re: [WordPress Trac] #5183: General Meta-Data Table

[WordPress Trac]

#5183: General Meta-Data Table
-----------------------------------------+----------------------------------
 Reporter:  filosofo                     |        Owner:  anonymous
     Type:  enhancement                  |       Status:  reopened 
 Priority:  normal                       |    Milestone:           
Component:  General                      |      Version:  2.3      
 Severity:  normal                       |   Resolution:           
 Keywords:  needs-patch meta-table meta  |  
-----------------------------------------+----------------------------------

Comment(by Denis-de-Bernardy):

 Keeping more reference material:

 {{{
 filosofo
 ddebernardy, that would be a regression.  the taxonomy system is one of
 the best parts of wp, because of its abstractness.
 11:48 PM ddebernardy
 I'd vote for it being one fo the worst parts, myself
 11:48 PM filosofo
 why?
 11:48 PM ddebernardy
 well, for one thing, the current implementation has a shared terms table
 11:49 PM
 which prevents a category and a tag with the same slug from having the a
 different name (with/without cap)
 11:49 PM
 then, there is the wp_term_relationships table
 11:49 PM
 which contains cats, and dogs, and what not
 11:49 PM
 this prevents us from defining a foreign key if needs be
 11:50 PM
 and it underperforms what we'd get with a table for posts (it can contain
 tags and cats, that's no issue) and a separate one for links
 11:50 PM
 then, in the wp_taxonomies I suggested, we'd have a unique key on
 (taxonomy,slug,parent)
 11:51 PM
 or something like that involving the three fields
 11:51 PM
 that would allow to have a category with the same slug and multiple
 parents
 11:51 PM
 lastly, a key on slug (or the previous key) would still allow to join
 wp_tax on itself, in order to cross the boundaries on link terms and post
 terms

 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/5183#comment:15>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software