0rsgSvZP

1-- Set all customer passwords to password123
2update customer_entity_varchar set value = '15d590025cf0bc5c7db18292ca8c73342d3a7706f0deb5589431e3a137b420cf:jK' where attribute_id = 12 and entity_type_id = 1;
3
4-- set all email addresses
5update customer_entity set email = concat('noname+', entity_id, '@gmail.com');
6update sales_flat_order_address set email = concat('noname+', customer_id, '@gmail.com') where customer_id is not null;
7update sales_flat_order set customer_email = concat('noname+', customer_id, '@gmail.com') where customer_id is not null;
8update sales_flat_order_address set email = concat('noname+unknown@gmail.com') where customer_id is null;
9update sales_flat_order set customer_email = concat('noname+unknown@gmail.com') where customer_id is null;
10update sales_flat_quote set customer_email = concat('noname+', customer_id, '@gmail.com') where customer_id is not null;
11update sales_flat_quote_address set email = concat('noname+', customer_id, '@gmail.com') where customer_id is not null;
12update sales_flat_quote_address set email = concat('noname+unknown@gmail.com') where customer_id is null;
13update sales_flat_quote set customer_email = concat('noname+unknown@gmail.com') where customer_id is null;
14
15-- set all phone numbers
16update customer_address_entity_varchar set value = '15551231234' where attribute_id = 31 and entity_type_id = 2;
17update sales_flat_order_address set email = '15551231234' where customer_id is not null;
18update sales_flat_order set customer_email = '15551231234' where customer_id is not null;
19update sales_flat_order_address set email = '15551231234' where customer_id is null;
20update sales_flat_order set customer_email = '15551231234' where customer_id is null;
21update sales_flat_quote set customer_email = '15551231234' where customer_id is not null;
22update sales_flat_quote_address set email = '15551231234' where customer_id is not null;
23update sales_flat_quote_address set email = '15551231234' where customer_id is null;
24update sales_flat_quote set customer_email = '15551231234' where customer_id is null;