sql/civicrm_case_sql.mysql

   1 -- +--------------------------------------------------------------------+
   2 -- | CiviCRM version 4.6                                                |
   3 -- +--------------------------------------------------------------------+
   4 -- | Copyright CiviCRM LLC (c) 2004-2015                                |
   5 -- +--------------------------------------------------------------------+
   6 -- | This file is a part of CiviCRM.                                    |
   7 -- |                                                                    |
   8 -- | CiviCRM is free software; you can copy, modify, and distribute it  |
   9 -- | under the terms of the GNU Affero General Public License           |
  10 -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  11 -- |                                                                    |
  12 -- | CiviCRM is distributed in the hope that it will be useful, but     |
  13 -- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  14 -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  15 -- | See the GNU Affero General Public License for more details.        |
  16 -- |                                                                    |
  17 -- | You should have received a copy of the GNU Affero General Public   |
  18 -- | License and the CiviCRM Licensing Exception along                  |
  19 -- | with this program; if not, contact CiviCRM LLC                     |
  20 -- | at info[AT]civicrm[DOT]org. If you have questions about the        |
  21 -- | GNU Affero General Public License or the licensing of CiviCRM,     |
  22 -- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  23 -- +--------------------------------------------------------------------+
  24 INSERT INTO
  25    civicrm_option_group (name, description, is_reserved, is_active)
  26 VALUES
  27  ('f1_case_type'           , 'Case Type'            , 1, 1),
  28  ('f1_case_sub_type'       , 'Case Sub Type'        , 1, 1),
  29  ('f1_case_violation'      , 'Violation Type'       , 1, 1),
  30  ('case_activity_type'     , 'Type'                 , 1, 1),
  31  ('communication_medium'   , 'Communication Medium' , 1, 1);
  32
  33
  34
  35
  36 SELECT @option_group_id_case_type        := max(id) from civicrm_option_group where name = 'f1_case_type';
  37 SELECT @option_group_id_case_stype       := max(id) from civicrm_option_group where name = 'f1_case_sub_type';
  38 SELECT @option_group_id_case_viol        := max(id) from civicrm_option_group where name = 'f1_case_violation';
  39 SELECT @option_group_id_case_atype       := max(id) from civicrm_option_group where name = 'case_activity_type';
  40 SELECT @option_group_id_case_comm        := max(id) from civicrm_option_group where name = 'communication_medium';
  41
  42 INSERT INTO
  43    `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
  44 VALUES
  45 (@option_group_id_case_type, 'Civil & Political'          ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  46 (@option_group_id_case_type, 'Economic, Social & Cultural',  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  47 (@option_group_id_case_type, 'Gender Issues'              ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  48 (@option_group_id_case_stype,'Labour Rights'              ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  49 (@option_group_id_case_stype,'Land Rights'                ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  50 (@option_group_id_case_stype,'LGTB Rights'                ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  51 (@option_group_id_case_stype,'State Corruption'           ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  52 (@option_group_id_case_stype,'Working with IDPs'          ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  53 (@option_group_id_case_viol, 'Arrested / Detained'        ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  54 (@option_group_id_case_viol, 'Disappeared'                ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  55 (@option_group_id_case_viol, 'Harassment'                 ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  56 (@option_group_id_case_viol, 'Killed'                     ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  57 (@option_group_id_case_viol, 'Legal Action'               ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  58 (@option_group_id_case_viol, 'Threats'                    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  59 (@option_group_id_case_viol, 'Tortured / Ill-treatment'   ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1),
  60 (@option_group_id_case_viol, 'Violence Against Women'     ,  8, NULL, NULL, 0, 0,  8, NULL, 0, 1, 1),
  61 (@option_group_id_case_atype,'Source(incoming)'           ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  62 (@option_group_id_case_atype,'Incoming correspondence'    ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  63 (@option_group_id_case_atype,'Incoming Press Release'     ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  64 (@option_group_id_case_atype,'Complaint'                  ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  65 (@option_group_id_case_atype,'Urgent Action(incoming)'    ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  66 (@option_group_id_case_atype,'Outgoing correspondence'    ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  67 (@option_group_id_case_atype,'Outgoing Press Release'     ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1),
  68 (@option_group_id_case_atype,'FL Action(outgoing)'        ,  8, NULL, NULL, 0, 0,  8, NULL, 0, 1, 1),
  69 (@option_group_id_case_atype,'FL Urgent Action(outgoing)' ,  9, NULL, NULL, 0, 0,  9, NULL, 0, 1, 1),
  70 (@option_group_id_case_atype,'Lobbying(outgoing)'         , 10, NULL, NULL, 0, 0, 10, NULL, 0, 1, 1),
  71 (@option_group_id_case_comm ,'E-mail'                     ,  1, NULL, NULL, 0, 1,  1, NULL, 0, 1, 1),
  72 (@option_group_id_case_comm ,'Fax'                        ,  2, NULL, NULL, 0, 0,  2, NULL, 0, 1, 1),
  73 (@option_group_id_case_comm ,'Letter'                     ,  3, NULL, NULL, 0, 0,  3, NULL, 0, 1, 1),
  74 (@option_group_id_case_comm ,'Meeting'                    ,  4, NULL, NULL, 0, 0,  4, NULL, 0, 1, 1),
  75 (@option_group_id_case_comm ,'SMS Message'                ,  5, NULL, NULL, 0, 0,  5, NULL, 0, 1, 1),
  76 (@option_group_id_case_comm ,'Telephone'                  ,  6, NULL, NULL, 0, 0,  6, NULL, 0, 1, 1),
  77 (@option_group_id_case_comm ,'Video Conference'           ,  7, NULL, NULL, 0, 0,  7, NULL, 0, 1, 1);