Categories
View Replies (1)

Resolved Some csvi tables do not have primary keys

  1. rusasadmins
    rusasadmins
  2. RO CSVI
  3. Thursday, 17 June 2021
  4.  Subscribe via email
We are considering using Gallera clustering which requires all of our tables to have primary keys on all tables. We are going through all of the tables in our databases that do not have primary keys (we are aware that some joomla core tables do not have primary keys).

csvi_icecat_index csv improved email roland 8 sites
csvi_icecat_suppliers csv improved email roland 8 sites
csvi_related_categories csv improved email roland 8 sites
csvi_related_products csv improved email roland 8 sites

Do you know if these tables will ever 'get' primary keys in future versions of csvi?

thanks,
Laura
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Laura,

These tables do not have primary keys indeed as these tables are not used for "permanent storage". The ICEcat tables are only one-way for inserting the index files from ICEcat and after that it is just queried. The related tables are to keep track of related products during an import and emptied afterwards.

There are no plans to add primary keys to these tables.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!