Shopping Cart's phpMyAdmin alterations
Zen v1.3.8a
Open phpMyAdmin for your Zen database and add the following line in the SQL tab, change zen_ prefix if needed:
ALTER TABLE `zen_products` ADD INDEX `idx_products_image` ( `products_image` );
osCommerce v2.2
Open phpMyAdmin for your OSC2 database and add the following two lines in the SQL tab:
ALTER TABLE `products` ADD INDEX `idx_products_image` ( `products_image` );
ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 32 );
CRE Loaded v6.3
Open phpMyAdmin for your CRE Loaded database and add the following four lines in the SQL tab:
ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
ALTER TABLE `products` ADD INDEX `idx_products_image` ( `products_image` );
ALTER TABLE `products` ADD INDEX `idx_products_image_lrg` ( `products_image_lrg` );
ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR( 32 );