Created
June 17, 2015 18:32
-
-
Save teiling88/a43523e10f1bbbefbccf to your computer and use it in GitHub Desktop.
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
SET foreign_key_checks = 0; | |
TRUNCATE s_article_configurator_dependencies; | |
TRUNCATE s_article_configurator_groups; | |
TRUNCATE s_article_configurator_option_relations; | |
TRUNCATE s_article_configurator_options; | |
TRUNCATE s_article_configurator_price_surcharges; | |
TRUNCATE s_article_configurator_set_group_relations; | |
TRUNCATE s_article_configurator_set_option_relations; | |
TRUNCATE s_article_configurator_sets; | |
TRUNCATE s_article_configurator_template_prices; | |
TRUNCATE s_article_configurator_template_prices_attributes; | |
TRUNCATE s_article_configurator_templates; | |
TRUNCATE s_article_configurator_templates_attributes; | |
TRUNCATE s_article_img_mapping_rules; | |
TRUNCATE s_article_img_mappings; | |
TRUNCATE s_articles; | |
TRUNCATE s_articles_also_bought_ro; | |
TRUNCATE s_articles_attributes; | |
TRUNCATE s_articles_avoid_customergroups; | |
TRUNCATE s_articles_categories; | |
TRUNCATE s_articles_categories_ro; | |
TRUNCATE s_articles_details; | |
TRUNCATE s_articles_downloads; | |
TRUNCATE s_articles_downloads_attributes; | |
TRUNCATE s_articles_esd; | |
TRUNCATE s_articles_esd_attributes; | |
TRUNCATE s_articles_esd_serials; | |
TRUNCATE s_articles_img; | |
TRUNCATE s_articles_img_attributes; | |
TRUNCATE s_articles_information; | |
TRUNCATE s_articles_information_attributes; | |
TRUNCATE s_articles_notification; | |
TRUNCATE s_articles_prices; | |
TRUNCATE s_articles_prices_attributes; | |
TRUNCATE s_articles_relationships; | |
TRUNCATE s_articles_similar; | |
TRUNCATE s_articles_similar_shown_ro; | |
TRUNCATE s_articles_supplier; | |
TRUNCATE s_articles_supplier_attributes; | |
TRUNCATE s_articles_top_seller_ro; | |
TRUNCATE s_articles_translations; | |
TRUNCATE s_articles_vote; | |
TRUNCATE s_filter_articles; | |
TRUNCATE s_order; | |
TRUNCATE s_order_attributes; | |
TRUNCATE s_order_basket; | |
TRUNCATE s_order_basket_attributes; | |
TRUNCATE s_order_billingaddress; | |
TRUNCATE s_order_billingaddress_attributes; | |
TRUNCATE s_order_comparisons; | |
TRUNCATE s_order_details; | |
TRUNCATE s_order_details_attributes; | |
TRUNCATE s_order_documents; | |
TRUNCATE s_order_documents_attributes; | |
TRUNCATE s_order_esd; | |
TRUNCATE s_order_history; | |
TRUNCATE s_order_notes; | |
TRUNCATE s_order_shippingaddress; | |
TRUNCATE s_order_shippingaddress_attributes; | |
TRUNCATE s_user; | |
TRUNCATE s_user_attributes; | |
TRUNCATE s_user_billingaddress; | |
TRUNCATE s_user_billingaddress_attributes; | |
TRUNCATE s_user_debit; | |
TRUNCATE s_user_pay_payone; | |
TRUNCATE s_user_shippingaddress; | |
TRUNCATE s_user_shippingaddress_attributes; | |
DELETE FROM s_media WHERE albumID = -1; | |
DELETE FROM s_categories WHERE id > 4; | |
SET foreign_key_checks = 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment