Changeset 25179

Timestamp:

08/30/2013 04:29:06 AM (11 years ago)

Author:

nacin

Message:

Add signup_id primary key to $wpdb->signups, and add better indexes.

props josephscott, pento, barry.
see #15004.

Location:

trunk/src

Files:

• wp-admin/includes/schema.php (modified) (2 diffs)
• wp-admin/includes/upgrade.php (modified) (1 diff)
• wp-includes/version.php (modified) (1 diff)

trunk/src/wp-admin/includes/schema.php

@@ -273 +273 @@
 ) $charset_collate;
 CREATE TABLE $wpdb->signups (
+  signup_id bigint(20) NOT NULL auto_increment,
   domain varchar(200) NOT NULL default '',
   path varchar(100) NOT NULL default '',
@@ -283 +284 @@
   activation_key varchar(50) NOT NULL default '',
   meta longtext,
+  PRIMARY KEY  (signup_id),
   KEY activation_key (activation_key),
-  KEY domain (domain)
+  KEY user_email (user_email)
+  KEY user_login_email (user_login,user_email),
+  KEY domain_path (domain,path),
 ) $charset_collate;";
 

trunk/src/wp-admin/includes/upgrade.php

@@ -1979 +1979 @@
     }
 
+    // Upgrade verions prior to 3.7
+    if ( $wp_current_db_version < 25179 && is_multisite() && is_main_network() && ! defined( 'DO_NOT_UPGRADE_GLOBAL_TABLES' ) ) {
+        $wpdb->query( "ALTER TABLE $wpdb->signups ADD signup_id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST" );
+        $wpdb->query( "ALTER TABLE $wpdb->signups DROP INDEX domain" );
+    }
 }
 

trunk/src/wp-includes/version.php

@@ -12 +12 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 24448;
+$wp_db_version = 25179;
 
 /**