DB updates

gistfile1.txt

update sales_flat_order set status = 'ready' where increment_id like '100001656' limit 1 \G;
update sales_flat_order_grid set status='ready' where increment_id like "%1656%"\G;
select entity_id from sales_flat_order where increment_id like "100001716";
### 1648
insert into sales_flat_order_status_history values(null, 1648, 0, 1, "Изменён статус заказа", 'ready', NOW() , 'order', 'Support');


update sales_flat_order set state="pending_payment", status = 'pending_payment' where increment_id like '100001716' limit 1 \G;
update sales_flat_order_grid set status='pending_payment' where increment_id like "100001716" \G;
select entity_id from sales_flat_order where increment_id like "100001716";
### 1721
insert into sales_flat_order_status_history values(null, 1721, 0, 1, "Изменён статус заказа", 'pending_payment', NOW(), 'order', 'Support');


SET NAMES utf8;
UPDATE  `stage_antoshka`.`sales_flat_order_payment` SET  `method` =  'upcpayment' WHERE  `sales_flat_order_payment`.`entity_id` =1788;
insert into sales_flat_order_status_history values(null, 1788, 0, 1, "Изменён метод оплаты", 'pending_payment', '2014-03-12 23:22:00', 'order', 'Support');

UPDATE  `stage_antoshka`.`sales_flat_order` SET  `state` =  'new', `status` =  'pending' WHERE  `sales_flat_order`.`entity_id` =1819;
UPDATE  `stage_antoshka`.`sales_flat_order_grid` SET  `status` =  'pending' WHERE  `sales_flat_order_grid`.`entity_id` =1819;
insert into sales_flat_order_status_history values(null, 1819, 0, 1, "Изменён статус заказа", 'ready', '2014-03-13 00:02:00', 'order', 'Support');