Changeset 6736 for trunk/wp-admin/includes/schema.php

Timestamp:

02/05/2008 11:29:59 PM (17 years ago)

Author:

ryan

Message:

Order by and index on comment_date_gmt instead of comment_date to insulate order from offset changes. fixes #5773

File:

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

trunk/wp-admin/includes/schema.php

@@ -54 +54 @@
   KEY comment_approved (comment_approved),
   KEY comment_post_ID (comment_post_ID),
-  KEY comment_approved_date (comment_approved,comment_date)
+  KEY comment_approved_date_gmt (comment_approved,comment_date_gmt)
 ) $charset_collate;
 CREATE TABLE $wpdb->links (