From e62d466be91570a1575ed9dceaab1f7fd9ee694d Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Tue, 21 Apr 2015 14:01:32 -0600 Subject: [PATCH] case_sample.tpl - Fix syntax for older MySQL --- CRM/Case/xml/configuration.sample/case_sample.mysql.tpl | 2 +- xml/templates/case_sample.tpl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Case/xml/configuration.sample/case_sample.mysql.tpl b/CRM/Case/xml/configuration.sample/case_sample.mysql.tpl index 250709fdec..fb94f3ecbc 100644 --- a/CRM/Case/xml/configuration.sample/case_sample.mysql.tpl +++ b/CRM/Case/xml/configuration.sample/case_sample.mysql.tpl @@ -12,7 +12,7 @@ SELECT @caseCompId := id FROM `civicrm_component` where `name` like 'CiviCase'; -- * Case Types -- * -- *******************************************************/ -SELECT @max_wt := COALESCE ( max(weight), 0 ) from civicrm_case_type; +SELECT @max_wt := COALESCE( max(weight), 0 ) from civicrm_case_type; INSERT IGNORE INTO `civicrm_case_type` ( {localize field='title'}`title`{/localize}, `name`, {localize field='description'}`description`{/localize}, `weight`, `is_reserved`, `is_active`) VALUES ({localize}'{ts escape="sql"}Housing Support{/ts}'{/localize}, 'housing_support', {localize}'{ts escape="sql"}Help homeless individuals obtain temporary and long-term housing{/ts}'{/localize}, @max_wt + 1, 0, 1), diff --git a/xml/templates/case_sample.tpl b/xml/templates/case_sample.tpl index f44a65d006..cdcb7e3f61 100644 --- a/xml/templates/case_sample.tpl +++ b/xml/templates/case_sample.tpl @@ -12,7 +12,7 @@ SELECT @caseCompId := id FROM `civicrm_component` where `name` like 'CiviCase'; -- * Case Types -- * -- *******************************************************/ -SELECT @max_wt := COALESCE ( max(weight), 0 ) from civicrm_case_type; +SELECT @max_wt := COALESCE( max(weight), 0 ) from civicrm_case_type; INSERT IGNORE INTO `civicrm_case_type` ( `title`, `name`, `description`, `weight`, `is_reserved`, `is_active`) VALUES ('{ts}Housing Support{/ts}', 'housing_support', '{ts}Help homeless individuals obtain temporary and long-term housing{/ts}', @max_wt + 1, 0, 1), -- 2.25.1