projects / civicrm-core.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
CRM-15934: more host patterns
[civicrm-core.git] / xml / templates / civicrm_data.tpl
CommitLineData
6a488035 1-- +--------------------------------------------------------------------+
39de6fd5 2-- | CiviCRM version 4.6 |
6a488035 3-- +--------------------------------------------------------------------+
811982aa 4-- | Copyright CiviCRM LLC (c) 2004-2014 |
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-- +--------------------------------------------------------------------+
d5864876
ARW		 24--
25-- Generated from {$smarty.template}
26-- {$generated}
27--
6a488035
TO		 28-- This file provides template to civicrm_data.mysql. Inserts all base data needed for a new CiviCRM DB
29
30SET @domainName := 'Default Domain Name';
31SET @defaultOrganization := 'Default Organization';
32
33-- Add components to system wide registry
34-- We're doing it early to avoid constraint errors.
35INSERT INTO civicrm_component (name, namespace) VALUES ('CiviEvent' , 'CRM_Event' );
36INSERT INTO civicrm_component (name, namespace) VALUES ('CiviContribute', 'CRM_Contribute' );
37INSERT INTO civicrm_component (name, namespace) VALUES ('CiviMember' , 'CRM_Member' );
38INSERT INTO civicrm_component (name, namespace) VALUES ('CiviMail' , 'CRM_Mailing' );
39INSERT INTO civicrm_component (name, namespace) VALUES ('CiviGrant' , 'CRM_Grant' );
40INSERT INTO civicrm_component (name, namespace) VALUES ('CiviPledge' , 'CRM_Pledge' );
41INSERT INTO civicrm_component (name, namespace) VALUES ('CiviCase' , 'CRM_Case' );
42INSERT INTO civicrm_component (name, namespace) VALUES ('CiviReport' , 'CRM_Report' );
43INSERT INTO civicrm_component (name, namespace) VALUES ('CiviCampaign' , 'CRM_Campaign' );
44
45-- Create organization contact
46INSERT INTO civicrm_contact( `contact_type`, `sort_name`, `display_name`, `legal_name`, `organization_name`)
47VALUES ('Organization', @defaultOrganization, @defaultOrganization, @defaultOrganization, @defaultOrganization);
48SET @contactID := LAST_INSERT_ID();
49
50INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date)
51VALUES
52(@contactID, 1, 'fixme.domainemail@example.org', 0, 0, 0, NULL, NULL);
53
54INSERT INTO civicrm_domain (name, version, contact_id) VALUES (@domainName, '2.2', @contactID);
55SELECT @domainID := id FROM civicrm_domain where name = 'Default Domain Name';
56
57-- Sample location types
58-- CRM-9120 for legacy reasons we are continuing to translate the 'name', but this
59-- field is used mainly as an ID, and display_name will be shown to the user, but
60-- we have not yet finished modifying all places where the 'name' is shown.
61INSERT INTO civicrm_location_type( name, display_name, vcard_name, description, is_reserved, is_active, is_default ) VALUES( '{ts escape="sql"}Home{/ts}', '{ts escape="sql"}Home{/ts}', 'HOME', '{ts escape="sql"}Place of residence{/ts}', 0, 1, 1 );
62INSERT INTO civicrm_location_type( name, display_name, vcard_name, description, is_reserved, is_active ) VALUES( '{ts escape="sql"}Work{/ts}', '{ts escape="sql"}Work{/ts}', 'WORK', '{ts escape="sql"}Work location{/ts}', 0, 1 );
63INSERT INTO civicrm_location_type( name, display_name, vcard_name, description, is_reserved, is_active ) VALUES( '{ts escape="sql"}Main{/ts}', '{ts escape="sql"}Main{/ts}', NULL, '{ts escape="sql"}Main office location{/ts}', 0, 1 );
64INSERT INTO civicrm_location_type( name, display_name, vcard_name, description, is_reserved, is_active ) VALUES( '{ts escape="sql"}Other{/ts}', '{ts escape="sql"}Other{/ts}', NULL, '{ts escape="sql"}Other location{/ts}', 0, 1 );
65-- the following location must stay with the untranslated Billing name, CRM-2064
66INSERT INTO civicrm_location_type( name, display_name, vcard_name, description, is_reserved, is_active ) VALUES( 'Billing', '{ts escape="sql"}Billing{/ts}', NULL, '{ts escape="sql"}Billing Address location{/ts}', 1, 1 );
67
68-- Sample relationship types
69INSERT INTO civicrm_relationship_type( name_a_b,label_a_b, name_b_a,label_b_a, description, contact_type_a, contact_type_b, is_reserved )
70 VALUES( 'Child of', '{ts escape="sql"}Child of{/ts}', 'Parent of', '{ts escape="sql"}Parent of{/ts}', '{ts escape="sql"}Parent/child relationship.{/ts}', 'Individual', 'Individual', 0 ),
71 ( 'Spouse of', '{ts escape="sql"}Spouse of{/ts}', 'Spouse of', '{ts escape="sql"}Spouse of{/ts}', '{ts escape="sql"}Spousal relationship.{/ts}', 'Individual', 'Individual', 0 ),
72 ( 'Partner of', '{ts escape="sql"}Partner of{/ts}', 'Partner of', '{ts escape="sql"}Partner of{/ts}', '{ts escape="sql"}Partner relationship.{/ts}', 'Individual', 'Individual', 0 ),
73 ( 'Sibling of', '{ts escape="sql"}Sibling of{/ts}', 'Sibling of', '{ts escape="sql"}Sibling of{/ts}', '{ts escape="sql"}Sibling relationship.{/ts}', 'Individual','Individual', 0 ),
74 ( 'Employee of', '{ts escape="sql"}Employee of{/ts}', 'Employer of', '{ts escape="sql"}Employer of{/ts}', '{ts escape="sql"}Employment relationship.{/ts}','Individual','Organization', 1 ),
75 ( 'Volunteer for', '{ts escape="sql"}Volunteer for{/ts}', 'Volunteer is', '{ts escape="sql"}Volunteer is{/ts}', '{ts escape="sql"}Volunteer relationship.{/ts}','Individual','Organization', 0 ),
76 ( 'Head of Household for', '{ts escape="sql"}Head of Household for{/ts}', 'Head of Household is', '{ts escape="sql"}Head of Household is{/ts}', '{ts escape="sql"}Head of household.{/ts}','Individual','Household', 1 ),
77 ( 'Household Member of', '{ts escape="sql"}Household Member of{/ts}', 'Household Member is', '{ts escape="sql"}Household Member is{/ts}', '{ts escape="sql"}Household membership.{/ts}','Individual','Household', 1 );
78
79-- Relationship Types for CiviCase
80INSERT INTO civicrm_relationship_type( name_a_b,label_a_b, name_b_a,label_b_a, description, contact_type_a, contact_type_b, is_reserved )
81 VALUES( 'Case Coordinator is', 'Case Coordinator is', 'Case Coordinator', 'Case Coordinator', 'Case Coordinator', 'Individual', 'Individual', 0 );
82INSERT INTO civicrm_relationship_type( name_a_b,label_a_b, name_b_a,label_b_a, description, contact_type_a, contact_type_b, is_reserved )
83 VALUES( 'Supervised by', 'Supervised by', 'Supervisor', 'Supervisor', 'Immediate workplace supervisor', 'Individual', 'Individual', 0 );
84
85
86-- Sample Tags
87INSERT INTO civicrm_tag( name, description, parent_id,used_for )
88 VALUES
89 ( '{ts escape="sql"}Non-profit{/ts}', '{ts escape="sql"}Any not-for-profit organization.{/ts}', NULL,'civicrm_contact'),
90 ( '{ts escape="sql"}Company{/ts}', '{ts escape="sql"}For-profit organization.{/ts}', NULL,'civicrm_contact'),
91 ( '{ts escape="sql"}Government Entity{/ts}', '{ts escape="sql"}Any governmental entity.{/ts}', NULL,'civicrm_contact'),
92 ( '{ts escape="sql"}Major Donor{/ts}', '{ts escape="sql"}High-value supporter of our organization.{/ts}', NULL,'civicrm_contact'),
93 ( '{ts escape="sql"}Volunteer{/ts}', '{ts escape="sql"}Active volunteers.{/ts}', NULL,'civicrm_contact' );
94
95{capture assign=subgroup}{ldelim}subscribe.group{rdelim}{/capture}
96{capture assign=suburl}{ldelim}subscribe.url{rdelim}{/capture}
97{capture assign=welgroup}{ldelim}welcome.group{rdelim}{/capture}
98{capture assign=unsubgroup}{ldelim}unsubscribe.group{rdelim}{/capture}
99{capture assign=actresub}{ldelim}action.resubscribe{rdelim}{/capture}
100{capture assign=actresuburl}{ldelim}action.resubscribeUrl{rdelim}{/capture}
101{capture assign=resubgroup}{ldelim}resubscribe.group{rdelim}{/capture}
102{capture assign=actunsub}{ldelim}action.unsubscribe{rdelim}{/capture}
103{capture assign=actunsuburl}{ldelim}action.unsubscribeUrl{rdelim}{/capture}
104{capture assign=domname}{ldelim}domain.name{rdelim}{/capture}
105
106-- sample CiviCRM mailing components
107INSERT INTO civicrm_mailing_component
108 (name,component_type,subject,body_html,body_text,is_default,is_active)
109VALUES
110 ('{ts escape="sql"}Mailing Header{/ts}','Header','{ts escape="sql"}Descriptive Title for this Header{/ts}','{ts escape="sql"}Sample Header for HTML formatted content.{/ts}','{ts escape="sql"}Sample Header for TEXT formatted content.{/ts}',1,1),
111 ('{ts escape="sql"}Mailing Footer{/ts}','Footer','{ts escape="sql"}Descriptive Title for this Footer.{/ts}','{ts escape="sql"}Sample Footer for HTML formatted content<br/><a href="{ldelim}action.optOutUrl{rdelim}">Unsubscribe</a> <br/> {ldelim}domain.address{rdelim}{/ts}','{ts escape="sql"}to unsubscribe: {ldelim}action.optOutUrl{rdelim}
112{ldelim}domain.address{rdelim}{/ts}',1,1),
113 ('{ts escape="sql"}Subscribe Message{/ts}','Subscribe','{ts escape="sql"}Subscription Confirmation Request{/ts}','{ts escape="sql" 1=$subgroup 2=$suburl}You have a pending subscription to the %1 mailing list. To confirm this subscription, reply to this email or click <a href="%2">here</a>.{/ts}','{ts escape="sql" 1=$subgroup 2=$suburl}You have a pending subscription to the %1 mailing list. To confirm this subscription, reply to this email or click on this link: %2{/ts}',1,1),
114 ('{ts escape="sql"}Welcome Message{/ts}','Welcome','{ts escape="sql"}Your Subscription has been Activated{/ts}','{ts escape="sql" 1=$welgroup}Welcome. Your subscription to the %1 mailing list has been activated.{/ts}','{ts escape="sql" 1=$welgroup}Welcome. Your subscription to the %1 mailing list has been activated.{/ts}',1,1),
115 ('{ts escape="sql"}Unsubscribe Message{/ts}','Unsubscribe','{ts escape="sql"}Un-subscribe Confirmation{/ts}','{ts escape="sql" 1=$unsubgroup 2=$actresub 3=$actresuburl}You have been un-subscribed from the following groups: %1. You can re-subscribe by mailing %2 or clicking <a href="%3">here</a>.{/ts}','{ts escape="sql" 1=$unsubgroup 2=$actresub}You have been un-subscribed from the following groups: %1. You can re-subscribe by mailing %2 or clicking %3{/ts}',1,1),
116 ('{ts escape="sql"}Resubscribe Message{/ts}','Resubscribe','{ts escape="sql"}Re-subscribe Confirmation{/ts}','{ts escape="sql" 1=$resubgroup 2=$actunsub 3=$actunsuburl}You have been re-subscribed to the following groups: %1. You can un-subscribe by mailing %2 or clicking <a href="%3">here</a>.{/ts}','{ts escape="sql" 1=$resubgroup 2=$actunsub 3=$actunsuburl}You have been re-subscribed to the following groups: %1. You can un-subscribe by mailing %2 or clicking %3{/ts}',1,1),
117 ('{ts escape="sql"}Opt-out Message{/ts}','OptOut','{ts escape="sql"}Opt-out Confirmation{/ts}','{ts escape="sql" 1=$domname}Your email address has been removed from %1 mailing lists.{/ts}','{ts escape="sql" 1=$domname}Your email address has been removed from %1 mailing lists.{/ts}',1,1),
118 ('{ts escape="sql"}Auto-responder{/ts}','Reply','{ts escape="sql"}Please Send Inquiries to Our Contact Email Address{/ts}','{ts escape="sql"}This is an automated reply from an un-attended mailbox. Please send any inquiries to the contact email address listed on our web-site.{/ts}','{ts escape="sql"}This is an automated reply from an un-attended mailbox. Please send any inquiries to the contact email address listed on our web-site.{/ts}',1,1);
119
120
121-- contribution types
122INSERT INTO
123 civicrm_financial_type(name, is_reserved, is_active, is_deductible)
124VALUES
125 ( '{ts escape="sql"}Donation{/ts}' , 0, 1, 1 ),
126 ( '{ts escape="sql"}Member Dues{/ts}' , 0, 1, 1 ),
127 ( '{ts escape="sql"}Campaign Contribution{/ts}', 0, 1, 0 ),
128 ( '{ts escape="sql"}Event Fee{/ts}' , 0, 1, 0 );
129
130-- option groups and values for 'preferred communication methods' , 'activity types', 'gender', etc.
131
132INSERT INTO
cede6590 133 `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`)
6a488035 134VALUES
cede6590
DG		 135 ('preferred_communication_method', '{ts escape="sql"}Preferred Communication Method{/ts}' , 1, 1, 0),
136 ('activity_type' , '{ts escape="sql"}Activity Type{/ts}' , 1, 1, 0),
137 ('gender' , '{ts escape="sql"}Gender{/ts}' , 1, 1, 0),
138 ('instant_messenger_service' , '{ts escape="sql"}Instant Messenger (IM) screen-names{/ts}', 1, 1, 0),
139 ('mobile_provider' , '{ts escape="sql"}Mobile Phone Providers{/ts}' , 1, 1, 0),
140 ('individual_prefix' , '{ts escape="sql"}Individual contact prefixes{/ts}' , 1, 1, 0),
141 ('individual_suffix' , '{ts escape="sql"}Individual contact suffixes{/ts}' , 1, 1, 0),
142 ('acl_role' , '{ts escape="sql"}ACL Role{/ts}' , 1, 1, 0),
143 ('accept_creditcard' , '{ts escape="sql"}Accepted Credit Cards{/ts}' , 1, 1, 0),
144 ('payment_instrument' , '{ts escape="sql"}Payment Instruments{/ts}' , 1, 1, 0),
145 ('contribution_status' , '{ts escape="sql"}Contribution Status{/ts}' , 1, 1, 1),
146 ('pcp_status' , '{ts escape="sql"}PCP Status{/ts}' , 1, 1, 1),
12f92dbd 147 ('pcp_owner_notify' , '{ts escape="sql"}PCP owner notifications{/ts}' , 1, 1, 1),
cede6590
DG		 148 ('participant_role' , '{ts escape="sql"}Participant Role{/ts}' , 1, 1, 0),
149 ('event_type' , '{ts escape="sql"}Event Type{/ts}' , 1, 1, 0),
150 ('contact_view_options' , '{ts escape="sql"}Contact View Options{/ts}' , 1, 1, 1),
151 ('contact_smart_group_display' , '{ts escape="sql"}Contact Smart Group View Options{/ts}' , 1, 1, 1),
152 ('contact_edit_options' , '{ts escape="sql"}Contact Edit Options{/ts}' , 1, 1, 1),
153 ('advanced_search_options' , '{ts escape="sql"}Advanced Search Options{/ts}' , 1, 1, 1),
154 ('user_dashboard_options' , '{ts escape="sql"}User Dashboard Options{/ts}' , 1, 1, 1),
155 ('address_options' , '{ts escape="sql"}Addressing Options{/ts}' , 1, 1, 0),
156 ('group_type' , '{ts escape="sql"}Group Type{/ts}' , 1, 1, 0),
157 ('grant_status' , '{ts escape="sql"}Grant status{/ts}' , 1, 1, 0),
158 ('grant_type' , '{ts escape="sql"}Grant Type{/ts}' , 1, 1, 0),
159 ('custom_search' , '{ts escape="sql"}Custom Search{/ts}' , 1, 1, 0),
160 ('activity_status' , '{ts escape="sql"}Activity Status{/ts}' , 1, 1, 0),
161 ('case_type' , '{ts escape="sql"}Case Type{/ts}' , 1, 1, 0),
162 ('case_status' , '{ts escape="sql"}Case Status{/ts}' , 1, 1, 0),
163 ('participant_listing' , '{ts escape="sql"}Participant Listing{/ts}' , 1, 1, 0),
164 ('safe_file_extension' , '{ts escape="sql"}Safe File Extension{/ts}' , 1, 1, 0),
165 ('from_email_address' , '{ts escape="sql"}From Email Address{/ts}' , 1, 1, 0),
166 ('mapping_type' , '{ts escape="sql"}Mapping Type{/ts}' , 1, 1, 1),
167 ('wysiwyg_editor' , '{ts escape="sql"}WYSIWYG Editor{/ts}' , 1, 1, 0),
168 ('recur_frequency_units' , '{ts escape="sql"}Recurring Frequency Units{/ts}' , 1, 1, 0),
169 ('phone_type' , '{ts escape="sql"}Phone Type{/ts}' , 1, 1, 0),
170 ('custom_data_type' , '{ts escape="sql"}Custom Data Type{/ts}' , 1, 1, 0),
171 ('visibility' , '{ts escape="sql"}Visibility{/ts}' , 1, 1, 0),
172 ('mail_protocol' , '{ts escape="sql"}Mail Protocol{/ts}' , 1, 1, 0),
173 ('priority' , '{ts escape="sql"}Priority{/ts}' , 1, 1, 0),
174 ('redaction_rule' , '{ts escape="sql"}Redaction Rule{/ts}' , 1, 1, 0),
175 ('report_template' , '{ts escape="sql"}Report Template{/ts}' , 1, 1, 0),
176 ('email_greeting' , '{ts escape="sql"}Email Greeting Type{/ts}' , 1, 1, 0),
177 ('postal_greeting' , '{ts escape="sql"}Postal Greeting Type{/ts}' , 1, 1, 0),
178 ('addressee' , '{ts escape="sql"}Addressee Type{/ts}' , 1, 1, 0),
179 ('contact_autocomplete_options' , '{ts escape="sql"}Autocomplete Contact Search{/ts}' , 1, 1, 1),
180 ('contact_reference_options' , '{ts escape="sql"}Contact Reference Autocomplete Options{/ts}', 1, 1, 1),
181 ('website_type' , '{ts escape="sql"}Website Type{/ts}' , 1, 1, 0),
182 ('tag_used_for' , '{ts escape="sql"}Tag Used For{/ts}' , 1, 1, 1),
183 ('currencies_enabled' , '{ts escape="sql"}Currencies Enabled{/ts}' , 1, 1, 0),
184 ('event_badge' , '{ts escape="sql"}Event Name Badge{/ts}' , 1, 1, 0),
185 ('note_privacy' , '{ts escape="sql"}Privacy levels for notes{/ts}' , 1, 1, 0),
186 ('campaign_type' , '{ts escape="sql"}Campaign Type{/ts}' , 1, 1, 0),
187 ('campaign_status' , '{ts escape="sql"}Campaign Status{/ts}' , 1, 1, 0),
188 ('system_extensions' , '{ts escape="sql"}CiviCRM Extensions{/ts}' , 1, 1, 0),
189 ('mail_approval_status' , '{ts escape="sql"}CiviMail Approval Status{/ts}' , 1, 1, 0),
190 ('engagement_index' , '{ts escape="sql"}Engagement Index{/ts}' , 1, 1, 0),
191 ('cg_extend_objects' , '{ts escape="sql"}Objects a custom group extends to{/ts}' , 1, 1, 0),
192 ('paper_size' , '{ts escape="sql"}Paper Size{/ts}' , 1, 1, 0),
193 ('pdf_format' , '{ts escape="sql"}PDF Page Format{/ts}' , 1, 1, 0),
194 ('label_format' , '{ts escape="sql"}Mailing Label Format{/ts}' , 1, 1, 0),
195 ('activity_contacts' , '{ts escape="sql"}Activity Contacts{/ts}' , 1, 1, 1),
196 ('account_relationship' , '{ts escape="sql"}Account Relationship{/ts}' , 1, 1, 0),
197 ('event_contacts' , '{ts escape="sql"}Event Recipients{/ts}' , 1, 1, 0),
198 ('conference_slot' , '{ts escape="sql"}Conference Slot{/ts}' , 1, 1, 0),
199 ('batch_type' , '{ts escape="sql"}Batch Type{/ts}' , 1, 1, 1),
200 ('batch_mode' , '{ts escape="sql"}Batch Mode{/ts}' , 1, 1, 1),
201 ('batch_status' , '{ts escape="sql"}Batch Status{/ts}' , 1, 1, 1),
202 ('sms_api_type' , '{ts escape="sql"}Api Type{/ts}' , 1, 1, 0),
203 ('sms_provider_name' , '{ts escape="sql"}Sms Provider Internal Name{/ts}' , 1, 1, 0),
204 ('auto_renew_options' , '{ts escape="sql"}Auto Renew Options{/ts}' , 1, 1, 1),
205 ('financial_account_type' , '{ts escape="sql"}Financial Account Type{/ts}' , 1, 1, 0),
206 ('financial_item_status' , '{ts escape="sql"}Financial Item Status{/ts}' , 1, 1, 1),
207 ('label_type' , '{ts escape="sql"}Label Type{/ts}' , 1, 1, 0),
208 ('name_badge' , '{ts escape="sql"}Name Badge Format{/ts}' , 1, 1, 0),
209 ('communication_style' , '{ts escape="sql"}Communication Style{/ts}' , 1, 1, 0),
3d65c75c 210 ('msg_mode' , '{ts escape="sql"}Message Mode{/ts}' , 1, 1, 0),
321121a1 211 ('contact_date_reminder_options' , '{ts escape="sql"}Contact Date Reminder Options{/ts}' , 1, 1, 1);
6a488035
TO		 212
213SELECT @option_group_id_pcm := max(id) from civicrm_option_group where name = 'preferred_communication_method';
214SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type';
215SELECT @option_group_id_gender := max(id) from civicrm_option_group where name = 'gender';
216SELECT @option_group_id_IMProvider := max(id) from civicrm_option_group where name = 'instant_messenger_service';
217SELECT @option_group_id_mobileProvider := max(id) from civicrm_option_group where name = 'mobile_provider';
218SELECT @option_group_id_prefix := max(id) from civicrm_option_group where name = 'individual_prefix';
219SELECT @option_group_id_suffix := max(id) from civicrm_option_group where name = 'individual_suffix';
220SELECT @option_group_id_aclRole := max(id) from civicrm_option_group where name = 'acl_role';
221SELECT @option_group_id_acc := max(id) from civicrm_option_group where name = 'accept_creditcard';
222SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument';
223SELECT @option_group_id_cs := max(id) from civicrm_option_group where name = 'contribution_status';
224SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status';
12f92dbd 225SELECT @option_group_id_pcpOwnerNotify := max(id) from civicrm_option_group where name = 'pcp_owner_notify';
6a488035
TO		 226SELECT @option_group_id_pRole := max(id) from civicrm_option_group where name = 'participant_role';
227SELECT @option_group_id_etype := max(id) from civicrm_option_group where name = 'event_type';
228SELECT @option_group_id_cvOpt := max(id) from civicrm_option_group where name = 'contact_view_options';
8acb3461 229SELECT @option_group_id_csgOpt := max(id) from civicrm_option_group where name = 'contact_smart_group_display';
6a488035
TO		 230SELECT @option_group_id_ceOpt := max(id) from civicrm_option_group where name = 'contact_edit_options';
231SELECT @option_group_id_asOpt := max(id) from civicrm_option_group where name = 'advanced_search_options';
232SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options';
233SELECT @option_group_id_adOpt := max(id) from civicrm_option_group where name = 'address_options';
234SELECT @option_group_id_gType := max(id) from civicrm_option_group where name = 'group_type';
235SELECT @option_group_id_grantSt := max(id) from civicrm_option_group where name = 'grant_status';
236SELECT @option_group_id_grantTyp := max(id) from civicrm_option_group where name = 'grant_type';
6a488035
TO		 237SELECT @option_group_id_csearch := max(id) from civicrm_option_group where name = 'custom_search';
238SELECT @option_group_id_acs := max(id) from civicrm_option_group where name = 'activity_status';
239SELECT @option_group_id_ct := max(id) from civicrm_option_group where name = 'case_type';
240SELECT @option_group_id_cas := max(id) from civicrm_option_group where name = 'case_status';
241SELECT @option_group_id_pl := max(id) from civicrm_option_group where name = 'participant_listing';
242SELECT @option_group_id_sfe := max(id) from civicrm_option_group where name = 'safe_file_extension';
243SELECT @option_group_id_mt := max(id) from civicrm_option_group where name = 'mapping_type';
244SELECT @option_group_id_we := max(id) from civicrm_option_group where name = 'wysiwyg_editor';
245SELECT @option_group_id_fu := max(id) from civicrm_option_group where name = 'recur_frequency_units';
246SELECT @option_group_id_pht := max(id) from civicrm_option_group where name = 'phone_type';
247SELECT @option_group_id_fma := max(id) from civicrm_option_group where name = 'from_email_address';
248SELECT @option_group_id_cdt := max(id) from civicrm_option_group where name = 'custom_data_type';
249SELECT @option_group_id_vis := max(id) from civicrm_option_group where name = 'visibility';
250SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol';
251SELECT @option_group_id_priority := max(id) from civicrm_option_group where name = 'priority';
252SELECT @option_group_id_rr := max(id) from civicrm_option_group where name = 'redaction_rule';
253SELECT @option_group_id_emailGreeting := max(id) from civicrm_option_group where name = 'email_greeting';
254SELECT @option_group_id_postalGreeting := max(id) from civicrm_option_group where name = 'postal_greeting';
255SELECT @option_group_id_addressee := max(id) from civicrm_option_group where name = 'addressee';
256SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template';
257SELECT @option_group_id_acsOpt := max(id) from civicrm_option_group where name = 'contact_autocomplete_options';
258SELECT @option_group_id_acConRef := max(id) from civicrm_option_group where name = 'contact_reference_options';
6a488035
TO		 259SELECT @option_group_id_website := max(id) from civicrm_option_group where name = 'website_type';
260SELECT @option_group_id_tuf := max(id) from civicrm_option_group where name = 'tag_used_for';
261SELECT @option_group_id_currency := max(id) from civicrm_option_group where name = 'currencies_enabled';
262SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge';
263SELECT @option_group_id_notePrivacy := max(id) from civicrm_option_group where name = 'note_privacy';
264SELECT @option_group_id_campaignType := max(id) from civicrm_option_group where name = 'campaign_type';
265SELECT @option_group_id_campaignStatus := max(id) from civicrm_option_group where name = 'campaign_status';
266SELECT @option_group_id_extensions := max(id) from civicrm_option_group where name = 'system_extensions';
267SELECT @option_group_id_mail_approval_status := max(id) from civicrm_option_group where name = 'mail_approval_status';
268SELECT @option_group_id_engagement_index := max(id) from civicrm_option_group where name = 'engagement_index';
269SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects';
270SELECT @option_group_id_paperSize := max(id) from civicrm_option_group where name = 'paper_size';
271SELECT @option_group_id_label := max(id) from civicrm_option_group where name = 'label_format';
272SELECT @option_group_id_aco := max(id) from civicrm_option_group where name = 'activity_contacts';
273SELECT @option_group_id_arel := max(id) from civicrm_option_group where name = 'account_relationship';
274SELECT @option_group_id_ere := max(id) from civicrm_option_group where name = 'event_contacts';
275SELECT @option_group_id_conference_slot := max(id) from civicrm_option_group where name = 'conference_slot';
276SELECT @option_group_id_batch_type := max(id) from civicrm_option_group where name = 'batch_type';
277SELECT @option_group_id_batch_status := max(id) from civicrm_option_group where name = 'batch_status';
278SELECT @option_group_id_batch_mode := max(id) from civicrm_option_group where name = 'batch_mode';
279SELECT @option_group_id_sms_api_type := max(id) from civicrm_option_group where name = 'sms_api_type';
280SELECT @option_group_id_sms_provider_name := max(id) from civicrm_option_group where name = 'sms_provider_name';
281SELECT @option_group_id_aro := max(id) from civicrm_option_group where name = 'auto_renew_options';
282SELECT @option_group_id_fat := max(id) from civicrm_option_group where name = 'financial_account_type';
283SELECT @option_group_id_financial_item_status := max(id) from civicrm_option_group where name = 'financial_item_status';
bcb99132 284SELECT @option_group_id_label_type := max(id) from civicrm_option_group where name = 'label_type';
ab3a115e 285SELECT @option_group_id_name_badge := max(id) from civicrm_option_group where name = 'name_badge';
aa62b355 286SELECT @option_group_id_communication_style := max(id) from civicrm_option_group where name = 'communication_style';
a3e3eea1 287SELECT @option_group_id_msg_mode := max(id) from civicrm_option_group where name = 'msg_mode';
3d65c75c 288SELECT @option_group_id_contactDateMode := max(id) from civicrm_option_group where name = 'contact_date_reminder_options';
6a488035
TO		 289
290SELECT @contributeCompId := max(id) FROM civicrm_component where name = 'CiviContribute';
291SELECT @eventCompId := max(id) FROM civicrm_component where name = 'CiviEvent';
292SELECT @memberCompId := max(id) FROM civicrm_component where name = 'CiviMember';
293SELECT @pledgeCompId := max(id) FROM civicrm_component where name = 'CiviPledge';
294SELECT @caseCompId := max(id) FROM civicrm_component where name = 'CiviCase';
295SELECT @grantCompId := max(id) FROM civicrm_component where name = 'CiviGrant';
296SELECT @campaignCompId := max(id) FROM civicrm_component where name = 'CiviCampaign';
297SELECT @mailCompId := max(id) FROM civicrm_component where name = 'CiviMail';
298
299INSERT INTO
300 `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)
301VALUES
302 (@option_group_id_pcm, '{ts escape="sql"}Phone{/ts}', 1, NULL, NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
303 (@option_group_id_pcm, '{ts escape="sql"}Email{/ts}', 2, NULL, NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
304 (@option_group_id_pcm, '{ts escape="sql"}Postal Mail{/ts}', 3, NULL, NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
305 (@option_group_id_pcm, '{ts escape="sql"}SMS{/ts}', 4, NULL, NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
306 (@option_group_id_pcm, '{ts escape="sql"}Fax{/ts}', 5, NULL, NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
307
a235e13c 308 (@option_group_id_act, '{ts escape="sql"}Meeting{/ts}', 1, 'Meeting', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
309 (@option_group_id_act, '{ts escape="sql"}Phone Call{/ts}', 2, 'Phone Call', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
6a488035 310 (@option_group_id_act, '{ts escape="sql"}Email{/ts}', 3, 'Email', NULL, 1, NULL, 3, '{ts escape="sql"}Email sent.{/ts}', 0, 1, 1, NULL, NULL),
e8cb3963 311 (@option_group_id_act, '{ts escape="sql"}Outbound SMS{/ts}', 4, 'SMS', NULL, 1, NULL, 4, '{ts escape="sql"}Text message (SMS) sent.{/ts}', 0, 1, 1, NULL, NULL),
6a488035
TO		 312 (@option_group_id_act, '{ts escape="sql"}Event Registration{/ts}', 5, 'Event Registration', NULL, 1, NULL, 5, '{ts escape="sql"}Online or offline event registration.{/ts}', 0, 1, 1, @eventCompId, NULL),
313 (@option_group_id_act, '{ts escape="sql"}Contribution{/ts}', 6, 'Contribution', NULL, 1, NULL, 6, '{ts escape="sql"}Online or offline contribution.{/ts}', 0, 1, 1, @contributeCompId, NULL),
314 (@option_group_id_act, '{ts escape="sql"}Membership Signup{/ts}', 7, 'Membership Signup', NULL, 1, NULL, 7, '{ts escape="sql"}Online or offline membership signup.{/ts}', 0, 1, 1, @memberCompId, NULL),
315 (@option_group_id_act, '{ts escape="sql"}Membership Renewal{/ts}', 8, 'Membership Renewal', NULL, 1, NULL, 8, '{ts escape="sql"}Online or offline membership renewal.{/ts}', 0, 1, 1, @memberCompId, NULL),
316 (@option_group_id_act, '{ts escape="sql"}Tell a Friend{/ts}', 9, 'Tell a Friend', NULL, 1, NULL, 9, '{ts escape="sql"}Send information about a contribution campaign or event to a friend.{/ts}', 0, 1, 1, NULL, NULL),
317 (@option_group_id_act, '{ts escape="sql"}Pledge Acknowledgment{/ts}', 10, 'Pledge Acknowledgment', NULL, 1, NULL, 10, '{ts escape="sql"}Send Pledge Acknowledgment.{/ts}', 0, 1, 1, @pledgeCompId, NULL),
318 (@option_group_id_act, '{ts escape="sql"}Pledge Reminder{/ts}', 11, 'Pledge Reminder', NULL, 1, NULL, 11, '{ts escape="sql"}Send Pledge Reminder.{/ts}', 0, 1, 1, @pledgeCompId, NULL),
66cae705 319 (@option_group_id_act, '{ts escape="sql"}Inbound Email{/ts}', 12, 'Inbound Email', NULL, 1, NULL, 12, '{ts escape="sql"}Inbound Email.{/ts}', 0, 1, 1, NULL, NULL),
6a488035
TO		 320
321-- Activity Types for case activities
61a46288 322 (@option_group_id_act, '{ts escape="sql"}Open Case{/ts}', 13, 'Open Case', NULL, 0, 0, 13, '', 0, 1, 1, @caseCompId, NULL),
323 (@option_group_id_act, '{ts escape="sql"}Follow up{/ts}', 14, 'Follow up', NULL, 0, 0, 14, '', 0, 1, 1, @caseCompId, NULL ),
324 (@option_group_id_act, '{ts escape="sql"}Change Case Type{/ts}', 15, 'Change Case Type', NULL, 0, 0, 15, '', 0, 1, 1, @caseCompId, NULL ),
325 (@option_group_id_act, '{ts escape="sql"}Change Case Status{/ts}', 16, 'Change Case Status', NULL, 0, 0, 16, '', 0, 1, 1, @caseCompId, NULL ),
6a488035
TO		 326
327 (@option_group_id_act, '{ts escape="sql"}Membership Renewal Reminder{/ts}', 17, 'Membership Renewal Reminder', NULL, 1, NULL, 17, '{ts escape="sql"}offline membership renewal reminder.{/ts}', 0, 1, 1, @memberCompId, NULL),
61a46288 328 (@option_group_id_act, '{ts escape="sql"}Change Case Start Date{/ts}', 18, 'Change Case Start Date', NULL, 0, 0, 18, '', 0, 1, 1, @caseCompId, NULL ),
6a488035 329 (@option_group_id_act, '{ts escape="sql"}Bulk Email{/ts}', 19, 'Bulk Email', NULL, 1, NULL, 19, '{ts escape="sql"}Bulk Email Sent.{/ts}', 0, 1, 1, NULL, NULL),
61a46288 330 (@option_group_id_act, '{ts escape="sql"}Assign Case Role{/ts}', 20, 'Assign Case Role', NULL,0, 0, 20, '', 0, 1, 1, @caseCompId, NULL),
331 (@option_group_id_act, '{ts escape="sql"}Remove Case Role{/ts}', 21, 'Remove Case Role', NULL,0, 0, 21, '', 0, 1, 1, @caseCompId, NULL),
6a488035
TO		 332 (@option_group_id_act, '{ts escape="sql"}Print PDF Letter{/ts}', 22, 'Print PDF Letter', NULL, 0, NULL, 22, '{ts escape="sql"}Print PDF Letter.{/ts}', 0, 1, 1, NULL, NULL),
333 (@option_group_id_act, '{ts escape="sql"}Merge Case{/ts}', 23, 'Merge Case', NULL, 0, NULL, 23, '', 0, 1, 1, @caseCompId, NULL ),
334 (@option_group_id_act, '{ts escape="sql"}Reassigned Case{/ts}', 24, 'Reassigned Case', NULL, 0, NULL, 24, '', 0, 1, 1, @caseCompId, NULL ),
335 (@option_group_id_act, '{ts escape="sql"}Link Cases{/ts}', 25, 'Link Cases', NULL, 0, NULL, 25, '', 0, 1, 1, @caseCompId, NULL ),
336 (@option_group_id_act, '{ts escape="sql"}Change Case Tags{/ts}', 26, 'Change Case Tags', NULL,0, 0, 26, '', 0, 1, 1, @caseCompId, NULL),
337 (@option_group_id_act, '{ts escape="sql"}Add Client To Case{/ts}', 27, 'Add Client To Case', NULL,0, 0, 26, '', 0, 1, 1, @caseCompId, NULL),
338
339-- Activity Types for CiviCampaign
340 (@option_group_id_act, '{ts escape="sql"}Survey{/ts}', 28, 'Survey', NULL,0, 0, 27, '', 0, 1, 1, @campaignCompId, NULL),
341 (@option_group_id_act, '{ts escape="sql"}Canvass{/ts}', 29, 'Canvass', NULL,0, 0, 28, '', 0, 1, 1, @campaignCompId, NULL),
342 (@option_group_id_act, '{ts escape="sql"}PhoneBank{/ts}', 30, 'PhoneBank', NULL,0, 0, 29, '', 0, 1, 1, @campaignCompId, NULL),
343 (@option_group_id_act, '{ts escape="sql"}WalkList{/ts}', 31, 'WalkList', NULL,0, 0, 30, '', 0, 1, 1, @campaignCompId, NULL),
344 (@option_group_id_act, '{ts escape="sql"}Petition Signature{/ts}', 32, 'Petition', NULL,0, 0, 31, '', 0, 1, 1, @campaignCompId, NULL),
345 (@option_group_id_act, '{ts escape="sql"}Mass SMS{/ts}', 34, 'Mass SMS', NULL, 1, NULL, 34, '{ts escape="sql"}Mass SMS{/ts}', 0, 1, 1, NULL, NULL),
346
347-- Activity Types for CiviCampaign CiviCase
348 (@option_group_id_act, '{ts escape="sql"}Change Custom Data{/ts}', 33, 'Change Custom Data', NULL,0, 0, 33, '', 0, 1, 1, @caseCompId, NULL),
349
350-- Additional Membership-related Activity Types
351 (@option_group_id_act, '{ts escape="sql"}Change Membership Status{/ts}', 35, 'Change Membership Status', NULL, 1, NULL, 35, '{ts escape="sql"}Change Membership Status.{/ts}', 0, 1, 1, @memberCompId, NULL),
352 (@option_group_id_act, '{ts escape="sql"}Change Membership Type{/ts}', 36, 'Change Membership Type', NULL, 1, NULL, 36, '{ts escape="sql"}Change Membership Type.{/ts}', 0, 1, 1, @memberCompId, NULL),
353
354 (@option_group_id_act, '{ts escape="sql"}Cancel Recurring Contribution{/ts}', 37, 'Cancel Recurring Contribution', NULL,1, 0, 37, '', 0, 1, 1, NULL, NULL),
355 (@option_group_id_act, '{ts escape="sql"}Update Recurring Contribution Billing Details{/ts}', 38, 'Update Recurring Contribution Billing Details', NULL,1, 0, 38, '', 0, 1, 1, NULL, NULL),
356 (@option_group_id_act, '{ts escape="sql"}Update Recurring Contribution{/ts}', 39, 'Update Recurring Contribution', NULL,1, 0, 39, '', 0, 1, 1, NULL, NULL),
357
a235e13c 358 (@option_group_id_act, '{ts escape="sql"}Reminder Sent{/ts}', 40, 'Reminder Sent', NULL, 1, 0, 40, '', 0, 1, 1, NULL, NULL),
6a488035
TO		 359
360 -- Activity Types for Financial Transactions Batch
361 (@option_group_id_act, '{ts escape="sql"}Export Accounting Batch{/ts}', 41, 'Export Accounting Batch', NULL, 1, 0, 41, 'Export Accounting Batch', 0, 1, 1, @contributeCompId, NULL),
362 (@option_group_id_act, '{ts escape="sql"}Create Batch{/ts}', 42, 'Create Batch', NULL, 1, 0, 42, 'Create Batch', 0, 1, 1, @contributeCompId, NULL),
363 (@option_group_id_act, '{ts escape="sql"}Edit Batch{/ts}', 43, 'Edit Batch', NULL, 1, 0, 43, 'Edit Batch', 0, 1, 1, @contributeCompId, NULL),
364
e8cb3963 365-- new sms options
aef3b876
ML		 366 (@option_group_id_act, '{ts escape="sql"}SMS delivery{/ts}', 44, 'SMS delivery', NULL, 1, NULL, 44, '{ts escape="sql"}SMS delivery{/ts}', 0, 1, 1, NULL, NULL),
367 (@option_group_id_act, '{ts escape="sql"}Inbound SMS{/ts}', 45, 'Inbound SMS', NULL, 1, NULL, 45, '{ts escape="sql"}Inbound SMS{/ts}', 0, 1, 1, NULL, NULL),
e8cb3963 368
0f602e3f 369
66cae705 370 -- Activity types for particial payment
0f602e3f
PJ		 371 (@option_group_id_act, '{ts escape="sql"}Payment{/ts}', 46, 'Payment', NULL, 1, NULL, 46, '{ts escape="sql"}Additional payment recorded for event or membership fee.{/ts}', 0, 1, 1, @contributeCompId, NULL),
372 (@option_group_id_act, '{ts escape="sql"}Refund{/ts}', 47, 'Refund', NULL, 1, NULL, 47, '{ts escape="sql"}Refund recorded for event or membership fee.{/ts}', 0, 1, 1, @contributeCompId, NULL),
373
2429e40c
PJ		 374 -- for selection changes
375 (@option_group_id_act, '{ts escape="sql"}Change Registration{/ts}', 48, 'Change Registration', NULL, 1, NULL, 48, '{ts escape="sql"}Changes to an existing event registration.{/ts}', 0, 1, 1, @eventCompId, NULL),
56ed0b01
PB		 376 -- for Print or Email Contribution Invoices
377 (@option_group_id_act, '{ts escape="sql"}Downloaded Invoice{/ts}', 49, 'Downloaded Invoice', NULL, 1, NULL, 49, '{ts escape="sql"}Downloaded Invoice.{/ts}',0, 1, 1, NULL, NULL),
378 (@option_group_id_act, '{ts escape="sql"}Emailed Invoice{/ts}', 50, 'Emailed Invoice', NULL, 1, NULL, 50, '{ts escape="sql"}Emailed Invoice.{/ts}',0, 1, 1, NULL, NULL),
2429e40c 379
6a488035
TO		 380 (@option_group_id_gender, '{ts escape="sql"}Female{/ts}', 1, 'Female', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
381 (@option_group_id_gender, '{ts escape="sql"}Male{/ts}', 2, 'Male', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
382 (@option_group_id_gender, '{ts escape="sql"}Transgender{/ts}', 3, 'Transgender', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
383
384 (@option_group_id_IMProvider, 'Yahoo', 1, 'Yahoo', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
385 (@option_group_id_IMProvider, 'MSN', 2, 'Msn', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
386 (@option_group_id_IMProvider, 'AIM', 3, 'Aim', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
387 (@option_group_id_IMProvider, 'GTalk', 4, 'Gtalk', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
388 (@option_group_id_IMProvider, 'Jabber',5, 'Jabber',NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
389 (@option_group_id_IMProvider, 'Skype', 6, 'Skype', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
390
391 (@option_group_id_mobileProvider, 'Sprint' , 1, 'Sprint' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
392 (@option_group_id_mobileProvider, 'Verizon' , 2, 'Verizon' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
393 (@option_group_id_mobileProvider, 'Cingular', 3, 'Cingular', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
394
395 (@option_group_id_prefix, '{ts escape="sql"}Mrs.{/ts}', 1, 'Mrs.', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
396 (@option_group_id_prefix, '{ts escape="sql"}Ms.{/ts}', 2, 'Ms.', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
397 (@option_group_id_prefix, '{ts escape="sql"}Mr.{/ts}', 3, 'Mr.', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
398 (@option_group_id_prefix, '{ts escape="sql"}Dr.{/ts}', 4, 'Dr.', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
399
400 (@option_group_id_suffix, '{ts escape="sql"}Jr.{/ts}', 1, 'Jr.', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
401 (@option_group_id_suffix, '{ts escape="sql"}Sr.{/ts}', 2, 'Sr.', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
402 (@option_group_id_suffix, 'II', 3, 'II', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
403 (@option_group_id_suffix, 'III', 4, 'III', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
404 (@option_group_id_suffix, 'IV', 5, 'IV', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
405 (@option_group_id_suffix, 'V', 6, 'V', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
406 (@option_group_id_suffix, 'VI', 7, 'VI', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
407 (@option_group_id_suffix, 'VII', 8, 'VII', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
408
409 (@option_group_id_aclRole, '{ts escape="sql"}Administrator{/ts}', 1, 'Admin', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
410 (@option_group_id_aclRole, '{ts escape="sql"}Authenticated{/ts}', 2, 'Auth' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
411
412 (@option_group_id_acc, 'Visa' , 1, 'Visa' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
413 (@option_group_id_acc, 'MasterCard', 2, 'MasterCard', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
414 (@option_group_id_acc, 'Amex' , 3, 'Amex' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
415 (@option_group_id_acc, 'Discover' , 4, 'Discover' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
416
d96cf288
DG		 417 (@option_group_id_pi, '{ts escape="sql"}Credit Card{/ts}', 1, 'Credit Card', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL),
418 (@option_group_id_pi, '{ts escape="sql"}Debit Card{/ts}', 2, 'Debit Card', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL),
419 (@option_group_id_pi, '{ts escape="sql"}Cash{/ts}', 3, 'Cash', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL),
420 (@option_group_id_pi, '{ts escape="sql"}Check{/ts}', 4, 'Check', NULL, 0, 1, 4, NULL, 0, 1, 1, NULL, NULL),
421 (@option_group_id_pi, '{ts escape="sql"}EFT{/ts}', 5, 'EFT', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 422
423 (@option_group_id_cs, '{ts escape="sql"}Completed{/ts}' , 1, 'Completed' , NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
424 (@option_group_id_cs, '{ts escape="sql"}Pending{/ts}' , 2, 'Pending' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
425 (@option_group_id_cs, '{ts escape="sql"}Cancelled{/ts}' , 3, 'Cancelled' , NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL),
426 (@option_group_id_cs, '{ts escape="sql"}Failed{/ts}' , 4, 'Failed' , NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL, NULL),
427 (@option_group_id_cs, '{ts escape="sql"}In Progress{/ts}', 5, 'In Progress', NULL, 0, NULL, 5, NULL, 0, 1, 1, NULL, NULL),
428 (@option_group_id_cs, '{ts escape="sql"}Overdue{/ts}' , 6, 'Overdue' , NULL, 0, NULL, 6, NULL, 0, 1, 1, NULL, NULL),
429 (@option_group_id_cs, '{ts escape="sql"}Refunded{/ts}' , 7, 'Refunded' , NULL, 0, NULL, 7, NULL, 0, 1, 1, NULL, NULL),
59e44db1 430 (@option_group_id_cs, '{ts escape="sql"}Partially paid{/ts}', 8, 'Partially paid', NULL, 0, NULL, 8, NULL, 0, 1, 1, NULL, NULL),
0f602e3f 431 (@option_group_id_cs, '{ts escape="sql"}Pending refund{/ts}', 9, 'Pending refund', NULL, 0, NULL, 9, NULL, 0, 1, 1, NULL, NULL),
6a488035
TO		 432
433 (@option_group_id_pcp, '{ts escape="sql"}Waiting Review{/ts}', 1, 'Waiting Review', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
434 (@option_group_id_pcp, '{ts escape="sql"}Approved{/ts}' , 2, 'Approved' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
435 (@option_group_id_pcp, '{ts escape="sql"}Not Approved{/ts}' , 3, 'Not Approved' , NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL),
436
12f92dbd
N		 437 (@option_group_id_pcpOwnerNotify, '{ts escape="sql"}Owner chooses whether to receive notifications{/ts}', 1, 'owner_chooses', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
438 (@option_group_id_pcpOwnerNotify, '{ts escape="sql"}Notifications are sent to ALL owners{/ts}' , 2, 'all_owners' , NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL),
439 (@option_group_id_pcpOwnerNotify, '{ts escape="sql"}Notifications are NOT available{/ts}' , 3, 'no_notifications' , NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL),
440
6a488035
TO		 441 (@option_group_id_pRole, '{ts escape="sql"}Attendee{/ts}', 1, 'Attendee', NULL, 1, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
442 (@option_group_id_pRole, '{ts escape="sql"}Volunteer{/ts}', 2, 'Volunteer', NULL, 1, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
443 (@option_group_id_pRole, '{ts escape="sql"}Host{/ts}', 3, 'Host', NULL, 1, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
444 (@option_group_id_pRole, '{ts escape="sql"}Speaker{/ts}', 4, 'Speaker', NULL, 1, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
445
446 (@option_group_id_etype, '{ts escape="sql"}Conference{/ts}', 1, 'Conference', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
447 (@option_group_id_etype, '{ts escape="sql"}Exhibition{/ts}', 2, 'Exhibition', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
448 (@option_group_id_etype, '{ts escape="sql"}Fundraiser{/ts}', 3, 'Fundraiser', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
449 (@option_group_id_etype, '{ts escape="sql"}Meeting{/ts}', 4, 'Meeting', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
450 (@option_group_id_etype, '{ts escape="sql"}Performance{/ts}',5, 'Performance', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
451 (@option_group_id_etype, '{ts escape="sql"}Workshop{/ts}', 6, 'Workshop', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
452
453-- note that these are not ts'ed since they are used for logic in most cases and not display
454-- they are used for display only in the prefernces field settings
455 (@option_group_id_cvOpt, '{ts escape="sql"}Activities{/ts}' , 1, 'activity', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
456 (@option_group_id_cvOpt, '{ts escape="sql"}Relationships{/ts}', 2, 'rel', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
457 (@option_group_id_cvOpt, '{ts escape="sql"}Groups{/ts}' , 3, 'group', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
458 (@option_group_id_cvOpt, '{ts escape="sql"}Notes{/ts}' , 4, 'note', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
459 (@option_group_id_cvOpt, '{ts escape="sql"}Tags{/ts}' , 5, 'tag', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
460 (@option_group_id_cvOpt, '{ts escape="sql"}Change Log{/ts}' , 6, 'log', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
461 (@option_group_id_cvOpt, '{ts escape="sql"}Contributions{/ts}', 7, 'CiviContribute', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
462 (@option_group_id_cvOpt, '{ts escape="sql"}Memberships{/ts}' , 8, 'CiviMember', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
463 (@option_group_id_cvOpt, '{ts escape="sql"}Events{/ts}' , 9, 'CiviEvent', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
464 (@option_group_id_cvOpt, '{ts escape="sql"}Cases{/ts}' , 10, 'CiviCase', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
465 (@option_group_id_cvOpt, '{ts escape="sql"}Grants{/ts}' , 11, 'CiviGrant', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
466 (@option_group_id_cvOpt, '{ts escape="sql"}Pledges{/ts}' , 13, 'CiviPledge', NULL, 0, NULL, 13, NULL, 0, 0, 1, NULL, NULL),
5c61cec2 467 (@option_group_id_cvOpt, '{ts escape="sql"}Mailings{/ts}' , 14, 'CiviMail', NULL, 0, NULL, 14, NULL, 0, 0, 1, NULL, NULL),
6a488035 468
8acb3461
KJ		 469
470 (@option_group_id_csgOpt, '{ts escape="sql"}Show Smart Groups on Demand{/ts}',1, 'showondemand', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
471 (@option_group_id_csgOpt, '{ts escape="sql"}Always Show Smart Groups{/ts}', 2, 'alwaysshow', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
472 (@option_group_id_csgOpt, '{ts escape="sql"}Hide Smart Groups{/ts}' , 3, 'hide', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
473
6a488035
TO		 474 (@option_group_id_ceOpt, '{ts escape="sql"}Custom Data{/ts}' , 1, 'CustomData', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
475 (@option_group_id_ceOpt, '{ts escape="sql"}Address{/ts}' , 2, 'Address', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
476 (@option_group_id_ceOpt, '{ts escape="sql"}Communication Preferences{/ts}', 3, 'CommunicationPreferences', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
477 (@option_group_id_ceOpt, '{ts escape="sql"}Notes{/ts}' , 4, 'Notes', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
478 (@option_group_id_ceOpt, '{ts escape="sql"}Demographics{/ts}' , 5, 'Demographics', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
479 (@option_group_id_ceOpt, '{ts escape="sql"}Tags and Groups{/ts}' , 6, 'TagsAndGroups', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
480 (@option_group_id_ceOpt, '{ts escape="sql"}Email{/ts}' , 7, 'Email', NULL, 1, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
481 (@option_group_id_ceOpt, '{ts escape="sql"}Phone{/ts}' , 8, 'Phone', NULL, 1, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
482 (@option_group_id_ceOpt, '{ts escape="sql"}Instant Messenger{/ts}' , 9, 'IM', NULL, 1, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
483 (@option_group_id_ceOpt, '{ts escape="sql"}Open ID{/ts}' , 10, 'OpenID', NULL, 1, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
484 (@option_group_id_ceOpt, '{ts escape="sql"}Website{/ts}' , 11, 'Website', NULL, 1, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
8b49cb50
OB		 485 (@option_group_id_ceOpt, '{ts escape="sql"}Prefix{/ts}' , 12, 'Prefix', NULL, 2, NULL, 12, NULL, 0, 0, 1, NULL, NULL),
486 (@option_group_id_ceOpt, '{ts escape="sql"}Formal Title{/ts}' , 13, 'Formal Title', NULL, 2, NULL, 13, NULL, 0, 0, 1, NULL, NULL),
487 (@option_group_id_ceOpt, '{ts escape="sql"}First Name{/ts}' , 14, 'First Name', NULL, 2, NULL, 14, NULL, 0, 0, 1, NULL, NULL),
488 (@option_group_id_ceOpt, '{ts escape="sql"}Middle Name{/ts}' , 15, 'Middle Name', NULL, 2, NULL, 15, NULL, 0, 0, 1, NULL, NULL),
489 (@option_group_id_ceOpt, '{ts escape="sql"}Last Name{/ts}' , 16, 'Last Name', NULL, 2, NULL, 16, NULL, 0, 0, 1, NULL, NULL),
490 (@option_group_id_ceOpt, '{ts escape="sql"}Suffix{/ts}' , 17, 'Suffix', NULL, 2, NULL, 17, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 491
492 (@option_group_id_asOpt, '{ts escape="sql"}Address Fields{/ts}' , 1, 'location', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
493 (@option_group_id_asOpt, '{ts escape="sql"}Custom Fields{/ts}' , 2, 'custom', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
494 (@option_group_id_asOpt, '{ts escape="sql"}Activities{/ts}' , 3, 'activity', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
495 (@option_group_id_asOpt, '{ts escape="sql"}Relationships{/ts}' , 4, 'relationship', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
496 (@option_group_id_asOpt, '{ts escape="sql"}Notes{/ts}' , 5, 'notes', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
497 (@option_group_id_asOpt, '{ts escape="sql"}Change{/ts} Log' , 6, 'changeLog', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
498 (@option_group_id_asOpt, '{ts escape="sql"}Contributions{/ts}' , 7, 'CiviContribute', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
499 (@option_group_id_asOpt, '{ts escape="sql"}Memberships{/ts}' , 8, 'CiviMember', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
500 (@option_group_id_asOpt, '{ts escape="sql"}Events{/ts}' , 9, 'CiviEvent', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
501 (@option_group_id_asOpt, '{ts escape="sql"}Cases{/ts}' , 10, 'CiviCase', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
502 {if 0} {* Temporary hack to eliminate Kabissa checkbox in site preferences. *}
503 (@option_group_id_asOpt, 'Kabissa' , 11, NULL, NULL, 0, NULL, 13, NULL, 0, 0, 1, NULL, NULL),
504 {/if}
505 (@option_group_id_asOpt, 'Grants' , 12, 'CiviGrant', NULL, 0, NULL, 14, NULL, 0, 0, 1, NULL, NULL),
506 (@option_group_id_asOpt, '{ts escape="sql"}Demographics{/ts}' , 13, 'demographics', NULL, 0, NULL, 15, NULL, 0, 0, 1, NULL, NULL),
507 (@option_group_id_asOpt, '{ts escape="sql"}Pledges{/ts}' , 15, 'CiviPledge', NULL, 0, NULL, 17, NULL, 0, 0, 1, NULL, NULL),
508 (@option_group_id_asOpt, '{ts escape="sql"}Contact Type{/ts}' , 16, 'contactType', NULL, 0, NULL, 18, NULL, 0, 0, 1, NULL, NULL),
509 (@option_group_id_asOpt, '{ts escape="sql"}Groups{/ts}' , 17, 'groups', NULL, 0, NULL, 19, NULL, 0, 0, 1, NULL, NULL),
510 (@option_group_id_asOpt, '{ts escape="sql"}Tags{/ts}' , 18, 'tags', NULL, 0, NULL, 20, NULL, 0, 0, 1, NULL, NULL),
511 (@option_group_id_asOpt, '{ts escape="sql"}Mailing{/ts}' , 19, 'CiviMail', NULL, 0, NULL, 21, NULL, 0, 0, 1, NULL, NULL),
512
513 (@option_group_id_udOpt, '{ts escape="sql"}Groups{/ts}' , 1, 'Groups', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
514 (@option_group_id_udOpt, '{ts escape="sql"}Contributions{/ts}' , 2, 'CiviContribute', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
515 (@option_group_id_udOpt, '{ts escape="sql"}Memberships{/ts}' , 3, 'CiviMember', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
516 (@option_group_id_udOpt, '{ts escape="sql"}Events{/ts}' , 4, 'CiviEvent', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
517 (@option_group_id_udOpt, '{ts escape="sql"}My Contacts / Organizations{/ts}', 5, 'Permissioned Orgs', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
518 (@option_group_id_udOpt, '{ts escape="sql"}Pledges{/ts}' , 7, 'CiviPledge', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
519 (@option_group_id_udOpt, '{ts escape="sql"}Personal Campaign Pages{/ts}' , 8, 'PCP', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
520 (@option_group_id_udOpt, '{ts escape="sql"}Assigned Activities{/ts}' , 9, 'Assigned Activities', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
56ed0b01 521 (@option_group_id_udOpt, '{ts escape="sql"}Invoices / Credit Notes{/ts}' , 10, 'Invoices / Credit Notes', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 522
523 (@option_group_id_acsOpt, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
524 (@option_group_id_acsOpt, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
525 (@option_group_id_acsOpt, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
526 (@option_group_id_acsOpt, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
527 (@option_group_id_acsOpt, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
528 (@option_group_id_acsOpt, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
3d8c6ffe 529 (@option_group_id_acsOpt, '{ts escape="sql"}Postal Code{/ts}' , 8, 'postal_code' , NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 530
531 (@option_group_id_acConRef, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
532 (@option_group_id_acConRef, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
533 (@option_group_id_acConRef, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
534 (@option_group_id_acConRef, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
535 (@option_group_id_acConRef, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
536 (@option_group_id_acConRef, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
3d8c6ffe 537 (@option_group_id_acConRef, '{ts escape="sql"}Postal Code{/ts}' , 8, 'country' , NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 538
539 (@option_group_id_adOpt, '{ts escape="sql"}Street Address{/ts}' , 1, 'street_address', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
c29131ec
DG		 540 (@option_group_id_adOpt, '{ts escape="sql"}Supplemental Address 1{/ts}' , 2, 'supplemental_address_1', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
541 (@option_group_id_adOpt, '{ts escape="sql"}Supplemental Address 2{/ts}' , 3, 'supplemental_address_2', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 542 (@option_group_id_adOpt, '{ts escape="sql"}City{/ts}' , 4, 'city' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
543 (@option_group_id_adOpt, '{ts escape="sql"}Zip / Postal Code{/ts}' , 5, 'postal_code' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
544 (@option_group_id_adOpt, '{ts escape="sql"}Postal Code Suffix{/ts}', 6, 'postal_code_suffix', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
545 (@option_group_id_adOpt, '{ts escape="sql"}County{/ts}' , 7, 'county' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
757069de 546 (@option_group_id_adOpt, '{ts escape="sql"}State/Province{/ts}' , 8, 'state_province', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 547 (@option_group_id_adOpt, '{ts escape="sql"}Country{/ts}' , 9, 'country' , NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
548 (@option_group_id_adOpt, '{ts escape="sql"}Latitude{/ts}' , 10, 'geo_code_1' , NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
549 (@option_group_id_adOpt, '{ts escape="sql"}Longitude{/ts}' , 11, 'geo_code_2', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
550 (@option_group_id_adOpt, '{ts escape="sql"}Address Name{/ts}' , 12, 'address_name', NULL, 0, NULL, 12, NULL, 0, 0, 1, NULL, NULL),
551 (@option_group_id_adOpt, '{ts escape="sql"}Street Address Parsing{/ts}', 13, 'street_address_parsing', NULL, 0, NULL, 13, NULL, 0, 0, 1, NULL, NULL),
552
553 (@option_group_id_gType, 'Access Control' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
554 (@option_group_id_gType, 'Mailing List' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
555
5948c543
DG		 556 (@option_group_id_grantSt, '{ts escape="sql"}Submitted{/ts}', 1, 'Submitted', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
557 (@option_group_id_grantSt, '{ts escape="sql"}Eligible{/ts}', 2, 'Eligible', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
558 (@option_group_id_grantSt, '{ts escape="sql"}Ineligible{/ts}', 3, 'Ineligible', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
559 (@option_group_id_grantSt, '{ts escape="sql"}Paid{/ts}', 4, 'Paid', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
560 (@option_group_id_grantSt, '{ts escape="sql"}Awaiting Information{/ts}', 5, 'Awaiting Information', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
561 (@option_group_id_grantSt, '{ts escape="sql"}Withdrawn{/ts}', 6, 'Withdrawn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
562 (@option_group_id_grantSt, '{ts escape="sql"}Approved for Payment{/ts}', 7, 'Approved for Payment', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 563
564 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Sample' , 1, 'CRM_Contact_Form_Search_Custom_Sample' , NULL, 0, NULL, 1, '{ts escape="sql"}Household Name and State{/ts}', 0, 0, 1, NULL, NULL),
565 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ContributionAggregate', 2, 'CRM_Contact_Form_Search_Custom_ContributionAggregate', NULL, 0, NULL, 2, '{ts escape="sql"}Contribution Aggregate{/ts}', 0, 0, 1, NULL, NULL),
566 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Basic' , 3, 'CRM_Contact_Form_Search_Custom_Basic' , NULL, 0, NULL, 3, '{ts escape="sql"}Basic Search{/ts}', 0, 0, 1, NULL, NULL),
567 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Group' , 4, 'CRM_Contact_Form_Search_Custom_Group' , NULL, 0, NULL, 4, '{ts escape="sql"}Include / Exclude Search{/ts}', 0, 0, 1, NULL, NULL),
568 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_PostalMailing' , 5, 'CRM_Contact_Form_Search_Custom_PostalMailing', NULL, 0, NULL, 5, '{ts escape="sql"}Postal Mailing{/ts}', 0, 0, 1, NULL, NULL),
569 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_Proximity' , 6, 'CRM_Contact_Form_Search_Custom_Proximity', NULL, 0, NULL, 6, '{ts escape="sql"}Proximity Search{/ts}', 0, 0, 1, NULL, NULL),
570 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_EventAggregate' , 7, 'CRM_Contact_Form_Search_Custom_EventAggregate', NULL, 0, NULL, 7, '{ts escape="sql"}Event Aggregate{/ts}', 0, 0, 1, NULL, NULL),
571 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ActivitySearch' , 8, 'CRM_Contact_Form_Search_Custom_ActivitySearch', NULL, 0, NULL, 8, '{ts escape="sql"}Activity Search{/ts}', 0, 0, 1, NULL, NULL),
572 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_PriceSet' , 9, 'CRM_Contact_Form_Search_Custom_PriceSet', NULL, 0, NULL, 9, '{ts escape="sql"}Price Set Details for Event Participants{/ts}', 0, 0, 1, NULL, NULL),
573 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ZipCodeRange' ,10, 'CRM_Contact_Form_Search_Custom_ZipCodeRange', NULL, 0, NULL, 10, '{ts escape="sql"}Zip Code Range{/ts}', 0, 0, 1, NULL, NULL),
574 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_DateAdded' ,11, 'CRM_Contact_Form_Search_Custom_DateAdded', NULL, 0, NULL, 11, '{ts escape="sql"}Date Added to CiviCRM{/ts}', 0, 0, 1, NULL, NULL),
575 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_MultipleValues' ,12, 'CRM_Contact_Form_Search_Custom_MultipleValues', NULL, 0, NULL, 12, '{ts escape="sql"}Custom Group Multiple Values Listing{/ts}', 0, 0, 1, NULL, NULL),
576 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_ContribSYBNT' ,13, 'CRM_Contact_Form_Search_Custom_ContribSYBNT', NULL, 0, NULL, 13, '{ts escape="sql"}Contributions made in Year X and not Year Y{/ts}', 0, 0, 1, NULL, NULL),
577 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_TagContributions' ,14, 'CRM_Contact_Form_Search_Custom_TagContributions', NULL, 0, NULL, 14, '{ts escape="sql"}Find Contribution Amounts by Tag{/ts}', 0, 0, 1, NULL, NULL),
578 (@option_group_id_csearch , 'CRM_Contact_Form_Search_Custom_FullText' ,15, 'CRM_Contact_Form_Search_Custom_FullText', NULL, 0, NULL, 15, '{ts escape="sql"}Full-text Search{/ts}', 0, 0, 1, NULL, NULL),
579
580-- report templates
581 (@option_group_id_report , '{ts escape="sql"}Constituent Report (Summary){/ts}', 'contact/summary', 'CRM_Report_Form_Contact_Summary', NULL, 0, NULL, 1, '{ts escape="sql"}Provides a list of address and telephone information for constituent records in your system.{/ts}', 0, 0, 1, NULL, NULL),
582 (@option_group_id_report , '{ts escape="sql"}Constituent Report (Detail){/ts}', 'contact/detail', 'CRM_Report_Form_Contact_Detail', NULL, 0, NULL, 2, '{ts escape="sql"}Provides contact-related information on contributions, memberships, events and activities.{/ts}', 0, 0, 1, NULL, NULL),
583 (@option_group_id_report , '{ts escape="sql"}Activity Report{/ts}', 'activity', 'CRM_Report_Form_Activity', NULL, 0, NULL, 3, '{ts escape="sql"}Provides a list of constituent activity including activity statistics for one/all contacts during a given date range(required){/ts}', 0, 0, 1, NULL, NULL),
584 (@option_group_id_report , '{ts escape="sql"}Walk / Phone List Report{/ts}', 'walklist', 'CRM_Report_Form_Walklist_Walklist', NULL, 0, NULL, 4, '{ts escape="sql"}Provides a detailed report for your walk/phonelist for targetted contacts{/ts}', 0, 0, 0, NULL, NULL),
585 (@option_group_id_report , '{ts escape="sql"}Current Employer Report{/ts}', 'contact/currentEmployer', 'CRM_Report_Form_Contact_CurrentEmployer', NULL, 0, NULL, 5, '{ts escape="sql"}Provides detail list of employer employee relationships along with employment details Ex Join Date{/ts}', 0, 0, 1, NULL, NULL),
586 (@option_group_id_report , '{ts escape="sql"}Contribution Summary Report{/ts}', 'contribute/summary', 'CRM_Report_Form_Contribute_Summary', NULL, 0, NULL, 6, '{ts escape="sql"}Groups and totals contributions by criteria including contact, time period, financial type, contributor location, etc.{/ts}', 0, 0, 1, @contributeCompId, NULL),
587 (@option_group_id_report , '{ts escape="sql"}Contribution Detail Report{/ts}', 'contribute/detail', 'CRM_Report_Form_Contribute_Detail', NULL, 0, NULL, 7, '{ts escape="sql"}Lists specific contributions by criteria including contact, time period, financial type, contributor location, etc. Contribution summary report points to this report for contribution details.{/ts}', 0, 0, 1, @contributeCompId, NULL),
588 (@option_group_id_report , '{ts escape="sql"}Repeat Contributions Report{/ts}', 'contribute/repeat', 'CRM_Report_Form_Contribute_Repeat', NULL, 0, NULL, 8, '{ts escape="sql"}Given two date ranges, shows contacts who contributed in both the date ranges with the amount contributed in each and the percentage increase / decrease.{/ts}', 0, 0, 1, @contributeCompId, NULL),
589 (@option_group_id_report , '{ts escape="sql"}Contributions by Organization Report{/ts}', 'contribute/organizationSummary', 'CRM_Report_Form_Contribute_OrganizationSummary', NULL, 0, NULL, 9, '{ts escape="sql"}Displays a detailed list of contributions grouped by organization, which includes contributions made by employees for the organisation.{/ts}', 0, 0, 1, @contributeCompId, NULL),
590 (@option_group_id_report , '{ts escape="sql"}Contributions by Household Report{/ts}', 'contribute/householdSummary', 'CRM_Report_Form_Contribute_HouseholdSummary', NULL, 0, NULL, 10, '{ts escape="sql"}Displays a detailed list of contributions grouped by household which includes contributions made by members of the household.{/ts}', 0, 0, 1, @contributeCompId, NULL),
591 (@option_group_id_report , '{ts escape="sql"}Top Donors Report{/ts}', 'contribute/topDonor', 'CRM_Report_Form_Contribute_TopDonor', NULL, 0, NULL, 11, '{ts escape="sql"}Provides a list of the top donors during a time period you define. You can include as many donors as you want (for example, top 100 of your donors).{/ts}', 0, 0, 1, @contributeCompId, NULL),
592 (@option_group_id_report , '{ts escape="sql"}SYBUNT Report{/ts}', 'contribute/sybunt', 'CRM_Report_Form_Contribute_Sybunt', NULL, 0, NULL, 12, '{ts escape="sql"}SYBUNT means some year(s) but not this year. Provides a list of constituents who donated at some time in the history of your organization but did not donate during the time period you specify.{/ts}', 0, 0, 1, @contributeCompId, NULL),
593 (@option_group_id_report , '{ts escape="sql"}LYBUNT Report{/ts}', 'contribute/lybunt', 'CRM_Report_Form_Contribute_Lybunt', NULL, 0, NULL, 13, '{ts escape="sql"}LYBUNT means last year but not this year. Provides a list of constituents who donated last year but did not donate during the time period you specify as the current year.{/ts}', 0, 0, 1, @contributeCompId, NULL),
594 (@option_group_id_report , '{ts escape="sql"}Soft Credit Report{/ts}', 'contribute/softcredit', 'CRM_Report_Form_Contribute_SoftCredit', NULL, 0, NULL, 14, '{ts escape="sql"}Shows contributions made by contacts that have been soft-credited to other contacts.{/ts}', 0, 0, 1,@contributeCompId, NULL),
595 (@option_group_id_report , '{ts escape="sql"}Membership Report (Summary){/ts}', 'member/summary', 'CRM_Report_Form_Member_Summary', NULL, 0, NULL, 15, '{ts escape="sql"}Provides a summary of memberships by type and join date.{/ts}', 0, 0, 1, @memberCompId, NULL),
596 (@option_group_id_report , '{ts escape="sql"}Membership Report (Detail){/ts}', 'member/detail', 'CRM_Report_Form_Member_Detail', NULL, 0, NULL, 16, '{ts escape="sql"}Provides a list of members along with their membership status and membership details (Join Date, Start Date, End Date). Can also display contributions (payments) associated with each membership.{/ts}', 0, 0, 1, @memberCompId, NULL),
597 (@option_group_id_report , '{ts escape="sql"}Membership Report (Lapsed){/ts}', 'member/lapse', 'CRM_Report_Form_Member_Lapse', NULL, 0, NULL, 17, '{ts escape="sql"}Provides a list of memberships that lapsed or will lapse before the date you specify.{/ts}', 0, 0, 1, @memberCompId, NULL),
598 (@option_group_id_report , '{ts escape="sql"}Event Participant Report (List){/ts}', 'event/participantListing', 'CRM_Report_Form_Event_ParticipantListing', NULL, 0, NULL, 18, '{ts escape="sql"}Provides lists of participants for an event.{/ts}', 0, 0, 1, @eventCompId, NULL),
599 (@option_group_id_report , '{ts escape="sql"}Event Income Report (Summary){/ts}', 'event/summary', 'CRM_Report_Form_Event_Summary', NULL, 0, NULL, 19, '{ts escape="sql"}Provides an overview of event income. You can include key information such as event ID, registration, attendance, and income generated to help you determine the success of an event.{/ts}', 0, 0, 1, @eventCompId, NULL),
600 (@option_group_id_report , '{ts escape="sql"}Event Income Report (Detail){/ts}', 'event/income', 'CRM_Report_Form_Event_Income', NULL, 0, NULL, 20, '{ts escape="sql"}Helps you to analyze the income generated by an event. The report can include details by participant type, status and payment method.{/ts}', 0, 0, 1, @eventCompId, NULL),
601 (@option_group_id_report , '{ts escape="sql"}Pledge Report{/ts}', 'pledge/detail', 'CRM_Report_Form_Pledge_Detail', NULL, 0, NULL, 21, '{ts escape="sql"}Pledge Report{/ts}', 0, 0, 1, @pledgeCompId, NULL),
fec1b4d0 602 (@option_group_id_report , '{ts escape="sql"}Pledged but not Paid Report{/ts}', 'pledge/pbnp', 'CRM_Report_Form_Pledge_Pbnp', NULL, 0, NULL, 22, '{ts escape="sql"}Pledged but not Paid Report{/ts}', 0, 0, 1, @pledgeCompId, NULL),
6a488035
TO		 603 (@option_group_id_report , '{ts escape="sql"}Relationship Report{/ts}', 'contact/relationship', 'CRM_Report_Form_Contact_Relationship', NULL, 0, NULL, 23, '{ts escape="sql"}Relationship Report{/ts}', 0, 0, 1, NULL, NULL),
604 (@option_group_id_report , '{ts escape="sql"}Case Summary Report{/ts}', 'case/summary', 'CRM_Report_Form_Case_Summary', NULL, 0, NULL, 24, '{ts escape="sql"}Provides a summary of cases and their duration by date range, status, staff member and / or case role.{/ts}', 0, 0, 1, @caseCompId, NULL),
a08aa8e8 605 (@option_group_id_report , '{ts escape="sql"}Case Time Spent Report{/ts}', 'case/timespent', 'CRM_Report_Form_Case_TimeSpent', NULL, 0, NULL, 25, '{ts escape="sql"}Aggregates time spent on case and / or non-case activities by activity type and contact.{/ts}', 0, 0, 1, @caseCompId, NULL),
6a488035
TO		 606 (@option_group_id_report , '{ts escape="sql"}Contact Demographics Report{/ts}', 'case/demographics', 'CRM_Report_Form_Case_Demographics', NULL, 0, NULL, 26, '{ts escape="sql"}Demographic breakdown for case clients (and or non-case contacts) in your database. Includes custom contact fields.{/ts}', 0, 0, 1, @caseCompId, NULL),
607 (@option_group_id_report , '{ts escape="sql"}Database Log Report{/ts}', 'contact/log', 'CRM_Report_Form_Contact_Log', NULL, 0, NULL, 27, '{ts escape="sql"}Log of contact and activity records created or updated in a given date range.{/ts}', 0, 0, 1, NULL, NULL),
608 (@option_group_id_report , '{ts escape="sql"}Activity Report (Summary){/ts}', 'activitySummary', 'CRM_Report_Form_ActivitySummary', NULL, 0, NULL, 28, '{ts escape="sql"}Shows activity statistics by type / date{/ts}', 0, 0, 1, NULL, NULL),
609 (@option_group_id_report, '{ts escape="sql"}Bookkeeping Transactions Report{/ts}', 'contribute/bookkeeping', 'CRM_Report_Form_Contribute_Bookkeeping', NULL, 0, 0, 29, '{ts escape="sql"}Shows Bookkeeping Transactions Report{/ts}', 0, 0, 1, 2, NULL),
610 (@option_group_id_report , {localize}'{ts escape="sql"}Grant Report (Detail){/ts}'{/localize}, 'grant/detail', 'CRM_Report_Form_Grant_Detail', NULL, 0, 0, 30, {localize}'{ts escape="sql"}Grant Report Detail{/ts}'{/localize}, 0, 0, 1, @grantCompId, NULL),
611 (@option_group_id_report, {localize}'{ts escape="sql"}Participant list Count Report{/ts}'{/localize}, 'event/participantlist', 'CRM_Report_Form_Event_ParticipantListCount', NULL, 0, 0, 31, {localize}'{ts escape="sql"}Shows the Participant list with Participant Count.{/ts}'{/localize}, 0, 0, 1, @eventCompId, NULL),
612 (@option_group_id_report, {localize}'{ts escape="sql"}Income Count Summary Report{/ts}'{/localize}, 'event/incomesummary', 'CRM_Report_Form_Event_IncomeCountSummary', NULL, 0, 0, 32, {localize}'{ts escape="sql"}Shows the Income Summary of events with Count.{/ts}'{/localize}, 0, 0, 1, @eventCompId, NULL),
613 (@option_group_id_report, {localize}'{ts escape="sql"}Case Detail Report{/ts}'{/localize}, 'case/detail', 'CRM_Report_Form_Case_Detail', NULL, 0, 0, 33, {localize}'{ts escape="sql"}Case Details{/ts}'{/localize}, 0, 0, 1, @caseCompId, NULL),
614 (@option_group_id_report, {localize}'{ts escape="sql"}Mail Bounce Report{/ts}'{/localize}, 'Mailing/bounce', 'CRM_Report_Form_Mailing_Bounce', NULL, 0, NULL, 34, {localize}'{ts escape="sql"}Bounce Report for mailings{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
615 (@option_group_id_report, {localize}'{ts escape="sql"}Mail Summary Report{/ts}'{/localize}, 'Mailing/summary', 'CRM_Report_Form_Mailing_Summary', NULL, 0, NULL, 35, {localize}'{ts escape="sql"}Summary statistics for mailings{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
616 (@option_group_id_report, {localize}'{ts escape="sql"}Mail Opened Report{/ts}'{/localize}, 'Mailing/opened', 'CRM_Report_Form_Mailing_Opened', NULL, 0, NULL, 36, {localize}'{ts escape="sql"}Display contacts who opened emails from a mailing{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
617 (@option_group_id_report, {localize}'{ts escape="sql"}Mail Clickthrough Report{/ts}'{/localize}, 'Mailing/clicks', 'CRM_Report_Form_Mailing_Clicks', NULL, 0, NULL, 37, {localize}'{ts escape="sql"}Display clicks from each mailing{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
618 (@option_group_id_report, {localize}'{ts escape="sql"}Contact Logging Report (Summary){/ts}'{/localize}, 'logging/contact/summary', 'CRM_Report_Form_Contact_LoggingSummary', NULL, 0, NULL, 38, {localize}'{ts escape="sql"}Contact modification report for the logging infrastructure (summary).{/ts}'{/localize}, 0, 0, 0, NULL, NULL),
619 (@option_group_id_report, {localize}'{ts escape="sql"}Contact Logging Report (Detail){/ts}'{/localize}, 'logging/contact/detail', 'CRM_Report_Form_Contact_LoggingDetail', NULL, 0, NULL, 39, {localize}'{ts escape="sql"}Contact modification report for the logging infrastructure (detail).{/ts}'{/localize}, 0, 0, 0, NULL, NULL),
620 (@option_group_id_report, {localize}'{ts escape="sql"}Contribute Logging Report (Summary){/ts}'{/localize}, 'logging/contribute/summary', 'CRM_Report_Form_Contribute_LoggingSummary', NULL, 0, NULL, 40, {localize}'{ts escape="sql"}Contribute modification report for the logging infrastructure (summary).{/ts}'{/localize}, 0, 0, 0, @contributeCompId, NULL),
621 (@option_group_id_report, {localize}'{ts escape="sql"}Contribute Logging Report (Detail){/ts}'{/localize}, 'logging/contribute/detail', 'CRM_Report_Form_Contribute_LoggingDetail', NULL, 0, NULL, 41, {localize}'{ts escape="sql"}Contribute modification report for the logging infrastructure (detail).{/ts}'{/localize}, 0, 0, 0, @contributeCompId, NULL),
622 (@option_group_id_report, {localize}'{ts escape="sql"}Grant Report (Statistics){/ts}'{/localize}, 'grant/statistics', 'CRM_Report_Form_Grant_Statistics', NULL, 0, NULL, 42, {localize}'{ts escape="sql"}Shows statistics for Grants.{/ts}'{/localize}, 0, 0, 1, @grantCompId, NULL),
623 (@option_group_id_report, {localize}'{ts escape="sql"}Survey Report (Detail){/ts}'{/localize}, 'survey/detail', 'CRM_Report_Form_Campaign_SurveyDetails', NULL, 0, NULL, 43, {localize}'{ts escape="sql"}Detailed report for canvassing, phone-banking, walk lists or other surveys.{/ts}'{/localize}, 0, 0, 1, @campaignCompId, NULL),
624 (@option_group_id_report, {localize}'{ts escape="sql"}Personal Campaign Page Report{/ts}'{/localize}, 'contribute/pcp', 'CRM_Report_Form_Contribute_PCP', NULL, 0, NULL, 44, {localize}'{ts escape="sql"}Summarizes amount raised and number of contributors for each Personal Campaign Page.{/ts}'{/localize}, 0, 0, 1, @contributeCompId, NULL),
625 (@option_group_id_report , {localize}'{ts escape="sql"}Pledge Summary Report{/ts}'{/localize}, 'pledge/summary', 'CRM_Report_Form_Pledge_Summary', NULL, 0, NULL, 45, {localize}'{ts escape="sql"}Summary of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.{/ts}'{/localize}, 0, 0, 1, @pledgeCompId, NULL),
05c12ce0 626 (@option_group_id_report , '{ts escape="sql"}Contribution Aggregate by Relationship{/ts}', 'contribute/history', 'CRM_Report_Form_Contribute_History', NULL, 0, NULL, 46, '{ts escape="sql"}List contact's donation history, grouped by year, along with contributions attributed to any of the contact's related contacts.{/ts}', 0, 0, 1, @contributeCompId, NULL),
6a488035
TO		 627 (@option_group_id_report, {localize}'{ts escape="sql"}Mail Detail Report{/ts}'{/localize}, 'mailing/detail', 'CRM_Report_Form_Mailing_Detail', NULL, 0, NULL, 47, {localize}'{ts escape="sql"}Provides reporting on Intended and Successful Deliveries, Unsubscribes and Opt-outs, Replies and Forwards.{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
628 (@option_group_id_report, {localize}'{ts escape="sql"}Contribution and Membership Details{/ts}'{/localize}, 'member/contributionDetail', 'CRM_Report_Form_Member_ContributionDetail', NULL, 0, NULL, 48, {localize}'{ts escape="sql"}Contribution details for any type of contribution, plus associated membership information for contributions which are in payment for memberships.{/ts}'{/localize}, 0, 0, 1, @memberCompId, NULL),
c1413e28 629 (@option_group_id_report, {localize}'{ts escape="sql"}Recurring Contributions Report{/ts}'{/localize}, 'contribute/recur', 'CRM_Report_Form_Contribute_Recur', NULL, 0, NULL, 49, {localize}'{ts escape="sql"}Provides information about the status of recurring contributions{/ts}'{/localize}, 0, 0, 1, @contributeCompId, NULL),
6a488035
TO		 630
631 (@option_group_id_acs, '{ts escape="sql"}Scheduled{/ts}', 1, 'Scheduled', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
632 (@option_group_id_acs, '{ts escape="sql"}Completed{/ts}', 2, 'Completed', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
633 (@option_group_id_acs, '{ts escape="sql"}Cancelled{/ts}', 3, 'Cancelled', NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL),
634 (@option_group_id_acs, '{ts escape="sql"}Left Message{/ts}', 4, 'Left Message', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
635 (@option_group_id_acs, '{ts escape="sql"}Unreachable{/ts}', 5, 'Unreachable', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
636 (@option_group_id_acs, '{ts escape="sql"}Not Required{/ts}', 6, 'Not Required', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
187e382a 637 (@option_group_id_acs, '{ts escape="sql"}Available{/ts}', 7, 'Available', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
5b8e40ab 638 (@option_group_id_acs, '{ts escape="sql"}No-show{/ts}', 8, 'No_show', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 639
640 (@option_group_id_cas, '{ts escape="sql"}Ongoing{/ts}' , 1, 'Open' , 'Opened', 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
641 (@option_group_id_cas, '{ts escape="sql"}Resolved{/ts}', 2, 'Closed', 'Closed', 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
642 (@option_group_id_cas, '{ts escape="sql"}Urgent{/ts}' , 3, 'Urgent', 'Opened', 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
643
644 (@option_group_id_pl, '{ts escape="sql"}Name Only{/ts}' , 1, 'Name Only' , NULL, 0, 0, 1, 'CRM_Event_Page_ParticipantListing_Name', 0, 1, 1, NULL, NULL),
645 (@option_group_id_pl, '{ts escape="sql"}Name and Email{/ts}', 2, 'Name and Email' , NULL, 0, 0, 2, 'CRM_Event_Page_ParticipantListing_NameAndEmail', 0, 1, 1, NULL, NULL),
646 (@option_group_id_pl, '{ts escape="sql"}Name, Status and Register Date{/ts}' , 3, 'Name, Status and Register Date', NULL, 0, 0, 3, 'CRM_Event_Page_ParticipantListing_NameStatusAndDate', 0, 1, 1, NULL, NULL),
647
648 (@option_group_id_sfe, 'jpg' , 1, NULL , NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL),
649 (@option_group_id_sfe, 'jpeg' , 2, NULL , NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL),
650 (@option_group_id_sfe, 'png' , 3, NULL , NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL),
651 (@option_group_id_sfe, 'gif' , 4, NULL , NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL),
652 (@option_group_id_sfe, 'txt' , 5, NULL , NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL),
653 (@option_group_id_sfe, 'pdf' , 6, NULL , NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL),
654 (@option_group_id_sfe, 'doc' , 7, NULL , NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL),
655 (@option_group_id_sfe, 'xls' , 8, NULL , NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL),
656 (@option_group_id_sfe, 'rtf' , 9, NULL , NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL),
657 (@option_group_id_sfe, 'csv' , 10, NULL , NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL),
658 (@option_group_id_sfe, 'ppt' , 11, NULL , NULL, 0, 0, 11, NULL, 0, 0, 1, NULL, NULL),
659 (@option_group_id_sfe, 'docx' , 12, NULL , NULL, 0, 0, 12, NULL, 0, 0, 1, NULL, NULL),
660 (@option_group_id_sfe, 'xlsx' , 13, NULL , NULL, 0, 0, 13, NULL, 0, 0, 1, NULL, NULL),
661
662
663 (@option_group_id_we, 'TinyMCE' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
664 (@option_group_id_we, 'CKEditor' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
665 (@option_group_id_we, 'Joomla Default Editor' , 3, NULL, NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL),
666 (@option_group_id_we, 'Drupal Default Editor', 4, NULL, NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL, NULL),
667
668 (@option_group_id_mt, '{ts escape="sql"}Search Builder{/ts}', 1, 'Search Builder', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL),
669 (@option_group_id_mt, '{ts escape="sql"}Import Contact{/ts}', 2, 'Import Contact', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL),
670 (@option_group_id_mt, '{ts escape="sql"}Import Activity{/ts}', 3, 'Import Activity', NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL),
671 (@option_group_id_mt, '{ts escape="sql"}Import Contribution{/ts}', 4, 'Import Contribution', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL),
672 (@option_group_id_mt, '{ts escape="sql"}Import Membership{/ts}', 5, 'Import Membership', NULL, 0, 0, 5, NULL, 0, 1, 1, NULL, NULL),
673 (@option_group_id_mt, '{ts escape="sql"}Import Participant{/ts}', 6, 'Import Participant', NULL, 0, 0, 6, NULL, 0, 1, 1, NULL, NULL),
674 (@option_group_id_mt, '{ts escape="sql"}Export Contact{/ts}', 7, 'Export Contact', NULL, 0, 0, 7, NULL, 0, 1, 1, NULL, NULL),
675 (@option_group_id_mt, '{ts escape="sql"}Export Contribution{/ts}', 8, 'Export Contribution', NULL, 0, 0, 8, NULL, 0, 1, 1, NULL, NULL),
676 (@option_group_id_mt, '{ts escape="sql"}Export Membership{/ts}', 9, 'Export Membership', NULL, 0, 0, 9, NULL, 0, 1, 1, NULL, NULL),
677 (@option_group_id_mt, '{ts escape="sql"}Export Participant{/ts}', 10, 'Export Participant', NULL, 0, 0, 10, NULL, 0, 1, 1, NULL, NULL),
678 (@option_group_id_mt, '{ts escape="sql"}Export Pledge{/ts}', 11, 'Export Pledge', NULL, 0, 0, 11, NULL, 0, 1, 1, NULL, NULL),
679 (@option_group_id_mt, '{ts escape="sql"}Export Case{/ts}', 12, 'Export Case', NULL, 0, 0, 12, NULL, 0, 1, 1, NULL, NULL),
680 (@option_group_id_mt, '{ts escape="sql"}Export Grant{/ts}', 13, 'Export Grant', NULL, 0, 0, 13, NULL, 0, 1, 1, NULL, NULL),
681 (@option_group_id_mt, '{ts escape="sql"}Export Activity{/ts}', 14, 'Export Activity', NULL, 0, 0, 14, NULL, 0, 1, 1, NULL, NULL),
682
683 (@option_group_id_fu, '{ts escape="sql"}day{/ts}' , 'day' , 'day', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
684 (@option_group_id_fu, '{ts escape="sql"}week{/ts}' , 'week' , 'week', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
685 (@option_group_id_fu, '{ts escape="sql"}month{/ts}' , 'month', 'month', NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL),
686 (@option_group_id_fu, '{ts escape="sql"}year{/ts}' , 'year' , 'year', NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL, NULL),
687
688-- phone types.
689 (@option_group_id_pht, '{ts escape="sql"}Phone{/ts}' , 1, 'Phone' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
690 (@option_group_id_pht, '{ts escape="sql"}Mobile{/ts}', 2, 'Mobile' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
691 (@option_group_id_pht, '{ts escape="sql"}Fax{/ts}' , 3, 'Fax' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
692 (@option_group_id_pht, '{ts escape="sql"}Pager{/ts}' , 4, 'Pager' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
693 (@option_group_id_pht, '{ts escape="sql"}Voicemail{/ts}' , 5, 'Voicemail' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
694
695-- custom data types.
696 (@option_group_id_cdt, 'Participant Role', '1', 'ParticipantRole', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ),
697 (@option_group_id_cdt, 'Participant Event Name', '2', 'ParticipantEventName', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ),
698 (@option_group_id_cdt, 'Participant Event Type', '3', 'ParticipantEventType', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ),
699
700-- visibility.
701 (@option_group_id_vis, 'Public', 1, 'public', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ),
702 (@option_group_id_vis, 'Admin', 2, 'admin', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ),
703
704-- mail protocol.
705 (@option_group_id_mp, 'IMAP', 1, 'IMAP', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ),
706 (@option_group_id_mp, 'Maildir', 2, 'Maildir', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ),
707 (@option_group_id_mp, 'POP3', 3, 'POP3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ),
708 (@option_group_id_mp, 'Localdir', 4, 'Localdir', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL ),
709
710-- priority
711 (@option_group_id_priority, '{ts escape="sql"}Urgent{/ts}', 1, 'Urgent', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
712 (@option_group_id_priority, '{ts escape="sql"}Normal{/ts}', 2, 'Normal', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
713 (@option_group_id_priority, '{ts escape="sql"}Low{/ts}', 3, 'Low', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
714
715-- redaction rule
716 (@option_group_id_rr, 'Vancouver', 'city_', NULL, NULL, 0, NULL, 1, NULL, 0, 0, 0, NULL, NULL),
717 (@option_group_id_rr, '{literal}/(19|20)(\\d{2})-(\\d{1,2})-(\\d{1,2})/{/literal}', 'date_', NULL, NULL, 1, NULL, 2, NULL, 0, 0, 0, NULL, NULL),
718
719-- email greeting.
720 (@option_group_id_emailGreeting, '{literal}Dear {contact.first_name}{/literal}', 1, '{literal}Dear {contact.first_name}{/literal}', NULL, 1, 1, 1, NULL, 0, 0, 1, NULL, NULL),
721 (@option_group_id_emailGreeting, '{literal}Dear {contact.individual_prefix} {contact.first_name} {contact.last_name}{/literal}', 2, '{literal}Dear {contact.individual_prefix} {contact.first_name} {contact.last_name}{/literal}', NULL, 1, 0, 2, NULL, 0, 0, 1, NULL, NULL),
722 (@option_group_id_emailGreeting, '{literal}Dear {contact.individual_prefix} {contact.last_name}{/literal}', 3, '{literal}Dear {contact.individual_prefix} {contact.last_name}{/literal}', NULL, 1, 0, 3, NULL, 0, 0, 1, NULL, NULL),
723 (@option_group_id_emailGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL),
548dc5ed 724 (@option_group_id_emailGreeting, '{literal}Dear {contact.household_name}{/literal}', 5, '{literal}Dear {contact.household_name}{/literal}', NULL, 2, 1, 5, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 725-- postal greeting.
726 (@option_group_id_postalGreeting, '{literal}Dear {contact.first_name}{/literal}', 1, '{literal}Dear {contact.first_name}{/literal}', NULL, 1, 1, 1, NULL, 0, 0, 1, NULL, NULL),
727 (@option_group_id_postalGreeting, '{literal}Dear {contact.individual_prefix} {contact.first_name} {contact.last_name}{/literal}', 2, '{literal}Dear {contact.individual_prefix} {contact.first_name} {contact.last_name}{/literal}', NULL, 1, 0, 2, NULL, 0, 0, 1, NULL, NULL),
728 (@option_group_id_postalGreeting, '{literal}Dear {contact.individual_prefix} {contact.last_name}{/literal}', 3, '{literal}Dear {contact.individual_prefix} {contact.last_name}{/literal}', NULL, 1, 0, 3, NULL, 0, 0, 1, NULL, NULL),
729 (@option_group_id_postalGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL),
548dc5ed 730 (@option_group_id_postalGreeting, '{literal}Dear {contact.household_name}{/literal}', 5, '{literal}Dear {contact.household_name}{/literal}', NULL, 2, 1, 5, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 731
732-- addressee
733 (@option_group_id_addressee, '{literal}{contact.individual_prefix}{ } {contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.individual_suffix}{/literal}', '1', '{literal}}{contact.individual_prefix}{ } {contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.individual_suffix}{/literal}', NULL , '1', '1', '1', NULL , '0', '0', '1', NULL , NULL),
734 (@option_group_id_addressee, '{literal}{contact.household_name}{/literal}', '2', '{literal}{contact.household_name}{/literal}', NULL , '2', '1', '2', NULL , '0', '0', '1', NULL , NULL),
735 (@option_group_id_addressee, '{literal}{contact.organization_name}{/literal}', '3', '{literal}{contact.organization_name}{/literal}', NULL , '3', '1', '3', NULL , '0', '0', '1', NULL , NULL),
736 (@option_group_id_addressee, '{literal}Customized{/literal}', '4', '{literal}Customized{/literal}', NULL , 0 , '0', '4', NULL , '0', '1', '1', NULL , NULL),
737
6a488035 738-- website type
887e764d
PN		 739 (@option_group_id_website, 'Work', 1, 'Work', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
740 (@option_group_id_website, 'Main', 2, 'Main', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
6a488035 741 (@option_group_id_website, 'Facebook', 3, 'Facebook', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
887e764d
PN		 742 (@option_group_id_website, 'Google+', 4, 'Google_', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
743 (@option_group_id_website, 'Instagram', 5, 'Instagram', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
744 (@option_group_id_website, 'LinkedIn', 6, 'LinkedIn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
745 (@option_group_id_website, 'MySpace', 7, 'MySpace', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
746 (@option_group_id_website, 'Pinterest', 8, 'Pinterest', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
747 (@option_group_id_website, 'SnapChat', 9, 'SnapChat', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
748 (@option_group_id_website, 'Tumblr', 10, 'Tumblr', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
749 (@option_group_id_website, 'Twitter', 11, 'Twitter', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
750 (@option_group_id_website, 'Vine', 12, 'Vine ', NULL, 0, NULL, 12, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 751
752-- Tag used for
753 (@option_group_id_tuf, 'Contacts', 'civicrm_contact', 'Contacts', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
754 (@option_group_id_tuf, 'Activities', 'civicrm_activity', 'Activities', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
755 (@option_group_id_tuf, 'Cases', 'civicrm_case', 'Cases', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
756 (@option_group_id_tuf, 'Attachments','civicrm_file', 'Attachements', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
757
758 (@option_group_id_currency, 'USD ($)', 'USD', 'USD', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
759
760-- event name badges
761 (@option_group_id_eventBadge, '{ts escape="sql"}Name Only{/ts}' , 1, 'CRM_Event_Badge_Simple' , NULL, 0, 0, 1, '{ts escape="sql"}Simple Event Name Badge{/ts}', 0, 1, 1, NULL, NULL),
762 (@option_group_id_eventBadge, '{ts escape="sql"}Name Tent{/ts}' , 2, 'CRM_Event_Badge_NameTent', NULL, 0, 0, 2, '{ts escape="sql"}Name Tent{/ts}', 0, 1, 1, NULL, NULL),
763 (@option_group_id_eventBadge , '{ts escape="sql"}With Logo{/ts}' , 3, 'CRM_Event_Badge_Logo' , NULL, 0, 0, 3, '{ts escape="sql"}You can set your own background image{/ts}', 0, 1, 1, NULL, NULL ),
764 (@option_group_id_eventBadge , '{ts escape="sql"}5395 with Logo{/ts}', 4, 'CRM_Event_Badge_Logo5395', NULL, 0, 0, 4, '{ts escape="sql"}Avery 5395 compatible labels with logo (4 up by 2, 59.2mm x 85.7mm){/ts}', 0, 1, 1, NULL, NULL ),
765
766-- note privacy levels
767 (@option_group_id_notePrivacy, '{ts escape="sql"}None{/ts}' , 0, '', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
768 (@option_group_id_notePrivacy, '{ts escape="sql"}Author Only{/ts}' , 1, '', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL),
769
770-- Compaign Types
771 (@option_group_id_campaignType, '{ts escape="sql"}Direct Mail{/ts}', 1, 'Direct Mail', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
772 (@option_group_id_campaignType, '{ts escape="sql"}Referral Program{/ts}', 2, 'Referral Program', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
773 (@option_group_id_campaignType, '{ts escape="sql"}Constituent Engagement{/ts}', 3, 'Constituent Engagement', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
774
775-- Campaign Status
776 (@option_group_id_campaignStatus, '{ts escape="sql"}Planned{/ts}', 1, 'Planned', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
777 (@option_group_id_campaignStatus, '{ts escape="sql"}In Progress{/ts}', 2, 'In Progress', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
778 (@option_group_id_campaignStatus, '{ts escape="sql"}Completed{/ts}', 3, 'Completed', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
779 (@option_group_id_campaignStatus, '{ts escape="sql"}Cancelled{/ts}', 4, 'Cancelled', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
780
781-- Engagement Level
782 (@option_group_id_engagement_index, '{ts escape="sql"}1{/ts}', 1, '1', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ),
783 (@option_group_id_engagement_index, '{ts escape="sql"}2{/ts}', 2, '2', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ),
784 (@option_group_id_engagement_index, '{ts escape="sql"}3{/ts}', 3, '3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ),
785 (@option_group_id_engagement_index, '{ts escape="sql"}4{/ts}', 4, '4', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL ),
786 (@option_group_id_engagement_index, '{ts escape="sql"}5{/ts}', 5, '5', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL ),
787
788-- Paper Sizes
789 (@option_group_id_paperSize, '{ts escape="sql"}Letter{/ts}', '{literal}{"metric":"in","width":8.5,"height":11}{/literal}', 'letter', NULL, NULL, 1, 1, NULL, 0, 0, 1, NULL, NULL),
790 (@option_group_id_paperSize, '{ts escape="sql"}Legal{/ts}', '{literal}{"metric":"in","width":8.5,"height":14}{/literal}', 'legal', NULL, NULL, 0, 2, NULL, 0, 0, 1, NULL, NULL),
791 (@option_group_id_paperSize, '{ts escape="sql"}Ledger{/ts}', '{literal}{"metric":"in","width":17,"height":11}{/literal}', 'ledger', NULL, NULL, 0, 3, NULL, 0, 0, 1, NULL, NULL),
792 (@option_group_id_paperSize, '{ts escape="sql"}Tabloid{/ts}', '{literal}{"metric":"in","width":11,"height":17}{/literal}', 'tabloid', NULL, NULL, 0, 4, NULL, 0, 0, 1, NULL, NULL),
793 (@option_group_id_paperSize, '{ts escape="sql"}Executive{/ts}', '{literal}{"metric":"in","width":7.25,"height":10.5}{/literal}', 'executive', NULL, NULL, 0, 5, NULL, 0, 0, 1, NULL, NULL),
794 (@option_group_id_paperSize, '{ts escape="sql"}Folio{/ts}', '{literal}{"metric":"in","width":8.5,"height":13}{/literal}', 'folio', NULL, NULL, 0, 6, NULL, 0, 0, 1, NULL, NULL),
795 (@option_group_id_paperSize, '{ts escape="sql"}Envelope #9{/ts}', '{literal}{"metric":"pt","width":638.93,"height":278.93}{/literal}', 'envelope-9', NULL, NULL, 0, 7, NULL, 0, 0, 1, NULL, NULL),
796 (@option_group_id_paperSize, '{ts escape="sql"}Envelope #10{/ts}', '{literal}{"metric":"pt","width":684,"height":297}{/literal}', 'envelope-10', NULL, NULL, 0, 8, NULL, 0, 0, 1, NULL, NULL),
797 (@option_group_id_paperSize, '{ts escape="sql"}Envelope #11{/ts}', '{literal}{"metric":"pt","width":747,"height":324}{/literal}', 'envelope-11', NULL, NULL, 0, 9, NULL, 0, 0, 1, NULL, NULL),
798 (@option_group_id_paperSize, '{ts escape="sql"}Envelope #12{/ts}', '{literal}{"metric":"pt","width":792,"height":342}{/literal}', 'envelope-12', NULL, NULL, 0, 10, NULL, 0, 0, 1, NULL, NULL),
799 (@option_group_id_paperSize, '{ts escape="sql"}Envelope #14{/ts}', '{literal}{"metric":"pt","width":828,"height":360}{/literal}', 'envelope-14', NULL, NULL, 0, 11, NULL, 0, 0, 1, NULL, NULL),
800 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B4{/ts}', '{literal}{"metric":"pt","width":1000.63,"height":708.66}{/literal}', 'envelope-b4', NULL, NULL, 0, 12, NULL, 0, 0, 1, NULL, NULL),
801 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B5{/ts}', '{literal}{"metric":"pt","width":708.66,"height":498.9}{/literal}', 'envelope-b5', NULL, NULL, 0, 13, NULL, 0, 0, 1, NULL, NULL),
802 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO B6{/ts}', '{literal}{"metric":"pt","width":498.9,"height":354.33}{/literal}', 'envelope-b6', NULL, NULL, 0, 14, NULL, 0, 0, 1, NULL, NULL),
803 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C3{/ts}', '{literal}{"metric":"pt","width":1298.27,"height":918.42}{/literal}', 'envelope-c3', NULL, NULL, 0, 15, NULL, 0, 0, 1, NULL, NULL),
804 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C4{/ts}', '{literal}{"metric":"pt","width":918.42,"height":649.13}{/literal}', 'envelope-c4', NULL, NULL, 0, 16, NULL, 0, 0, 1, NULL, NULL),
805 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C5{/ts}', '{literal}{"metric":"pt","width":649.13,"height":459.21}{/literal}', 'envelope-c5', NULL, NULL, 0, 17, NULL, 0, 0, 1, NULL, NULL),
806 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO C6{/ts}', '{literal}{"metric":"pt","width":459.21,"height":323.15}{/literal}', 'envelope-c6', NULL, NULL, 0, 18, NULL, 0, 0, 1, NULL, NULL),
807 (@option_group_id_paperSize, '{ts escape="sql"}Envelope ISO DL{/ts}', '{literal}{"metric":"pt","width":623.622,"height":311.811}{/literal}', 'envelope-dl', NULL, NULL, 0, 19, NULL, 0, 0, 1, NULL, NULL),
808 (@option_group_id_paperSize, '{ts escape="sql"}ISO A0{/ts}', '{literal}{"metric":"pt","width":2383.94,"height":3370.39}{/literal}', 'a0', NULL, NULL, 0, 20, NULL, 0, 0, 1, NULL, NULL),
809 (@option_group_id_paperSize, '{ts escape="sql"}ISO A1{/ts}', '{literal}{"metric":"pt","width":1683.78,"height":2383.94}{/literal}', 'a1', NULL, NULL, 0, 21, NULL, 0, 0, 1, NULL, NULL),
810 (@option_group_id_paperSize, '{ts escape="sql"}ISO A2{/ts}', '{literal}{"metric":"pt","width":1190.55,"height":1683.78}{/literal}', 'a2', NULL, NULL, 0, 22, NULL, 0, 0, 1, NULL, NULL),
811 (@option_group_id_paperSize, '{ts escape="sql"}ISO A3{/ts}', '{literal}{"metric":"pt","width":841.89,"height":1190.55}{/literal}', 'a3', NULL, NULL, 0, 23, NULL, 0, 0, 1, NULL, NULL),
812 (@option_group_id_paperSize, '{ts escape="sql"}ISO A4{/ts}', '{literal}{"metric":"pt","width":595.28,"height":841.89}{/literal}', 'a4', NULL, NULL, 0, 24, NULL, 0, 0, 1, NULL, NULL),
813 (@option_group_id_paperSize, '{ts escape="sql"}ISO A5{/ts}', '{literal}{"metric":"pt","width":419.53,"height":595.28}{/literal}', 'a5', NULL, NULL, 0, 25, NULL, 0, 0, 1, NULL, NULL),
814 (@option_group_id_paperSize, '{ts escape="sql"}ISO A6{/ts}', '{literal}{"metric":"pt","width":297.64,"height":419.53}{/literal}', 'a6', NULL, NULL, 0, 26, NULL, 0, 0, 1, NULL, NULL),
815 (@option_group_id_paperSize, '{ts escape="sql"}ISO A7{/ts}', '{literal}{"metric":"pt","width":209.76,"height":297.64}{/literal}', 'a7', NULL, NULL, 0, 27, NULL, 0, 0, 1, NULL, NULL),
816 (@option_group_id_paperSize, '{ts escape="sql"}ISO A8{/ts}', '{literal}{"metric":"pt","width":147.4,"height":209.76}{/literal}', 'a8', NULL, NULL, 0, 28, NULL, 0, 0, 1, NULL, NULL),
817 (@option_group_id_paperSize, '{ts escape="sql"}ISO A9{/ts}', '{literal}{"metric":"pt","width":104.88,"height":147.4}{/literal}', 'a9', NULL, NULL, 0, 29, NULL, 0, 0, 1, NULL, NULL),
818 (@option_group_id_paperSize, '{ts escape="sql"}ISO A10{/ts}', '{literal}{"metric":"pt","width":73.7,"height":104.88}{/literal}', 'a10', NULL, NULL, 0, 30, NULL, 0, 0, 1, NULL, NULL),
819 (@option_group_id_paperSize, '{ts escape="sql"}ISO B0{/ts}', '{literal}{"metric":"pt","width":2834.65,"height":4008.19}{/literal}', 'b0', NULL, NULL, 0, 31, NULL, 0, 0, 1, NULL, NULL),
820 (@option_group_id_paperSize, '{ts escape="sql"}ISO B1{/ts}', '{literal}{"metric":"pt","width":2004.09,"height":2834.65}{/literal}', 'b1', NULL, NULL, 0, 32, NULL, 0, 0, 1, NULL, NULL),
821 (@option_group_id_paperSize, '{ts escape="sql"}ISO B2{/ts}', '{literal}{"metric":"pt","width":1417.32,"height":2004.09}{/literal}', 'b2', NULL, NULL, 0, 33, NULL, 0, 0, 1, NULL, NULL),
822 (@option_group_id_paperSize, '{ts escape="sql"}ISO B3{/ts}', '{literal}{"metric":"pt","width":1000.63,"height":1417.32}{/literal}', 'b3', NULL, NULL, 0, 34, NULL, 0, 0, 1, NULL, NULL),
823 (@option_group_id_paperSize, '{ts escape="sql"}ISO B4{/ts}', '{literal}{"metric":"pt","width":708.66,"height":1000.63}{/literal}', 'b4', NULL, NULL, 0, 35, NULL, 0, 0, 1, NULL, NULL),
824 (@option_group_id_paperSize, '{ts escape="sql"}ISO B5{/ts}', '{literal}{"metric":"pt","width":498.9,"height":708.66}{/literal}', 'b5', NULL, NULL, 0, 36, NULL, 0, 0, 1, NULL, NULL),
825 (@option_group_id_paperSize, '{ts escape="sql"}ISO B6{/ts}', '{literal}{"metric":"pt","width":354.33,"height":498.9}{/literal}', 'b6', NULL, NULL, 0, 37, NULL, 0, 0, 1, NULL, NULL),
826 (@option_group_id_paperSize, '{ts escape="sql"}ISO B7{/ts}', '{literal}{"metric":"pt","width":249.45,"height":354.33}{/literal}', 'b7', NULL, NULL, 0, 38, NULL, 0, 0, 1, NULL, NULL),
827 (@option_group_id_paperSize, '{ts escape="sql"}ISO B8{/ts}', '{literal}{"metric":"pt","width":175.75,"height":249.45}{/literal}', 'b8', NULL, NULL, 0, 39, NULL, 0, 0, 1, NULL, NULL),
828 (@option_group_id_paperSize, '{ts escape="sql"}ISO B9{/ts}', '{literal}{"metric":"pt","width":124.72,"height":175.75}{/literal}', 'b9', NULL, NULL, 0, 40, NULL, 0, 0, 1, NULL, NULL),
829 (@option_group_id_paperSize, '{ts escape="sql"}ISO B10{/ts}', '{literal}{"metric":"pt","width":87.87,"height":124.72}{/literal}', 'b10', NULL, NULL, 0, 41, NULL, 0, 0, 1, NULL, NULL),
830 (@option_group_id_paperSize, '{ts escape="sql"}ISO C0{/ts}', '{literal}{"metric":"pt","width":2599.37,"height":3676.54}{/literal}', 'c0', NULL, NULL, 0, 42, NULL, 0, 0, 1, NULL, NULL),
831 (@option_group_id_paperSize, '{ts escape="sql"}ISO C1{/ts}', '{literal}{"metric":"pt","width":1836.85,"height":2599.37}{/literal}', 'c1', NULL, NULL, 0, 43, NULL, 0, 0, 1, NULL, NULL),
832 (@option_group_id_paperSize, '{ts escape="sql"}ISO C2{/ts}', '{literal}{"metric":"pt","width":1298.27,"height":1836.85}{/literal}', 'c2', NULL, NULL, 0, 44, NULL, 0, 0, 1, NULL, NULL),
833 (@option_group_id_paperSize, '{ts escape="sql"}ISO C3{/ts}', '{literal}{"metric":"pt","width":918.43,"height":1298.27}{/literal}', 'c3', NULL, NULL, 0, 45, NULL, 0, 0, 1, NULL, NULL),
834 (@option_group_id_paperSize, '{ts escape="sql"}ISO C4{/ts}', '{literal}{"metric":"pt","width":649.13,"height":918.43}{/literal}', 'c4', NULL, NULL, 0, 46, NULL, 0, 0, 1, NULL, NULL),
835 (@option_group_id_paperSize, '{ts escape="sql"}ISO C5{/ts}', '{literal}{"metric":"pt","width":459.21,"height":649.13}{/literal}', 'c5', NULL, NULL, 0, 47, NULL, 0, 0, 1, NULL, NULL),
836 (@option_group_id_paperSize, '{ts escape="sql"}ISO C6{/ts}', '{literal}{"metric":"pt","width":323.15,"height":459.21}{/literal}', 'c6', NULL, NULL, 0, 48, NULL, 0, 0, 1, NULL, NULL),
837 (@option_group_id_paperSize, '{ts escape="sql"}ISO C7{/ts}', '{literal}{"metric":"pt","width":229.61,"height":323.15}{/literal}', 'c7', NULL, NULL, 0, 49, NULL, 0, 0, 1, NULL, NULL),
838 (@option_group_id_paperSize, '{ts escape="sql"}ISO C8{/ts}', '{literal}{"metric":"pt","width":161.57,"height":229.61}{/literal}', 'c8', NULL, NULL, 0, 50, NULL, 0, 0, 1, NULL, NULL),
839 (@option_group_id_paperSize, '{ts escape="sql"}ISO C9{/ts}', '{literal}{"metric":"pt","width":113.39,"height":161.57}{/literal}', 'c9', NULL, NULL, 0, 51, NULL, 0, 0, 1, NULL, NULL),
840 (@option_group_id_paperSize, '{ts escape="sql"}ISO C10{/ts}', '{literal}{"metric":"pt","width":79.37,"height":113.39}{/literal}', 'c10', NULL, NULL, 0, 52, NULL, 0, 0, 1, NULL, NULL),
841 (@option_group_id_paperSize, '{ts escape="sql"}ISO RA0{/ts}', '{literal}{"metric":"pt","width":2437.8,"height":3458.27}{/literal}', 'ra0', NULL, NULL, 0, 53, NULL, 0, 0, 1, NULL, NULL),
842 (@option_group_id_paperSize, '{ts escape="sql"}ISO RA1{/ts}', '{literal}{"metric":"pt","width":1729.13,"height":2437.8}{/literal}', 'ra1', NULL, NULL, 0, 54, NULL, 0, 0, 1, NULL, NULL),
843 (@option_group_id_paperSize, '{ts escape="sql"}ISO RA2{/ts}', '{literal}{"metric":"pt","width":1218.9,"height":1729.13}{/literal}', 'ra2', NULL, NULL, 0, 55, NULL, 0, 0, 1, NULL, NULL),
844 (@option_group_id_paperSize, '{ts escape="sql"}ISO RA3{/ts}', '{literal}{"metric":"pt","width":864.57,"height":1218.9}{/literal}', 'ra3', NULL, NULL, 0, 56, NULL, 0, 0, 1, NULL, NULL),
845 (@option_group_id_paperSize, '{ts escape="sql"}ISO RA4{/ts}', '{literal}{"metric":"pt","width":609.45,"height":864.57}{/literal}', 'ra4', NULL, NULL, 0, 57, NULL, 0, 0, 1, NULL, NULL),
846 (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA0{/ts}', '{literal}{"metric":"pt","width":2551.18,"height":3628.35}{/literal}', 'sra0', NULL, NULL, 0, 58, NULL, 0, 0, 1, NULL, NULL),
847 (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA1{/ts}', '{literal}{"metric":"pt","width":1814.17,"height":2551.18}{/literal}', 'sra1', NULL, NULL, 0, 59, NULL, 0, 0, 1, NULL, NULL),
848 (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA2{/ts}', '{literal}{"metric":"pt","width":1275.59,"height":1814.17}{/literal}', 'sra2', NULL, NULL, 0, 60, NULL, 0, 0, 1, NULL, NULL),
849 (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA3{/ts}', '{literal}{"metric":"pt","width":907.09,"height":1275.59}{/literal}', 'sra3', NULL, NULL, 0, 61, NULL, 0, 0, 1, NULL, NULL),
850 (@option_group_id_paperSize, '{ts escape="sql"}ISO SRA4{/ts}', '{literal}{"metric":"pt","width":637.8,"height":907.09}{/literal}', 'sra4', NULL, NULL, 0, 62, NULL, 0, 0, 1, NULL, NULL),
851
852-- activity_contacts
853 (@option_group_id_aco, '{ts escape="sql"}Activity Assignees{/ts}', 1, 'Activity Assignees', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
854 (@option_group_id_aco, '{ts escape="sql"}Activity Source{/ts}', 2, 'Activity Source', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
855 (@option_group_id_aco, '{ts escape="sql"}Activity Targets{/ts}', 3, 'Activity Targets', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
856
857-- financial_account_type
858-- grouping field is specific to Quickbooks for mapping to .iif format
859 (@option_group_id_fat, '{ts escape="sql"}Asset{/ts}', 1, 'Asset', NULL, 0, 0, 1, 'Things you own', 0, 1, 1, 2, NULL),
860 (@option_group_id_fat, '{ts escape="sql"}Liability{/ts}', 2, 'Liability', NULL, 0, 0, 2, 'Things you own, like a grant still to be disbursed', 0, 1, 1, 2, NULL),
861 (@option_group_id_fat, '{ts escape="sql"}Revenue{/ts}', 3, 'Revenue', NULL, 0, 1, 3, 'Income from contributions and sales of tickets and memberships', 0, 1, 1, 2, NULL),
862 (@option_group_id_fat, '{ts escape="sql"}Cost of Sales{/ts}', 4, 'Cost of Sales', NULL, 0, 0, 4, 'Costs incurred to get revenue, e.g. premiums for donations, dinner for a fundraising dinner ticket', 0, 1, 1, 2, NULL),
863 (@option_group_id_fat, '{ts escape="sql"}Expenses{/ts}', 5, 'Expenses', NULL, 0, 0, 5, 'Things that are paid for that are consumable, e.g. grants disbursed', 0, 1, 1, 2, NULL),
864
865-- account_relationship
866 (@option_group_id_arel, '{ts escape="sql"}Income Account is{/ts}', 1, 'Income Account is', NULL, 0, 1, 1, 'Income Account is', 0, 1, 1, 2, NULL),
867 (@option_group_id_arel, '{ts escape="sql"}Credit/Contra Account is{/ts}', 2, 'Credit/Contra Account is', NULL, 0, 0, 2, 'Credit/Contra Account is', 0, 1, 0, 2, NULL),
868 (@option_group_id_arel, '{ts escape="sql"}Accounts Receivable Account is{/ts}', 3, 'Accounts Receivable Account is', NULL, 0, 0, 3, 'Accounts Receivable Account is', 0, 1, 1, 2, NULL),
869 (@option_group_id_arel, '{ts escape="sql"}Credit Liability Account is{/ts}', 4, 'Credit Liability Account is', NULL, 0, 0, 4, 'Credit Liability Account is', 0, 1, 0, 2, NULL),
870 (@option_group_id_arel, '{ts escape="sql"}Expense Account is{/ts}', 5, 'Expense Account is', NULL, 0, 0, 5, 'Expense Account is', 0, 1, 1, 2, NULL),
871 (@option_group_id_arel, '{ts escape="sql"}Asset Account is{/ts}', 6, 'Asset Account is', NULL, 0, 0, 6, 'Asset Account is', 0, 1, 1, 2, NULL),
872 (@option_group_id_arel, '{ts escape="sql"}Cost of Sales Account is{/ts}', 7, 'Cost of Sales Account is', NULL, 0, 0, 7, 'Cost of Sales Account is', 0, 1, 1, 2, NULL),
873 (@option_group_id_arel, '{ts escape="sql"}Premiums Inventory Account is{/ts}', 8, 'Premiums Inventory Account is', NULL, 0, 0, 8, 'Premiums Inventory Account is', 0, 1, 1, 2, NULL),
874 (@option_group_id_arel, '{ts escape="sql"}Discounts Account is{/ts}', 9, 'Discounts Account is', NULL, 0, 0, 9, 'Discounts Account is', 0, 1, 1, 2, NULL),
4d6769aa 875 (@option_group_id_arel, '{ts escape="sql"}Sales Tax Account is{/ts}', 10, 'Sales Tax Account is', NULL, 0, 0, 10, 'Sales Tax Account is', 0, 1, 1, 2, NULL),
6a488035
TO		 876
877-- event_contacts
878 (@option_group_id_ere, '{ts escape="sql"}Participant Role{/ts}', 1, 'participant_role', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
879
880-- default conference slots
9b6dda7b
ML		 881 (@option_group_id_conference_slot, '{ts escape="sql"}Morning Sessions{/ts}', 1, 'Morning Sessions', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
882 (@option_group_id_conference_slot, '{ts escape="sql"}Evening Sessions{/ts}', 2, 'Evening Sessions', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
6a488035 883
00f6e1a8 884-- default batch types
9b6dda7b
ML		 885 (@option_group_id_batch_type, '{ts escape="sql"}Contribution{/ts}', 1, 'Contribution', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
886 (@option_group_id_batch_type, '{ts escape="sql"}Membership{/ts}', 2, 'Membership', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
00f6e1a8 887 (@option_group_id_batch_type, '{ts escape="sql"}Pledge Payment{/ts}', 3, 'Pledge Payment', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
9b6dda7b
ML		 888
889-- default batch statuses
890 (@option_group_id_batch_status, '{ts escape="sql"}Open{/ts}', 1, 'Open', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
891 (@option_group_id_batch_status, '{ts escape="sql"}Closed{/ts}', 2, 'Closed', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
892 (@option_group_id_batch_status, '{ts escape="sql"}Data Entry{/ts}', 3, 'Data Entry', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
893 (@option_group_id_batch_status, '{ts escape="sql"}Reopened{/ts}', 4, 'Reopened', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
894 (@option_group_id_batch_status, '{ts escape="sql"}Exported{/ts}', 5, 'Exported', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
6a488035
TO		 895
896-- default batch modes
897 (@option_group_id_batch_mode, '{ts escape="sql"}Manual Batch{/ts}', 1, 'Manual Batch', NULL, 0, 0, 1, 'Manual Batch', 0, 1, 1, 2, NULL),
898 (@option_group_id_batch_mode, '{ts escape="sql"}Automatic Batch{/ts}', 2, 'Automatic Batch', NULL, 0, 0, 2, 'Automatic Batch', 0, 1, 1, 2, NULL),
899
900-- Financial Item Status
901 (@option_group_id_financial_item_status, '{ts escape="sql"}Paid{/ts}', 1, 'Paid', NULL, 0, 0, 1, 'Paid', 0, 1, 1, 2, NULL),
902 (@option_group_id_financial_item_status, '{ts escape="sql"}Partially paid{/ts}', 2, 'Partially paid', NULL, 0, 0, 2, 'Partially paid', 0, 1, 1, 2, NULL),
903 (@option_group_id_financial_item_status, '{ts escape="sql"}Unpaid{/ts}', 3, 'Unpaid', NULL, 0, 0, 1, 'Unpaid', 0, 1, 1, 2, NULL),
904
905-- sms_api_type
906 (@option_group_id_sms_api_type, 'http', 1, 'http', NULL, NULL, 0, 1, NULL, 0, 1, 1, NULL, NULL),
907 (@option_group_id_sms_api_type, 'xml', 2, 'xml', NULL, NULL, 0, 2, NULL, 0, 1, 1, NULL, NULL),
908 (@option_group_id_sms_api_type, 'smtp', 3, 'smtp', NULL, NULL, 0, 3, NULL, 0, 1, 1, NULL, NULL),
909
910-- auto renew options
bcb99132
KJ		 911 (@option_group_id_aro, '{ts escape="sql"}Renewal Reminder (non-auto-renew memberships only){/ts}', 1, 'Renewal Reminder (non-auto-renew memberships only)', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
912 (@option_group_id_aro, '{ts escape="sql"}Auto-renew Memberships Only{/ts}', 2, 'Auto-renew Memberships Only', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
913 (@option_group_id_aro, '{ts escape="sql"}Reminder for Both{/ts}', 3, 'Reminder for Both', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
914
915-- Label Type
916 (@option_group_id_label_type, '{ts escape="sql"}Event Badge{/ts}', 1, 'Event Badge', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
6a488035 917
ab3a115e 918-- Name Label format
71c3b634 919 (@option_group_id_name_badge, '{ts escape="sql"}Avery 5395{/ts}', '{literal}{"name":"Avery 5395","paper-size":"a4","metric":"mm","lMargin":15,"tMargin":26,"NX":2,"NY":4,"SpaceX":10,"SpaceY":5,"width":83,"height":57,"font-size":12,"orientation":"portrait","font-name":"helvetica","font-style":"","lPadding":3,"tPadding":3}{/literal}', 'Avery 5395', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
61aabec4 920 (@option_group_id_name_badge, '{ts escape="sql"}A6 Badge Portrait 150x106{/ts}', '{literal}{"paper-size":"a4","orientation":"landscape","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":1,"metric":"mm","lMargin":25,"tMargin":27,"SpaceX":0,"SpaceY":35,"width":106,"height":150,"lPadding":5,"tPadding":5}{/literal}', 'A6 Badge Portrait 150x106', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
71c3b634 921 (@option_group_id_name_badge, '{ts escape="sql"}Fattorini Name Badge 100x65{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":4,"metric":"mm","lMargin":6,"tMargin":19,"SpaceX":0,"SpaceY":0,"width":100,"height":65,"lPadding":0,"tPadding":0}{/literal}', 'Fattorini Name Badge 100x65', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
82f30429 922 (@option_group_id_name_badge, '{ts escape="sql"}Hanging Badge 3-3/4" x 4-3"/4{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"times","font-size":6,"font-style":"","NX":2,"NY":2,"metric":"mm","lMargin":10,"tMargin":28,"SpaceX":0,"SpaceY":0,"width":96,"height":121,"lPadding":5,"tPadding":5}{/literal}', 'Hanging Badge 3-3/4" x 4-3"/4', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
ab3a115e
KJ		 923
924-- Mailing Label Formats
6a488035
TO		 925 (@option_group_id_label, '{ts escape="sql"}Avery 3475{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":10,"font-style":"","metric":"mm","lMargin":0,"tMargin":5,"NX":3,"NY":8,"SpaceX":0,"SpaceY":0,"width":70,"height":36,"lPadding":5.08,"tPadding":5.08}{/literal}', '3475', 'Avery', NULL, 0, 1, NULL, 0, 1, 1, NULL, NULL),
926 (@option_group_id_label, '{ts escape="sql"}Avery 5160{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":8,"font-style":"","metric":"in","lMargin":0.21975,"tMargin":0.5,"NX":3,"NY":10,"SpaceX":0.14,"SpaceY":0,"width":2.5935,"height":1,"lPadding":0.20,"tPadding":0.20}{/literal}', '5160', 'Avery', NULL, 0, 2, NULL, 0, 1, 1, NULL, NULL),
927 (@option_group_id_label, '{ts escape="sql"}Avery 5161{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":8,"font-style":"","metric":"in","lMargin":0.175,"tMargin":0.5,"NX":2,"NY":10,"SpaceX":0.15625,"SpaceY":0,"width":4,"height":1,"lPadding":0.20,"tPadding":0.20}{/literal}', '5161', 'Avery', NULL, 0, 3, NULL, 0, 1, 1, NULL, NULL),
928 (@option_group_id_label, '{ts escape="sql"}Avery 5162{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":8,"font-style":"","metric":"in","lMargin":0.1525,"tMargin":0.88,"NX":2,"NY":7,"SpaceX":0.195,"SpaceY":0,"width":4,"height":1.33,"lPadding":0.20,"tPadding":0.20}{/literal}', '5162', 'Avery', NULL, 0, 4, NULL, 0, 1, 1, NULL, NULL),
929 (@option_group_id_label, '{ts escape="sql"}Avery 5163{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":8,"font-style":"","metric":"in","lMargin":0.18,"tMargin":0.5,"NX":2,"NY":5,"SpaceX":0.14,"SpaceY":0,"width":4,"height":2,"lPadding":0.20,"tPadding":0.20}{/literal}', '5163', 'Avery', NULL, 0, 5, NULL, 0, 1, 1, NULL, NULL),
930 (@option_group_id_label, '{ts escape="sql"}Avery 5164{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":12,"font-style":"","metric":"in","lMargin":0.156,"tMargin":0.5,"NX":2,"NY":3,"SpaceX":0.1875,"SpaceY":0,"width":4,"height":3.33,"lPadding":0.20,"tPadding":0.20}{/literal}', '5164', 'Avery', NULL, 0, 6, NULL, 0, 1, 1, NULL, NULL),
931 (@option_group_id_label, '{ts escape="sql"}Avery 8600{/ts}', '{literal}{"paper-size":"letter","orientation":"portrait","font-name":"helvetica","font-size":8,"font-style":"","metric":"mm","lMargin":7.1,"tMargin":19,"NX":3,"NY":10,"SpaceX":9.5,"SpaceY":3.1,"width":66.6,"height":25.4,"lPadding":5.08,"tPadding":5.08}{/literal}', '8600', 'Avery', NULL, 0, 7, NULL, 0, 1, 1, NULL, NULL),
932 (@option_group_id_label, '{ts escape="sql"}Avery L7160{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":9,"font-style":"","metric":"in","lMargin":0.28,"tMargin":0.6,"NX":3,"NY":7,"SpaceX":0.1,"SpaceY":0,"width":2.5,"height":1.5,"lPadding":0.20,"tPadding":0.20}{/literal}', 'L7160', 'Avery', NULL, 0, 8, NULL, 0, 1, 1, NULL, NULL),
933 (@option_group_id_label, '{ts escape="sql"}Avery L7161{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":9,"font-style":"","metric":"in","lMargin":0.28,"tMargin":0.35,"NX":3,"NY":6,"SpaceX":0.1,"SpaceY":0,"width":2.5,"height":1.83,"lPadding":0.20,"tPadding":0.20}{/literal}', 'L7161', 'Avery', NULL, 0, 9, NULL, 0, 1, 1, NULL, NULL),
934 (@option_group_id_label, '{ts escape="sql"}Avery L7162{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":9,"font-style":"","metric":"in","lMargin":0.18,"tMargin":0.51,"NX":2,"NY":8,"SpaceX":0.1,"SpaceY":0,"width":3.9,"height":1.33,"lPadding":0.20,"tPadding":0.20}{/literal}', 'L7162', 'Avery', NULL, 0, 10, NULL, 0, 1, 1, NULL, NULL),
aa62b355
OB		 935 (@option_group_id_label, '{ts escape="sql"}Avery L7163{/ts}', '{literal}{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":9,"font-style":"","metric":"in","lMargin":0.18,"tMargin":0.6,"NX":2,"NY":7,"SpaceX":0.1,"SpaceY":0,"width":3.9,"height":1.5,"lPadding":0.20,"tPadding":0.20}{/literal}', 'L7163', 'Avery', NULL, 0, 11, NULL, 0, 1, 1, NULL, NULL),
936
937-- Communication Styles
938 (@option_group_id_communication_style, '{ts escape="sql"}Formal{/ts}' , 1, 'formal' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
a3e3eea1 939 (@option_group_id_communication_style, '{ts escape="sql"}Familiar{/ts}', 2, 'familiar', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL),
940
941-- Message Mode
942(@option_group_id_msg_mode, '{ts escape="sql"}Email{/ts}', 'Email', 'Email', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
943(@option_group_id_msg_mode, '{ts escape="sql"}SMS{/ts}', 'SMS', 'SMS', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL),
3d65c75c
AH		 944(@option_group_id_msg_mode, '{ts escape="sql"}User Preference{/ts}', 'User_Preference', 'User Preference', NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL),
945
946-- Reminder Options for Contact Date Fields
947(@option_group_id_contactDateMode, '{ts escape="sql"}Actual date only{/ts}', '1', 'Actual date only', NULL, NULL, 0, 1, NULL, 0, 1, 1, NULL, NULL),
321121a1 948(@option_group_id_contactDateMode, '{ts escape="sql"}Each anniversary{/ts}', '2', 'Each anniversary', NULL, NULL, 0, 2, NULL, 0, 1, 1, NULL, NULL);
6a488035
TO		 949
950-- financial accounts
951SELECT @opval := value FROM civicrm_option_value WHERE name = 'Revenue' and option_group_id = @option_group_id_fat;
952SELECT @opexp := value FROM civicrm_option_value WHERE name = 'Expenses' and option_group_id = @option_group_id_fat;
953SELECT @opAsset := value FROM civicrm_option_value WHERE name = 'Asset' and option_group_id = @option_group_id_fat;
954SELECT @opLiability := value FROM civicrm_option_value WHERE name = 'Liability' and option_group_id = @option_group_id_fat;
955SELECT @opCost := value FROM civicrm_option_value WHERE name = 'Cost of Sales' and option_group_id = @option_group_id_fat;
956
957INSERT INTO
958 `civicrm_financial_account` (`name`, `contact_id`, `financial_account_type_id`, `description`, `accounting_code`, `account_type_code`, `is_reserved`, `is_active`, `is_deductible`, `is_default`)
959VALUES
ddaa8ef1 960 ( '{ts escape="sql"}Donation{/ts}' , @contactID, @opval, 'Default account for donations', '4200', 'INC', 0, 1, 1, 1 ),
6a488035
TO		 961 ( '{ts escape="sql"}Member Dues{/ts}' , @contactID, @opval, 'Default account for membership sales', '4400', 'INC', 0, 1, 1, 0 ),
962 ( '{ts escape="sql"}Campaign Contribution{/ts}', @contactID, @opval, 'Sample account for recording payments to a campaign', '4100', 'INC', 0, 1, 0, 0 ),
963 ( '{ts escape="sql"}Event Fee{/ts}' , @contactID, @opval, 'Default account for event ticket sales', '4300', 'INC', 0, 1, 0, 0 ),
ddaa8ef1 964 ( '{ts escape="sql"}Banking Fees{/ts}' , @contactID, @opexp, 'Payment processor fees and manually recorded banking fees', '5200', 'EXP', 0, 1, 0, 1 ),
6a488035
TO		 965 ( '{ts escape="sql"}Deposit Bank Account{/ts}' , @contactID, @opAsset, 'All manually recorded cash and cheques go to this account', '1100', 'BANK', 0, 1, 0, 1 ),
966 ( '{ts escape="sql"}Accounts Receivable{/ts}' , @contactID, @opAsset, 'Amounts to be received later (eg pay later event revenues)', '1200', 'AR', 0, 1, 0, 0 ),
ddaa8ef1
PN		 967 ( '{ts escape="sql"}Accounts Payable{/ts}' , @contactID, @opLiability, 'Amounts to be paid out such as grants and refunds', '2200', 'AP', 0, 1, 0, 1 ),
968 ( '{ts escape="sql"}Premiums{/ts}' , @contactID, @opCost, 'Account to record cost of premiums provided to payors', '5100', 'COGS', 0, 1, 0, 1 ),
6a488035
TO		 969 ( '{ts escape="sql"}Premiums inventory{/ts}' , @contactID, @opAsset, 'Account representing value of premiums inventory', '1375', 'OCASSET', 0, 1, 0, 0 ),
970 ( '{ts escape="sql"}Discounts{/ts}' , @contactID, @opval, 'Contra-revenue account for amounts discounted from sales', '4900', 'INC', 0, 1, 0, 0 ),
971 ( '{ts escape="sql"}Payment Processor Account{/ts}', @contactID, @opAsset, 'Account to record payments into a payment processor merchant account', '1150', 'BANK', 0, 1, 0, 0
972);
973
974-- Now insert option values which require domainID
975--
976
977INSERT INTO
978 `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `domain_id`, `visibility_id`)
979VALUES
980-- from email address.
981 (@option_group_id_fma, '"FIXME" <info@EXAMPLE.ORG>', '1', '"FIXME" <info@EXAMPLE.ORG>', NULL, 0, 1, 1, '{ts escape="sql"}Default domain email address and from name.{/ts}', 0, 0, 1, NULL, @domainID, NULL ),
982
983-- grant types
984 (@option_group_id_grantTyp, '{ts escape="sql"}Emergency{/ts}' , 1, 'Emergency' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, @domainID, NULL),
985 (@option_group_id_grantTyp, '{ts escape="sql"}Family Support{/ts}' , 2, 'Family Support' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, @domainID, NULL),
986 (@option_group_id_grantTyp, '{ts escape="sql"}General Protection{/ts}' , 3, 'General Protection', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, @domainID, NULL),
987 (@option_group_id_grantTyp, '{ts escape="sql"}Impunity{/ts}' , 4, 'Impunity' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, @domainID, NULL),
988
6a488035
TO		 989-- Mail Approval Status Preferences
990 (@option_group_id_mail_approval_status, '{ts escape="sql"}Approved{/ts}' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
991 (@option_group_id_mail_approval_status, '{ts escape="sql"}Rejected{/ts}' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
992 (@option_group_id_mail_approval_status, '{ts escape="sql"}None{/ts}' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL),
993
994-- custom group objects
995 (@option_group_id_cgeo, '{ts escape="sql"}Survey{/ts}', 'Survey', 'civicrm_survey', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL, NULL),
996 (@option_group_id_cgeo, '{ts escape="sql"}Cases{/ts}', 'Case', 'civicrm_case', NULL, 0, NULL, 2, 'CRM_Case_PseudoConstant::caseType;', 0, 0, 1, NULL, NULL, NULL);
997
998-- CRM-6138
999{include file='languages.tpl'}
1000
1001-- /*******************************************************
1002-- *
1003-- * Encounter Medium Option Values (for case activities)
1004-- *
1005-- *******************************************************/
1006INSERT INTO `civicrm_option_group` (name, title, description, is_reserved, is_active)
1007 VALUES ('encounter_medium', 'Encounter Medium', 'Encounter medium for case activities (e.g. In Person, By Phone, etc.)', 1, 1);
1008SELECT @option_group_id_medium := max(id) from civicrm_option_group where name = 'encounter_medium';
1009INSERT INTO
1010 `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`)
1011VALUES
1012 (@option_group_id_medium, '{ts escape="sql"}In Person{/ts}', 1, 'in_person', NULL, 0, 0, 1, NULL, 0, 1, 1),
1013 (@option_group_id_medium, '{ts escape="sql"}Phone{/ts}', 2, 'phone', NULL, 0, 1, 2, NULL, 0, 1, 1),
1014 (@option_group_id_medium, '{ts escape="sql"}Email{/ts}', 3, 'email', NULL, 0, 0, 3, NULL, 0, 1, 1),
1015 (@option_group_id_medium, '{ts escape="sql"}Fax{/ts}', 4, 'fax', NULL, 0, 0, 4, NULL, 0, 1, 1),
1016 (@option_group_id_medium, '{ts escape="sql"}Letter Mail{/ts}', 5, 'letter_mail', NULL, 0, 0, 5, NULL, 0, 1, 1);
1017
1018-- sample membership status entries
1019INSERT INTO
1020 civicrm_membership_status(name, label, start_event, start_event_adjust_unit, start_event_adjust_interval, end_event, end_event_adjust_unit, end_event_adjust_interval, is_current_member, is_admin, weight, is_default, is_active, is_reserved)
1021VALUES
1022 ('New', '{ts escape="sql"}New{/ts}', 'join_date', null, null,'join_date','month',3, 1, 0, 1, 0, 1, 0),
1023 ('Current', '{ts escape="sql"}Current{/ts}', 'start_date', null, null,'end_date', null, null, 1, 0, 2, 1, 1, 0),
1024 ('Grace', '{ts escape="sql"}Grace{/ts}', 'end_date', null, null,'end_date','month', 1, 1, 0, 3, 0, 1, 0),
1025 ('Expired', '{ts escape="sql"}Expired{/ts}', 'end_date', 'month', 1, null, null, null, 0, 0, 4, 0, 1, 0),
1026 ('Pending', '{ts escape="sql"}Pending{/ts}', 'join_date', null, null,'join_date',null,null, 0, 0, 5, 0, 1, 1),
c4a02b20 1027 ('Cancelled', '{ts escape="sql"}Cancelled{/ts}', 'join_date', null, null,'join_date',null,null, 0, 0, 6, 0, 1, 1),
6a488035
TO		 1028 ('Deceased', '{ts escape="sql"}Deceased{/ts}', null, null, null, null, null, null, 0, 1, 7, 0, 1, 1);
1029
1030
1031INSERT INTO `civicrm_preferences_date`
1032 (name, start, end, date_format, time_format, description)
1033VALUES
1034 ( 'activityDate' , 20, 10, '', '', 'Date for activities including contributions: receive, receipt, cancel. membership: join, start, renew. case: start, end.' ),
1035 ( 'activityDateTime', 20, 10, '', 1, 'Date and time for activity: scheduled. participant: registered.' ),
1036 ( 'birth' , 100, 0, '', '', 'Birth and deceased dates. Only year, month and day fields are supported.' ),
1037 ( 'creditCard' , 0, 10, 'M Y', '', 'Month and year only for credit card expiration.' ),
1038 ( 'custom' , 20, 20, '', '', 'Uses date range passed in by form field. Can pass in a posix date part parameter. Start and end offsets defined here are ignored.'),
1039 ( 'mailing' , 0, 1, '', '', 'Date and time. Used for scheduling mailings.' ),
1040 ( 'searchDate' , 20, 20, '', '', 'Used in search forms.' );
1041
1042
1043-- various processor options
1044--
1045-- Table structure for table `civicrm_payment_processor_type`
1046--
1047
1048INSERT INTO `civicrm_payment_processor_type`
1049 (name, title, description, is_active, is_default, user_name_label, password_label, signature_label, subject_label, class_name, url_site_default, url_api_default, url_recur_default, url_button_default, url_site_test_default, url_api_test_default, url_recur_test_default, url_button_test_default, billing_mode, is_recur )
1050VALUES
1051 ('PayPal_Standard', '{ts escape="sql"}PayPal - Website Payments Standard{/ts}', NULL,1,0,'{ts escape="sql"}Merchant Account Email{/ts}',NULL,NULL,NULL,'Payment_PayPalImpl','https://www.paypal.com/',NULL,'https://www.paypal.com/',NULL,'https://www.sandbox.paypal.com/',NULL,'https://www.sandbox.paypal.com/',NULL,4,1),
1052 ('PayPal', '{ts escape="sql"}PayPal - Website Payments Pro{/ts}', NULL,1,0,'{ts escape="sql"}User Name{/ts}','{ts escape="sql"}Password{/ts}','{ts escape="sql"}Signature{/ts}',NULL,'Payment_PayPalImpl','https://www.paypal.com/','https://api-3t.paypal.com/','https://www.paypal.com/','https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/','https://api-3t.sandbox.paypal.com/','https://www.sandbox.paypal.com/','https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',3, 1 ),
1053 ('PayPal_Express', '{ts escape="sql"}PayPal - Express{/ts}', NULL,1,0,'{ts escape="sql"}User Name{/ts}','{ts escape="sql"}Password{/ts}','{ts escape="sql"}Signature{/ts}',NULL,'Payment_PayPalImpl','https://www.paypal.com/','https://api-3t.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif','https://www.sandbox.paypal.com/','https://api-3t.sandbox.paypal.com/',NULL,'https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif',2,NULL),
1054 ('Google_Checkout', '{ts escape="sql"}Google Checkout{/ts}', NULL,1,0,'{ts escape="sql"}Merchant ID{/ts}','{ts escape="sql"}Key{/ts}',NULL,NULL,'Payment_Google','https://checkout.google.com/',NULL,'https://checkout.google.com/','https://checkout.google.com/buttons/checkout.gif?merchant_id=YOURMERCHANTIDHERE&w=160&h=43&style=white&variant=text&loc=en_US','https://sandbox.google.com/checkout/',NULL,'https://sandbox.google.com/checkout/','https://sandbox.google.com/checkout/buttons/checkout.gif?merchant_id=YOURMERCHANTIDHERE&w=160&h=43&style=white&variant=text&loc=en_US',4,1),
1055 ('Moneris', '{ts escape="sql"}Moneris{/ts}', NULL,1,0,'{ts escape="sql"}User Name{/ts}','{ts escape="sql"}Password{/ts}','{ts escape="sql"}Store ID{/ts}',NULL,'Payment_Moneris','https://www3.moneris.com/',NULL,NULL,NULL,'https://esqa.moneris.com/',NULL,NULL,NULL,1,1),
1056 ('AuthNet', '{ts escape="sql"}Authorize.Net{/ts}', NULL,1,0,'{ts escape="sql"}API Login{/ts}','{ts escape="sql"}Payment Key{/ts}','{ts escape="sql"}MD5 Hash{/ts}',NULL,'Payment_AuthorizeNet','https://secure.authorize.net/gateway/transact.dll',NULL,'https://api.authorize.net/xml/v1/request.api',NULL,'https://test.authorize.net/gateway/transact.dll',NULL,'https://apitest.authorize.net/xml/v1/request.api',NULL,1,1),
1057 ('PayJunction', '{ts escape="sql"}PayJunction{/ts}', NULL,1,0,'User Name','Password',NULL,NULL,'Payment_PayJunction','https://payjunction.com/quick_link',NULL,NULL,NULL,'https://www.payjunctionlabs.com/quick_link',NULL,NULL,NULL,1,1),
1058 ('eWAY', '{ts escape="sql"}eWAY (Single Currency){/ts}', NULL,1,0,'Customer ID',NULL,NULL,NULL,'Payment_eWAY','https://www.eway.com.au/gateway_cvn/xmlpayment.asp',NULL,NULL,NULL,'https://www.eway.com.au/gateway_cvn/xmltest/testpage.asp',NULL,NULL,NULL,1,0),
1059 ('Payment_Express', '{ts escape="sql"}DPS Payment Express{/ts}', NULL,1,0,'User ID','Key','Mac Key - pxaccess only',NULL,'Payment_PaymentExpress','https://www.paymentexpress.com/pleaseenteraurl',NULL,NULL,NULL,'https://www.paymentexpress.com/pleaseenteratesturl',NULL,NULL,NULL,4,0),
1060 ('Dummy', '{ts escape="sql"}Dummy Payment Processor{/ts}',NULL,1,1,'{ts escape="sql"}User Name{/ts}',NULL,NULL,NULL,'Payment_Dummy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1),
1061 ('Elavon', '{ts escape="sql"}Elavon Payment Processor{/ts}','{ts escape="sql"}Elavon / Nova Virtual Merchant{/ts}',1,0,'{ts escape="sql"}SSL Merchant ID {/ts}','{ts escape="sql"}SSL User ID{/ts}','{ts escape="sql"}SSL PIN{/ts}',NULL,'Payment_Elavon','https://www.myvirtualmerchant.com/VirtualMerchant/processxml.do',NULL,NULL,NULL,'https://www.myvirtualmerchant.com/VirtualMerchant/processxml.do',NULL,NULL,NULL,1,0),
1062 ('Realex', '{ts escape="sql"}Realex Payment{/ts}', NULL,1,0,'Merchant ID', 'Password', NULL, 'Account', 'Payment_Realex', 'https://epage.payandshop.com/epage.cgi', NULL, NULL, NULL, 'https://epage.payandshop.com/epage-remote.cgi', NULL, NULL, NULL, 1, 0 ),
1063 ('PayflowPro', '{ts escape="sql"}PayflowPro{/ts}', NULL,1,0,'Vendor ID', 'Password', 'Partner (merchant)', 'User', 'Payment_PayflowPro', 'https://Payflowpro.paypal.com', NULL, NULL, NULL, 'https://pilot-Payflowpro.paypal.com', NULL, NULL, NULL, 1, 0 ),
1064 ('FirstData', '{ts escape="sql"}FirstData (aka linkpoint){/ts}', '{ts escape="sql"}FirstData (aka linkpoint){/ts}', 1, 0, 'Store name', 'certificate path', NULL, NULL, 'Payment_FirstData', 'https://secure.linkpt.net', NULL, NULL, NULL, 'https://staging.linkpt.net', NULL, NULL, NULL, 1, NULL);
1065
1066
1067-- the fuzzy default dedupe rules
1068-- IndividualSupervised uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualSupervised)
1069INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1070VALUES ('Individual', 20, 'Supervised', 'IndividualSupervised', '{ts escape="sql"}Name and Email (reserved){/ts}', 1);
1071
1072SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1073INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1074VALUES (@drgid, 'civicrm_contact', 'first_name', 5),
1075 (@drgid, 'civicrm_contact', 'last_name', 7),
1076 (@drgid, 'civicrm_email' , 'email', 10);
1077
1078INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1079VALUES ('Organization', 10, 'Supervised', 'OrganizationSupervised', '{ts escape="sql"}Name and Email{/ts}', 0);
1080
1081SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1082INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1083VALUES (@drgid, 'civicrm_contact', 'organization_name', 10),
1084 (@drgid, 'civicrm_email' , 'email', 10);
1085
1086INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1087VALUES ('Household', 10, 'Supervised', 'HouseholdSupervised', '{ts escape="sql"}Name and Email{/ts}', 0);
1088
1089SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1090INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1091VALUES (@drgid, 'civicrm_contact', 'household_name', 10),
1092 (@drgid, 'civicrm_email' , 'email', 10);
1093
1094-- the strict dedupe rules
1095-- IndividualUnsupervised uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualUnsupervised)
1096INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1097VALUES ('Individual', 10, 'Unsupervised', 'IndividualUnsupervised', '{ts escape="sql"}Email (reserved){/ts}', 1);
1098
1099SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1100INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1101VALUES (@drgid, 'civicrm_email', 'email', 10);
1102
1103INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1104VALUES ('Organization', 10, 'Unsupervised', 'OrganizationUnsupervised', '{ts escape="sql"}Name and Email{/ts}', 0);
1105
1106SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1107INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1108VALUES (@drgid, 'civicrm_contact', 'organization_name', 10),
1109 (@drgid, 'civicrm_email' , 'email', 10);
1110
1111INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1112VALUES ('Household', 10, 'Unsupervised', 'HouseholdUnsupervised', '{ts escape="sql"}Name and Email{/ts}', 0);
1113
1114SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1115INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1116VALUES (@drgid, 'civicrm_contact', 'household_name', 10),
1117 (@drgid, 'civicrm_email' , 'email', 10);
1118
1119-- IndividualGeneral uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualGeneral)
1120INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved)
1121VALUES ('Individual', 15, 'General', 'IndividualGeneral', '{ts escape="sql"}Name and Address (reserved){/ts}', 1);
1122
1123SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group;
1124INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight)
1125VALUES (@drgid, 'civicrm_contact', 'first_name', '5'),
1126 (@drgid, 'civicrm_contact', 'last_name', '5'),
1127 (@drgid, 'civicrm_address', 'street_address', '5'),
1128 (@drgid, 'civicrm_contact', 'middle_name', '1'),
1129 (@drgid, 'civicrm_contact', 'suffix_id', '1');
1130
1131-- Sample counties (state-province and country lists defined in a separate tpl files)
1132INSERT INTO civicrm_county (name, state_province_id) VALUES ('Alameda', 1004);
1133INSERT INTO civicrm_county (name, state_province_id) VALUES ('Contra Costa', 1004);
1134INSERT INTO civicrm_county (name, state_province_id) VALUES ('Marin', 1004);
1135INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Francisco', 1004);
1136INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Mateo', 1004);
1137INSERT INTO civicrm_county (name, state_province_id) VALUES ('Santa Clara', 1004);
1138
1139-- Bounce classification patterns
1140INSERT INTO civicrm_mailing_bounce_type
1141 (name, description, hold_threshold)
1142 VALUES ('AOL', '{ts escape="sql"}AOL Terms of Service complaint{/ts}', 1);
1143
1144SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'AOL';
1145INSERT INTO civicrm_mailing_bounce_pattern
1146 (bounce_type_id, pattern)
1147 VALUES
1148 (@bounceTypeID, 'Client TOS Notification');
1149
1150INSERT INTO civicrm_mailing_bounce_type
1151 (name, description, hold_threshold)
1152 VALUES ('Away', '{ts escape="sql"}Recipient is on vacation{/ts}', 30);
1153
1154SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Away';
1155INSERT INTO civicrm_mailing_bounce_pattern
1156 (bounce_type_id, pattern)
1157 VALUES
1158 (@bounceTypeID, '(be|am)? (out of|away from) (the|my)? (office|computer|town)'),
1159 (@bounceTypeID, 'i am on vacation');
1160
1161INSERT INTO civicrm_mailing_bounce_type
1162 (name, description, hold_threshold)
1163 VALUES ('Dns', '{ts escape="sql"}Unable to resolve recipient domain{/ts}', 3);
1164
1165SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns';
1166INSERT INTO civicrm_mailing_bounce_pattern
1167 (bounce_type_id, pattern)
1168 VALUES
1169 (@bounceTypeID, 'name(server entry| lookup failure)'),
1170 (@bounceTypeID, 'no (mail server|matches to nameserver query|dns entries)'),
f29cfa44
DL		 1171 (@bounceTypeID, 'reverse dns entry'),
1172 (@bounceTypeID, 'Host or domain name not found');
6a488035
TO		 1173
1174INSERT INTO civicrm_mailing_bounce_type
1175 (name, description, hold_threshold)
1176 VALUES ('Host', '{ts escape="sql"}Unable to deliver to destintation mail server{/ts}', 3);
1177
1178SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host';
1179INSERT INTO civicrm_mailing_bounce_pattern
1180 (bounce_type_id, pattern)
1181 VALUES
1182 (@bounceTypeID, '(unknown|not local) host'),
1183 (@bounceTypeID, 'all hosts have been failing'),
1184 (@bounceTypeID, 'allowed rcpthosts'),
1185 (@bounceTypeID, 'connection (refused|timed out)'),
1186 (@bounceTypeID, 'not connected'),
1187 (@bounceTypeID, 'couldn\'t find any host named'),
1188 (@bounceTypeID, 'error involving remote host'),
1189 (@bounceTypeID, 'host unknown'),
1190 (@bounceTypeID, 'invalid host name'),
1191 (@bounceTypeID, 'isn\'t in my control/locals file'),
1192 (@bounceTypeID, 'local configuration error'),
1193 (@bounceTypeID, 'not a gateway'),
4b701e6b 1194 (@bounceTypeID, 'server is (down or unreachable|not responding)'),
6a488035 1195 (@bounceTypeID, 'too many connections'),
f29cfa44
DL		 1196 (@bounceTypeID, 'unable to connect'),
1197 (@bounceTypeID, 'lost connection'),
4b701e6b
JK		 1198 (@bounceTypeID, 'conversation with [^ ]* timed out while'),
1199 (@bounceTypeID, 'server requires authentication'),
1200 (@bounceTypeID, 'authentication (is )?required');
6a488035
TO		 1201
1202INSERT INTO civicrm_mailing_bounce_type
1203 (name, description, hold_threshold)
1204 VALUES ('Inactive', '{ts escape="sql"}User account is no longer active{/ts}', 1);
1205
1206SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Inactive';
1207INSERT INTO civicrm_mailing_bounce_pattern
1208 (bounce_type_id, pattern)
1209 VALUES
1210 (@bounceTypeID, '(my )?e-?mail( address)? has changed'),
1211 (@bounceTypeID, 'account (inactive|expired|deactivated)'),
1212 (@bounceTypeID, 'account is locked'),
1213 (@bounceTypeID, 'changed \w+( e-?mail)? address'),
1214 (@bounceTypeID, 'deactivated mailbox'),
1215 (@bounceTypeID, 'disabled or discontinued'),
1216 (@bounceTypeID, 'inactive user'),
1217 (@bounceTypeID, 'is inactive on this domain'),
1218 (@bounceTypeID, 'mail receiving disabled'),
1219 (@bounceTypeID, 'mail( ?)address is administrative?ly disabled'),
1220 (@bounceTypeID, 'mailbox (temporarily disabled|currently suspended)'),
1221 (@bounceTypeID, 'no longer (accepting mail|on server|in use|with|employed|on staff|works for|using this account)'),
6c722cd3 1222 (@bounceTypeID, 'not accepting (mail|messages)'),
6a488035
TO		 1223 (@bounceTypeID, 'please use my new e-?mail address'),
1224 (@bounceTypeID, 'this address no longer accepts mail'),
6c722cd3
JK		 1225 (@bounceTypeID, 'user account suspended'),
1226 (@bounceTypeID, 'account that you tried to reach is disabled'),
1227 (@bounceTypeID, 'User banned');
6a488035
TO		 1228
1229INSERT INTO civicrm_mailing_bounce_type
1230 (name, description, hold_threshold)
1231 VALUES ('Invalid', '{ts escape="sql"}Email address is not valid{/ts}', 1);
1232
1233SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Invalid';
1234INSERT INTO civicrm_mailing_bounce_pattern
1235 (bounce_type_id, pattern)
1236 VALUES
1237 (@bounceTypeID, '(user|recipient( name)?) is not recognized'),
1238 (@bounceTypeID, '554 delivery error'),
1239 (@bounceTypeID, 'address does not exist'),
1240 (@bounceTypeID, 'address(es)? could not be found'),
1241 (@bounceTypeID, 'addressee unknown'),
1242 (@bounceTypeID, 'bad destination'),
1243 (@bounceTypeID, 'badly formatted address'),
1244 (@bounceTypeID, 'can\'t open mailbox for'),
1245 (@bounceTypeID, 'cannot deliver'),
1246 (@bounceTypeID, 'delivery to the following recipient(s)? failed'),
1247 (@bounceTypeID, 'destination addresses were unknown'),
1248 (@bounceTypeID, 'did not reach the following recipient'),
1249 (@bounceTypeID, 'does not exist'),
1250 (@bounceTypeID, 'does not like recipient'),
1251 (@bounceTypeID, 'does not specify a valid notes mail file'),
1252 (@bounceTypeID, 'illegal alias'),
1253 (@bounceTypeID, 'invalid (mailbox|(e-?mail )?address|recipient|final delivery)'),
1254 (@bounceTypeID, 'invalid( or unknown)?( virtual)? user'),
1255 (@bounceTypeID, 'mail delivery to this user is not allowed'),
1256 (@bounceTypeID, 'mailbox (not found|unavailable|name not allowed)'),
1257 (@bounceTypeID, 'message could not be forwarded'),
1258 (@bounceTypeID, 'missing or malformed local(-| )part'),
1259 (@bounceTypeID, 'no e-?mail address registered'),
1260 (@bounceTypeID, 'no such (mail drop|mailbox( \w+)?|(e-?mail )?address|recipient|(local )?user)( here)?'),
1261 (@bounceTypeID, 'no mailbox here by that name'),
1262 (@bounceTypeID, 'not (listed in|found in directory|known at this site|our customer)'),
1263 (@bounceTypeID, 'not a valid( (user|mailbox))?'),
1264 (@bounceTypeID, 'not present in directory entry'),
1265 (@bounceTypeID, 'recipient (does not exist|(is )?unknown)'),
1266 (@bounceTypeID, 'this user doesn\'t have a yahoo.com address'),
1267 (@bounceTypeID, 'unavailable to take delivery of the message'),
1268 (@bounceTypeID, 'unavailable mailbox'),
1269 (@bounceTypeID, 'unknown (local( |-)part|recipient)'),
1270 (@bounceTypeID, 'unknown( or illegal)? user( account)?'),
1271 (@bounceTypeID, 'unrecognized recipient'),
1272 (@bounceTypeID, 'unregistered address'),
1273 (@bounceTypeID, 'user (unknown|does not exist)'),
1274 (@bounceTypeID, 'user doesn\'t have an? \w+ account'),
1275 (@bounceTypeID, 'user(\'s e-?mail name is)? not found'),
1276 (@bounceTypeID, '^Validation failed for:');
1277
1278INSERT INTO civicrm_mailing_bounce_type
1279 (name, description, hold_threshold)
1280 VALUES ('Loop', '{ts escape="sql"}Mail routing error{/ts}', 3);
1281
1282SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Loop';
1283INSERT INTO civicrm_mailing_bounce_pattern
1284 (bounce_type_id, pattern)
1285 VALUES
1c30bc92 1286 (@bounceTypeID, '(mail( forwarding)?|routing).loop'),
6a488035
TO		 1287 (@bounceTypeID, 'excessive recursion'),
1288 (@bounceTypeID, 'loop detected'),
1289 (@bounceTypeID, 'maximum hop count exceeded'),
1290 (@bounceTypeID, 'message was forwarded more than the maximum allowed times'),
1c30bc92 1291 (@bounceTypeID, 'too many (hops|recursive forwards)');
6a488035
TO		 1292
1293INSERT INTO civicrm_mailing_bounce_type
1294 (name, description, hold_threshold)
1295 VALUES ('Quota', '{ts escape="sql"}User inbox is full{/ts}', 3);
1296
1297SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Quota';
1298INSERT INTO civicrm_mailing_bounce_pattern
1299 (bounce_type_id, pattern)
1300 VALUES
b49cdea8 1301 (@bounceTypeID, '(disk(space)?|over the allowed|exceed(ed|s)?|storage) quota'),
6a488035
TO		 1302 (@bounceTypeID, '522_mailbox_full'),
1303 (@bounceTypeID, 'exceeds allowed message count'),
1304 (@bounceTypeID, 'file too large'),
1305 (@bounceTypeID, 'full mailbox'),
b49cdea8
JK		 1306 (@bounceTypeID, '(mail|in)(box|folder) ((for user \w+ )?is )?full'),
1307 (@bounceTypeID, 'mailbox (has exceeded|is over) the limit'),
6a488035
TO		 1308 (@bounceTypeID, 'mailbox( exceeds allowed)? size'),
1309 (@bounceTypeID, 'no space left for this user'),
1310 (@bounceTypeID, 'over\\s?quota'),
1311 (@bounceTypeID, 'quota (for the mailbox )?has been exceeded'),
b49cdea8 1312 (@bounceTypeID, 'quota ?(usage|violation|exceeded)'),
6a488035 1313 (@bounceTypeID, 'recipient storage full'),
b49cdea8
JK		 1314 (@bounceTypeID, 'not able to receive more mail'),
1315 (@bounceTypeID, 'doesn.t have enough disk space left'),
1316 (@bounceTypeID, 'exceeded storage allocation'),
1317 (@bounceTypeID, 'running out of disk space');
6a488035
TO		 1318
1319INSERT INTO civicrm_mailing_bounce_type
1320 (name, description, hold_threshold)
1321 VALUES ('Relay', '{ts escape="sql"}Unable to reach destination mail server{/ts}', 3);
1322
1323SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay';
1324INSERT INTO civicrm_mailing_bounce_pattern
1325 (bounce_type_id, pattern)
1326 VALUES
1327 (@bounceTypeID, 'cannot find your hostname'),
1328 (@bounceTypeID, 'ip name lookup'),
1329 (@bounceTypeID, 'not configured to relay mail'),
9dd1b580 1330 (@bounceTypeID, 'relay(ing)? (not permitted|(access )?denied)'),
6a488035
TO		 1331 (@bounceTypeID, 'relayed mail to .+? not allowed'),
1332 (@bounceTypeID, 'sender ip must resolve'),
f29cfa44
DL		 1333 (@bounceTypeID, 'unable to relay'),
1334 (@bounceTypeID, 'No route to host'),
9dd1b580
JK		 1335 (@bounceTypeID, 'Network is unreachable'),
1336 (@bounceTypeID, 'unrouteable address'),
1337 (@bounceTypeID, 'We don.t handle mail for'),
1338 (@bounceTypeID, 'we do not relay'),
1339 (@bounceTypeID, 'Rejected by next-hop'),
1340 (@bounceTypeID, 'not permitted to( *550)? relay through this server');
6a488035
TO		 1341
1342INSERT INTO civicrm_mailing_bounce_type
1343 (name, description, hold_threshold)
1344 VALUES ('Spam', '{ts escape="sql"}Message caught by a content filter{/ts}', 1);
1345
1346SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam';
1347INSERT INTO civicrm_mailing_bounce_pattern
1348 (bounce_type_id, pattern)
1349 VALUES
1350 (@bounceTypeID, '(bulk( e-?mail)|content|attachment blocking|virus|mail system) filters?'),
1351 (@bounceTypeID, '(hostile|questionable|unacceptable) content'),
1352 (@bounceTypeID, 'address .+? has not been verified'),
1353 (@bounceTypeID, 'anti-?spam (polic\w+|software)'),
1354 (@bounceTypeID, 'anti-?virus gateway has detected'),
1355 (@bounceTypeID, 'blacklisted'),
1356 (@bounceTypeID, 'blocked message'),
1357 (@bounceTypeID, 'content control'),
1358 (@bounceTypeID, 'delivery not authorized'),
1359 (@bounceTypeID, 'does not conform to our e-?mail policy'),
1360 (@bounceTypeID, 'excessive spam content'),
1361 (@bounceTypeID, 'message looks suspicious'),
1362 (@bounceTypeID, 'open relay'),
1363 (@bounceTypeID, 'sender was rejected'),
1364 (@bounceTypeID, 'spam(check| reduction software| filters?)'),
1365 (@bounceTypeID, 'blocked by a user configured filter'),
85574191
KJ		 1366 (@bounceTypeID, 'detected as spam'),
1367 (@bounceTypeID, 'X-HmXmrOriginalRecipient');
6a488035
TO		 1368
1369INSERT INTO civicrm_mailing_bounce_type
1370 (name, description, hold_threshold)
1371 VALUES ('Syntax', '{ts escape="sql"}Error in SMTP transaction{/ts}', 3);
1372
1373SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Syntax';
1374INSERT INTO civicrm_mailing_bounce_pattern
1375 (bounce_type_id, pattern)
1376 VALUES
1377 (@bounceTypeID, 'nonstandard smtp line terminator'),
1378 (@bounceTypeID, 'syntax error in from address'),
1379 (@bounceTypeID, 'unknown smtp code');
1380
1381-- add sample and reserved profiles
1382
1383INSERT INTO civicrm_uf_group
1384 (id, name, group_type, title, is_cms_user, is_reserved, help_post) VALUES
1385 (1, 'name_and_address', 'Individual,Contact', '{ts escape="sql"}Name and Address{/ts}', 0, 0, NULL),
1386 (2, 'supporter_profile', 'Individual,Contact', '{ts escape="sql"}Supporter Profile{/ts}', 2, 0, '<p><strong>{ts escape="sql"}The information you provide will NOT be shared with any third party organisations.{/ts}</strong></p><p>{ts escape="sql"}Thank you for getting involved in our campaign!{/ts}</p>'),
1387 (3, 'participant_status', 'Participant', '{ts escape="sql"}Participant Status{/ts}', 0, 1, NULL),
1388 (4, 'new_individual', 'Individual,Contact', '{ts escape="sql"}New Individual{/ts}' , 0, 1, NULL),
1389 (5, 'new_organization', 'Organization,Contact','{ts escape="sql"}New Organization{/ts}' , 0, 1, NULL),
1390 (6, 'new_household', 'Household,Contact', '{ts escape="sql"}New Household{/ts}' , 0, 1, NULL),
a235e13c 1391 (7, 'summary_overlay', 'Contact', '{ts escape="sql"}Summary Overlay{/ts}' , 0, 1, NULL),
1392 (8, 'shared_address', 'Contact', '{ts escape="sql"}Shared Address{/ts}' , 0, 1, NULL),
6a488035 1393 (9, 'on_behalf_organization', 'Contact,Organization','{ts escape="sql"}On Behalf Of Organization{/ts}', 0, 1, NULL),
42b29ffc 1394 (10, 'contribution_batch_entry', 'Contribution', '{ts escape="sql"}Contribution Bulk Entry{/ts}' , 0, 1, NULL),
1395 (11, 'membership_batch_entry', 'Membership', '{ts escape="sql"}Membership Bulk Entry{/ts}' , 0, 1, NULL),
8381af80 1396 (12, 'event_registration', 'Individual,Contact', '{ts escape="sql"}Your Registration Info{/ts}', 0, 0, NULL),
1397 (13, 'honoree_individual', 'Individual,Contact', '{ts escape="sql"}Honoree Individual{/ts}', 0, 1, NULL);
6a488035 1398
133e2c99 1399
6a488035
TO		 1400INSERT INTO civicrm_uf_join
1401 (is_active,module,entity_table,entity_id,weight,uf_group_id)
1402VALUES
1403 (1, 'User Registration',NULL, NULL,1,1),
1404 (1, 'User Account', NULL, NULL, 1, 1),
1405 (1, 'Profile', NULL, NULL, 1, 1),
1406 (1, 'Profile', NULL, NULL, 2, 2),
2e57a21b 1407 (1, 'Profile', NULL, NULL, 11, 12);
6a488035
TO		 1408
1409INSERT INTO civicrm_uf_field
a235e13c 1410 ( uf_group_id, field_name, is_required, is_reserved, weight, visibility, in_selector, is_searchable, location_type_id, label, field_type, help_post, phone_type_id ) VALUES
42b29ffc 1411 ( 1, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL),
1412 ( 1, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL),
1413 ( 1, 'street_address', 0, 0, 3, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Street Address (Home){/ts}', 'Contact', NULL, NULL),
1414 ( 1, 'city', 0, 0, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}City (Home){/ts}', 'Contact', NULL, NULL),
1415 ( 1, 'postal_code', 0, 0, 5, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Postal Code (Home){/ts}', 'Contact', NULL, NULL),
1416 ( 1, 'country', 0, 0, 6, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Country (Home){/ts}', 'Contact', NULL, NULL),
1417 ( 1, 'state_province', 0, 0, 7, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}State (Home){/ts}', 'Contact', NULL, NULL),
1418 ( 2, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL),
1419 ( 2, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL),
1420 ( 2, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL),
1421 ( 3, 'participant_status', 1, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Participant Status{/ts}', 'Participant', NULL, NULL),
1422 ( 4, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL),
1423 ( 4, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL),
1424 ( 4, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL),
1425 ( 5, 'organization_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Organization Name{/ts}', 'Organization', NULL, NULL),
1426 ( 5, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL),
1427 ( 6, 'household_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Household Name{/ts}', 'Household', NULL, NULL),
1428 ( 6, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL),
1429 ( 7, 'phone', 1, 0, 1, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Home Phone{/ts}', 'Contact', NULL, 1 ),
1430 ( 7, 'phone', 1, 0, 2, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Home Mobile{/ts}', 'Contact', NULL, 2 ),
1431 ( 7, 'street_address', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Primary Address{/ts}', 'Contact', NULL, NULL),
1432 ( 7, 'city', 1, 0, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}City{/ts}', 'Contact', NULL, NULL),
1433 ( 7, 'state_province', 1, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}State{/ts}', 'Contact', NULL, NULL),
1434 ( 7, 'postal_code', 1, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Postal Code{/ts}', 'Contact', NULL, NULL),
1435 ( 7, 'email', 1, 0, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Primary Email{/ts}', 'Contact', NULL, NULL),
1436 ( 7, 'group', 1, 0, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Groups{/ts}', 'Contact', NULL, NULL),
1437 ( 7, 'tag', 1, 0, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Tags{/ts}', 'Contact', NULL, NULL),
1438 ( 7, 'gender_id', 1, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Gender{/ts}', 'Individual', NULL, NULL),
1439 ( 7, 'birth_date', 1, 0, 11, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Date of Birth{/ts}', 'Individual', NULL, NULL),
1440 ( 8, 'street_address', 1, 1, 1, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Street Address (Home){/ts}', 'Contact', NULL, NULL),
1441 ( 8, 'city', 1, 1, 2, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}City (Home){/ts}', 'Contact', NULL, NULL),
1442 ( 8, 'postal_code', 0, 0, 3, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Postal Code (Home){/ts}', 'Contact', NULL, NULL),
1443 ( 8, 'country', 0, 0, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Country (Home){/ts}', 'Contact', NULL, NULL),
1444 ( 8, 'state_province', 0, 0, 5, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}State (Home){/ts}', 'Contact', NULL, NULL),
1445 ( 9, 'organization_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Organization Name{/ts}', 'Organization', NULL, NULL),
1446 ( 9, 'phone', 1, 0, 2, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Phone (Main) {/ts}', 'Contact', NULL, 1),
1447 ( 9, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Email (Main) {/ts}', 'Contact', NULL, NULL),
1448 ( 9, 'street_address', 1, 0, 4, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Street Address{/ts}', 'Contact', NULL, NULL),
1449 ( 9, 'city', 1, 0, 5, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}City{/ts}', 'Contact', NULL, NULL),
1450 ( 9, 'postal_code', 1, 0, 6, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Postal Code{/ts}', 'Contact', NULL, NULL),
1451 ( 9, 'country', 1, 0, 7, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Country{/ts}', 'Contact', NULL, NULL),
757069de 1452 ( 9, 'state_province', 1, 0, 8, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}State/Province{/ts}', 'Contact', NULL, NULL),
42b29ffc 1453 ( 10, 'financial_type', 1, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Type{/ts}', 'Contribution', NULL, NULL ),
6a488035
TO		 1454 ( 10, 'total_amount', 1, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Amount{/ts}', 'Contribution', NULL, NULL ),
1455 ( 10, 'contribution_status_id', 1, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Status{/ts}', 'Contribution', NULL, NULL ),
1456 ( 10, 'receive_date', 1, 1, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Received{/ts}', 'Contribution', NULL, NULL ),
1457 ( 10, 'contribution_source', 0, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Source{/ts}', 'Contribution', NULL, NULL ),
1458 ( 10, 'payment_instrument', 0, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Paid By{/ts}', 'Contribution', NULL, NULL ),
1459 ( 10, 'check_number', 0, 0, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Check Number{/ts}', 'Contribution', NULL, NULL ),
1460 ( 10, 'send_receipt', 0, 0, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Send Receipt{/ts}', 'Contribution', NULL, NULL ),
1461 ( 10, 'invoice_id', 0, 0, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Invoice ID{/ts}', 'Contribution', NULL, NULL ),
5ee60152 1462 ( 10, 'soft_credit', 0, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit{/ts}', 'Contribution', NULL, NULL ),
42b29ffc 1463 ( 10, 'soft_credit_type', 0, 0, 11, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit Type{/ts}', 'Contribution', NULL, NULL ),
6a488035
TO		 1464 ( 11, 'membership_type', 1, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Type{/ts}', 'Membership', NULL, NULL ),
1465 ( 11, 'join_date', 1, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Member Since{/ts}', 'Membership', NULL, NULL ),
1466 ( 11, 'membership_start_date', 0, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Start Date{/ts}', 'Membership', NULL, NULL ),
1467 ( 11, 'membership_end_date', 0, 1, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}End Date{/ts}', 'Membership', NULL, NULL ),
1468 ( 11, 'membership_source', 0, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Source{/ts}', 'Membership', NULL, NULL ),
1469 ( 11, 'send_receipt', 0, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Send Receipt{/ts}', 'Membership', NULL, NULL ),
42b29ffc 1470 ( 11, 'financial_type', 1, 1, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Financial Type{/ts}', 'Membership', NULL, NULL ),
6a488035
TO		 1471 ( 11, 'total_amount', 1, 1, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Amount{/ts}', 'Membership', NULL, NULL ),
1472 ( 11, 'receive_date', 1, 1, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Received{/ts}', 'Membership', NULL, NULL ),
1473 ( 11, 'payment_instrument', 0, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Paid By{/ts}', 'Membership', NULL, NULL ),
1474 ( 11, 'check_number', 0, 0, 11, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Check Number{/ts}', 'Membership', NULL, NULL ),
1475 ( 11, 'contribution_status_id', 1, 1, 12, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Payment Status{/ts}', 'Membership', NULL, NULL ),
5ee60152 1476 ( 11, 'soft_credit', 0, 0, 13, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit{/ts}', 'Membership', NULL, NULL ),
9e1854a1 1477 ( 11, 'soft_credit_type', 0, 0, 14, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit Type{/ts}', 'Membership', NULL, NULL ),
e6ff0ead
DG		 1478 ( 12, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL),
1479 ( 12, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL),
42b29ffc 1480 ( 12, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL),
1481 ( 13, 'prefix_id', 0, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Individual Prefix{/ts}', 'Individual', NULL, NULL),
1482 ( 13, 'first_name', 1, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL),
1483 ( 13, 'last_name', 1, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL),
1484 ( 13, 'email', 0, 1, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL);
6a488035
TO		 1485
1486
1487INSERT INTO civicrm_participant_status_type
1488 (id, name, label, class, is_reserved, is_active, is_counted, weight, visibility_id) VALUES
1489 (1, 'Registered', '{ts escape="sql"}Registered{/ts}', 'Positive', 1, 1, 1, 1, 1 ),
1490 (2, 'Attended', '{ts escape="sql"}Attended{/ts}', 'Positive', 0, 1, 1, 2, 2 ),
1491 (3, 'No-show', '{ts escape="sql"}No-show{/ts}', 'Negative', 0, 1, 0, 3, 2 ),
1492 (4, 'Cancelled', '{ts escape="sql"}Cancelled{/ts}', 'Negative', 1, 1, 0, 4, 2 ),
1493 (5, 'Pending from pay later', '{ts escape="sql"}Pending from pay later{/ts}', 'Pending', 1, 1, 1, 5, 2 ),
1494 (6, 'Pending from incomplete transaction', '{ts escape="sql"}Pending from incomplete transaction{/ts}', 'Pending', 1, 1, 0, 6, 2 ),
1495 (7, 'On waitlist', '{ts escape="sql"}On waitlist{/ts}', 'Waiting', 1, 0, 0, 7, 2 ),
1496 (8, 'Awaiting approval', '{ts escape="sql"}Awaiting approval{/ts}', 'Waiting', 1, 0, 1, 8, 2 ),
1497 (9, 'Pending from waitlist', '{ts escape="sql"}Pending from waitlist{/ts}', 'Pending', 1, 0, 1, 9, 2 ),
1498 (10, 'Pending from approval', '{ts escape="sql"}Pending from approval{/ts}', 'Pending', 1, 0, 1, 10, 2 ),
1499 (11, 'Rejected', '{ts escape="sql"}Rejected{/ts}', 'Negative', 1, 0, 0, 11, 2 ),
1500 (12, 'Expired', '{ts escape="sql"}Expired{/ts}', 'Negative', 1, 1, 0, 12, 2 ),
59e44db1 1501 (13, 'Pending in cart', '{ts escape="sql"}Pending in cart{/ts}', 'Pending', 1, 1, 0, 13, 2 ),
0f602e3f
PJ		 1502 (14, 'Partially paid', '{ts escape="sql"}Partially paid{/ts}', 'Positive', 1, 1, 1, 14, 2 ),
1503 (15, 'Pending refund', '{ts escape="sql"}Pending refund{/ts}', 'Positive', 1, 1, 1, 14, 2 );
59e44db1 1504
6a488035
TO		 1505
1506
1507-- CRM-8150
1508INSERT INTO civicrm_action_mapping
1509(entity, entity_value, entity_value_label, entity_status, entity_status_label, entity_date_start, entity_date_end, entity_recipient)
1510VALUES
1511( 'civicrm_activity', 'activity_type', 'Activity Type', 'activity_status', 'Activity Status', 'activity_date_time', NULL, 'activity_contacts'),
1512( 'civicrm_participant', 'event_type', 'Event Type', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'),
1513( 'civicrm_participant', 'civicrm_event', 'Event Name', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'),
1514( 'civicrm_membership', 'civicrm_membership_type', 'Membership Type', 'auto_renew_options', 'Auto Renew Options', 'membership_join_date', 'membership_end_date', NULL),
3d65c75c
AH		 1515( 'civicrm_participant', 'event_template', 'Event Template', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'),
1516( 'civicrm_contact', 'civicrm_contact', 'Date Field', 'contact_date_reminder_options', 'Annual Options', 'date_field', NULL, NULL);
6a488035
TO		 1517
1518INSERT INTO `civicrm_contact_type`
1519 (`id`, `name`, `label`,`image_URL`, `parent_id`, `is_active`,`is_reserved`)
1520 VALUES
1521 ( 1, 'Individual' , '{ts escape="sql"}Individual{/ts}' , NULL, NULL, 1, 1),
1522 ( 2, 'Household' , '{ts escape="sql"}Household{/ts}' , NULL, NULL, 1, 1),
1523 ( 3, 'Organization', '{ts escape="sql"}Organization{/ts}', NULL, NULL, 1, 1);
1524
1525{include file='civicrm_msg_template.tpl'}
1526
1527-- CRM-8358
1528
1529INSERT INTO `civicrm_job`
1530 ( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
1531VALUES
1532 ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Send Scheduled Mailings{/ts}', '{ts escape="sql" skip="true"}Sends out scheduled CiviMail mailings{/ts}', 'job', 'process_mailing', NULL, 0),
1533 ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Fetch Bounces{/ts}', '{ts escape="sql" skip="true"}Fetches bounces from mailings and writes them to mailing statistics{/ts}', 'job', 'fetch_bounces', NULL, 0),
1534 ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Process Inbound Emails{/ts}', '{ts escape="sql" skip="true"}Inserts activity for a contact or a case by retrieving inbound emails from a mail directory{/ts}', 'job', 'fetch_activities', NULL, 0),
1535 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Process Pledges{/ts}', '{ts escape="sql" skip="true"}Updates pledge records and sends out reminders{/ts}', 'job', 'process_pledge','{ts escape="sql" skip="true"}send_reminders=[1 or 0] optional- 1 to send payment reminders{/ts}', 0),
1536 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Geocode and Parse Addresses{/ts}', '{ts escape="sql" skip="true"}Retrieves geocodes (lat and long) and / or parses street addresses (populates street number, street name, etc.){/ts}', 'job', 'geocode', '{ts escape="sql" skip="true"}geocoding=[1 or 0] required
1537parse=[1 or 0] required
1538start=[contact ID] optional-begin with this contact ID
1539end=[contact ID] optional-process contacts with IDs less than this
1540throttle=[1 or 0] optional-1 adds five second sleep{/ts}', 0),
1541 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Update Greetings and Addressees{/ts}','{ts escape="sql" skip="true"}Goes through contact records and updates email and postal greetings, or addressee value{/ts}', 'job', 'update_greeting','{ts escape="sql" skip="true"}ct=[Individual or Household or Organization] required
1542gt=[email_greeting or postal_greeting or addressee] required
24f77640 1543force=[0 or 1] optional-0 update contacts with null value, 1 update all
1544limit=Number optional-Limit the number of contacts to update{/ts}', 0),
6a488035
TO		 1545 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Mail Reports{/ts}', '{ts escape="sql" skip="true"}Generates and sends out reports via email{/ts}', 'job', 'mail_report','{ts escape="sql" skip="true"}instanceId=[ID of report instance] required
1546format=[csv or print] optional-output CSV or print-friendly HTML, else PDF{/ts}', 0),
1547 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Send Scheduled Reminders{/ts}', '{ts escape="sql" skip="true"}Sends out scheduled reminders via email{/ts}', 'job', 'send_reminder', NULL, 0),
1548 ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Update Participant Statuses{/ts}', '{ts escape="sql" skip="true"}Updates pending event participant statuses based on time{/ts}', 'job', 'process_participant', NULL, 0),
1549 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Update Membership Statuses{/ts}', '{ts escape="sql" skip="true"}Updates membership statuses. WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality, which supports multiple renewal reminders.{/ts}', 'job', 'process_membership', NULL, 0),
1550 ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Process Survey Respondents{/ts}', '{ts escape="sql" skip="true"}Releases reserved survey respondents when they have been reserved for longer than the Release Frequency days specified for that survey.{/ts}', 'job', 'process_respondent',NULL, 0),
1551 ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Clean-up Temporary Data and Files{/ts}','{ts escape="sql" skip="true"}Removes temporary data and files, and clears old data from cache tables. Recommend running this job every hour to help prevent database and file system bloat.{/ts}', 'job', 'cleanup', NULL, 0),
1552 ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Send Scheduled SMS{/ts}', '{ts escape="sql" skip="true"}Sends out scheduled SMS{/ts}', 'job', 'process_sms', NULL, 0),
1553 ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Rebuild Smart Group Cache{/ts}', '{ts escape="sql" skip="true"}Rebuilds the smart group cache.{/ts}', 'job', 'group_rebuild', '{ts escape="sql" skip="true"}limit=Number optional-Limit the number of smart groups rebuild{/ts}', 0),
1554 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Disable expired relationships{/ts}','{ts escape="sql" skip="true"}Disables relationships that have expired (ie. those relationships whose end date is in the past).{/ts}', 'job', 'disable_expired_relationships', NULL, 0),
1555 ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Validate Email Address from Mailings.{/ts}', '{ts escape="sql" skip="true"}Updates the reset_date on an email address to indicate that there was a valid delivery to this email address.{/ts}', 'mailing', 'update_email_resetdate', '{ts escape="sql" skip="true"}minDays, maxDays=Consider mailings that have completed between minDays and maxDays{/ts}', 0);
1556
4636d4fd
DL		 1557SELECT @option_value_rel_id := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Income Account is';
1558SELECT @option_value_rel_id_exp := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Expense Account is';
1559SELECT @option_value_rel_id_ar := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Accounts Receivable Account is';
1560SELECT @option_value_rel_id_as := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Asset Account is';
ddaa8ef1 1561SELECT @option_value_rel_id_cg := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Cost of Sales Account is';
4636d4fd 1562
a235e13c 1563SELECT @financial_type_id_dtn := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Donation{/ts}';
1564SELECT @financial_type_id_md := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Member Dues{/ts}';
1565SELECT @financial_type_id_cc := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Campaign Contribution{/ts}';
1566SELECT @financial_type_id_ef := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Event Fee{/ts}';
4636d4fd
DL		 1567
1568SELECT @financial_account_id_dtn := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Donation{/ts}';
a235e13c 1569SELECT @financial_account_id_md := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Member Dues{/ts}';
1570SELECT @financial_account_id_cc := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Campaign Contribution{/ts}';
1571SELECT @financial_account_id_ef := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Event Fee{/ts}';
1572SELECT @financial_account_id_bf := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Banking Fees{/ts}';
1573SELECT @financial_account_id_ap := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Accounts Receivable{/ts}';
4636d4fd
DL		 1574SELECT @financial_account_id_ar := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Deposit Bank Account{/ts}';
1575SELECT @financial_account_id_pp := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Payment Processor Account{/ts}';
ddaa8ef1 1576SELECT @financial_account_id_pr := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Premiums{/ts}';
6a488035
TO		 1577
1578INSERT INTO `civicrm_entity_financial_account`
1579 ( entity_table, entity_id, account_relationship, financial_account_id )
1580VALUES
1581 ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id, @financial_account_id_dtn ),
1582 ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_exp, @financial_account_id_bf ),
1583 ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_ar, @financial_account_id_ap ),
ddaa8ef1 1584 ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_cg, @financial_account_id_pr ),
6a488035
TO		 1585 ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id, @financial_account_id_md ),
1586 ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_exp, @financial_account_id_bf ),
1587 ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_ar, @financial_account_id_ap ),
ddaa8ef1 1588 ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_cg, @financial_account_id_pr ),
6a488035
TO		 1589 ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id, @financial_account_id_cc ),
1590 ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_exp, @financial_account_id_bf ),
1591 ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_ar, @financial_account_id_ap ),
ddaa8ef1 1592 ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_cg, @financial_account_id_pr ),
6a488035
TO		 1593 ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_exp, @financial_account_id_bf ),
1594 ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_ar, @financial_account_id_ap ),
ddaa8ef1
PN		 1595 ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id, @financial_account_id_ef ),
1596 ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_cg, @financial_account_id_pr );
6a488035
TO		 1597
1598-- CRM-11516
1599INSERT INTO civicrm_entity_financial_account (entity_table, entity_id, account_relationship, financial_account_id)
1600SELECT 'civicrm_option_value', cov.id, @option_value_rel_id_as, @financial_account_id_ar FROM `civicrm_option_group` cog
1601LEFT JOIN civicrm_option_value cov ON cog.id = cov.option_group_id
1602WHERE cog.name = 'payment_instrument' AND cov.name NOT IN ('Credit Card', 'Debit Card');
1603
1604SELECT @option_value_cc_id := max(id) FROM `civicrm_option_value` WHERE `option_group_id` = @option_group_id_pi AND `name` = 'Credit Card';
1605SELECT @option_value_dc_id := max(id) FROM `civicrm_option_value` WHERE `option_group_id` = @option_group_id_pi AND `name` = 'Debit Card';
1606
1607INSERT INTO `civicrm_entity_financial_account`
1608 ( entity_table, entity_id, account_relationship, financial_account_id )
1609VALUES
1610 ( 'civicrm_option_value', @option_value_cc_id, @option_value_rel_id_as, @financial_account_id_pp),
1611 ( 'civicrm_option_value', @option_value_dc_id, @option_value_rel_id_as, @financial_account_id_pp);
1612
1613-- CRM-9714
1614
1615SELECT @financial_type_id := max(id) FROM `civicrm_financial_type` WHERE `name` = 'Member Dues';
1616INSERT INTO `civicrm_price_set` ( `name`, `title`, `is_active`, `extends`, `is_quick_config`, `financial_type_id`, `is_reserved` )
1617VALUES ( 'default_contribution_amount', 'Contribution Amount', '1', '2', '1', NULL,1),
1618( 'default_membership_type_amount', 'Membership Amount', '1', '3', '1', @financial_type_id,1);
1619
1620SELECT @setID := max(id) FROM civicrm_price_set WHERE name = 'default_contribution_amount' AND extends = 2 AND is_quick_config = 1 ;
1621
1622INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`,`weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`,`visibility_id` )
1623VALUES ( @setID, 'contribution_amount', 'Contribution Amount', 'Text', '1', '1', '1', '1', '1', '1' );
1624
1625SELECT @fieldID := max(id) FROM civicrm_price_field WHERE name = 'contribution_amount' AND price_set_id = @setID;
1626
1627INSERT INTO `civicrm_price_field_value` ( `price_field_id`, `name`, `label`, `amount`, `weight`, `is_default`, `is_active`, `financial_type_id`)
1628VALUES ( @fieldID, 'contribution_amount', 'Contribution Amount', '1', '1', '0', '1', 1);
1629
51fa20cb 1630-- CRM-13833
1631INSERT INTO civicrm_option_group (`name`, `title`, `is_reserved`, `is_active`) VALUES ('soft_credit_type', {localize}'{ts escape="sql"}Soft Credit Types{/ts}'{/localize}, 1, 1);
1632
1633SELECT @option_group_id_soft_credit_type := max(id) from civicrm_option_group where name = 'soft_credit_type';
1634
1635INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `weight`, `is_default`, `is_active`, `is_reserved`)
1636VALUES
1637 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}In Honor of{/ts}'{/localize}, 1, 'in_honor_of', 1, 0, 1, 1),
1638 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}In Memory of{/ts}'{/localize}, 2, 'in_memory_of', 2, 0, 1, 1),
1639 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Solicited{/ts}'{/localize}, 3, 'solicited', 3, 1, 1, 1),
1640 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Household{/ts}'{/localize}, 4, 'household', 4, 0, 1, 0),
1641 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Workplace Giving{/ts}'{/localize}, 5, 'workplace', 5, 0, 1, 0),
1642 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Foundation Affiliate{/ts}'{/localize}, 6, 'foundation_affiliate', 6, 0, 1, 0),
1643 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}3rd-party Service{/ts}'{/localize}, 7, '3rd-party_service', 7, 0, 1, 0),
1644 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Donor-advised Fund{/ts}'{/localize}, 8, 'donor-advised_fund', 8, 0, 1, 0),
1645 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Matched Gift{/ts}'{/localize}, 9, 'matched_gift', 9, 0, 1, 0),
12792976 1646 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Personal Campaign Page{/ts}'{/localize}, 10, 'pcp', 10, 0, 1, 1),
1647 (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Gift{/ts}'{/localize}, 11, 'gift', 11, 0, 1, 1);
1648