Carey careys7
careys7
/ removeTestDataResetEntitySeries.sql
Created
July 16, 2014 04:14
— forked from peterjaap/removeTestDataResetEntitySeries.sql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Empty relevant tables | |
| DELETE FROM sales_flat_creditmemo; | |
| DELETE FROM sales_flat_invoice; | |
| DELETE FROM sales_flat_order; | |
| DELETE FROM sales_flat_quote; | |
| DELETE FROM sales_flat_shipment; | |
| DELETE FROM customer_entity; | |
| # Reset increment_ids | |
| # Beware of store_ids when using multiple stores |