Jump to content

Database Maintenance


Recommended Posts

Just spotted these, highlighted in orange:

  1. CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY.
  2. CubeCart_inventory.popularity has no key set. Expecting KEY.
  3. CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY.
  4. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY.
  5. CubeCart_reviews.approved has no key set. Expecting KEY.
  6. CubeCart_seo_urls.type has no key set. Expecting KEY.
  7. CubeCart_seo_urls.item_id has no key set. Expecting KEY.

Anything I should worry about?

Link to post
Share on other sites

They are unlikely to cause any real issues but having indexes on columns that dont currently have them and (to a lesser extent) having the correct type of index, will speed up queries made by CubeCart.  As it is so simple to add them, I would definitely recommend you do so

Ian

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...