[wp-trac] Re: [WordPress Trac] #3723: Tagging

[WordPress Trac]

#3723: Tagging
-------------------------+--------------------------------------------------
 Reporter:  ryan         |        Owner:  ryan
     Type:  enhancement  |       Status:  new 
 Priority:  normal       |    Milestone:  2.2 
Component:  General      |      Version:  2.1 
 Severity:  normal       |   Resolution:      
 Keywords:  tags         |  
-------------------------+--------------------------------------------------
Comment (by andy):

 There is no point when a category becomes off-limits to links or posts. It
 is applied via the post2cat/link2cat tables.

 I think the reason for keeping postcats/linkcats/tags in the same table is
 that the metadata is identical. A category "Dogs" will have the same
 description and slug as the tag "Dogs".

 There is no need for a category_type column.

 Where we may get some additional benefit is in consolidating the
 link2cat/post2cat/post2tag tables into a single table called relationships
 or some such.
 {{{
 CREATE TABLE rels (
  rel_table ... /* posts, links, comments, users, etc. */
  rel_type ... /* category, tag, label, etc. */
  rel_cat_id ... /* key to categories table */
  rel_item_id ... /* key to item table (posts, etc.) */
 ) ...
 }}}

 If we avoid enums, this can be used for all sorts of crazy *onomies and
 plugins. It might also make for tighter integration with bbPress and who
 knows what else.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3723#comment:29>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software