kowalikus

-- catalog_product_entity_varchar

SELECT `value_id`,  (SELECT `attribute_code` FROM `eav_attribute` ea WHERE
 ea.`attribute_id` = cpev1.`attribute_id`) AS attribute_code, `value`, (SELECT `value` FROM `catalog_product_entity_varchar` cpev2 WHERE
 cpev1.`entity_id` = cpev2.`entity_id`
 AND cpev1.`entity_type_id` = cpev2.`entity_type_id` 
 AND cpev1.`attribute_id` = cpev2.`attribute_id` 
 AND cpev2.`store_id` = 1) AS value_lampy, (SELECT `value_id` FROM `catalog_product_entity_varchar` cpev2 WHERE
 cpev1.`entity_id` = cpev2.`entity_id`
 AND cpev1.`entity_type_id` = cpev2.`entity_type_id` 

kowalikus

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `sales_flat_creditmemo`; 
TRUNCATE `sales_flat_creditmemo_comment`; 
TRUNCATE `sales_flat_creditmemo_grid`; 
TRUNCATE `sales_flat_creditmemo_item`; 
TRUNCATE `sales_flat_invoice`; 
TRUNCATE `sales_flat_invoice_comment`; 
TRUNCATE `sales_flat_invoice_grid`; 
TRUNCATE `sales_flat_invoice_item`; 

kowalikus

-- Change password for existing user
UPDATE admin_user SET password = md5('password') WHERE username = 'admin';

-- Change URL
UPDATE core_config_data SET value = 'http://localhost/' WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

-- Add new user admin with password 12345678, password md5($salt.$pass).":".$salt
INSERT INTO admin_user SELECT NULL user_id,
"First name" firstname,
"Last name" lastname,