X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Ftemplates%2Fcase_sample.tpl;h=cdcb7e3f61f63775334dea9c8edbbcbfb9095775;hb=8bfce657bc212f3b5288b6b5c3535fad7323dbfc;hp=e069bbdbf484d73f8317d1f8c9bceb07d4975b58;hpb=da7a33feb6f28d09a8b2de93cb702b43ed484851;p=civicrm-core.git diff --git a/xml/templates/case_sample.tpl b/xml/templates/case_sample.tpl index e069bbdbf4..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), @@ -59,7 +59,7 @@ INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `name` INSERT INTO `civicrm_option_value` ( `option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id` ) (SELECT @option_group_id_activity_type, 'ADC referral', (SELECT @max_val := @max_val+1), 'ADC referral', NULL, 0, 0, (SELECT @max_val := @max_val+1), '', 0, 0, 1, @caseCompId FROM dual WHERE NOT EXISTS (SELECT * FROM `civicrm_option_value` WHERE `name` = 'ADC referral')); - + -- /******************************************************* -- * -- * Relationship Types