Skip to content

Instantly share code, notes, and snippets.

@teiling88
Created June 17, 2015 18:32
Show Gist options
  • Save teiling88/a43523e10f1bbbefbccf to your computer and use it in GitHub Desktop.
Save teiling88/a43523e10f1bbbefbccf to your computer and use it in GitHub Desktop.
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