|
Wednesday 09 July 2008 6:21:11 am
I am using MySQL (version 5.0.22) with ezPublish 4.0 and I get the same warning messages regarding indexes using the same columns for the tables below:
Problems with indexes of table `ezcontentobject_attribute`
PRIMARY and INDEX keys should not both be set for column `id`
More than one INDEX key was created for column `contentobject_id`
Problems with indexes of table `ezcontentobject_name`
PRIMARY and INDEX keys should not both be set for column `contentobject_id`
Problems with indexes of table `ezenumobjectvalue`
PRIMARY and INDEX keys should not both be set for column `contentobject_attribute_id`
Problems with indexes of table `ezkeyword`
More than one INDEX key was created for column `keyword`
Problems with indexes of table `ezkeyword_attribute_link`
More than one INDEX key was created for column `keyword_id`
Problems with indexes of table `eznode_assignment`
More than one INDEX key was created for column `contentobject_id`
Problems with indexes of table `ezurlalias_ml`
PRIMARY and INDEX keys should not both be set for column `parent`
More than one INDEX key was created for column `parent`
More than one INDEX key was created for column `text`
More than one INDEX key was created for column `action`
More than one INDEX key was created for column `action_type` I believe MySQL will ignore the redundant indexes, however perhaps a review of the schema would be advisable.
|