Hi,
When you use the affiliate system in the HikaShop backend, HikaShop will create temporally some views and will delete them just after that.
Some export/import my in PHPMyAdmin does not handle right the views and import them as "table" (but it's not tables).
That's why we now force the deletion of the views in the affiliate system once the processing has been made.
If you really can't delete them ; One solution could be to create a new database, to move every tables except the views, drop the old database and rename the new one.
Once you will clean these views/tables ; you shouldn't have any other issue because HikaShop are deleting them now (so they won't be in the future database exports).
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.