Originally Posted by
MaxBodine
Hi Twitch,
************ sql file ***************
ALTER TABLE products CHANGE products_image products_image VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `products` ADD `products_image1` VARCHAR(256) NULL AFTER `products_image`;
ALTER TABLE `products` ADD `products_image2` VARCHAR(256) NULL AFTER `products_image1`;
ALTER TABLE `products` ADD `products_image3` VARCHAR(256) NULL AFTER `products_image2`;
ALTER TABLE `products` ADD `products_image4` VARCHAR(256) NULL AFTER `products_image3`;
ALTER TABLE `products` ADD `products_image5` VARCHAR(256) NULL AFTER `products_image4`;
ALTER TABLE `products` ADD `products_image6` VARCHAR(256) NULL AFTER `products_image5`;
ALTER TABLE `products` ADD `products_image7` VARCHAR(256) NULL AFTER `products_image6`;
ALTER TABLE `products` ADD `products_image8` VARCHAR(256) NULL AFTER `products_image7`;
DELETE FROM product_type_layout WHERE configuration_key = 'SHOW_PRODUCT_INFO_ADDITIONAL_IMAGES';
INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added)
VALUES ('Show Product Additional Images - Twitch', 'SHOW_PRODUCT_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional Images on Product Info <br/> 0= OFF <br/> 1= Stock Zen Cart <br/> 2= Twitch Additional Product Images', '1', '13', 'zen_cfg_select_option(array(\'0\', \'1\', \'2\'), ', now());
********************* eof sql *****************
Did I miss any sql?
Bookmarks