| Christoph Dorn 2007-09-29, 4:07 am |
| I am trying to dump the schema of a wordpress database to an XML file as
a test.
The dump fails with the following error:
there was already an primary index or autoincrement field in "wp_options" before "PRIMARY"
The schema of the wp_options table is as follows:
CREATE TABLE `wp_options` (
`option_id` bigint(20) NOT NULL AUTO_INCREMENT,
`blog_id` int(11) NOT NULL DEFAULT '0',
`option_name` varchar(64) NOT NULL DEFAULT '',
`option_can_override` enum('Y','N') NOT NULL DEFAULT 'Y',
`option_type` int(11) NOT NULL DEFAULT '1',
`option_value` longtext NOT NULL,
`option_width` int(11) NOT NULL DEFAULT '20',
`option_height` int(11) NOT NULL DEFAULT '8',
`option_description` tinytext NOT NULL,
`option_admin_level` int(11) NOT NULL DEFAULT '1',
`autoload` enum('yes','no') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`option_id`,`blog_id`,`option_name`),
KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8
Looks like the MDB2_Schema_Validator does not like the multi-column
primary key?
Is this a bug or am I doing something wrong?
Thanks
Christoph
|