sql/civicrm_case_sql.mysql

   1 -- +--------------------------------------------------------------------+
   2 -- | Copyright CiviCRM LLC. All rights reserved.                        |
   3 -- |                                                                    |
   4 -- | This work is published under the GNU AGPLv3 license with some      |
   5 -- | permitted exceptions and without any warranty. For full license    |
   6 -- | and copyright information, see https://civicrm.org/licensing       |
   7 -- +--------------------------------------------------------------------+
   8 INSERT INTO
   9    civicrm_option_group (name, description, is_reserved, is_active)
  10 VALUES
  11  ('f1_case_type'           , 'Case Type'            , 1, 1),
  12  ('f1_case_sub_type'       , 'Case Sub Type'        , 1, 1),
  13  ('f1_case_violation'      , 'Violation Type'       , 1, 1),
  14  ('case_activity_type'     , 'Type'                 , 1, 1),
  15  ('communication_medium'   , 'Communication Medium' , 1, 1);
  16
  17
  18
  19
  20 SELECT @option_group_id_case_type        := max(id) from civicrm_option_group where name = 'f1_case_type';
  21 SELECT @option_group_id_case_stype       := max(id) from civicrm_option_group where name = 'f1_case_sub_type';
  22 SELECT @option_group_id_case_viol        := max(id) from civicrm_option_group where name = 'f1_case_violation';
  23 SELECT @option_group_id_case_atype       := max(id) from civicrm_option_group where name = 'case_activity_type';
  24 SELECT @option_group_id_case_comm        := max(id) from civicrm_option_group where name = 'communication_medium';
  25
  26 INSERT INTO
  27    `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
  28 VALUES
  29 (@option_group_id_case_type, 'Civil & Political'          ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  30 (@option_group_id_case_type, 'Economic, Social & Cultural',  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  31 (@option_group_id_case_type, 'Gender Issues'              ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  32 (@option_group_id_case_stype,'Labour Rights'              ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  33 (@option_group_id_case_stype,'Land Rights'                ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  34 (@option_group_id_case_stype,'LGTB Rights'                ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  35 (@option_group_id_case_stype,'State Corruption'           ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  36 (@option_group_id_case_stype,'Working with IDPs'          ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  37 (@option_group_id_case_viol, 'Arrested / Detained'        ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  38 (@option_group_id_case_viol, 'Disappeared'                ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  39 (@option_group_id_case_viol, 'Harassment'                 ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  40 (@option_group_id_case_viol, 'Killed'                     ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  41 (@option_group_id_case_viol, 'Legal Action'               ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  42 (@option_group_id_case_viol, 'Threats'                    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  43 (@option_group_id_case_viol, 'Tortured / Ill-treatment'   ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1),
  44 (@option_group_id_case_viol, 'Violence Against Women'     ,  8, NULL, NULL, 0, 0,  8, NULL, 0, 1, 1),
  45 (@option_group_id_case_atype,'Source(incoming)'           ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  46 (@option_group_id_case_atype,'Incoming correspondence'    ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  47 (@option_group_id_case_atype,'Incoming Press Release'     ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  48 (@option_group_id_case_atype,'Complaint'                  ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  49 (@option_group_id_case_atype,'Urgent Action(incoming)'    ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  50 (@option_group_id_case_atype,'Outgoing correspondence'    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  51 (@option_group_id_case_atype,'Outgoing Press Release'     ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1),
  52 (@option_group_id_case_atype,'FL Action(outgoing)'        ,  8, NULL, NULL, 0, 0,  8, NULL, 0, 1, 1),
  53 (@option_group_id_case_atype,'FL Urgent Action(outgoing)' ,  9, NULL, NULL, 0, 0,  9, NULL, 0, 1, 1),
  54 (@option_group_id_case_atype,'Lobbying(outgoing)'         , 10, NULL, NULL, 0, 0, 10, NULL, 0, 1, 1),
  55 (@option_group_id_case_comm ,'E-mail'                     ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  56 (@option_group_id_case_comm ,'Fax'                        ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  57 (@option_group_id_case_comm ,'Letter'                     ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  58 (@option_group_id_case_comm ,'Meeting'                    ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  59 (@option_group_id_case_comm ,'SMS Message'                ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  60 (@option_group_id_case_comm ,'Telephone'                  ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  61 (@option_group_id_case_comm ,'Video Conference'           ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1);