magento删除所有用户订单delete order customer(二)
sitor_info`;
72
73
ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;
74
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;
75
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;
76
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;
77
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;
78
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;
79
ALTER TABLE `customer_entity` AUTO_INCREMENT=1;
80
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;
81
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;
82
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;
83
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;
84
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;
85
ALTER TABLE `log_customer` AUTO_INCREMENT=1;
86
ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
87
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;
88
89
-- This is to Reset all the ID counters
90
TRUNCATE `eav_entity_store`;
91
ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1;
92
93
SET FOREIGN_KEY_CHECKS=1;