Hi,

I just ran a CHECK TABLES on my sugar installation, and got the following messages from phpadmin. Is this cause for alarm? If it is, what should the correct database structure be? Is there a reference somewhere?

Problems with indexes of table `accounts`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `accounts_bugs`
More than one INDEX key was created for column `account_id`
Problems with indexes of table `accounts_contacts`
More than one INDEX key was created for column `account_id`
More than one INDEX key was created for column `contact_id`
Problems with indexes of table `accounts_opportunities`
More than one INDEX key was created for column `account_id`
More than one INDEX key was created for column `opportunity_id`
Problems with indexes of table `acl_actions`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `acl_roles`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `acl_roles_actions`
More than one INDEX key was created for column `role_id`
Problems with indexes of table `acl_roles_users`
More than one INDEX key was created for column `role_id`
Problems with indexes of table `bugs`
UNIQUE and INDEX keys should not both be set for column `bug_number`
Problems with indexes of table `calls_contacts`
More than one INDEX key was created for column `call_id`
Problems with indexes of table `calls_users`
More than one INDEX key was created for column `call_id`
Problems with indexes of table `cases`
UNIQUE and INDEX keys should not both be set for column `case_number`
Problems with indexes of table `cases_bugs`
More than one INDEX key was created for column `case_id`
Problems with indexes of table `contacts`
More than one INDEX key was created for column `deleted`
Problems with indexes of table `contacts_bugs`
More than one INDEX key was created for column `contact_id`
Problems with indexes of table `contacts_cases`
More than one INDEX key was created for column `contact_id`
Problems with indexes of table `contacts_users`
More than one INDEX key was created for column `contact_id`
Problems with indexes of table `email_cache`
More than one INDEX key was created for column `ie_id`
Problems with indexes of table `fields_meta_data`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `leads`
More than one INDEX key was created for column `last_name`
Problems with indexes of table `meetings_contacts`
More than one INDEX key was created for column `meeting_id`
Problems with indexes of table `meetings_users`
More than one INDEX key was created for column `meeting_id`
Problems with indexes of table `opportunities_contacts`
More than one INDEX key was created for column `opportunity_id`
Problems with indexes of table `outbound_email`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `projects_accounts`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `projects_bugs`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `projects_cases`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `projects_contacts`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `projects_opportunities`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `projects_products`
More than one INDEX key was created for column `project_id`
Problems with indexes of table `prospects`
More than one INDEX key was created for column `last_name`
Problems with indexes of table `prospect_list_campaigns`
More than one INDEX key was created for column `prospect_list_id`
Problems with indexes of table `roles`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `tracker`
More than one INDEX key was created for column `user_id`
Problems with indexes of table `users`
More than one INDEX key was created for column `user_name`