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

Timestamp:

11/19/2009 04:42:07 PM (17 years ago)

Author:

ryan

Message:

Make option_id primary. Add uniques for option_name and autoload. see #2699

File:

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

trunk/wp-admin/includes/schema.php

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