Merge pull request #2243 from eileenmcnaughton/CRM-14021

[civicrm-core.git] / sql / civicrm_case_sql.mysql

diff --git a/sql/civicrm_case_sql.mysql b/sql/civicrm_case_sql.mysql
index 17093fd9c77670144c87cac6a94a67e93c245b75..db190d44df1f376480f7ba6fe6ad20cba7e09472 100644 (file)
--- a/sql/civicrm_case_sql.mysql
+++ b/sql/civicrm_case_sql.mysql
@@ -21,15 +21,15 @@
 -- | GNU Affero General Public License or the licensing of CiviCRM,     |
 -- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
 -- +--------------------------------------------------------------------+
-INSERT INTO 
-   civicrm_option_group (name, description, is_reserved, is_active) 
-VALUES 
+INSERT INTO
+   civicrm_option_group (name, description, is_reserved, is_active)
+VALUES
  ('f1_case_type'           , 'Case Type'            , 1, 1),
  ('f1_case_sub_type'       , 'Case Sub Type'        , 1, 1),
  ('f1_case_violation'      , 'Violation Type'       , 1, 1),
  ('case_activity_type'     , 'Type'                 , 1, 1),
  ('communication_medium'   , 'Communication Medium' , 1, 1);
-       
+
 
 
 
@@ -39,8 +39,8 @@ SELECT @option_group_id_case_viol        := max(id) from civicrm_option_group wh
 SELECT @option_group_id_case_atype       := max(id) from civicrm_option_group where name = 'case_activity_type';
 SELECT @option_group_id_case_comm        := max(id) from civicrm_option_group where name = 'communication_medium';
 
-INSERT INTO 
-   `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) 
+INSERT INTO
+   `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
 VALUES
 (@option_group_id_case_type, 'Civil & Political'          ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
 (@option_group_id_case_type, 'Economic, Social & Cultural',  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
@@ -63,7 +63,7 @@ VALUES
 (@option_group_id_case_atype,'Incoming Press Release'     ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
 (@option_group_id_case_atype,'Complaint'                  ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
 (@option_group_id_case_atype,'Urgent Action(incoming)'    ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
-(@option_group_id_case_atype,'Outgoing correspondence'    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1), 
+(@option_group_id_case_atype,'Outgoing correspondence'    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
 (@option_group_id_case_atype,'Outgoing Press Release'     ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1),
 (@option_group_id_case_atype,'FL Action(outgoing)'        ,  8, NULL, NULL, 0, 0,  8, NULL, 0, 1, 1),
 (@option_group_id_case_atype,'FL Urgent Action(outgoing)' ,  9, NULL, NULL, 0, 0,  9, NULL, 0, 1, 1),