Issue status update for http://drupal.org/node/19399 Project: Drupal Version: cvs Component: database system Category: bug reports Priority: normal Assigned to: Anonymous Reported by: timothy bennett Updated by: timothy bennett Status: active Commit# 14491 modifies the term_node table to make both tid and nid primary keys. That is, ALTER TABLE term_node ADD PRIMARY KEY (tid,nid); However, I've got nodes (as referenced by nid) that have multiple taxonomy terms associated with them (as reference by tid). As such, the node_term table with have duplicate entries of nid, one for each term (tid) that the node is associated with. I don't believe you can make a column a primary key if the values are not unique can you? (Ref: http://drupal.org/node/19275) -- timothy timothy bennett