Migrace virtuemart

ALTER TABLE `j25_virtuemart_medias` ADD `virtuemart_product_id` INT( 11 ) NOT NULL AFTER `virtuemart_vendor_id`;
ALTER TABLE `j25_virtuemart_medias` ADD INDEX ( `virtuemart_product_id` );
INSERT INTO j25_virtuemart_medias( virtuemart_product_id, file_url )
SELECT virtuemart_product_id, product_url
FROM j25_virtuemart_products
WHERE product_url IS NOT NULL
AND product_url != '';
UPDATE `j25_virtuemart_medias` SET file_mimetype = 'image/jpeg',
file_type = 'product' WHERE virtuemart_product_id >0;
UPDATE j25_virtuemart_medias SET file_title = SUBSTRING_INDEX( file_url, '/' , -1 ) WHERE virtuemart_product_id >0;
INSERT INTO `j25_virtuemart_product_medias`
(virtuemart_product_id,virtuemart_media_id,ordering)
SELECT virtuemart_product_id,virtuemart_media_id,1
FROM j25_virtuemart_medias
WHERE virtuemart_product_id>0;
UPDATE `j25_virtuemart_medias` SET file_url = REPLACE( file_url, 'http://www.vasedomena.cz/adresar_s_obrazky/', '' ) WHERE virtuemart_product_id >0;
ALTER TABLE `j25_virtuemart_medias` ADD `file_url2` VARCHAR( 900 ) NOT NULL AFTER `file_url`;
UPDATE `j25_virtuemart_medias` SET file_url2 =file_url;
UPDATE `j25_virtuemart_medias` SET file_url = REPLACE( file_url, '/', '_' ) WHERE virtuemart_product_id >0;
UPDATE `j25_virtuemart_medias` SET file_url = CONCAT('images/stories/virtuemart/product/', file_url) WHERE virtuemart_product_id >0