germancin
5/28/2015 - 2:44 PM

gistfile1.sql

SET @product_id_55 = (select `id` from st_products where slug='zin-55-cd-dvd-sce');
INSERT INTO `st_product_media` (`id`, `product_id`, `color`, `type`, `data`, `display_order`, `correlation_id`)
VALUES (UUID(), @product_id_55, NULL, 'image', '1-bunzin55.jpg', 100, '1-bunzin55.jpg');
	
SET @product_id_55_or = (select `id` from st_products where slug='zin-55original-cd-dvd-sce');
INSERT INTO `st_product_media` (`id`, `product_id`, `color`, `type`, `data`, `display_order`, `correlation_id`)
VALUES (UUID(), @product_id_55_or, NULL, 'image', '1-bunzin55original.jpg', 100, '1-bunzin55original.jpg');

SET @product_id_56 = (select `id` from st_products where slug='zin-56-cd-dvd-sce');
INSERT INTO `st_product_media` (`id`, `product_id`, `color`, `type`, `data`, `display_order`, `correlation_id`)
VALUES (UUID(), @product_id_56, NULL, 'image', '1-bunzin56.jpg', 100, '1-bunzin56.jpg');

SET @product_id_56_or = (select `id` from st_products where slug='zin-56original-cd-dvd-sce');
INSERT INTO `st_product_media` (`id`, `product_id`, `color`, `type`, `data`, `display_order`, `correlation_id`)
VALUES (UUID(), @product_id_56_or, NULL, 'image', '1-bunzin56original.jpg', 100, '1-bunzin56original.jpg');