What happened to the custom fields?

[Kent Multer]

I just ran the update wizard for Merchant version 10.07.02. It showed me this warning:

Miva Merchant 10.07.02 makes changes to Custom Fields database tables

What changes? I've written a lot of modules that work with these tables; I need to know what's been changed. The release notes mention some improvements in performance, but there's nothing about the changes to the tables.

Thanks --

[dcarver]

We created an indexes sNN_CFMXXXValues_2 ON sNN_CFMXXXValues ( field_id, value ) on all the custom field value tables. We did this due to the fact that the module now only searches either value or value_long based on the passed in search length. This greatly improved performance on sites that had tens of millions custom field records.

[Kent Multer]

Thanks, David. New indexes won't affect my modules -- or anyone else's. :^)

And indexes on the value columns are a good feature. I've occasionally written modules that created these indexes, to speed up DB queries.

[ILoveHostasaurus]

You should not be utilizing direct database queries against Miva Merchant core tables, you should use function calls to interact with that data. Using database queries against core tables will not be reliable, and will introduce security issues. And you should in no way ever be altering the schema on tables you didn't create.