X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Ftemplates%2Fcase_sample.tpl;h=f44a65d006a07555e95a917e60afed51d754c037;hb=840e3c4af354178d1be194ee75d6bf8176170bab;hp=ec6997a92d356a99ce871232a829a95342a9521f;hpb=4014394ebf74035cc7cc8bee5b37e8057f2c96b2;p=civicrm-core.git diff --git a/xml/templates/case_sample.tpl b/xml/templates/case_sample.tpl index ec6997a92d..f44a65d006 100644 --- a/xml/templates/case_sample.tpl +++ b/xml/templates/case_sample.tpl @@ -15,8 +15,8 @@ SELECT @caseCompId := id FROM `civicrm_component` where `name` like 'CiviCase'; 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