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

Timestamp:

08/26/2009 10:46:33 PM (16 years ago)

Author:

ryan

Message:

Make option_name the primary key for the options table. Props Denis-de-Bernardy. fixes #2699

File:

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

trunk/wp-admin/includes/schema.php

@@ -100 +100 @@
   option_value longtext NOT NULL,
   autoload varchar(20) NOT NULL default 'yes',
-  PRIMARY KEY  (option_id,blog_id,option_name),
-  KEY option_name (option_name)
+  PRIMARY KEY  (option_name),
+  KEY option_id (option_id)
 ) $charset_collate;
 CREATE TABLE $wpdb->postmeta (