From a3243ca96cf749b7840f0582df0cbddca1311a75 Mon Sep 17 00:00:00 2001 From: eileen Date: Wed, 17 Apr 2013 08:55:57 +1200 Subject: [PATCH] drop report temp tables on db clean up. This helps where TEMPORARY tables are a bit limiting due to their join restrictions or the desire to retain them for when the data doesn't go stale that quickly --- CRM/Core/Config.php | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/CRM/Core/Config.php b/CRM/Core/Config.php index 3356f00974..cfda390e50 100644 --- a/CRM/Core/Config.php +++ b/CRM/Core/Config.php @@ -728,9 +728,12 @@ class CRM_Core_Config extends CRM_Core_Config_Variables { SELECT TABLE_NAME as tableName FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = %1 -AND ( TABLE_NAME LIKE 'civicrm_import_job_%' -OR TABLE_NAME LIKE 'civicrm_export_temp%' -OR TABLE_NAME LIKE 'civicrm_task_action_temp%' ) +AND + ( TABLE_NAME LIKE 'civicrm_import_job_%' + OR TABLE_NAME LIKE 'civicrm_export_temp%' + OR TABLE_NAME LIKE 'civicrm_task_action_temp%' + OR TABLE_NAME LIKE 'civicrm_report_temp%' + ) "; $params = array(1 => array($dao->database(), 'String')); -- 2.25.1