CB database error PRIMARY key does not exist

I am running CB 1.91 on Joomla3.2.1 apache. After installing Paid Subs, I set it up and configured Paypal as gateway and tested. Everything works except that the newly registered user cannot login. Upon investigation I found, CB tools check database alerted to about 20 database errors in CB. The autofix did not work, has an SQL problem with dropping and adding primary keys. I fixed all manually except for two.

Core CB Database structure differences:
Table #__comprofiler_members Index PRIMARY does not exist
Table #__comprofiler_views Index PRIMARY Column viewer_id is not the intended column, but lastview

I have tried everything in my limited sql ability to add primary to the above indexes but not one of the options are acceptable to PhPMyAdmin. Had about six other that I could fix but these two are beyond my ability.

Your help will be highly appreciated.
Thank you

The indexes for those two tables are as follows.

Members:


Views:


However your indexes being missing is a huge problem. You've some serious database issues if your indexes are all messed up.