Changeset 19799 for trunk/wp-admin/includes/upgrade.php

Timestamp:

01/31/2012 06:26:07 PM (14 years ago)

Author:

ryan

Message:

Drop the comment_approved index from the comments table. comment_approved_date_gmt is sufficient. fixes #19935

File:

• trunk/wp-admin/includes/upgrade.php (modified) (2 diffs)

trunk/wp-admin/includes/upgrade.php

@@ -460 +460 @@
         upgrade_330();
 
-    if ( $wp_current_db_version < 19793 )
+    if ( $wp_current_db_version < 19799 )
         upgrade_340();
 
@@ -1225 +1225 @@
     global $wp_current_db_version, $wpdb;
 
-    $wpdb->hide_errors();
-    $wpdb->query( "ALTER TABLE $wpdb->options DROP COLUMN blog_id" );
-    $wpdb->show_errors();
-}   
-    
+    if ( $wp_current_db_version < 19798 ) {
+        $wpdb->hide_errors();
+        $wpdb->query( "ALTER TABLE $wpdb->options DROP COLUMN blog_id" );
+        $wpdb->show_errors();
+    }
+
+    if ( $wp_current_db_version < 19799 ) {
+        $wpdb->hide_errors();
+        $wpdb->query("ALTER TABLE $wpdb->comments DROP INDEX comment_approved");
+        $wpdb->show_errors();
+    }
+}
+
 /**
  * Execute network level changes