id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
14513,Time for a wp_post_relationships table?,mikeschinkel,,"Now that we have custom post types the obvious next step for people using them is to start relating post types using parent-child and/or many-to-many relationships.  I've implemented a taxonomy-mirrored-posts plugin but am starting to discover [http://lists.automattic.com/pipermail/wp-hackers/2010-July/033510.html many of the problems that @prettyboymp has pointed out on wp-hackers] and think it might be time we consider adding a new table to allow us to relate post and to allow us to build functionality around this table such as related post pickers, etc.

I'd like to offer a [http://en.wikipedia.org/wiki/Straw_man_proposal straw man proposal] to start discussions of a potential `wp_post_relationships` table added to WordPress 3.1 with three fields: `parent_id`, `post_id` and `term_taxonomy_id.` This allows us to relate any two post records and optionally associate at taxonomy+term to classify the relationship (here's the SQL to create the table): 

{{{
CREATE TABLE `wp_post_relationships` (
  `parent_id` bigint(20) unsigned NOT NULL,
  `post_id` bigint(20) unsigned NOT NULL,
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`parent_id`,`post_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`),
  KEY `post_id` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
}}}

Looking forward to your feedback.",feature request,closed,normal,,Post Types,3.0.1,normal,maybelater,,mikeschinkel@… momo360modena ben@… sorich87@… mau wikichaves goto10 cogmios axwax johnnychen jwriteclub bainternet hello@… azizur ciobi deryk@… tammyhart trac@… frank@… mpretty@… chris@… dougal@… rwuensche@… sabreuse r_a_m_i@… chuck@… tomaugerdotcom@… freshman66 skippybosco sirzooro MHagemeister travis@… mercijavier@… info@… andrewayala jeremyfelt code@… lol@… murtrd ali.mohammadhosseini@… wordpress@… hhhsands marcosf wordpress@… wp@…