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: Goba -Status: active +Status: by design Not a bug. Goba Previous comments: ------------------------------------------------------------------------ March 24, 2005 - 21:28 : timothy bennett 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 ------------------------------------------------------------------------ March 24, 2005 - 21:36 : chx It's a multiple column PRIMARY KEY and it will apply unless you have the same nid-tid pair twice which shall not happen...