Skip to content

Instantly share code, notes, and snippets.

@emtii
Created May 24, 2017 13:47
Show Gist options
  • Save emtii/f8c832851874bd58252c7bd06205cb91 to your computer and use it in GitHub Desktop.
Save emtii/f8c832851874bd58252c7bd06205cb91 to your computer and use it in GitHub Desktop.
delete orders from sw5.1.0 instance
1. truncate
====================================================================================================================
SET foreign_key_checks = 0;
TRUNCATE `s_order`;
TRUNCATE `s_order_attributes`;
TRUNCATE `s_order_basket`;
TRUNCATE `s_order_basket_attributes`;
TRUNCATE `s_order_basket_saved`;
TRUNCATE `s_order_basket_saved_items`;
TRUNCATE `s_order_billingaddress`;
TRUNCATE `s_order_billingaddress_attribtues`;
TRUNCATE `s_order_comparisons`;
TRUNCATE `s_order_details`;
TRUNCATE `s_order_details_attribtues`;
TRUNCATE `s_order_documents`;
TRUNCATE `s_order_documents_attributes`;
TRUNCATE `s_order_esd`;
TRUNCATE `s_order_history`;
TRUNCATE `s_order_notes`;
TRUNCATE `s_order_number`;
TRUNCATE `s_order_shippingaddress`;
TRUNCATE `s_order_shippingaddress_attributes`;
SET foreign_key_checks = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment