WordPress.org

Make WordPress Core

Changeset 13227


Ignore:
Timestamp:
02/19/2010 05:56:40 PM (10 years ago)
Author:
ryan
Message:

Add an index on comment_parent to speed up wp_delete_comment() reparenting queries. fixes #12289

Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/includes/schema.php

    r13137 r13227  
    8282  KEY comment_post_ID (comment_post_ID),
    8383  KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
    84   KEY comment_date_gmt (comment_date_gmt)
     84  KEY comment_date_gmt (comment_date_gmt),
     85  KEY comment_parent (comment_parent)
    8586) $charset_collate;
    8687CREATE TABLE $wpdb->links (
  • trunk/wp-admin/includes/upgrade.php

    r13209 r13227  
    11031103 */
    11041104function upgrade_300() {
    1105     populate_roles_300();
    1106     if ( is_multisite() && is_main_site() && ! defined( 'MULTISITE' ) && get_site_option( 'siteurl' ) === false )
    1107         add_site_option( 'siteurl', '' );
     1105    global $wp_current_db_version;
     1106
     1107    if ( $wp_current_db_version < 12751 ) {
     1108        populate_roles_300();
     1109        if ( is_multisite() && is_main_site() && ! defined( 'MULTISITE' ) && get_site_option( 'siteurl' ) === false )
     1110            add_site_option( 'siteurl', '' );
     1111    }
    11081112}
    11091113
  • trunk/wp-includes/version.php

    r12753 r13227  
    1616 * @global int $wp_db_version
    1717 */
    18 $wp_db_version = 12751;
     18$wp_db_version = 13226;
    1919
    2020/**
Note: See TracChangeset for help on using the changeset viewer.