projects / civicrm-core.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Merge remote-tracking branch 'upstream/4.6' into 4.6-master-2015-08-24-22-26-45
[civicrm-core.git] / sql / civicrm_case_sql.mysql
CommitLineData
6a488035 1-- +--------------------------------------------------------------------+
9242538c 2-- | CiviCRM version 4.6 |
6a488035 3-- +--------------------------------------------------------------------+
e7112fa7 4-- | Copyright CiviCRM LLC (c) 2004-2015 |
6a488035
TO		 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-- +--------------------------------------------------------------------+
c213dee5 24INSERT INTO
25 civicrm_option_group (name, description, is_reserved, is_active)
26VALUES
6a488035
TO		 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);
c213dee5 32
6a488035
TO		 33
34
35
36SELECT @option_group_id_case_type := max(id) from civicrm_option_group where name = 'f1_case_type';
37SELECT @option_group_id_case_stype := max(id) from civicrm_option_group where name = 'f1_case_sub_type';
38SELECT @option_group_id_case_viol := max(id) from civicrm_option_group where name = 'f1_case_violation';
39SELECT @option_group_id_case_atype := max(id) from civicrm_option_group where name = 'case_activity_type';
40SELECT @option_group_id_case_comm := max(id) from civicrm_option_group where name = 'communication_medium';
41
c213dee5 42INSERT INTO
43 `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
6a488035
TO		 44VALUES
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),
c213dee5 66(@option_group_id_case_atype,'Outgoing correspondence' , 6, NULL, NULL, 0, 0, 6, NULL, 0, 1, 1),
6a488035
TO		 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);