gistfile1.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;
update enterprise_mview_metadata SET version_id = 0, status = 2;