Created
October 29, 2020 15:20
-
-
Save leohilbert/64d8712ff479621708c7033ddf68be62 to your computer and use it in GitHub Desktop.
SQL-Commands to purge your Shopware database from the Shopware B2B-Suite (4.3.0)
This file contains 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
SET FOREIGN_KEY_CHECKS=OFF; | |
DROP TABLE IF EXISTS `b2b_acl_contact_address`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_budget`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_contact`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_contingent_group`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_order_list`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_role`; | |
DROP TABLE IF EXISTS `b2b_acl_contact_route_privilege`; | |
DROP TABLE IF EXISTS `b2b_acl_role_address`; | |
DROP TABLE IF EXISTS `b2b_acl_role_budget`; | |
DROP TABLE IF EXISTS `b2b_acl_role_contact`; | |
DROP TABLE IF EXISTS `b2b_acl_role_contingent_group`; | |
DROP TABLE IF EXISTS `b2b_acl_role_order_list`; | |
DROP TABLE IF EXISTS `b2b_acl_role_role`; | |
DROP TABLE IF EXISTS `b2b_acl_role_route_privilege`; | |
DROP TABLE IF EXISTS `b2b_acl_route`; | |
DROP TABLE IF EXISTS `b2b_acl_route_privilege`; | |
DROP TABLE IF EXISTS `b2b_audit_log_index`; | |
DROP TABLE IF EXISTS `b2b_audit_log`; | |
DROP TABLE IF EXISTS `b2b_audit_log_author`; | |
DROP TABLE IF EXISTS `b2b_order_context`; | |
DROP TABLE IF EXISTS `b2b_order_list`; | |
DROP TABLE IF EXISTS `b2b_order_number`; | |
DROP TABLE IF EXISTS `b2b_debtor_contact`; | |
DROP TABLE IF EXISTS `b2b_store_front_auth`; | |
DROP TABLE IF EXISTS `b2b_budget_notify`; | |
DROP TABLE IF EXISTS `b2b_budget_address`; | |
DROP TABLE IF EXISTS `b2b_budget_transaction`; | |
DROP TABLE IF EXISTS `b2b_budget`; | |
DROP TABLE IF EXISTS `b2b_contact_contingent_group`; | |
DROP TABLE IF EXISTS `b2b_contact_password_activation`; | |
DROP TABLE IF EXISTS `b2b_contingent_group`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule_category`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule_product_number_allowance`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule_product_order_number`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule_product_price`; | |
DROP TABLE IF EXISTS `b2b_contingent_group_rule_time_restriction`; | |
DROP TABLE IF EXISTS `b2b_customer_address_data`; | |
DROP TABLE IF EXISTS `b2b_customer_data`; | |
DROP TABLE IF EXISTS `b2b_default_order_list`; | |
DROP TABLE IF EXISTS `b2b_in_stocks`; | |
DROP TABLE IF EXISTS `b2b_line_item_list`; | |
DROP TABLE IF EXISTS `b2b_line_item_reference`; | |
DROP TABLE IF EXISTS `b2b_migration`; | |
DROP TABLE IF EXISTS `b2b_offer`; | |
DROP TABLE IF EXISTS `b2b_role`; | |
DROP TABLE IF EXISTS `b2b_role_contact`; | |
DROP TABLE IF EXISTS `b2b_role_contingent_group`; | |
DROP TABLE IF EXISTS `b2b_sales_representative_clients`; | |
DROP TABLE IF EXISTS `b2b_prices`; | |
SET FOREIGN_KEY_CHECKS=ON; | |
DELETE | |
FROM state_machine_state | |
WHERE technical_name IN ('orderclearance_denied', 'orderclearance_open'); | |
DELETE | |
FROM custom_field | |
WHERE name IN ('b2b_auth_id', 'send_offer_status_changed_notification_mail'); | |
DELETE | |
FROM custom_field_set | |
WHERE name IN ('swag_b2b_plugin_order', 'swag_b2b_plugin_user'); | |
DELETE | |
FROM mail_template_type | |
WHERE technical_name IN | |
('b2bPasswordActivation', | |
'b2bOrderClearanceInquiry', | |
'b2bOrderClearanceAccepted', | |
'b2bOfferStatusChanged_general', | |
'b2bBudgetNotify'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment