Changeset 25179 for trunk/src/wp-admin/includes/upgrade.php

Timestamp:

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

Author:

nacin

Message:

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

props josephscott, pento, barry.
see #15004.

File:

• trunk/src/wp-admin/includes/upgrade.php (modified) (1 diff)

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" );
+    }
 }