[drupal-devel] [bug] Can't apply database update_128

[Goba]

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...