[wp-trac] [WordPress Trac] #38265: Add term_relationship_id column to wp_term_relationships

[WordPress Trac]

#38265: Add term_relationship_id column to wp_term_relationships
-------------------------------------+------------------------------
 Reporter:  johnjamesjacoby          |       Owner:
     Type:  feature request          |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Taxonomy                 |     Version:
 Severity:  normal                   |  Resolution:
 Keywords:  2nd-opinion needs-patch  |     Focuses:
-------------------------------------+------------------------------

Comment (by johnjamesjacoby):

 38265.diff does the following:

 * Changes the primary key to a new `term_relationship_id` column
 * Maintains the uniqueness of the `object_id` and `term_taxonomy_id`
 column index

 With these 2 changes, the following is achievable:

 * Term relationships are now identifiable using 1 single unique integer
 * `wp_term_relationshipmeta` can associate meta data to the penultimate
 `term_relationship_id` column using the meta-data API

 ----

 Things to do:

 * `ALTER` queries for upgrade routine
 * Performance test whether `object_id` needs its own index, vs. the
 composite one on both

--
Ticket URL: <https://core.trac.wordpress.org/ticket/38265#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform