Cacher is the code snippet organizer for pro developers

# Got this script from Adore
# Choose which SQL to run yourself, some lines are project specific.

TRUNCATE `adminnotification_inbox`;
TRUNCATE `cataloginventory_stock_status_cl`;
TRUNCATE `catalogsearch_fulltext_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 `enterprise_url_rewrite_category_cl`;
TRUNCATE `enterprise_url_rewrite_product_cl`;
TRUNCATE `enterprise_url_rewrite_redirect_cl`;
TRUNCATE `log_customer`;
TRUNCATE `log_quote`;
TRUNCATE `log_summary`;
TRUNCATE `log_summary_type`;
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;
TRUNCATE `log_visitor_online`;
TRUNCATE `report_event`;


TRUNCATE `enterprise_logging_event_changes`;
TRUNCATE `index_process_event`;
TRUNCATE `purchase_order_product`;
TRUNCATE `purchase_sales_order_planning`;
TRUNCATE `qdos_activity_log`;
TRUNCATE `report_compared_product_index`;
TRUNCATE `report_viewed_product_index`;

TRUNCATE `core_cache_tag`;

TRUNCATE `core_cache`;

TRUNCATE `core_session`;

TRUNCATE `aw_core_logger`;
TRUNCATE `catalog_category_flat_cl`;

TRUNCATE `dataflow_batch_export`;
TRUNCATE `dataflow_batch_import`;

DELETE FROM sales_flat_quote_address WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);

DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);

DELETE FROM sales_flat_quote_item WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);

DELETE FROM  `aw_followup_queue` WHERE  `sent_at` IS NOT NULL;