[wp-trac] [WordPress Trac] #24279: wp_signups table does not have a primary key

[WordPress Trac]

#24279: wp_signups table does not have a primary key
-------------------------+-----------------------------
 Reporter:  econnell     |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Database     |    Version:  3.5.1
 Severity:  normal       |   Keywords:
-------------------------+-----------------------------
 There was an old bug from 7 years ago on the WPMU Trac that was marked as
 "wontfix" for this, however, this is the only table in the WP database
 schema that is missing a primary key.

 Using Percona XtraDB Cluster, a primary key is needed on all tables in
 order to perform DELETE statements across the cluster as described here:
 http://www.percona.com/doc/percona-xtradb-cluster/limitation.html.  It can
 just be an auto increment "id" column if duplicate entries are needed in
 this table.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/24279>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software