'table' => 'civicrm_case_activity',
'when' => 'AFTER',
'event' => ['INSERT'],
- 'sql' => "\nUPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.case_id;\n",
+ 'sql' => "UPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.case_id;",
],
[
'upgrade_check' => ['table' => 'civicrm_case', 'column' => 'modified_date'],
'table' => 'civicrm_activity',
'when' => 'BEFORE',
'event' => ['UPDATE', 'DELETE'],
- 'sql' => "\nUPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);\n",
+ 'sql' => "UPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);",
],
],
]