Changeset 3678 for trunk/wp-admin/upgrade-schema.php

Timestamp:

04/02/2006 12:33:10 AM (20 years ago)

Author:

ryan

Message:

Some optimization of the post query. #2604

File:

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

trunk/wp-admin/upgrade-schema.php

@@ -114 +114 @@
   guid varchar(255) NOT NULL default '',
   menu_order int(11) NOT NULL default '0',
-  post_type varchar(100) NOT NULL default 'post',
+  post_type varchar(20) NOT NULL default 'post',
   post_mime_type varchar(100) NOT NULL default '',
   comment_count bigint(20) NOT NULL default '0',
   PRIMARY KEY  (ID),
-  KEY post_name (post_name)
+  KEY post_name (post_name),
+  KEY type_status_date (post_type, post_status, post_date)
 );
 CREATE TABLE $wpdb->users (