/*修改订单时间*/
update sales_flat_order set created_at="2015-04-12 06:13:47" where increment_id="100000689";
update sales_flat_order_grid set created_at="2015-04-12 06:13:47" where increment_id="100000689";
update sales_flat_order_item as t1
left join sales_flat_order as t2 on t2.entity_id=t1.order_id
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689";
update sales_flat_order_status_history as t1
left join sales_flat_order as t2 on t2.entity_id=t1.parent_id
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689" and t1.status="pending_payment";
/* 下面的表不要了*/
/*
update sales_flat_quote as t1
left join sales_flat_order as t2 on t1.reserved_order_id=t2.increment_id
set t1.created_at="2015-03-24 06:53:20" where t2.increment_id="100000378";
update sales_flat_quote_address as t1
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";
update sales_flat_quote_item as t1
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";
update sales_flat_quote_payment as t1
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";
update sales_flat_quote_shipping_rate as t1
left join sales_flat_quote_address as t2 on t1.address_id=t2.address_id
left join sales_flat_quote as t3 on t2.quote_id=t3.entity_id
left join sales_flat_order as t4 on t3.reserved_order_id=t4.increment_id
set t1.created_at="2015-03-24 06:53:20" where t4.increment_id="100000378"; */