id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
15471,Associate Attachments with Multiple Parents,filosofo,,"There's no logical reason attachments couldn't be associated with multiple posts, and it would make a number of things easier and avoid needless duplication.

I suggest we do this by setting the attachment parent(s) in postmeta, with (possibly) multiple keys named `_parent`, like so:

{{{
+---------+---------+-------------------+------------+
| meta_id | post_id | meta_key          | meta_value |
+---------+---------+-------------------+------------+
|       1 |     123 | _parent           | 456        | 
|       2 |     123 | _parent           | 789        | 
+---------+---------+-------------------+------------+
}}}

Here, 123 is the attachment object's ID, and 456 and 789 are the IDs of its associated post objects.

Thoughts?

",feature request,closed,normal,,Media,,normal,duplicate,,mikeschinkel@… ciobi deryk@… dartanjan