X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Ftemplates%2Fcase_sample.tpl;h=cdcb7e3f61f63775334dea9c8edbbcbfb9095775;hb=8bfce657bc212f3b5288b6b5c3535fad7323dbfc;hp=ec6997a92d356a99ce871232a829a95342a9521f;hpb=0ec03e9fabc23b802ac80cb68c44b5abaf7f8585;p=civicrm-core.git diff --git a/xml/templates/case_sample.tpl b/xml/templates/case_sample.tpl index ec6997a92d..cdcb7e3f61 100644 --- a/xml/templates/case_sample.tpl +++ b/xml/templates/case_sample.tpl @@ -12,11 +12,11 @@ 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}', 'HousingSupport', '{ts}Help homeless individuals obtain temporary and long-term housing{/ts}', @max_wt + 1, 0, 1), - ('{ts}Adult Day Care Referral{/ts}', 'AdultDayCareReferral', '{ts}Arranging adult day care for senior individuals{/ts}', @max_wt + 2, 0, 1); + ('{ts}Housing Support{/ts}', 'housing_support', '{ts}Help homeless individuals obtain temporary and long-term housing{/ts}', @max_wt + 1, 0, 1), + ('{ts}Adult Day Care Referral{/ts}', 'adult_day_care_referral', '{ts}Arranging adult day care for senior individuals{/ts}', @max_wt + 2, 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