Merge pull request #4734 from jitendrapurohit/CRM-15694

[civicrm-core.git] / xml / templates / case_sample.tpl

diff --git a/xml/templates/case_sample.tpl b/xml/templates/case_sample.tpl
index cf66ff33322bfc4646c8413c13e4507188904a88..f44a65d006a07555e95a917e60afed51d754c037 100644 (file)
--- a/xml/templates/case_sample.tpl
+++ b/xml/templates/case_sample.tpl
@@ -14,9 +14,9 @@ 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` (`name`, `title`, `description`, `is_active`, `is_reserved`, `weight`, `definition`) VALUES
-('housing_support', '{ts}Housing Support{/ts}', '{ts}Help homeless individuals obtain temporary and long-term housing{/ts}', 1, 0, @max_wt + 1, 0x3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d2269736f2d383835392d3122203f3e0a0a3c43617365547970653e0a20203c6e616d653e486f7573696e6720537570706f72743c2f6e616d653e0a20203c416374697669747954797065733e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4f70656e20436173653c2f6e616d653e0a2020202020203c6d61785f696e7374616e6365733e313c2f6d61785f696e7374616e6365733e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4d65646963616c206576616c756174696f6e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4d656e74616c206865616c7468206576616c756174696f6e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e5365637572652074656d706f7261727920686f7573696e673c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e496e636f6d6520616e642062656e65666974732073746162696c697a6174696f6e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4c6f6e672d7465726d20686f7573696e6720706c616e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e466f6c6c6f772075703c2f6e616d653e0a202020203c2f4163746976697479547970653e0a20203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e6765204361736520547970653c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e67652043617365205374617475733c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e6765204361736520537461727420446174653c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4c696e6b2043617365733c2f6e616d653e0a202020203c2f4163746976697479547970653e0a20203c2f416374697669747954797065733e0a20203c4163746976697479536574733e0a202020203c41637469766974795365743e0a2020202020203c6e616d653e7374616e646172645f74696d656c696e653c2f6e616d653e0a2020202020203c6c6162656c3e5374616e646172642054696d656c696e653c2f6c6162656c3e0a2020202020203c74696d656c696e653e747275653c2f74696d656c696e653e0a2020202020203c416374697669747954797065733e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4f70656e20436173653c2f6e616d653e0a202020202020202020203c7374617475733e436f6d706c657465643c2f7374617475733e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4d65646963616c206576616c756174696f6e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e313c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4d656e74616c206865616c7468206576616c756174696f6e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e313c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e5365637572652074656d706f7261727920686f7573696e673c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e323c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e466f6c6c6f772075703c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e333c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e496e636f6d6520616e642062656e65666974732073746162696c697a6174696f6e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e373c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4c6f6e672d7465726d20686f7573696e6720706c616e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e31343c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e466f6c6c6f772075703c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e32313c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a2020202020203c2f416374697669747954797065733e0a202020203c2f41637469766974795365743e0a20203c2f4163746976697479536574733e0a20203c43617365526f6c65733e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e486f6d656c65737320536572766963657320436f6f7264696e61746f723c2f6e616d653e0a20202020202020203c63726561746f723e313c2f63726561746f723e0a20202020202020203c6d616e616765723e313c2f6d616e616765723e0a202020203c2f52656c6174696f6e73686970547970653e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e4865616c746820536572766963657320436f6f7264696e61746f723c2f6e616d653e0a202020203c2f52656c6174696f6e73686970547970653e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e42656e6566697473205370656369616c6973743c2f6e616d653e0a202020203c2f52656c6174696f6e73686970547970653e0a203c2f43617365526f6c65733e0a3c2f43617365547970653e0a),
-('adult_day_care_referral', '{ts}Adult Day Care Referral{/ts}', '{ts}Arranging adult day care for senior individuals{/ts}', 1, 0, @max_wt + 2, 0x3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d2269736f2d383835392d3122203f3e0a0a3c43617365547970653e0a20203c6e616d653e4164756c7420446179204361726520526566657272616c3c2f6e616d653e0a20203c416374697669747954797065733e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4f70656e20436173653c2f6e616d653e0a2020202020203c6d61785f696e7374616e6365733e313c2f6d61785f696e7374616e6365733e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4d65646963616c206576616c756174696f6e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4d656e74616c206865616c7468206576616c756174696f6e3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e41444320726566657272616c3c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e466f6c6c6f772075703c2f6e616d653e0a202020203c2f4163746976697479547970653e0a20203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e6765204361736520547970653c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e67652043617365205374617475733c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4368616e6765204361736520537461727420446174653c2f6e616d653e0a202020203c2f4163746976697479547970653e0a202020203c4163746976697479547970653e0a2020202020203c6e616d653e4c696e6b2043617365733c2f6e616d653e0a202020203c2f4163746976697479547970653e0a20203c2f416374697669747954797065733e0a20203c4163746976697479536574733e0a202020203c41637469766974795365743e0a2020202020203c6e616d653e7374616e646172645f74696d656c696e653c2f6e616d653e0a2020202020203c6c6162656c3e5374616e646172642054696d656c696e653c2f6c6162656c3e0a2020202020203c74696d656c696e653e747275653c2f74696d656c696e653e0a2020202020203c416374697669747954797065733e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4f70656e20436173653c2f6e616d653e0a202020202020202020203c7374617475733e436f6d706c657465643c2f7374617475733e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4d65646963616c206576616c756174696f6e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e333c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e4d656e74616c206865616c7468206576616c756174696f6e3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e373c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e41444320726566657272616c3c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e31303c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a20202020202020203c4163746976697479547970653e0a202020202020202020203c6e616d653e466f6c6c6f772075703c2f6e616d653e0a202020202020202020203c7265666572656e63655f61637469766974793e4f70656e20436173653c2f7265666572656e63655f61637469766974793e0a202020202020202020203c7265666572656e63655f6f66667365743e31343c2f7265666572656e63655f6f66667365743e0a202020202020202020203c7265666572656e63655f73656c6563743e6e65776573743c2f7265666572656e63655f73656c6563743e0a20202020202020203c2f4163746976697479547970653e0a2020202020203c2f416374697669747954797065733e0a202020203c2f41637469766974795365743e0a20203c2f4163746976697479536574733e0a20203c43617365526f6c65733e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e53656e696f7220536572766963657320436f6f7264696e61746f723c2f6e616d653e0a20202020202020203c63726561746f723e313c2f63726561746f723e0a202020203c2f52656c6174696f6e73686970547970653e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e4865616c746820536572766963657320436f6f7264696e61746f723c2f6e616d653e0a202020203c2f52656c6174696f6e73686970547970653e0a202020203c52656c6174696f6e73686970547970653e0a20202020202020203c6e616d653e42656e6566697473205370656369616c6973743c2f6e616d653e0a202020203c2f52656c6174696f6e73686970547970653e0a203c2f43617365526f6c65733e0a3c2f43617365547970653e0a);
+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),
+  ('{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