Skip to content

Instantly share code, notes, and snippets.

@blessani

blessani/reset_magento_ee_cl.sql

Created November 15, 2016 10:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save blessani/eb15ee935df5646ec46e9d613bde284b to your computer and use it in GitHub Desktop.
Save blessani/eb15ee935df5646ec46e9d613bde284b to your computer and use it in GitHub Desktop.
Download ZIP
Reset Magento EE Changelogs
Raw
reset_magento_ee_cl.sql
TRUNCATE catalog_product_flat_cl;
TRUNCATE catalog_category_product_index_cl;
TRUNCATE catalog_category_product_cat_cl;
TRUNCATE catalog_category_flat_cl;
TRUNCATE catalogsearch_fulltext_cl;
TRUNCATE cataloginventory_stock_status_cl;
TRUNCATE catalog_product_flat_cl;
TRUNCATE catalog_product_index_price_cl;
TRUNCATE enterprise_url_rewrite_category_cl;
TRUNCATE enterprise_url_rewrite_product_cl;
TRUNCATE enterprise_url_rewrite_redirect_cl;
UPDATE enterprise_mview_metadata SET version_id = 0, status = 2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment