SET FOREIGN_KEY_CHECKS=0;
TRUNCATE sales_flat_invoice ;
TRUNCATE sales_flat_invoice_grid;
TRUNCATE sales_flat_invoice_item ;
TRUNCATE sales_flat_order ;
TRUNCATE sales_flat_order_address ;
TRUNCATE sales_flat_quote_shipping_rate ;
TRUNCATE sales_flat_quote_payment ;
TRUNCATE sales_flat_quote_item_option ;
TRUNCATE sales_flat_quote_item ;
ALTER TABLE sales_flat_invoice AUTO_INCREMENT=1;
ALTER TABLE sales_flat_invoice_grid AUTO_INCREMENT=1;
ALTER TABLE sales_flat_invoice_item AUTO_INCREMENT=1;
ALTER TABLE sales_flat_order AUTO_INCREMENT=1;
ALTER TABLE sales_flat_order_address AUTO_INCREMENT=1;
ALTER TABLE sales_flat_quote_shipping_rate AUTO_INCREMENT=1;
ALTER TABLE sales_flat_quote_payment AUTO_INCREMENT=1;
ALTER TABLE sales_flat_quote_item_option AUTO_INCREMENT=1;
ALTER TABLE sales_flat_quote_item AUTO_INCREMENT=1;
TRUNCATE customer_address_entity;
TRUNCATE customer_address_entity_datetime;
TRUNCATE customer_address_entity_decimal;
TRUNCATE customer_address_entity_int;
TRUNCATE customer_address_entity_text;
TRUNCATE customer_address_entity_varchar;
TRUNCATE customer_entity;
TRUNCATE customer_entity_datetime;
TRUNCATE customer_entity_decimal;
TRUNCATE customer_entity_int;
TRUNCATE customer_entity_text;
TRUNCATE customer_entity_varchar;
TRUNCATE customer_group;
ALTER TABLE customer_address_entity AUTO_INCREMENT=1;
ALTER TABLE customer_address_entity_datetime AUTO_INCREMENT=1;
ALTER TABLE customer_address_entity_decimal AUTO_INCREMENT=1;
ALTER TABLE customer_address_entity_int AUTO_INCREMENT=1;
ALTER TABLE customer_address_entity_text AUTO_INCREMENT=1;
ALTER TABLE customer_address_entity_varchar AUTO_INCREMENT=1;
ALTER TABLE customer_entity AUTO_INCREMENT=1;
ALTER TABLE customer_entity_datetime AUTO_INCREMENT=1;
ALTER TABLE customer_entity_decimal AUTO_INCREMENT=1;
ALTER TABLE customer_entity_int AUTO_INCREMENT=1;
ALTER TABLE customer_entity_text AUTO_INCREMENT=1;
ALTER TABLE customer_entity_varchar AUTO_INCREMENT=1;
ALTER TABLE customer_group AUTO_INCREMENT=1;
TRUNCATE review ;
TRUNCATE review_detail ;
TRUNCATE review_entity ;
TRUNCATE review_entity_summary ;
TRUNCATE review_status ;
TRUNCATE review_store ;
ALTER TABLE review AUTO_INCREMENT=1;
ALTER TABLE review_detail AUTO_INCREMENT=1;
ALTER TABLE review_entity AUTO_INCREMENT=1;
ALTER TABLE review_entity_summary AUTO_INCREMENT=1;
ALTER TABLE review_status AUTO_INCREMENT=1;
ALTER TABLE review_store AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;
除非注明, askADC博客 的文章均为原创,转载请注明作者和出处。
本文链接地址: http://blog.askadc.com/magento-1-4-1-%e6%b8%85%e7%a9%ba%e8%ae%a2%e5%8d%95%e5%92%8c%e5%ae%a2%e6%88%b7/