Skip to content

Instantly share code, notes, and snippets.

@davefarthing

davefarthing/reset-cl.sql

Created August 6, 2015 07:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davefarthing/1261d6dcbde3dd475be4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davefarthing/1261d6dcbde3dd475be4 to your computer and use it in GitHub Desktop.
Download ZIP
Magento EE - Index Changelog reset
Raw
reset-cl.sql
truncate `catalog_category_flat_cl`;
truncate `catalog_category_product_cat_cl`;
truncate `catalog_category_product_index_cl`;
truncate `catalog_product_flat_cl`;
truncate `catalog_product_index_price_cl`;
truncate `cataloginventory_stock_status_cl`;
truncate `catalogsearch_fulltext_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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment