Saludos, no se mucho de bases de datos, quisiera por favor alguien me ayudara a insertar unas tablas en mi base de datos para que en oscommerce tenga la opcion de agregar mas imágenes en la descripción de los productos...
Aquí esta la contribución a trabajar: Multi images extra by nico
2) Run this 2 query on your db (please note that the original table “products” is not affected):
CREATE TABLE `products_images` (
`products_id` int(11) NOT NULL auto_increment,
`products_image1` varchar(64) default NULL,
`products_image2` varchar(64) NOT NULL default '',
`products_image3` varchar(64) NOT NULL default '',
`products_image4` varchar(64) NOT NULL default '',
`products_image5` varchar(64) NOT NULL default '',
`products_image6` varchar(64) NOT NULL default '',
`products_image7` varchar(64) NOT NULL default '',
`products_image8` varchar(64) NOT NULL default '',
`products_image9` varchar(64) NOT NULL default '',
PRIMARY KEY (`products_id`)
);
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES (
'', 'Number of extra images', 'NB_IMAGE_EXTRA', '4', 'Number of extra images (0 to 9)', '4', '9', NULL , '2006-04-17 14:10:42', NULL , NULL
);