Commit | Line | Data |
---|---|---|
6a488035 | 1 | -- +--------------------------------------------------------------------+ |
39de6fd5 | 2 | -- | CiviCRM version 4.6 | |
6a488035 | 3 | -- +--------------------------------------------------------------------+ |
e7112fa7 | 4 | -- | Copyright CiviCRM LLC (c) 2004-2015 | |
6a488035 TO |
5 | -- +--------------------------------------------------------------------+ |
6 | -- | This file is a part of CiviCRM. | | |
7 | -- | | | |
8 | -- | CiviCRM is free software; you can copy, modify, and distribute it | | |
9 | -- | under the terms of the GNU Affero General Public License | | |
10 | -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | |
11 | -- | | | |
12 | -- | CiviCRM is distributed in the hope that it will be useful, but | | |
13 | -- | WITHOUT ANY WARRANTY; without even the implied warranty of | | |
14 | -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | |
15 | -- | See the GNU Affero General Public License for more details. | | |
16 | -- | | | |
17 | -- | You should have received a copy of the GNU Affero General Public | | |
18 | -- | License and the CiviCRM Licensing Exception along | | |
19 | -- | with this program; if not, contact CiviCRM LLC | | |
20 | -- | at info[AT]civicrm[DOT]org. If you have questions about the | | |
21 | -- | GNU Affero General Public License or the licensing of CiviCRM, | | |
22 | -- | see the CiviCRM license FAQ at http://civicrm.org/licensing | | |
23 | -- +--------------------------------------------------------------------+ | |
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 | ||
30 | SET @domainName := 'Default Domain Name'; | |
31 | SET @defaultOrganization := 'Default Organization'; | |
32 | ||
33 | -- Add components to system wide registry | |
34 | -- We're doing it early to avoid constraint errors. | |
35 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviEvent' , 'CRM_Event' ); | |
36 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviContribute', 'CRM_Contribute' ); | |
37 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviMember' , 'CRM_Member' ); | |
38 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviMail' , 'CRM_Mailing' ); | |
39 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviGrant' , 'CRM_Grant' ); | |
40 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviPledge' , 'CRM_Pledge' ); | |
41 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviCase' , 'CRM_Case' ); | |
42 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviReport' , 'CRM_Report' ); | |
43 | INSERT INTO civicrm_component (name, namespace) VALUES ('CiviCampaign' , 'CRM_Campaign' ); | |
44 | ||
45 | -- Create organization contact | |
46 | INSERT INTO civicrm_contact( `contact_type`, `sort_name`, `display_name`, `legal_name`, `organization_name`) | |
47 | VALUES ('Organization', @defaultOrganization, @defaultOrganization, @defaultOrganization, @defaultOrganization); | |
48 | SET @contactID := LAST_INSERT_ID(); | |
49 | ||
50 | INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary, is_billing, on_hold, hold_date, reset_date) | |
51 | VALUES | |
52 | (@contactID, 1, 'fixme.domainemail@example.org', 0, 0, 0, NULL, NULL); | |
53 | ||
54 | INSERT INTO civicrm_domain (name, version, contact_id) VALUES (@domainName, '2.2', @contactID); | |
55 | SELECT @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. | |
61 | INSERT 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 ); | |
62 | INSERT 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 ); | |
63 | INSERT 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 ); | |
64 | INSERT 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 | |
66 | INSERT 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 | |
69 | INSERT 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 | |
80 | INSERT 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 ); | |
82 | INSERT 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 | |
87 | INSERT 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 | |
107 | INSERT INTO civicrm_mailing_component | |
108 | (name,component_type,subject,body_html,body_text,is_default,is_active) | |
109 | VALUES | |
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 | |
122 | INSERT INTO | |
123 | civicrm_financial_type(name, is_reserved, is_active, is_deductible) | |
124 | VALUES | |
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 | ||
132 | INSERT INTO | |
cede6590 | 133 | `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) |
6a488035 | 134 | VALUES |
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 | |
213 | SELECT @option_group_id_pcm := max(id) from civicrm_option_group where name = 'preferred_communication_method'; | |
214 | SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type'; | |
215 | SELECT @option_group_id_gender := max(id) from civicrm_option_group where name = 'gender'; | |
216 | SELECT @option_group_id_IMProvider := max(id) from civicrm_option_group where name = 'instant_messenger_service'; | |
217 | SELECT @option_group_id_mobileProvider := max(id) from civicrm_option_group where name = 'mobile_provider'; | |
218 | SELECT @option_group_id_prefix := max(id) from civicrm_option_group where name = 'individual_prefix'; | |
219 | SELECT @option_group_id_suffix := max(id) from civicrm_option_group where name = 'individual_suffix'; | |
220 | SELECT @option_group_id_aclRole := max(id) from civicrm_option_group where name = 'acl_role'; | |
221 | SELECT @option_group_id_acc := max(id) from civicrm_option_group where name = 'accept_creditcard'; | |
222 | SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument'; | |
223 | SELECT @option_group_id_cs := max(id) from civicrm_option_group where name = 'contribution_status'; | |
224 | SELECT @option_group_id_pcp := max(id) from civicrm_option_group where name = 'pcp_status'; | |
12f92dbd | 225 | SELECT @option_group_id_pcpOwnerNotify := max(id) from civicrm_option_group where name = 'pcp_owner_notify'; |
6a488035 TO |
226 | SELECT @option_group_id_pRole := max(id) from civicrm_option_group where name = 'participant_role'; |
227 | SELECT @option_group_id_etype := max(id) from civicrm_option_group where name = 'event_type'; | |
228 | SELECT @option_group_id_cvOpt := max(id) from civicrm_option_group where name = 'contact_view_options'; | |
8acb3461 | 229 | SELECT @option_group_id_csgOpt := max(id) from civicrm_option_group where name = 'contact_smart_group_display'; |
6a488035 TO |
230 | SELECT @option_group_id_ceOpt := max(id) from civicrm_option_group where name = 'contact_edit_options'; |
231 | SELECT @option_group_id_asOpt := max(id) from civicrm_option_group where name = 'advanced_search_options'; | |
232 | SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options'; | |
233 | SELECT @option_group_id_adOpt := max(id) from civicrm_option_group where name = 'address_options'; | |
234 | SELECT @option_group_id_gType := max(id) from civicrm_option_group where name = 'group_type'; | |
235 | SELECT @option_group_id_grantSt := max(id) from civicrm_option_group where name = 'grant_status'; | |
236 | SELECT @option_group_id_grantTyp := max(id) from civicrm_option_group where name = 'grant_type'; | |
6a488035 TO |
237 | SELECT @option_group_id_csearch := max(id) from civicrm_option_group where name = 'custom_search'; |
238 | SELECT @option_group_id_acs := max(id) from civicrm_option_group where name = 'activity_status'; | |
239 | SELECT @option_group_id_ct := max(id) from civicrm_option_group where name = 'case_type'; | |
240 | SELECT @option_group_id_cas := max(id) from civicrm_option_group where name = 'case_status'; | |
241 | SELECT @option_group_id_pl := max(id) from civicrm_option_group where name = 'participant_listing'; | |
242 | SELECT @option_group_id_sfe := max(id) from civicrm_option_group where name = 'safe_file_extension'; | |
243 | SELECT @option_group_id_mt := max(id) from civicrm_option_group where name = 'mapping_type'; | |
244 | SELECT @option_group_id_we := max(id) from civicrm_option_group where name = 'wysiwyg_editor'; | |
245 | SELECT @option_group_id_fu := max(id) from civicrm_option_group where name = 'recur_frequency_units'; | |
246 | SELECT @option_group_id_pht := max(id) from civicrm_option_group where name = 'phone_type'; | |
247 | SELECT @option_group_id_fma := max(id) from civicrm_option_group where name = 'from_email_address'; | |
248 | SELECT @option_group_id_cdt := max(id) from civicrm_option_group where name = 'custom_data_type'; | |
249 | SELECT @option_group_id_vis := max(id) from civicrm_option_group where name = 'visibility'; | |
250 | SELECT @option_group_id_mp := max(id) from civicrm_option_group where name = 'mail_protocol'; | |
251 | SELECT @option_group_id_priority := max(id) from civicrm_option_group where name = 'priority'; | |
252 | SELECT @option_group_id_rr := max(id) from civicrm_option_group where name = 'redaction_rule'; | |
253 | SELECT @option_group_id_emailGreeting := max(id) from civicrm_option_group where name = 'email_greeting'; | |
254 | SELECT @option_group_id_postalGreeting := max(id) from civicrm_option_group where name = 'postal_greeting'; | |
255 | SELECT @option_group_id_addressee := max(id) from civicrm_option_group where name = 'addressee'; | |
256 | SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template'; | |
257 | SELECT @option_group_id_acsOpt := max(id) from civicrm_option_group where name = 'contact_autocomplete_options'; | |
258 | SELECT @option_group_id_acConRef := max(id) from civicrm_option_group where name = 'contact_reference_options'; | |
6a488035 TO |
259 | SELECT @option_group_id_website := max(id) from civicrm_option_group where name = 'website_type'; |
260 | SELECT @option_group_id_tuf := max(id) from civicrm_option_group where name = 'tag_used_for'; | |
261 | SELECT @option_group_id_currency := max(id) from civicrm_option_group where name = 'currencies_enabled'; | |
262 | SELECT @option_group_id_eventBadge := max(id) from civicrm_option_group where name = 'event_badge'; | |
263 | SELECT @option_group_id_notePrivacy := max(id) from civicrm_option_group where name = 'note_privacy'; | |
264 | SELECT @option_group_id_campaignType := max(id) from civicrm_option_group where name = 'campaign_type'; | |
265 | SELECT @option_group_id_campaignStatus := max(id) from civicrm_option_group where name = 'campaign_status'; | |
266 | SELECT @option_group_id_extensions := max(id) from civicrm_option_group where name = 'system_extensions'; | |
267 | SELECT @option_group_id_mail_approval_status := max(id) from civicrm_option_group where name = 'mail_approval_status'; | |
268 | SELECT @option_group_id_engagement_index := max(id) from civicrm_option_group where name = 'engagement_index'; | |
269 | SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects'; | |
270 | SELECT @option_group_id_paperSize := max(id) from civicrm_option_group where name = 'paper_size'; | |
271 | SELECT @option_group_id_label := max(id) from civicrm_option_group where name = 'label_format'; | |
272 | SELECT @option_group_id_aco := max(id) from civicrm_option_group where name = 'activity_contacts'; | |
273 | SELECT @option_group_id_arel := max(id) from civicrm_option_group where name = 'account_relationship'; | |
274 | SELECT @option_group_id_ere := max(id) from civicrm_option_group where name = 'event_contacts'; | |
275 | SELECT @option_group_id_conference_slot := max(id) from civicrm_option_group where name = 'conference_slot'; | |
276 | SELECT @option_group_id_batch_type := max(id) from civicrm_option_group where name = 'batch_type'; | |
277 | SELECT @option_group_id_batch_status := max(id) from civicrm_option_group where name = 'batch_status'; | |
278 | SELECT @option_group_id_batch_mode := max(id) from civicrm_option_group where name = 'batch_mode'; | |
279 | SELECT @option_group_id_sms_api_type := max(id) from civicrm_option_group where name = 'sms_api_type'; | |
280 | SELECT @option_group_id_sms_provider_name := max(id) from civicrm_option_group where name = 'sms_provider_name'; | |
281 | SELECT @option_group_id_aro := max(id) from civicrm_option_group where name = 'auto_renew_options'; | |
282 | SELECT @option_group_id_fat := max(id) from civicrm_option_group where name = 'financial_account_type'; | |
283 | SELECT @option_group_id_financial_item_status := max(id) from civicrm_option_group where name = 'financial_item_status'; | |
bcb99132 | 284 | SELECT @option_group_id_label_type := max(id) from civicrm_option_group where name = 'label_type'; |
ab3a115e | 285 | SELECT @option_group_id_name_badge := max(id) from civicrm_option_group where name = 'name_badge'; |
aa62b355 | 286 | SELECT @option_group_id_communication_style := max(id) from civicrm_option_group where name = 'communication_style'; |
a3e3eea1 | 287 | SELECT @option_group_id_msg_mode := max(id) from civicrm_option_group where name = 'msg_mode'; |
3d65c75c | 288 | SELECT @option_group_id_contactDateMode := max(id) from civicrm_option_group where name = 'contact_date_reminder_options'; |
6a488035 TO |
289 | |
290 | SELECT @contributeCompId := max(id) FROM civicrm_component where name = 'CiviContribute'; | |
291 | SELECT @eventCompId := max(id) FROM civicrm_component where name = 'CiviEvent'; | |
292 | SELECT @memberCompId := max(id) FROM civicrm_component where name = 'CiviMember'; | |
293 | SELECT @pledgeCompId := max(id) FROM civicrm_component where name = 'CiviPledge'; | |
294 | SELECT @caseCompId := max(id) FROM civicrm_component where name = 'CiviCase'; | |
295 | SELECT @grantCompId := max(id) FROM civicrm_component where name = 'CiviGrant'; | |
296 | SELECT @campaignCompId := max(id) FROM civicrm_component where name = 'CiviCampaign'; | |
297 | SELECT @mailCompId := max(id) FROM civicrm_component where name = 'CiviMail'; | |
298 | ||
299 | INSERT 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`) | |
301 | VALUES | |
2e26e3ba CW |
302 | (@option_group_id_pcm, '{ts escape="sql"}Phone{/ts}', 1, 'Phone', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
303 | (@option_group_id_pcm, '{ts escape="sql"}Email{/ts}', 2, 'Email', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
304 | (@option_group_id_pcm, '{ts escape="sql"}Postal Mail{/ts}', 3, 'Postal Mail', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
305 | (@option_group_id_pcm, '{ts escape="sql"}SMS{/ts}', 4, 'SMS', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
306 | (@option_group_id_pcm, '{ts escape="sql"}Fax{/ts}', 5, 'Fax', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 | 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), | |
d9235b45 | 379 | -- for manual contact merge |
a52928d9 | 380 | (@option_group_id_act, '{ts escape="sql"}Contact Merged{/ts}', 51, 'Contact Merged', NULL, 1, NULL, 51, '{ts escape="sql"}Contact Merged{/ts}',0, 1, 1, NULL, NULL), |
2429e40c | 381 | |
6a488035 TO |
382 | (@option_group_id_gender, '{ts escape="sql"}Female{/ts}', 1, 'Female', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
383 | (@option_group_id_gender, '{ts escape="sql"}Male{/ts}', 2, 'Male', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
384 | (@option_group_id_gender, '{ts escape="sql"}Transgender{/ts}', 3, 'Transgender', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
385 | ||
386 | (@option_group_id_IMProvider, 'Yahoo', 1, 'Yahoo', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
387 | (@option_group_id_IMProvider, 'MSN', 2, 'Msn', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
388 | (@option_group_id_IMProvider, 'AIM', 3, 'Aim', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
389 | (@option_group_id_IMProvider, 'GTalk', 4, 'Gtalk', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
390 | (@option_group_id_IMProvider, 'Jabber',5, 'Jabber',NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
391 | (@option_group_id_IMProvider, 'Skype', 6, 'Skype', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
392 | ||
393 | (@option_group_id_mobileProvider, 'Sprint' , 1, 'Sprint' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
394 | (@option_group_id_mobileProvider, 'Verizon' , 2, 'Verizon' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
395 | (@option_group_id_mobileProvider, 'Cingular', 3, 'Cingular', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
396 | ||
397 | (@option_group_id_prefix, '{ts escape="sql"}Mrs.{/ts}', 1, 'Mrs.', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
398 | (@option_group_id_prefix, '{ts escape="sql"}Ms.{/ts}', 2, 'Ms.', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
399 | (@option_group_id_prefix, '{ts escape="sql"}Mr.{/ts}', 3, 'Mr.', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
400 | (@option_group_id_prefix, '{ts escape="sql"}Dr.{/ts}', 4, 'Dr.', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
401 | ||
402 | (@option_group_id_suffix, '{ts escape="sql"}Jr.{/ts}', 1, 'Jr.', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
403 | (@option_group_id_suffix, '{ts escape="sql"}Sr.{/ts}', 2, 'Sr.', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
404 | (@option_group_id_suffix, 'II', 3, 'II', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
405 | (@option_group_id_suffix, 'III', 4, 'III', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
406 | (@option_group_id_suffix, 'IV', 5, 'IV', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
407 | (@option_group_id_suffix, 'V', 6, 'V', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
408 | (@option_group_id_suffix, 'VI', 7, 'VI', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
409 | (@option_group_id_suffix, 'VII', 8, 'VII', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
410 | ||
411 | (@option_group_id_aclRole, '{ts escape="sql"}Administrator{/ts}', 1, 'Admin', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
412 | (@option_group_id_aclRole, '{ts escape="sql"}Authenticated{/ts}', 2, 'Auth' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
413 | ||
414 | (@option_group_id_acc, 'Visa' , 1, 'Visa' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
415 | (@option_group_id_acc, 'MasterCard', 2, 'MasterCard', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
416 | (@option_group_id_acc, 'Amex' , 3, 'Amex' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
417 | (@option_group_id_acc, 'Discover' , 4, 'Discover' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
418 | ||
d96cf288 DG |
419 | (@option_group_id_pi, '{ts escape="sql"}Credit Card{/ts}', 1, 'Credit Card', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL), |
420 | (@option_group_id_pi, '{ts escape="sql"}Debit Card{/ts}', 2, 'Debit Card', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL), | |
421 | (@option_group_id_pi, '{ts escape="sql"}Cash{/ts}', 3, 'Cash', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL), | |
422 | (@option_group_id_pi, '{ts escape="sql"}Check{/ts}', 4, 'Check', NULL, 0, 1, 4, NULL, 0, 1, 1, NULL, NULL), | |
423 | (@option_group_id_pi, '{ts escape="sql"}EFT{/ts}', 5, 'EFT', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 TO |
424 | |
425 | (@option_group_id_cs, '{ts escape="sql"}Completed{/ts}' , 1, 'Completed' , NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL), | |
426 | (@option_group_id_cs, '{ts escape="sql"}Pending{/ts}' , 2, 'Pending' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
427 | (@option_group_id_cs, '{ts escape="sql"}Cancelled{/ts}' , 3, 'Cancelled' , NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL), | |
428 | (@option_group_id_cs, '{ts escape="sql"}Failed{/ts}' , 4, 'Failed' , NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL, NULL), | |
429 | (@option_group_id_cs, '{ts escape="sql"}In Progress{/ts}', 5, 'In Progress', NULL, 0, NULL, 5, NULL, 0, 1, 1, NULL, NULL), | |
430 | (@option_group_id_cs, '{ts escape="sql"}Overdue{/ts}' , 6, 'Overdue' , NULL, 0, NULL, 6, NULL, 0, 1, 1, NULL, NULL), | |
431 | (@option_group_id_cs, '{ts escape="sql"}Refunded{/ts}' , 7, 'Refunded' , NULL, 0, NULL, 7, NULL, 0, 1, 1, NULL, NULL), | |
59e44db1 | 432 | (@option_group_id_cs, '{ts escape="sql"}Partially paid{/ts}', 8, 'Partially paid', NULL, 0, NULL, 8, NULL, 0, 1, 1, NULL, NULL), |
0f602e3f | 433 | (@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 |
434 | |
435 | (@option_group_id_pcp, '{ts escape="sql"}Waiting Review{/ts}', 1, 'Waiting Review', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL), | |
436 | (@option_group_id_pcp, '{ts escape="sql"}Approved{/ts}' , 2, 'Approved' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
437 | (@option_group_id_pcp, '{ts escape="sql"}Not Approved{/ts}' , 3, 'Not Approved' , NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL), | |
438 | ||
12f92dbd N |
439 | (@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), |
440 | (@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), | |
441 | (@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), | |
442 | ||
6a488035 TO |
443 | (@option_group_id_pRole, '{ts escape="sql"}Attendee{/ts}', 1, 'Attendee', NULL, 1, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
444 | (@option_group_id_pRole, '{ts escape="sql"}Volunteer{/ts}', 2, 'Volunteer', NULL, 1, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
445 | (@option_group_id_pRole, '{ts escape="sql"}Host{/ts}', 3, 'Host', NULL, 1, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
446 | (@option_group_id_pRole, '{ts escape="sql"}Speaker{/ts}', 4, 'Speaker', NULL, 1, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
447 | ||
448 | (@option_group_id_etype, '{ts escape="sql"}Conference{/ts}', 1, 'Conference', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
449 | (@option_group_id_etype, '{ts escape="sql"}Exhibition{/ts}', 2, 'Exhibition', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
450 | (@option_group_id_etype, '{ts escape="sql"}Fundraiser{/ts}', 3, 'Fundraiser', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
451 | (@option_group_id_etype, '{ts escape="sql"}Meeting{/ts}', 4, 'Meeting', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
452 | (@option_group_id_etype, '{ts escape="sql"}Performance{/ts}',5, 'Performance', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
453 | (@option_group_id_etype, '{ts escape="sql"}Workshop{/ts}', 6, 'Workshop', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
454 | ||
455 | -- note that these are not ts'ed since they are used for logic in most cases and not display | |
456 | -- they are used for display only in the prefernces field settings | |
457 | (@option_group_id_cvOpt, '{ts escape="sql"}Activities{/ts}' , 1, 'activity', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
458 | (@option_group_id_cvOpt, '{ts escape="sql"}Relationships{/ts}', 2, 'rel', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
459 | (@option_group_id_cvOpt, '{ts escape="sql"}Groups{/ts}' , 3, 'group', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
460 | (@option_group_id_cvOpt, '{ts escape="sql"}Notes{/ts}' , 4, 'note', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
461 | (@option_group_id_cvOpt, '{ts escape="sql"}Tags{/ts}' , 5, 'tag', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
462 | (@option_group_id_cvOpt, '{ts escape="sql"}Change Log{/ts}' , 6, 'log', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
463 | (@option_group_id_cvOpt, '{ts escape="sql"}Contributions{/ts}', 7, 'CiviContribute', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
464 | (@option_group_id_cvOpt, '{ts escape="sql"}Memberships{/ts}' , 8, 'CiviMember', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
465 | (@option_group_id_cvOpt, '{ts escape="sql"}Events{/ts}' , 9, 'CiviEvent', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL), | |
466 | (@option_group_id_cvOpt, '{ts escape="sql"}Cases{/ts}' , 10, 'CiviCase', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL), | |
467 | (@option_group_id_cvOpt, '{ts escape="sql"}Grants{/ts}' , 11, 'CiviGrant', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL), | |
468 | (@option_group_id_cvOpt, '{ts escape="sql"}Pledges{/ts}' , 13, 'CiviPledge', NULL, 0, NULL, 13, NULL, 0, 0, 1, NULL, NULL), | |
5c61cec2 | 469 | (@option_group_id_cvOpt, '{ts escape="sql"}Mailings{/ts}' , 14, 'CiviMail', NULL, 0, NULL, 14, NULL, 0, 0, 1, NULL, NULL), |
6a488035 | 470 | |
8acb3461 KJ |
471 | |
472 | (@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), | |
473 | (@option_group_id_csgOpt, '{ts escape="sql"}Always Show Smart Groups{/ts}', 2, 'alwaysshow', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
474 | (@option_group_id_csgOpt, '{ts escape="sql"}Hide Smart Groups{/ts}' , 3, 'hide', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
475 | ||
6a488035 TO |
476 | (@option_group_id_ceOpt, '{ts escape="sql"}Custom Data{/ts}' , 1, 'CustomData', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
477 | (@option_group_id_ceOpt, '{ts escape="sql"}Address{/ts}' , 2, 'Address', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
478 | (@option_group_id_ceOpt, '{ts escape="sql"}Communication Preferences{/ts}', 3, 'CommunicationPreferences', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
479 | (@option_group_id_ceOpt, '{ts escape="sql"}Notes{/ts}' , 4, 'Notes', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
480 | (@option_group_id_ceOpt, '{ts escape="sql"}Demographics{/ts}' , 5, 'Demographics', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
481 | (@option_group_id_ceOpt, '{ts escape="sql"}Tags and Groups{/ts}' , 6, 'TagsAndGroups', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
482 | (@option_group_id_ceOpt, '{ts escape="sql"}Email{/ts}' , 7, 'Email', NULL, 1, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
483 | (@option_group_id_ceOpt, '{ts escape="sql"}Phone{/ts}' , 8, 'Phone', NULL, 1, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
484 | (@option_group_id_ceOpt, '{ts escape="sql"}Instant Messenger{/ts}' , 9, 'IM', NULL, 1, NULL, 9, NULL, 0, 0, 1, NULL, NULL), | |
485 | (@option_group_id_ceOpt, '{ts escape="sql"}Open ID{/ts}' , 10, 'OpenID', NULL, 1, NULL, 10, NULL, 0, 0, 1, NULL, NULL), | |
486 | (@option_group_id_ceOpt, '{ts escape="sql"}Website{/ts}' , 11, 'Website', NULL, 1, NULL, 11, NULL, 0, 0, 1, NULL, NULL), | |
8b49cb50 OB |
487 | (@option_group_id_ceOpt, '{ts escape="sql"}Prefix{/ts}' , 12, 'Prefix', NULL, 2, NULL, 12, NULL, 0, 0, 1, NULL, NULL), |
488 | (@option_group_id_ceOpt, '{ts escape="sql"}Formal Title{/ts}' , 13, 'Formal Title', NULL, 2, NULL, 13, NULL, 0, 0, 1, NULL, NULL), | |
489 | (@option_group_id_ceOpt, '{ts escape="sql"}First Name{/ts}' , 14, 'First Name', NULL, 2, NULL, 14, NULL, 0, 0, 1, NULL, NULL), | |
490 | (@option_group_id_ceOpt, '{ts escape="sql"}Middle Name{/ts}' , 15, 'Middle Name', NULL, 2, NULL, 15, NULL, 0, 0, 1, NULL, NULL), | |
491 | (@option_group_id_ceOpt, '{ts escape="sql"}Last Name{/ts}' , 16, 'Last Name', NULL, 2, NULL, 16, NULL, 0, 0, 1, NULL, NULL), | |
492 | (@option_group_id_ceOpt, '{ts escape="sql"}Suffix{/ts}' , 17, 'Suffix', NULL, 2, NULL, 17, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 TO |
493 | |
494 | (@option_group_id_asOpt, '{ts escape="sql"}Address Fields{/ts}' , 1, 'location', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
495 | (@option_group_id_asOpt, '{ts escape="sql"}Custom Fields{/ts}' , 2, 'custom', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
496 | (@option_group_id_asOpt, '{ts escape="sql"}Activities{/ts}' , 3, 'activity', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
497 | (@option_group_id_asOpt, '{ts escape="sql"}Relationships{/ts}' , 4, 'relationship', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
498 | (@option_group_id_asOpt, '{ts escape="sql"}Notes{/ts}' , 5, 'notes', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
499 | (@option_group_id_asOpt, '{ts escape="sql"}Change{/ts} Log' , 6, 'changeLog', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
500 | (@option_group_id_asOpt, '{ts escape="sql"}Contributions{/ts}' , 7, 'CiviContribute', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
501 | (@option_group_id_asOpt, '{ts escape="sql"}Memberships{/ts}' , 8, 'CiviMember', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL), | |
502 | (@option_group_id_asOpt, '{ts escape="sql"}Events{/ts}' , 9, 'CiviEvent', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL), | |
503 | (@option_group_id_asOpt, '{ts escape="sql"}Cases{/ts}' , 10, 'CiviCase', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL), | |
504 | {if 0} {* Temporary hack to eliminate Kabissa checkbox in site preferences. *} | |
505 | (@option_group_id_asOpt, 'Kabissa' , 11, NULL, NULL, 0, NULL, 13, NULL, 0, 0, 1, NULL, NULL), | |
506 | {/if} | |
507 | (@option_group_id_asOpt, 'Grants' , 12, 'CiviGrant', NULL, 0, NULL, 14, NULL, 0, 0, 1, NULL, NULL), | |
508 | (@option_group_id_asOpt, '{ts escape="sql"}Demographics{/ts}' , 13, 'demographics', NULL, 0, NULL, 15, NULL, 0, 0, 1, NULL, NULL), | |
509 | (@option_group_id_asOpt, '{ts escape="sql"}Pledges{/ts}' , 15, 'CiviPledge', NULL, 0, NULL, 17, NULL, 0, 0, 1, NULL, NULL), | |
510 | (@option_group_id_asOpt, '{ts escape="sql"}Contact Type{/ts}' , 16, 'contactType', NULL, 0, NULL, 18, NULL, 0, 0, 1, NULL, NULL), | |
511 | (@option_group_id_asOpt, '{ts escape="sql"}Groups{/ts}' , 17, 'groups', NULL, 0, NULL, 19, NULL, 0, 0, 1, NULL, NULL), | |
512 | (@option_group_id_asOpt, '{ts escape="sql"}Tags{/ts}' , 18, 'tags', NULL, 0, NULL, 20, NULL, 0, 0, 1, NULL, NULL), | |
513 | (@option_group_id_asOpt, '{ts escape="sql"}Mailing{/ts}' , 19, 'CiviMail', NULL, 0, NULL, 21, NULL, 0, 0, 1, NULL, NULL), | |
514 | ||
515 | (@option_group_id_udOpt, '{ts escape="sql"}Groups{/ts}' , 1, 'Groups', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
516 | (@option_group_id_udOpt, '{ts escape="sql"}Contributions{/ts}' , 2, 'CiviContribute', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
517 | (@option_group_id_udOpt, '{ts escape="sql"}Memberships{/ts}' , 3, 'CiviMember', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
518 | (@option_group_id_udOpt, '{ts escape="sql"}Events{/ts}' , 4, 'CiviEvent', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
519 | (@option_group_id_udOpt, '{ts escape="sql"}My Contacts / Organizations{/ts}', 5, 'Permissioned Orgs', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
520 | (@option_group_id_udOpt, '{ts escape="sql"}Pledges{/ts}' , 7, 'CiviPledge', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
521 | (@option_group_id_udOpt, '{ts escape="sql"}Personal Campaign Pages{/ts}' , 8, 'PCP', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
522 | (@option_group_id_udOpt, '{ts escape="sql"}Assigned Activities{/ts}' , 9, 'Assigned Activities', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL), | |
56ed0b01 | 523 | (@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 |
524 | |
525 | (@option_group_id_acsOpt, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
526 | (@option_group_id_acsOpt, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
527 | (@option_group_id_acsOpt, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
528 | (@option_group_id_acsOpt, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
529 | (@option_group_id_acsOpt, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
530 | (@option_group_id_acsOpt, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
3d8c6ffe | 531 | (@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 |
532 | |
533 | (@option_group_id_acConRef, '{ts escape="sql"}Email Address{/ts}' , 2, 'email' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
534 | (@option_group_id_acConRef, '{ts escape="sql"}Phone{/ts}' , 3, 'phone' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
535 | (@option_group_id_acConRef, '{ts escape="sql"}Street Address{/ts}' , 4, 'street_address', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
536 | (@option_group_id_acConRef, '{ts escape="sql"}City{/ts}' , 5, 'city' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
537 | (@option_group_id_acConRef, '{ts escape="sql"}State/Province{/ts}' , 6, 'state_province', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
538 | (@option_group_id_acConRef, '{ts escape="sql"}Country{/ts}' , 7, 'country' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
3d8c6ffe | 539 | (@option_group_id_acConRef, '{ts escape="sql"}Postal Code{/ts}' , 8, 'country' , NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), |
6a488035 TO |
540 | |
541 | (@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 |
542 | (@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), |
543 | (@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 |
544 | (@option_group_id_adOpt, '{ts escape="sql"}City{/ts}' , 4, 'city' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), |
545 | (@option_group_id_adOpt, '{ts escape="sql"}Zip / Postal Code{/ts}' , 5, 'postal_code' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
546 | (@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), | |
547 | (@option_group_id_adOpt, '{ts escape="sql"}County{/ts}' , 7, 'county' , NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
757069de | 548 | (@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 |
549 | (@option_group_id_adOpt, '{ts escape="sql"}Country{/ts}' , 9, 'country' , NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL), |
550 | (@option_group_id_adOpt, '{ts escape="sql"}Latitude{/ts}' , 10, 'geo_code_1' , NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL), | |
551 | (@option_group_id_adOpt, '{ts escape="sql"}Longitude{/ts}' , 11, 'geo_code_2', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL), | |
552 | (@option_group_id_adOpt, '{ts escape="sql"}Address Name{/ts}' , 12, 'address_name', NULL, 0, NULL, 12, NULL, 0, 0, 1, NULL, NULL), | |
553 | (@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), | |
554 | ||
32cbca85 CW |
555 | (@option_group_id_gType, '{ts escape="sql"}Access Control{/ts}', 1, 'Access Control', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL), |
556 | (@option_group_id_gType, '{ts escape="sql"}Mailing List{/ts}', 2, 'Mailing List', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
6a488035 | 557 | |
5948c543 DG |
558 | (@option_group_id_grantSt, '{ts escape="sql"}Submitted{/ts}', 1, 'Submitted', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL), |
559 | (@option_group_id_grantSt, '{ts escape="sql"}Eligible{/ts}', 2, 'Eligible', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
560 | (@option_group_id_grantSt, '{ts escape="sql"}Ineligible{/ts}', 3, 'Ineligible', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
561 | (@option_group_id_grantSt, '{ts escape="sql"}Paid{/ts}', 4, 'Paid', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
562 | (@option_group_id_grantSt, '{ts escape="sql"}Awaiting Information{/ts}', 5, 'Awaiting Information', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
563 | (@option_group_id_grantSt, '{ts escape="sql"}Withdrawn{/ts}', 6, 'Withdrawn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
564 | (@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 |
565 | |
566 | (@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), | |
567 | (@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), | |
568 | (@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), | |
569 | (@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), | |
570 | (@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), | |
571 | (@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), | |
572 | (@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), | |
573 | (@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), | |
574 | (@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), | |
575 | (@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), | |
576 | (@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), | |
577 | (@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), | |
578 | (@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), | |
579 | (@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), | |
580 | (@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), | |
581 | ||
582 | -- report templates | |
583 | (@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), | |
584 | (@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), | |
585 | (@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), | |
e4f46be0 | 586 | (@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 targeted contacts{/ts}', 0, 0, 0, NULL, NULL), |
6a488035 TO |
587 | (@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), |
588 | (@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), | |
589 | (@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), | |
590 | (@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), | |
591 | (@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), | |
592 | (@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), | |
593 | (@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), | |
594 | (@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), | |
595 | (@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), | |
596 | (@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), | |
597 | (@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), | |
598 | (@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), | |
599 | (@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), | |
600 | (@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), | |
601 | (@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), | |
602 | (@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), | |
603 | (@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 | 604 | (@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 |
605 | (@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), |
606 | (@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 | 607 | (@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 |
608 | (@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), |
609 | (@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), | |
610 | (@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), | |
611 | (@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), | |
612 | (@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), | |
613 | (@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), | |
614 | (@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), | |
615 | (@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), | |
616 | (@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), | |
617 | (@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), | |
618 | (@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), | |
619 | (@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), | |
620 | (@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), | |
621 | (@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), | |
622 | (@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), | |
623 | (@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), | |
624 | (@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), | |
625 | (@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), | |
626 | (@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), | |
627 | (@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 | 628 | (@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 |
629 | (@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), |
630 | (@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 | 631 | (@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 |
632 | |
633 | (@option_group_id_acs, '{ts escape="sql"}Scheduled{/ts}', 1, 'Scheduled', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL), | |
634 | (@option_group_id_acs, '{ts escape="sql"}Completed{/ts}', 2, 'Completed', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
635 | (@option_group_id_acs, '{ts escape="sql"}Cancelled{/ts}', 3, 'Cancelled', NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL), | |
636 | (@option_group_id_acs, '{ts escape="sql"}Left Message{/ts}', 4, 'Left Message', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
637 | (@option_group_id_acs, '{ts escape="sql"}Unreachable{/ts}', 5, 'Unreachable', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
638 | (@option_group_id_acs, '{ts escape="sql"}Not Required{/ts}', 6, 'Not Required', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
187e382a | 639 | (@option_group_id_acs, '{ts escape="sql"}Available{/ts}', 7, 'Available', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), |
5b8e40ab | 640 | (@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 |
641 | |
642 | (@option_group_id_cas, '{ts escape="sql"}Ongoing{/ts}' , 1, 'Open' , 'Opened', 0, 1, 1, NULL, 0, 1, 1, NULL, NULL), | |
643 | (@option_group_id_cas, '{ts escape="sql"}Resolved{/ts}', 2, 'Closed', 'Closed', 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
644 | (@option_group_id_cas, '{ts escape="sql"}Urgent{/ts}' , 3, 'Urgent', 'Opened', 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
645 | ||
646 | (@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), | |
647 | (@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), | |
648 | (@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), | |
649 | ||
2e26e3ba CW |
650 | (@option_group_id_sfe, 'jpg', 1, 'jpg', NULL, 0, 0, 1, NULL, 0, 0, 1, NULL, NULL), |
651 | (@option_group_id_sfe, 'jpeg', 2, 'jpeg', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL), | |
652 | (@option_group_id_sfe, 'png', 3, 'png', NULL, 0, 0, 3, NULL, 0, 0, 1, NULL, NULL), | |
653 | (@option_group_id_sfe, 'gif', 4, 'gif', NULL, 0, 0, 4, NULL, 0, 0, 1, NULL, NULL), | |
654 | (@option_group_id_sfe, 'txt', 5, 'txt', NULL, 0, 0, 5, NULL, 0, 0, 1, NULL, NULL), | |
655 | (@option_group_id_sfe, 'pdf', 6, 'pdf', NULL, 0, 0, 6, NULL, 0, 0, 1, NULL, NULL), | |
656 | (@option_group_id_sfe, 'doc', 7, 'doc', NULL, 0, 0, 7, NULL, 0, 0, 1, NULL, NULL), | |
657 | (@option_group_id_sfe, 'xls', 8, 'xls', NULL, 0, 0, 8, NULL, 0, 0, 1, NULL, NULL), | |
658 | (@option_group_id_sfe, 'rtf', 9, 'rtf', NULL, 0, 0, 9, NULL, 0, 0, 1, NULL, NULL), | |
659 | (@option_group_id_sfe, 'csv', 10, 'csv', NULL, 0, 0, 10, NULL, 0, 0, 1, NULL, NULL), | |
660 | (@option_group_id_sfe, 'ppt', 11, 'ppt', NULL, 0, 0, 11, NULL, 0, 0, 1, NULL, NULL), | |
661 | (@option_group_id_sfe, 'docx', 12, 'docx', NULL, 0, 0, 12, NULL, 0, 0, 1, NULL, NULL), | |
662 | (@option_group_id_sfe, 'xlsx', 13, 'xlsx', NULL, 0, 0, 13, NULL, 0, 0, 1, NULL, NULL), | |
663 | ||
2e26e3ba | 664 | (@option_group_id_we, 'CKEditor', 2, 'CKEditor', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), |
6a488035 TO |
665 | |
666 | (@option_group_id_mt, '{ts escape="sql"}Search Builder{/ts}', 1, 'Search Builder', NULL, 0, 0, 1, NULL, 0, 1, 1, NULL, NULL), | |
667 | (@option_group_id_mt, '{ts escape="sql"}Import Contact{/ts}', 2, 'Import Contact', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL), | |
668 | (@option_group_id_mt, '{ts escape="sql"}Import Activity{/ts}', 3, 'Import Activity', NULL, 0, 0, 3, NULL, 0, 1, 1, NULL, NULL), | |
669 | (@option_group_id_mt, '{ts escape="sql"}Import Contribution{/ts}', 4, 'Import Contribution', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL), | |
670 | (@option_group_id_mt, '{ts escape="sql"}Import Membership{/ts}', 5, 'Import Membership', NULL, 0, 0, 5, NULL, 0, 1, 1, NULL, NULL), | |
671 | (@option_group_id_mt, '{ts escape="sql"}Import Participant{/ts}', 6, 'Import Participant', NULL, 0, 0, 6, NULL, 0, 1, 1, NULL, NULL), | |
672 | (@option_group_id_mt, '{ts escape="sql"}Export Contact{/ts}', 7, 'Export Contact', NULL, 0, 0, 7, NULL, 0, 1, 1, NULL, NULL), | |
673 | (@option_group_id_mt, '{ts escape="sql"}Export Contribution{/ts}', 8, 'Export Contribution', NULL, 0, 0, 8, NULL, 0, 1, 1, NULL, NULL), | |
674 | (@option_group_id_mt, '{ts escape="sql"}Export Membership{/ts}', 9, 'Export Membership', NULL, 0, 0, 9, NULL, 0, 1, 1, NULL, NULL), | |
675 | (@option_group_id_mt, '{ts escape="sql"}Export Participant{/ts}', 10, 'Export Participant', NULL, 0, 0, 10, NULL, 0, 1, 1, NULL, NULL), | |
676 | (@option_group_id_mt, '{ts escape="sql"}Export Pledge{/ts}', 11, 'Export Pledge', NULL, 0, 0, 11, NULL, 0, 1, 1, NULL, NULL), | |
677 | (@option_group_id_mt, '{ts escape="sql"}Export Case{/ts}', 12, 'Export Case', NULL, 0, 0, 12, NULL, 0, 1, 1, NULL, NULL), | |
678 | (@option_group_id_mt, '{ts escape="sql"}Export Grant{/ts}', 13, 'Export Grant', NULL, 0, 0, 13, NULL, 0, 1, 1, NULL, NULL), | |
679 | (@option_group_id_mt, '{ts escape="sql"}Export Activity{/ts}', 14, 'Export Activity', NULL, 0, 0, 14, NULL, 0, 1, 1, NULL, NULL), | |
680 | ||
681 | (@option_group_id_fu, '{ts escape="sql"}day{/ts}' , 'day' , 'day', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL), | |
682 | (@option_group_id_fu, '{ts escape="sql"}week{/ts}' , 'week' , 'week', NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL), | |
683 | (@option_group_id_fu, '{ts escape="sql"}month{/ts}' , 'month', 'month', NULL, 0, NULL, 3, NULL, 0, 1, 1, NULL, NULL), | |
684 | (@option_group_id_fu, '{ts escape="sql"}year{/ts}' , 'year' , 'year', NULL, 0, NULL, 4, NULL, 0, 1, 1, NULL, NULL), | |
685 | ||
686 | -- phone types. | |
687 | (@option_group_id_pht, '{ts escape="sql"}Phone{/ts}' , 1, 'Phone' , NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
688 | (@option_group_id_pht, '{ts escape="sql"}Mobile{/ts}', 2, 'Mobile' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
689 | (@option_group_id_pht, '{ts escape="sql"}Fax{/ts}' , 3, 'Fax' , NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
690 | (@option_group_id_pht, '{ts escape="sql"}Pager{/ts}' , 4, 'Pager' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
691 | (@option_group_id_pht, '{ts escape="sql"}Voicemail{/ts}' , 5, 'Voicemail' , NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
692 | ||
693 | -- custom data types. | |
694 | (@option_group_id_cdt, 'Participant Role', '1', 'ParticipantRole', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ), | |
695 | (@option_group_id_cdt, 'Participant Event Name', '2', 'ParticipantEventName', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ), | |
696 | (@option_group_id_cdt, 'Participant Event Type', '3', 'ParticipantEventType', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ), | |
697 | ||
698 | -- visibility. | |
699 | (@option_group_id_vis, 'Public', 1, 'public', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ), | |
700 | (@option_group_id_vis, 'Admin', 2, 'admin', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ), | |
701 | ||
702 | -- mail protocol. | |
703 | (@option_group_id_mp, 'IMAP', 1, 'IMAP', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ), | |
704 | (@option_group_id_mp, 'Maildir', 2, 'Maildir', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ), | |
705 | (@option_group_id_mp, 'POP3', 3, 'POP3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ), | |
706 | (@option_group_id_mp, 'Localdir', 4, 'Localdir', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL ), | |
707 | ||
708 | -- priority | |
709 | (@option_group_id_priority, '{ts escape="sql"}Urgent{/ts}', 1, 'Urgent', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
710 | (@option_group_id_priority, '{ts escape="sql"}Normal{/ts}', 2, 'Normal', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
711 | (@option_group_id_priority, '{ts escape="sql"}Low{/ts}', 3, 'Low', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
712 | ||
2e26e3ba CW |
713 | -- redaction rule FIXME: should this be in sample data instead? |
714 | (@option_group_id_rr, 'Vancouver', 'city_', 'city_', NULL, 0, NULL, 1, NULL, 0, 0, 0, NULL, NULL), | |
715 | (@option_group_id_rr, '{literal}/(19|20)(\\d{2})-(\\d{1,2})-(\\d{1,2})/{/literal}', 'date_', 'date_', NULL, 1, NULL, 2, NULL, 0, 0, 0, NULL, NULL), | |
6a488035 TO |
716 | |
717 | -- email greeting. | |
718 | (@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), | |
719 | (@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), | |
720 | (@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), | |
721 | (@option_group_id_emailGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL), | |
548dc5ed | 722 | (@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 |
723 | -- postal greeting. |
724 | (@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), | |
725 | (@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), | |
726 | (@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), | |
727 | (@option_group_id_postalGreeting, '{literal}Customized{/literal}', 4, '{literal}Customized{/literal}', NULL, 0, 0, 4, NULL, 0, 1, 1, NULL, NULL), | |
548dc5ed | 728 | (@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 |
729 | |
730 | -- addressee | |
731 | (@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), | |
732 | (@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), | |
733 | (@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), | |
734 | (@option_group_id_addressee, '{literal}Customized{/literal}', '4', '{literal}Customized{/literal}', NULL , 0 , '0', '4', NULL , '0', '1', '1', NULL , NULL), | |
735 | ||
6a488035 | 736 | -- website type |
887e764d PN |
737 | (@option_group_id_website, 'Work', 1, 'Work', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL), |
738 | (@option_group_id_website, 'Main', 2, 'Main', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 | 739 | (@option_group_id_website, 'Facebook', 3, 'Facebook', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), |
887e764d PN |
740 | (@option_group_id_website, 'Google+', 4, 'Google_', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), |
741 | (@option_group_id_website, 'Instagram', 5, 'Instagram', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
742 | (@option_group_id_website, 'LinkedIn', 6, 'LinkedIn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL), | |
743 | (@option_group_id_website, 'MySpace', 7, 'MySpace', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL), | |
744 | (@option_group_id_website, 'Pinterest', 8, 'Pinterest', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL), | |
745 | (@option_group_id_website, 'SnapChat', 9, 'SnapChat', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL), | |
746 | (@option_group_id_website, 'Tumblr', 10, 'Tumblr', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL), | |
747 | (@option_group_id_website, 'Twitter', 11, 'Twitter', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL), | |
748 | (@option_group_id_website, 'Vine', 12, 'Vine ', NULL, 0, NULL, 12, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 TO |
749 | |
750 | -- Tag used for | |
751 | (@option_group_id_tuf, 'Contacts', 'civicrm_contact', 'Contacts', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
752 | (@option_group_id_tuf, 'Activities', 'civicrm_activity', 'Activities', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
753 | (@option_group_id_tuf, 'Cases', 'civicrm_case', 'Cases', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
754 | (@option_group_id_tuf, 'Attachments','civicrm_file', 'Attachements', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
755 | ||
756 | (@option_group_id_currency, 'USD ($)', 'USD', 'USD', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL), | |
757 | ||
758 | -- event name badges | |
759 | (@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), | |
760 | (@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), | |
761 | (@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 ), | |
762 | (@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 ), | |
763 | ||
764 | -- note privacy levels | |
2e26e3ba CW |
765 | (@option_group_id_notePrivacy, '{ts escape="sql"}None{/ts}', 0, 'None', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL), |
766 | (@option_group_id_notePrivacy, '{ts escape="sql"}Author Only{/ts}', 1, 'Author Only', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL), | |
6a488035 TO |
767 | |
768 | -- Compaign Types | |
769 | (@option_group_id_campaignType, '{ts escape="sql"}Direct Mail{/ts}', 1, 'Direct Mail', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
770 | (@option_group_id_campaignType, '{ts escape="sql"}Referral Program{/ts}', 2, 'Referral Program', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
771 | (@option_group_id_campaignType, '{ts escape="sql"}Constituent Engagement{/ts}', 3, 'Constituent Engagement', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
772 | ||
773 | -- Campaign Status | |
774 | (@option_group_id_campaignStatus, '{ts escape="sql"}Planned{/ts}', 1, 'Planned', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
775 | (@option_group_id_campaignStatus, '{ts escape="sql"}In Progress{/ts}', 2, 'In Progress', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
776 | (@option_group_id_campaignStatus, '{ts escape="sql"}Completed{/ts}', 3, 'Completed', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
777 | (@option_group_id_campaignStatus, '{ts escape="sql"}Cancelled{/ts}', 4, 'Cancelled', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
778 | ||
779 | -- Engagement Level | |
780 | (@option_group_id_engagement_index, '{ts escape="sql"}1{/ts}', 1, '1', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL ), | |
781 | (@option_group_id_engagement_index, '{ts escape="sql"}2{/ts}', 2, '2', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL ), | |
782 | (@option_group_id_engagement_index, '{ts escape="sql"}3{/ts}', 3, '3', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL ), | |
783 | (@option_group_id_engagement_index, '{ts escape="sql"}4{/ts}', 4, '4', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL ), | |
784 | (@option_group_id_engagement_index, '{ts escape="sql"}5{/ts}', 5, '5', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL ), | |
785 | ||
786 | -- Paper Sizes | |
787 | (@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), | |
788 | (@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), | |
789 | (@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), | |
790 | (@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), | |
791 | (@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), | |
792 | (@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), | |
793 | (@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), | |
794 | (@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), | |
795 | (@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), | |
796 | (@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), | |
797 | (@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), | |
798 | (@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), | |
799 | (@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), | |
800 | (@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), | |
801 | (@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), | |
802 | (@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), | |
803 | (@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), | |
804 | (@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), | |
805 | (@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), | |
806 | (@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), | |
807 | (@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), | |
808 | (@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), | |
809 | (@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), | |
810 | (@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), | |
811 | (@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), | |
812 | (@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), | |
813 | (@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), | |
814 | (@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), | |
815 | (@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), | |
816 | (@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), | |
817 | (@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), | |
818 | (@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), | |
819 | (@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), | |
820 | (@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), | |
821 | (@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), | |
822 | (@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), | |
823 | (@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), | |
824 | (@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), | |
825 | (@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), | |
826 | (@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), | |
827 | (@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), | |
828 | (@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), | |
829 | (@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), | |
830 | (@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), | |
831 | (@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), | |
832 | (@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), | |
833 | (@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), | |
834 | (@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), | |
835 | (@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), | |
836 | (@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), | |
837 | (@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), | |
838 | (@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), | |
839 | (@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), | |
840 | (@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), | |
841 | (@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), | |
842 | (@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), | |
843 | (@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), | |
844 | (@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), | |
845 | (@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), | |
846 | (@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), | |
847 | (@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), | |
848 | (@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), | |
849 | ||
850 | -- activity_contacts | |
851 | (@option_group_id_aco, '{ts escape="sql"}Activity Assignees{/ts}', 1, 'Activity Assignees', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
852 | (@option_group_id_aco, '{ts escape="sql"}Activity Source{/ts}', 2, 'Activity Source', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
853 | (@option_group_id_aco, '{ts escape="sql"}Activity Targets{/ts}', 3, 'Activity Targets', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
854 | ||
855 | -- financial_account_type | |
856 | -- grouping field is specific to Quickbooks for mapping to .iif format | |
857 | (@option_group_id_fat, '{ts escape="sql"}Asset{/ts}', 1, 'Asset', NULL, 0, 0, 1, 'Things you own', 0, 1, 1, 2, NULL), | |
858 | (@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), | |
859 | (@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), | |
860 | (@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), | |
861 | (@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), | |
862 | ||
863 | -- account_relationship | |
864 | (@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), | |
865 | (@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), | |
866 | (@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), | |
867 | (@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), | |
868 | (@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), | |
869 | (@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), | |
870 | (@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), | |
871 | (@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), | |
872 | (@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 | 873 | (@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 |
874 | |
875 | -- event_contacts | |
876 | (@option_group_id_ere, '{ts escape="sql"}Participant Role{/ts}', 1, 'participant_role', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
877 | ||
878 | -- default conference slots | |
9b6dda7b ML |
879 | (@option_group_id_conference_slot, '{ts escape="sql"}Morning Sessions{/ts}', 1, 'Morning Sessions', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
880 | (@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 | 881 | |
00f6e1a8 | 882 | -- default batch types |
9b6dda7b ML |
883 | (@option_group_id_batch_type, '{ts escape="sql"}Contribution{/ts}', 1, 'Contribution', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), |
884 | (@option_group_id_batch_type, '{ts escape="sql"}Membership{/ts}', 2, 'Membership', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
00f6e1a8 | 885 | (@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 |
886 | |
887 | -- default batch statuses | |
888 | (@option_group_id_batch_status, '{ts escape="sql"}Open{/ts}', 1, 'Open', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL), | |
889 | (@option_group_id_batch_status, '{ts escape="sql"}Closed{/ts}', 2, 'Closed', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL), | |
890 | (@option_group_id_batch_status, '{ts escape="sql"}Data Entry{/ts}', 3, 'Data Entry', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL), | |
891 | (@option_group_id_batch_status, '{ts escape="sql"}Reopened{/ts}', 4, 'Reopened', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL), | |
892 | (@option_group_id_batch_status, '{ts escape="sql"}Exported{/ts}', 5, 'Exported', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL), | |
6a488035 TO |
893 | |
894 | -- default batch modes | |
895 | (@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), | |
896 | (@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), | |
897 | ||
898 | -- Financial Item Status | |
899 | (@option_group_id_financial_item_status, '{ts escape="sql"}Paid{/ts}', 1, 'Paid', NULL, 0, 0, 1, 'Paid', 0, 1, 1, 2, NULL), | |
900 | (@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), | |
901 | (@option_group_id_financial_item_status, '{ts escape="sql"}Unpaid{/ts}', 3, 'Unpaid', NULL, 0, 0, 1, 'Unpaid', 0, 1, 1, 2, NULL), | |
902 | ||
903 | -- sms_api_type | |
904 | (@option_group_id_sms_api_type, 'http', 1, 'http', NULL, NULL, 0, 1, NULL, 0, 1, 1, NULL, NULL), | |
905 | (@option_group_id_sms_api_type, 'xml', 2, 'xml', NULL, NULL, 0, 2, NULL, 0, 1, 1, NULL, NULL), | |
906 | (@option_group_id_sms_api_type, 'smtp', 3, 'smtp', NULL, NULL, 0, 3, NULL, 0, 1, 1, NULL, NULL), | |
907 | ||
908 | -- auto renew options | |
bcb99132 KJ |
909 | (@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), |
910 | (@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), | |
911 | (@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), | |
912 | ||
913 | -- Label Type | |
914 | (@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 | 915 | |
ab3a115e | 916 | -- Name Label format |
71c3b634 | 917 | (@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 | 918 | (@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 | 919 | (@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 | 920 | (@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 |
921 | |
922 | -- Mailing Label Formats | |
6a488035 TO |
923 | (@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), |
924 | (@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), | |
925 | (@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), | |
926 | (@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), | |
927 | (@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), | |
928 | (@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), | |
929 | (@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), | |
930 | (@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), | |
931 | (@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), | |
932 | (@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 |
933 | (@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), |
934 | ||
935 | -- Communication Styles | |
936 | (@option_group_id_communication_style, '{ts escape="sql"}Formal{/ts}' , 1, 'formal' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL), | |
a3e3eea1 | 937 | (@option_group_id_communication_style, '{ts escape="sql"}Familiar{/ts}', 2, 'familiar', NULL, 0, 0, 2, NULL, 0, 0, 1, NULL, NULL), |
938 | ||
939 | -- Message Mode | |
940 | (@option_group_id_msg_mode, '{ts escape="sql"}Email{/ts}', 'Email', 'Email', NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL), | |
941 | (@option_group_id_msg_mode, '{ts escape="sql"}SMS{/ts}', 'SMS', 'SMS', NULL, 0, 0, 2, NULL, 0, 1, 1, NULL, NULL), | |
3d65c75c AH |
942 | (@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), |
943 | ||
944 | -- Reminder Options for Contact Date Fields | |
945 | (@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 | 946 | (@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 |
947 | |
948 | -- financial accounts | |
949 | SELECT @opval := value FROM civicrm_option_value WHERE name = 'Revenue' and option_group_id = @option_group_id_fat; | |
950 | SELECT @opexp := value FROM civicrm_option_value WHERE name = 'Expenses' and option_group_id = @option_group_id_fat; | |
951 | SELECT @opAsset := value FROM civicrm_option_value WHERE name = 'Asset' and option_group_id = @option_group_id_fat; | |
952 | SELECT @opLiability := value FROM civicrm_option_value WHERE name = 'Liability' and option_group_id = @option_group_id_fat; | |
953 | SELECT @opCost := value FROM civicrm_option_value WHERE name = 'Cost of Sales' and option_group_id = @option_group_id_fat; | |
954 | ||
955 | INSERT INTO | |
956 | `civicrm_financial_account` (`name`, `contact_id`, `financial_account_type_id`, `description`, `accounting_code`, `account_type_code`, `is_reserved`, `is_active`, `is_deductible`, `is_default`) | |
957 | VALUES | |
ddaa8ef1 | 958 | ( '{ts escape="sql"}Donation{/ts}' , @contactID, @opval, 'Default account for donations', '4200', 'INC', 0, 1, 1, 1 ), |
6a488035 TO |
959 | ( '{ts escape="sql"}Member Dues{/ts}' , @contactID, @opval, 'Default account for membership sales', '4400', 'INC', 0, 1, 1, 0 ), |
960 | ( '{ts escape="sql"}Campaign Contribution{/ts}', @contactID, @opval, 'Sample account for recording payments to a campaign', '4100', 'INC', 0, 1, 0, 0 ), | |
961 | ( '{ts escape="sql"}Event Fee{/ts}' , @contactID, @opval, 'Default account for event ticket sales', '4300', 'INC', 0, 1, 0, 0 ), | |
ddaa8ef1 | 962 | ( '{ts escape="sql"}Banking Fees{/ts}' , @contactID, @opexp, 'Payment processor fees and manually recorded banking fees', '5200', 'EXP', 0, 1, 0, 1 ), |
6a488035 TO |
963 | ( '{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 ), |
964 | ( '{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 |
965 | ( '{ts escape="sql"}Accounts Payable{/ts}' , @contactID, @opLiability, 'Amounts to be paid out such as grants and refunds', '2200', 'AP', 0, 1, 0, 1 ), |
966 | ( '{ts escape="sql"}Premiums{/ts}' , @contactID, @opCost, 'Account to record cost of premiums provided to payors', '5100', 'COGS', 0, 1, 0, 1 ), | |
6a488035 TO |
967 | ( '{ts escape="sql"}Premiums inventory{/ts}' , @contactID, @opAsset, 'Account representing value of premiums inventory', '1375', 'OCASSET', 0, 1, 0, 0 ), |
968 | ( '{ts escape="sql"}Discounts{/ts}' , @contactID, @opval, 'Contra-revenue account for amounts discounted from sales', '4900', 'INC', 0, 1, 0, 0 ), | |
969 | ( '{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 | |
970 | ); | |
971 | ||
972 | -- Now insert option values which require domainID | |
973 | -- | |
974 | ||
975 | INSERT INTO | |
976 | `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`) | |
977 | VALUES | |
978 | -- from email address. | |
979 | (@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 ), | |
980 | ||
981 | -- grant types | |
982 | (@option_group_id_grantTyp, '{ts escape="sql"}Emergency{/ts}' , 1, 'Emergency' , NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, @domainID, NULL), | |
983 | (@option_group_id_grantTyp, '{ts escape="sql"}Family Support{/ts}' , 2, 'Family Support' , NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, @domainID, NULL), | |
984 | (@option_group_id_grantTyp, '{ts escape="sql"}General Protection{/ts}' , 3, 'General Protection', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, @domainID, NULL), | |
985 | (@option_group_id_grantTyp, '{ts escape="sql"}Impunity{/ts}' , 4, 'Impunity' , NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, @domainID, NULL), | |
986 | ||
6a488035 TO |
987 | -- Mail Approval Status Preferences |
988 | (@option_group_id_mail_approval_status, '{ts escape="sql"}Approved{/ts}' , 1, 'Approved', NULL, 0, 1, 1, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), | |
989 | (@option_group_id_mail_approval_status, '{ts escape="sql"}Rejected{/ts}' , 2, 'Rejected', NULL, 0, 0, 2, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), | |
990 | (@option_group_id_mail_approval_status, '{ts escape="sql"}None{/ts}' , 3, 'None', NULL, 0, 0, 3, NULL, 0, 1, 1, @mailCompId, @domainID, NULL), | |
991 | ||
992 | -- custom group objects | |
993 | (@option_group_id_cgeo, '{ts escape="sql"}Survey{/ts}', 'Survey', 'civicrm_survey', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL, NULL), | |
994 | (@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); | |
995 | ||
996 | -- CRM-6138 | |
997 | {include file='languages.tpl'} | |
998 | ||
999 | -- /******************************************************* | |
1000 | -- * | |
1001 | -- * Encounter Medium Option Values (for case activities) | |
1002 | -- * | |
1003 | -- *******************************************************/ | |
1004 | INSERT INTO `civicrm_option_group` (name, title, description, is_reserved, is_active) | |
1005 | VALUES ('encounter_medium', 'Encounter Medium', 'Encounter medium for case activities (e.g. In Person, By Phone, etc.)', 1, 1); | |
1006 | SELECT @option_group_id_medium := max(id) from civicrm_option_group where name = 'encounter_medium'; | |
1007 | INSERT INTO | |
1008 | `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`) | |
1009 | VALUES | |
1010 | (@option_group_id_medium, '{ts escape="sql"}In Person{/ts}', 1, 'in_person', NULL, 0, 0, 1, NULL, 0, 1, 1), | |
1011 | (@option_group_id_medium, '{ts escape="sql"}Phone{/ts}', 2, 'phone', NULL, 0, 1, 2, NULL, 0, 1, 1), | |
1012 | (@option_group_id_medium, '{ts escape="sql"}Email{/ts}', 3, 'email', NULL, 0, 0, 3, NULL, 0, 1, 1), | |
1013 | (@option_group_id_medium, '{ts escape="sql"}Fax{/ts}', 4, 'fax', NULL, 0, 0, 4, NULL, 0, 1, 1), | |
1014 | (@option_group_id_medium, '{ts escape="sql"}Letter Mail{/ts}', 5, 'letter_mail', NULL, 0, 0, 5, NULL, 0, 1, 1); | |
1015 | ||
1016 | -- sample membership status entries | |
1017 | INSERT INTO | |
1018 | 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) | |
1019 | VALUES | |
1020 | ('New', '{ts escape="sql"}New{/ts}', 'join_date', null, null,'join_date','month',3, 1, 0, 1, 0, 1, 0), | |
1021 | ('Current', '{ts escape="sql"}Current{/ts}', 'start_date', null, null,'end_date', null, null, 1, 0, 2, 1, 1, 0), | |
1022 | ('Grace', '{ts escape="sql"}Grace{/ts}', 'end_date', null, null,'end_date','month', 1, 1, 0, 3, 0, 1, 0), | |
1023 | ('Expired', '{ts escape="sql"}Expired{/ts}', 'end_date', 'month', 1, null, null, null, 0, 0, 4, 0, 1, 0), | |
1024 | ('Pending', '{ts escape="sql"}Pending{/ts}', 'join_date', null, null,'join_date',null,null, 0, 0, 5, 0, 1, 1), | |
c4a02b20 | 1025 | ('Cancelled', '{ts escape="sql"}Cancelled{/ts}', 'join_date', null, null,'join_date',null,null, 0, 0, 6, 0, 1, 1), |
6a488035 TO |
1026 | ('Deceased', '{ts escape="sql"}Deceased{/ts}', null, null, null, null, null, null, 0, 1, 7, 0, 1, 1); |
1027 | ||
1028 | ||
1029 | INSERT INTO `civicrm_preferences_date` | |
1030 | (name, start, end, date_format, time_format, description) | |
1031 | VALUES | |
1032 | ( 'activityDate' , 20, 10, '', '', 'Date for activities including contributions: receive, receipt, cancel. membership: join, start, renew. case: start, end.' ), | |
1033 | ( 'activityDateTime', 20, 10, '', 1, 'Date and time for activity: scheduled. participant: registered.' ), | |
1034 | ( 'birth' , 100, 0, '', '', 'Birth and deceased dates. Only year, month and day fields are supported.' ), | |
1035 | ( 'creditCard' , 0, 10, 'M Y', '', 'Month and year only for credit card expiration.' ), | |
1036 | ( '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.'), | |
1037 | ( 'mailing' , 0, 1, '', '', 'Date and time. Used for scheduling mailings.' ), | |
1038 | ( 'searchDate' , 20, 20, '', '', 'Used in search forms.' ); | |
1039 | ||
1040 | ||
1041 | -- various processor options | |
1042 | -- | |
1043 | -- Table structure for table `civicrm_payment_processor_type` | |
1044 | -- | |
1045 | ||
1046 | INSERT INTO `civicrm_payment_processor_type` | |
1047 | (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 ) | |
1048 | VALUES | |
1049 | ('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), | |
1050 | ('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 ), | |
1051 | ('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), | |
1052 | ('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), | |
1053 | ('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), | |
1054 | ('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), | |
1055 | ('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), | |
1056 | ('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), | |
1057 | ('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), | |
1058 | ('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), | |
1059 | ('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), | |
1060 | ('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 ), | |
1061 | ('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 ), | |
1062 | ('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); | |
1063 | ||
1064 | ||
1065 | -- the fuzzy default dedupe rules | |
1066 | -- IndividualSupervised uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualSupervised) | |
1067 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1068 | VALUES ('Individual', 20, 'Supervised', 'IndividualSupervised', '{ts escape="sql"}Name and Email (reserved){/ts}', 1); | |
1069 | ||
1070 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1071 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1072 | VALUES (@drgid, 'civicrm_contact', 'first_name', 5), | |
1073 | (@drgid, 'civicrm_contact', 'last_name', 7), | |
1074 | (@drgid, 'civicrm_email' , 'email', 10); | |
1075 | ||
1076 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1077 | VALUES ('Organization', 10, 'Supervised', 'OrganizationSupervised', '{ts escape="sql"}Name and Email{/ts}', 0); | |
1078 | ||
1079 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1080 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1081 | VALUES (@drgid, 'civicrm_contact', 'organization_name', 10), | |
1082 | (@drgid, 'civicrm_email' , 'email', 10); | |
1083 | ||
1084 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1085 | VALUES ('Household', 10, 'Supervised', 'HouseholdSupervised', '{ts escape="sql"}Name and Email{/ts}', 0); | |
1086 | ||
1087 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1088 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1089 | VALUES (@drgid, 'civicrm_contact', 'household_name', 10), | |
1090 | (@drgid, 'civicrm_email' , 'email', 10); | |
1091 | ||
1092 | -- the strict dedupe rules | |
1093 | -- IndividualUnsupervised uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualUnsupervised) | |
1094 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1095 | VALUES ('Individual', 10, 'Unsupervised', 'IndividualUnsupervised', '{ts escape="sql"}Email (reserved){/ts}', 1); | |
1096 | ||
1097 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1098 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1099 | VALUES (@drgid, 'civicrm_email', 'email', 10); | |
1100 | ||
1101 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1102 | VALUES ('Organization', 10, 'Unsupervised', 'OrganizationUnsupervised', '{ts escape="sql"}Name and Email{/ts}', 0); | |
1103 | ||
1104 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1105 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1106 | VALUES (@drgid, 'civicrm_contact', 'organization_name', 10), | |
1107 | (@drgid, 'civicrm_email' , 'email', 10); | |
1108 | ||
1109 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1110 | VALUES ('Household', 10, 'Unsupervised', 'HouseholdUnsupervised', '{ts escape="sql"}Name and Email{/ts}', 0); | |
1111 | ||
1112 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1113 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1114 | VALUES (@drgid, 'civicrm_contact', 'household_name', 10), | |
1115 | (@drgid, 'civicrm_email' , 'email', 10); | |
1116 | ||
1117 | -- IndividualGeneral uses hard-coded optimized query (CRM_Dedupe_BAO_QueryBuilder_IndividualGeneral) | |
1118 | INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, used, name, title, is_reserved) | |
1119 | VALUES ('Individual', 15, 'General', 'IndividualGeneral', '{ts escape="sql"}Name and Address (reserved){/ts}', 1); | |
1120 | ||
1121 | SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; | |
1122 | INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) | |
1123 | VALUES (@drgid, 'civicrm_contact', 'first_name', '5'), | |
1124 | (@drgid, 'civicrm_contact', 'last_name', '5'), | |
1125 | (@drgid, 'civicrm_address', 'street_address', '5'), | |
1126 | (@drgid, 'civicrm_contact', 'middle_name', '1'), | |
1127 | (@drgid, 'civicrm_contact', 'suffix_id', '1'); | |
1128 | ||
1129 | -- Sample counties (state-province and country lists defined in a separate tpl files) | |
1130 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('Alameda', 1004); | |
1131 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('Contra Costa', 1004); | |
1132 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('Marin', 1004); | |
1133 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Francisco', 1004); | |
1134 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Mateo', 1004); | |
1135 | INSERT INTO civicrm_county (name, state_province_id) VALUES ('Santa Clara', 1004); | |
1136 | ||
1137 | -- Bounce classification patterns | |
1138 | INSERT INTO civicrm_mailing_bounce_type | |
1139 | (name, description, hold_threshold) | |
1140 | VALUES ('AOL', '{ts escape="sql"}AOL Terms of Service complaint{/ts}', 1); | |
1141 | ||
1142 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'AOL'; | |
1143 | INSERT INTO civicrm_mailing_bounce_pattern | |
1144 | (bounce_type_id, pattern) | |
1145 | VALUES | |
1146 | (@bounceTypeID, 'Client TOS Notification'); | |
1147 | ||
1148 | INSERT INTO civicrm_mailing_bounce_type | |
1149 | (name, description, hold_threshold) | |
1150 | VALUES ('Away', '{ts escape="sql"}Recipient is on vacation{/ts}', 30); | |
1151 | ||
1152 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Away'; | |
1153 | INSERT INTO civicrm_mailing_bounce_pattern | |
1154 | (bounce_type_id, pattern) | |
1155 | VALUES | |
1156 | (@bounceTypeID, '(be|am)? (out of|away from) (the|my)? (office|computer|town)'), | |
1157 | (@bounceTypeID, 'i am on vacation'); | |
1158 | ||
1159 | INSERT INTO civicrm_mailing_bounce_type | |
1160 | (name, description, hold_threshold) | |
1161 | VALUES ('Dns', '{ts escape="sql"}Unable to resolve recipient domain{/ts}', 3); | |
1162 | ||
1163 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Dns'; | |
1164 | INSERT INTO civicrm_mailing_bounce_pattern | |
1165 | (bounce_type_id, pattern) | |
1166 | VALUES | |
1167 | (@bounceTypeID, 'name(server entry| lookup failure)'), | |
1168 | (@bounceTypeID, 'no (mail server|matches to nameserver query|dns entries)'), | |
f29cfa44 DL |
1169 | (@bounceTypeID, 'reverse dns entry'), |
1170 | (@bounceTypeID, 'Host or domain name not found'); | |
6a488035 TO |
1171 | |
1172 | INSERT INTO civicrm_mailing_bounce_type | |
1173 | (name, description, hold_threshold) | |
1174 | VALUES ('Host', '{ts escape="sql"}Unable to deliver to destintation mail server{/ts}', 3); | |
1175 | ||
1176 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Host'; | |
1177 | INSERT INTO civicrm_mailing_bounce_pattern | |
1178 | (bounce_type_id, pattern) | |
1179 | VALUES | |
1180 | (@bounceTypeID, '(unknown|not local) host'), | |
1181 | (@bounceTypeID, 'all hosts have been failing'), | |
1182 | (@bounceTypeID, 'allowed rcpthosts'), | |
1183 | (@bounceTypeID, 'connection (refused|timed out)'), | |
1184 | (@bounceTypeID, 'not connected'), | |
1185 | (@bounceTypeID, 'couldn\'t find any host named'), | |
1186 | (@bounceTypeID, 'error involving remote host'), | |
1187 | (@bounceTypeID, 'host unknown'), | |
1188 | (@bounceTypeID, 'invalid host name'), | |
1189 | (@bounceTypeID, 'isn\'t in my control/locals file'), | |
1190 | (@bounceTypeID, 'local configuration error'), | |
1191 | (@bounceTypeID, 'not a gateway'), | |
4b701e6b | 1192 | (@bounceTypeID, 'server is (down or unreachable|not responding)'), |
6a488035 | 1193 | (@bounceTypeID, 'too many connections'), |
f29cfa44 DL |
1194 | (@bounceTypeID, 'unable to connect'), |
1195 | (@bounceTypeID, 'lost connection'), | |
4b701e6b JK |
1196 | (@bounceTypeID, 'conversation with [^ ]* timed out while'), |
1197 | (@bounceTypeID, 'server requires authentication'), | |
1198 | (@bounceTypeID, 'authentication (is )?required'); | |
6a488035 TO |
1199 | |
1200 | INSERT INTO civicrm_mailing_bounce_type | |
1201 | (name, description, hold_threshold) | |
1202 | VALUES ('Inactive', '{ts escape="sql"}User account is no longer active{/ts}', 1); | |
1203 | ||
1204 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Inactive'; | |
1205 | INSERT INTO civicrm_mailing_bounce_pattern | |
1206 | (bounce_type_id, pattern) | |
1207 | VALUES | |
1208 | (@bounceTypeID, '(my )?e-?mail( address)? has changed'), | |
1209 | (@bounceTypeID, 'account (inactive|expired|deactivated)'), | |
1210 | (@bounceTypeID, 'account is locked'), | |
1211 | (@bounceTypeID, 'changed \w+( e-?mail)? address'), | |
1212 | (@bounceTypeID, 'deactivated mailbox'), | |
1213 | (@bounceTypeID, 'disabled or discontinued'), | |
1214 | (@bounceTypeID, 'inactive user'), | |
1215 | (@bounceTypeID, 'is inactive on this domain'), | |
1216 | (@bounceTypeID, 'mail receiving disabled'), | |
1217 | (@bounceTypeID, 'mail( ?)address is administrative?ly disabled'), | |
1218 | (@bounceTypeID, 'mailbox (temporarily disabled|currently suspended)'), | |
1219 | (@bounceTypeID, 'no longer (accepting mail|on server|in use|with|employed|on staff|works for|using this account)'), | |
6c722cd3 | 1220 | (@bounceTypeID, 'not accepting (mail|messages)'), |
6a488035 TO |
1221 | (@bounceTypeID, 'please use my new e-?mail address'), |
1222 | (@bounceTypeID, 'this address no longer accepts mail'), | |
6c722cd3 JK |
1223 | (@bounceTypeID, 'user account suspended'), |
1224 | (@bounceTypeID, 'account that you tried to reach is disabled'), | |
1225 | (@bounceTypeID, 'User banned'); | |
6a488035 TO |
1226 | |
1227 | INSERT INTO civicrm_mailing_bounce_type | |
1228 | (name, description, hold_threshold) | |
1229 | VALUES ('Invalid', '{ts escape="sql"}Email address is not valid{/ts}', 1); | |
1230 | ||
1231 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Invalid'; | |
1232 | INSERT INTO civicrm_mailing_bounce_pattern | |
1233 | (bounce_type_id, pattern) | |
1234 | VALUES | |
1235 | (@bounceTypeID, '(user|recipient( name)?) is not recognized'), | |
1236 | (@bounceTypeID, '554 delivery error'), | |
1237 | (@bounceTypeID, 'address does not exist'), | |
2ef143bb JK |
1238 | (@bounceTypeID, 'address(es)?( you (entered|specified))? (could|was)( not|n.t)( be)? found'), |
1239 | (@bounceTypeID, 'address(ee)? (unknown|invalid)'), | |
6a488035 TO |
1240 | (@bounceTypeID, 'bad destination'), |
1241 | (@bounceTypeID, 'badly formatted address'), | |
1242 | (@bounceTypeID, 'can\'t open mailbox for'), | |
1243 | (@bounceTypeID, 'cannot deliver'), | |
1244 | (@bounceTypeID, 'delivery to the following recipient(s)? failed'), | |
1245 | (@bounceTypeID, 'destination addresses were unknown'), | |
1246 | (@bounceTypeID, 'did not reach the following recipient'), | |
1247 | (@bounceTypeID, 'does not exist'), | |
1248 | (@bounceTypeID, 'does not like recipient'), | |
1249 | (@bounceTypeID, 'does not specify a valid notes mail file'), | |
1250 | (@bounceTypeID, 'illegal alias'), | |
1251 | (@bounceTypeID, 'invalid (mailbox|(e-?mail )?address|recipient|final delivery)'), | |
1252 | (@bounceTypeID, 'invalid( or unknown)?( virtual)? user'), | |
2ef143bb | 1253 | (@bounceTypeID, '(mail )?delivery (to this user )?is not allowed'), |
6a488035 TO |
1254 | (@bounceTypeID, 'mailbox (not found|unavailable|name not allowed)'), |
1255 | (@bounceTypeID, 'message could not be forwarded'), | |
1256 | (@bounceTypeID, 'missing or malformed local(-| )part'), | |
1257 | (@bounceTypeID, 'no e-?mail address registered'), | |
4d00ef28 | 1258 | (@bounceTypeID, 'no such (mail drop|mailbox( \\w+)?|(e-?mail )?address|recipient|(local )?user|person)( here)?'), |
2ef143bb | 1259 | (@bounceTypeID, 'no mailbox (here )?by that name'), |
6a488035 TO |
1260 | (@bounceTypeID, 'not (listed in|found in directory|known at this site|our customer)'), |
1261 | (@bounceTypeID, 'not a valid( (user|mailbox))?'), | |
1262 | (@bounceTypeID, 'not present in directory entry'), | |
2ef143bb | 1263 | (@bounceTypeID, 'recipient (does not exist|(is )?unknown|rejected|denied|not found)'), |
6a488035 TO |
1264 | (@bounceTypeID, 'this user doesn\'t have a yahoo.com address'), |
1265 | (@bounceTypeID, 'unavailable to take delivery of the message'), | |
1266 | (@bounceTypeID, 'unavailable mailbox'), | |
2ef143bb | 1267 | (@bounceTypeID, 'unknown (local( |-)part|recipient|address error)'), |
6a488035 TO |
1268 | (@bounceTypeID, 'unknown( or illegal)? user( account)?'), |
1269 | (@bounceTypeID, 'unrecognized recipient'), | |
1270 | (@bounceTypeID, 'unregistered address'), | |
1271 | (@bounceTypeID, 'user (unknown|does not exist)'), | |
1272 | (@bounceTypeID, 'user doesn\'t have an? \w+ account'), | |
1273 | (@bounceTypeID, 'user(\'s e-?mail name is)? not found'), | |
2ef143bb JK |
1274 | (@bounceTypeID, '^Validation failed for:'), |
1275 | (@bounceTypeID, '5.1.0 Address rejected'), | |
1276 | (@bounceTypeID, 'no valid recipients?'), | |
1277 | (@bounceTypeID, 'RecipNotFound'), | |
1278 | (@bounceTypeID, 'no one at this address'), | |
1279 | (@bounceTypeID, 'misconfigured forwarding address'), | |
1280 | (@bounceTypeID, 'account is not allowed'), | |
f0e821bb | 1281 | (@bounceTypeID, 'Address .<[^>]*>. not known here'), |
c6df8482 | 1282 | (@bounceTypeID, '{literal}Recipient address rejected: ([a-zA-Z0-9-]+\\.)+[a-zA-Z]{2,}{/literal}'), |
20603b2a JK |
1283 | (@bounceTypeID, 'Non sono riuscito a trovare l.indirizzo e-mail'), |
1284 | (@bounceTypeID, 'nadie con esta direcci..?n'), | |
1285 | (@bounceTypeID, 'ni bilo mogo..?e najti prejemnikovega e-po..?tnega naslova'), | |
1286 | (@bounceTypeID, 'Elektronski naslov (je ukinjen|ne obstaja)'), | |
1287 | (@bounceTypeID, 'nepravilno nastavljen predal'); | |
6a488035 TO |
1288 | |
1289 | INSERT INTO civicrm_mailing_bounce_type | |
1290 | (name, description, hold_threshold) | |
1291 | VALUES ('Loop', '{ts escape="sql"}Mail routing error{/ts}', 3); | |
1292 | ||
1293 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Loop'; | |
1294 | INSERT INTO civicrm_mailing_bounce_pattern | |
1295 | (bounce_type_id, pattern) | |
1296 | VALUES | |
1c30bc92 | 1297 | (@bounceTypeID, '(mail( forwarding)?|routing).loop'), |
6a488035 TO |
1298 | (@bounceTypeID, 'excessive recursion'), |
1299 | (@bounceTypeID, 'loop detected'), | |
1300 | (@bounceTypeID, 'maximum hop count exceeded'), | |
1301 | (@bounceTypeID, 'message was forwarded more than the maximum allowed times'), | |
1c30bc92 | 1302 | (@bounceTypeID, 'too many (hops|recursive forwards)'); |
6a488035 TO |
1303 | |
1304 | INSERT INTO civicrm_mailing_bounce_type | |
1305 | (name, description, hold_threshold) | |
1306 | VALUES ('Quota', '{ts escape="sql"}User inbox is full{/ts}', 3); | |
1307 | ||
1308 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Quota'; | |
1309 | INSERT INTO civicrm_mailing_bounce_pattern | |
1310 | (bounce_type_id, pattern) | |
1311 | VALUES | |
b49cdea8 | 1312 | (@bounceTypeID, '(disk(space)?|over the allowed|exceed(ed|s)?|storage) quota'), |
6a488035 TO |
1313 | (@bounceTypeID, '522_mailbox_full'), |
1314 | (@bounceTypeID, 'exceeds allowed message count'), | |
1315 | (@bounceTypeID, 'file too large'), | |
1316 | (@bounceTypeID, 'full mailbox'), | |
4d00ef28 | 1317 | (@bounceTypeID, '(mail|in)(box|folder) ((for user \\w+ )?is )?full'), |
b49cdea8 | 1318 | (@bounceTypeID, 'mailbox (has exceeded|is over) the limit'), |
6a488035 TO |
1319 | (@bounceTypeID, 'mailbox( exceeds allowed)? size'), |
1320 | (@bounceTypeID, 'no space left for this user'), | |
1321 | (@bounceTypeID, 'over\\s?quota'), | |
1322 | (@bounceTypeID, 'quota (for the mailbox )?has been exceeded'), | |
b49cdea8 | 1323 | (@bounceTypeID, 'quota ?(usage|violation|exceeded)'), |
6a488035 | 1324 | (@bounceTypeID, 'recipient storage full'), |
b49cdea8 JK |
1325 | (@bounceTypeID, 'not able to receive more mail'), |
1326 | (@bounceTypeID, 'doesn.t have enough disk space left'), | |
1327 | (@bounceTypeID, 'exceeded storage allocation'), | |
1328 | (@bounceTypeID, 'running out of disk space'); | |
6a488035 TO |
1329 | |
1330 | INSERT INTO civicrm_mailing_bounce_type | |
1331 | (name, description, hold_threshold) | |
1332 | VALUES ('Relay', '{ts escape="sql"}Unable to reach destination mail server{/ts}', 3); | |
1333 | ||
1334 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Relay'; | |
1335 | INSERT INTO civicrm_mailing_bounce_pattern | |
1336 | (bounce_type_id, pattern) | |
1337 | VALUES | |
1338 | (@bounceTypeID, 'cannot find your hostname'), | |
1339 | (@bounceTypeID, 'ip name lookup'), | |
1340 | (@bounceTypeID, 'not configured to relay mail'), | |
9dd1b580 | 1341 | (@bounceTypeID, 'relay(ing)? (not permitted|(access )?denied)'), |
6a488035 TO |
1342 | (@bounceTypeID, 'relayed mail to .+? not allowed'), |
1343 | (@bounceTypeID, 'sender ip must resolve'), | |
f29cfa44 DL |
1344 | (@bounceTypeID, 'unable to relay'), |
1345 | (@bounceTypeID, 'No route to host'), | |
9dd1b580 JK |
1346 | (@bounceTypeID, 'Network is unreachable'), |
1347 | (@bounceTypeID, 'unrouteable address'), | |
1348 | (@bounceTypeID, 'We don.t handle mail for'), | |
1349 | (@bounceTypeID, 'we do not relay'), | |
1350 | (@bounceTypeID, 'Rejected by next-hop'), | |
1351 | (@bounceTypeID, 'not permitted to( *550)? relay through this server'); | |
6a488035 TO |
1352 | |
1353 | INSERT INTO civicrm_mailing_bounce_type | |
1354 | (name, description, hold_threshold) | |
1355 | VALUES ('Spam', '{ts escape="sql"}Message caught by a content filter{/ts}', 1); | |
1356 | ||
1357 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam'; | |
1358 | INSERT INTO civicrm_mailing_bounce_pattern | |
1359 | (bounce_type_id, pattern) | |
1360 | VALUES | |
1361 | (@bounceTypeID, '(bulk( e-?mail)|content|attachment blocking|virus|mail system) filters?'), | |
1362 | (@bounceTypeID, '(hostile|questionable|unacceptable) content'), | |
1363 | (@bounceTypeID, 'address .+? has not been verified'), | |
1364 | (@bounceTypeID, 'anti-?spam (polic\w+|software)'), | |
1365 | (@bounceTypeID, 'anti-?virus gateway has detected'), | |
1366 | (@bounceTypeID, 'blacklisted'), | |
1367 | (@bounceTypeID, 'blocked message'), | |
1368 | (@bounceTypeID, 'content control'), | |
1369 | (@bounceTypeID, 'delivery not authorized'), | |
1370 | (@bounceTypeID, 'does not conform to our e-?mail policy'), | |
1371 | (@bounceTypeID, 'excessive spam content'), | |
1372 | (@bounceTypeID, 'message looks suspicious'), | |
1373 | (@bounceTypeID, 'open relay'), | |
1374 | (@bounceTypeID, 'sender was rejected'), | |
1375 | (@bounceTypeID, 'spam(check| reduction software| filters?)'), | |
1376 | (@bounceTypeID, 'blocked by a user configured filter'), | |
40ddeeca JK |
1377 | (@bounceTypeID, '(detected|rejected) as spam'), |
1378 | (@bounceTypeID, 'X-HmXmrOriginalRecipient'), | |
4d00ef28 | 1379 | (@bounceTypeID, 'Client host .[^ ]*. blocked'), |
40ddeeca JK |
1380 | (@bounceTypeID, 'automatic(ally-generated)? messages are not accepted'), |
1381 | (@bounceTypeID, 'denied by policy'), | |
4d00ef28 | 1382 | (@bounceTypeID, 'has no corresponding reverse \\(PTR\\) address'), |
40ddeeca JK |
1383 | (@bounceTypeID, 'has a policy that( [^ ]*)? prohibited the mail that you sent'), |
1384 | (@bounceTypeID, 'is likely unsolicited mail'), | |
1385 | (@bounceTypeID, 'Local Policy Violation'), | |
1386 | (@bounceTypeID, 'ni bilo mogo..?e dostaviti zaradi varnostnega pravilnika'); | |
6a488035 TO |
1387 | |
1388 | INSERT INTO civicrm_mailing_bounce_type | |
1389 | (name, description, hold_threshold) | |
1390 | VALUES ('Syntax', '{ts escape="sql"}Error in SMTP transaction{/ts}', 3); | |
1391 | ||
1392 | SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Syntax'; | |
1393 | INSERT INTO civicrm_mailing_bounce_pattern | |
1394 | (bounce_type_id, pattern) | |
1395 | VALUES | |
1396 | (@bounceTypeID, 'nonstandard smtp line terminator'), | |
1397 | (@bounceTypeID, 'syntax error in from address'), | |
1398 | (@bounceTypeID, 'unknown smtp code'); | |
1399 | ||
1400 | -- add sample and reserved profiles | |
1401 | ||
1402 | INSERT INTO civicrm_uf_group | |
1403 | (id, name, group_type, title, is_cms_user, is_reserved, help_post) VALUES | |
1404 | (1, 'name_and_address', 'Individual,Contact', '{ts escape="sql"}Name and Address{/ts}', 0, 0, NULL), | |
1405 | (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>'), | |
1406 | (3, 'participant_status', 'Participant', '{ts escape="sql"}Participant Status{/ts}', 0, 1, NULL), | |
1407 | (4, 'new_individual', 'Individual,Contact', '{ts escape="sql"}New Individual{/ts}' , 0, 1, NULL), | |
1408 | (5, 'new_organization', 'Organization,Contact','{ts escape="sql"}New Organization{/ts}' , 0, 1, NULL), | |
1409 | (6, 'new_household', 'Household,Contact', '{ts escape="sql"}New Household{/ts}' , 0, 1, NULL), | |
a235e13c | 1410 | (7, 'summary_overlay', 'Contact', '{ts escape="sql"}Summary Overlay{/ts}' , 0, 1, NULL), |
1411 | (8, 'shared_address', 'Contact', '{ts escape="sql"}Shared Address{/ts}' , 0, 1, NULL), | |
6a488035 | 1412 | (9, 'on_behalf_organization', 'Contact,Organization','{ts escape="sql"}On Behalf Of Organization{/ts}', 0, 1, NULL), |
42b29ffc | 1413 | (10, 'contribution_batch_entry', 'Contribution', '{ts escape="sql"}Contribution Bulk Entry{/ts}' , 0, 1, NULL), |
1414 | (11, 'membership_batch_entry', 'Membership', '{ts escape="sql"}Membership Bulk Entry{/ts}' , 0, 1, NULL), | |
8381af80 | 1415 | (12, 'event_registration', 'Individual,Contact', '{ts escape="sql"}Your Registration Info{/ts}', 0, 0, NULL), |
1416 | (13, 'honoree_individual', 'Individual,Contact', '{ts escape="sql"}Honoree Individual{/ts}', 0, 1, NULL); | |
6a488035 | 1417 | |
133e2c99 | 1418 | |
6a488035 TO |
1419 | INSERT INTO civicrm_uf_join |
1420 | (is_active,module,entity_table,entity_id,weight,uf_group_id) | |
1421 | VALUES | |
1422 | (1, 'User Registration',NULL, NULL,1,1), | |
1423 | (1, 'User Account', NULL, NULL, 1, 1), | |
1424 | (1, 'Profile', NULL, NULL, 1, 1), | |
1425 | (1, 'Profile', NULL, NULL, 2, 2), | |
2e57a21b | 1426 | (1, 'Profile', NULL, NULL, 11, 12); |
6a488035 TO |
1427 | |
1428 | INSERT INTO civicrm_uf_field | |
a235e13c | 1429 | ( 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 | 1430 | ( 1, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL), |
1431 | ( 1, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL), | |
1432 | ( 1, 'street_address', 0, 0, 3, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Street Address (Home){/ts}', 'Contact', NULL, NULL), | |
1433 | ( 1, 'city', 0, 0, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}City (Home){/ts}', 'Contact', NULL, NULL), | |
1434 | ( 1, 'postal_code', 0, 0, 5, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Postal Code (Home){/ts}', 'Contact', NULL, NULL), | |
1435 | ( 1, 'country', 0, 0, 6, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Country (Home){/ts}', 'Contact', NULL, NULL), | |
1436 | ( 1, 'state_province', 0, 0, 7, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}State (Home){/ts}', 'Contact', NULL, NULL), | |
1437 | ( 2, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL), | |
1438 | ( 2, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL), | |
1439 | ( 2, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL), | |
1440 | ( 3, 'participant_status', 1, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Participant Status{/ts}', 'Participant', NULL, NULL), | |
1441 | ( 4, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL), | |
1442 | ( 4, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL), | |
1443 | ( 4, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL), | |
1444 | ( 5, 'organization_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Organization Name{/ts}', 'Organization', NULL, NULL), | |
1445 | ( 5, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL), | |
1446 | ( 6, 'household_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Household Name{/ts}', 'Household', NULL, NULL), | |
1447 | ( 6, 'email', 0, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL), | |
1448 | ( 7, 'phone', 1, 0, 1, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Home Phone{/ts}', 'Contact', NULL, 1 ), | |
1449 | ( 7, 'phone', 1, 0, 2, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Home Mobile{/ts}', 'Contact', NULL, 2 ), | |
1450 | ( 7, 'street_address', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Primary Address{/ts}', 'Contact', NULL, NULL), | |
1451 | ( 7, 'city', 1, 0, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}City{/ts}', 'Contact', NULL, NULL), | |
1452 | ( 7, 'state_province', 1, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}State{/ts}', 'Contact', NULL, NULL), | |
1453 | ( 7, 'postal_code', 1, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Postal Code{/ts}', 'Contact', NULL, NULL), | |
1454 | ( 7, 'email', 1, 0, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Primary Email{/ts}', 'Contact', NULL, NULL), | |
1455 | ( 7, 'group', 1, 0, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Groups{/ts}', 'Contact', NULL, NULL), | |
1456 | ( 7, 'tag', 1, 0, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Tags{/ts}', 'Contact', NULL, NULL), | |
1457 | ( 7, 'gender_id', 1, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Gender{/ts}', 'Individual', NULL, NULL), | |
1458 | ( 7, 'birth_date', 1, 0, 11, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Date of Birth{/ts}', 'Individual', NULL, NULL), | |
1459 | ( 8, 'street_address', 1, 1, 1, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Street Address (Home){/ts}', 'Contact', NULL, NULL), | |
1460 | ( 8, 'city', 1, 1, 2, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}City (Home){/ts}', 'Contact', NULL, NULL), | |
1461 | ( 8, 'postal_code', 0, 0, 3, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Postal Code (Home){/ts}', 'Contact', NULL, NULL), | |
1462 | ( 8, 'country', 0, 0, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Country (Home){/ts}', 'Contact', NULL, NULL), | |
1463 | ( 8, 'state_province', 0, 0, 5, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}State (Home){/ts}', 'Contact', NULL, NULL), | |
1464 | ( 9, 'organization_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Organization Name{/ts}', 'Organization', NULL, NULL), | |
1465 | ( 9, 'phone', 1, 0, 2, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Phone (Main) {/ts}', 'Contact', NULL, 1), | |
1466 | ( 9, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Email (Main) {/ts}', 'Contact', NULL, NULL), | |
1467 | ( 9, 'street_address', 1, 0, 4, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Street Address{/ts}', 'Contact', NULL, NULL), | |
1468 | ( 9, 'city', 1, 0, 5, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}City{/ts}', 'Contact', NULL, NULL), | |
1469 | ( 9, 'postal_code', 1, 0, 6, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Postal Code{/ts}', 'Contact', NULL, NULL), | |
1470 | ( 9, 'country', 1, 0, 7, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}Country{/ts}', 'Contact', NULL, NULL), | |
757069de | 1471 | ( 9, 'state_province', 1, 0, 8, 'User and User Admin Only', 0, 0, 3, '{ts escape="sql"}State/Province{/ts}', 'Contact', NULL, NULL), |
0576b84b SB |
1472 | ( 10, 'financial_type', 0, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Financial Type{/ts}', 'Contribution', NULL, NULL ), |
1473 | ( 10, 'total_amount', 0, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Amount{/ts}', 'Contribution', NULL, NULL ), | |
6a488035 TO |
1474 | ( 10, 'contribution_status_id', 1, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Status{/ts}', 'Contribution', NULL, NULL ), |
1475 | ( 10, 'receive_date', 1, 1, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Received{/ts}', 'Contribution', NULL, NULL ), | |
1476 | ( 10, 'contribution_source', 0, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Source{/ts}', 'Contribution', NULL, NULL ), | |
1477 | ( 10, 'payment_instrument', 0, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Paid By{/ts}', 'Contribution', NULL, NULL ), | |
1478 | ( 10, 'check_number', 0, 0, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Check Number{/ts}', 'Contribution', NULL, NULL ), | |
1479 | ( 10, 'send_receipt', 0, 0, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Send Receipt{/ts}', 'Contribution', NULL, NULL ), | |
1480 | ( 10, 'invoice_id', 0, 0, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Invoice ID{/ts}', 'Contribution', NULL, NULL ), | |
5ee60152 | 1481 | ( 10, 'soft_credit', 0, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit{/ts}', 'Contribution', NULL, NULL ), |
42b29ffc | 1482 | ( 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 ), |
7bdc0ff4 | 1483 | ( 11, 'membership_type', 1, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Membership Type{/ts}', 'Membership', NULL, NULL ), |
6a488035 TO |
1484 | ( 11, 'join_date', 1, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Member Since{/ts}', 'Membership', NULL, NULL ), |
1485 | ( 11, 'membership_start_date', 0, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Start Date{/ts}', 'Membership', NULL, NULL ), | |
1486 | ( 11, 'membership_end_date', 0, 1, 4, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}End Date{/ts}', 'Membership', NULL, NULL ), | |
1487 | ( 11, 'membership_source', 0, 0, 5, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Source{/ts}', 'Membership', NULL, NULL ), | |
1488 | ( 11, 'send_receipt', 0, 0, 6, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Send Receipt{/ts}', 'Membership', NULL, NULL ), | |
0576b84b SB |
1489 | ( 11, 'financial_type', 0, 1, 7, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Financial Type{/ts}', 'Membership', NULL, NULL ), |
1490 | ( 11, 'total_amount', 0, 1, 8, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Amount{/ts}', 'Membership', NULL, NULL ), | |
6a488035 TO |
1491 | ( 11, 'receive_date', 1, 1, 9, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Received{/ts}', 'Membership', NULL, NULL ), |
1492 | ( 11, 'payment_instrument', 0, 0, 10, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Paid By{/ts}', 'Membership', NULL, NULL ), | |
1493 | ( 11, 'check_number', 0, 0, 11, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Check Number{/ts}', 'Membership', NULL, NULL ), | |
1494 | ( 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 | 1495 | ( 11, 'soft_credit', 0, 0, 13, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Soft Credit{/ts}', 'Membership', NULL, NULL ), |
9e1854a1 | 1496 | ( 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 |
1497 | ( 12, 'first_name', 1, 0, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL), |
1498 | ( 12, 'last_name', 1, 0, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL), | |
42b29ffc | 1499 | ( 12, 'email', 1, 0, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL), |
1500 | ( 13, 'prefix_id', 0, 1, 1, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Individual Prefix{/ts}', 'Individual', NULL, NULL), | |
1501 | ( 13, 'first_name', 1, 1, 2, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}First Name{/ts}', 'Individual', NULL, NULL), | |
1502 | ( 13, 'last_name', 1, 1, 3, 'User and User Admin Only', 0, 0, NULL, '{ts escape="sql"}Last Name{/ts}', 'Individual', NULL, NULL), | |
1503 | ( 13, 'email', 0, 1, 4, 'User and User Admin Only', 0, 0, 1, '{ts escape="sql"}Email Address{/ts}', 'Contact', NULL, NULL); | |
6a488035 TO |
1504 | |
1505 | ||
1506 | INSERT INTO civicrm_participant_status_type | |
1507 | (id, name, label, class, is_reserved, is_active, is_counted, weight, visibility_id) VALUES | |
1508 | (1, 'Registered', '{ts escape="sql"}Registered{/ts}', 'Positive', 1, 1, 1, 1, 1 ), | |
1509 | (2, 'Attended', '{ts escape="sql"}Attended{/ts}', 'Positive', 0, 1, 1, 2, 2 ), | |
1510 | (3, 'No-show', '{ts escape="sql"}No-show{/ts}', 'Negative', 0, 1, 0, 3, 2 ), | |
1511 | (4, 'Cancelled', '{ts escape="sql"}Cancelled{/ts}', 'Negative', 1, 1, 0, 4, 2 ), | |
1512 | (5, 'Pending from pay later', '{ts escape="sql"}Pending from pay later{/ts}', 'Pending', 1, 1, 1, 5, 2 ), | |
1513 | (6, 'Pending from incomplete transaction', '{ts escape="sql"}Pending from incomplete transaction{/ts}', 'Pending', 1, 1, 0, 6, 2 ), | |
1514 | (7, 'On waitlist', '{ts escape="sql"}On waitlist{/ts}', 'Waiting', 1, 0, 0, 7, 2 ), | |
1515 | (8, 'Awaiting approval', '{ts escape="sql"}Awaiting approval{/ts}', 'Waiting', 1, 0, 1, 8, 2 ), | |
1516 | (9, 'Pending from waitlist', '{ts escape="sql"}Pending from waitlist{/ts}', 'Pending', 1, 0, 1, 9, 2 ), | |
1517 | (10, 'Pending from approval', '{ts escape="sql"}Pending from approval{/ts}', 'Pending', 1, 0, 1, 10, 2 ), | |
1518 | (11, 'Rejected', '{ts escape="sql"}Rejected{/ts}', 'Negative', 1, 0, 0, 11, 2 ), | |
1519 | (12, 'Expired', '{ts escape="sql"}Expired{/ts}', 'Negative', 1, 1, 0, 12, 2 ), | |
59e44db1 | 1520 | (13, 'Pending in cart', '{ts escape="sql"}Pending in cart{/ts}', 'Pending', 1, 1, 0, 13, 2 ), |
0f602e3f PJ |
1521 | (14, 'Partially paid', '{ts escape="sql"}Partially paid{/ts}', 'Positive', 1, 1, 1, 14, 2 ), |
1522 | (15, 'Pending refund', '{ts escape="sql"}Pending refund{/ts}', 'Positive', 1, 1, 1, 14, 2 ); | |
59e44db1 | 1523 | |
6a488035 TO |
1524 | |
1525 | ||
1526 | -- CRM-8150 | |
1527 | INSERT INTO civicrm_action_mapping | |
1528 | (entity, entity_value, entity_value_label, entity_status, entity_status_label, entity_date_start, entity_date_end, entity_recipient) | |
1529 | VALUES | |
1530 | ( 'civicrm_activity', 'activity_type', 'Activity Type', 'activity_status', 'Activity Status', 'activity_date_time', NULL, 'activity_contacts'), | |
1531 | ( 'civicrm_participant', 'event_type', 'Event Type', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'), | |
1532 | ( 'civicrm_participant', 'civicrm_event', 'Event Name', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'), | |
1533 | ( 'civicrm_membership', 'civicrm_membership_type', 'Membership Type', 'auto_renew_options', 'Auto Renew Options', 'membership_join_date', 'membership_end_date', NULL), | |
3d65c75c AH |
1534 | ( 'civicrm_participant', 'event_template', 'Event Template', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'), |
1535 | ( 'civicrm_contact', 'civicrm_contact', 'Date Field', 'contact_date_reminder_options', 'Annual Options', 'date_field', NULL, NULL); | |
6a488035 TO |
1536 | |
1537 | INSERT INTO `civicrm_contact_type` | |
1538 | (`id`, `name`, `label`,`image_URL`, `parent_id`, `is_active`,`is_reserved`) | |
1539 | VALUES | |
1540 | ( 1, 'Individual' , '{ts escape="sql"}Individual{/ts}' , NULL, NULL, 1, 1), | |
1541 | ( 2, 'Household' , '{ts escape="sql"}Household{/ts}' , NULL, NULL, 1, 1), | |
1542 | ( 3, 'Organization', '{ts escape="sql"}Organization{/ts}', NULL, NULL, 1, 1); | |
1543 | ||
1544 | {include file='civicrm_msg_template.tpl'} | |
1545 | ||
1546 | -- CRM-8358 | |
1547 | ||
1548 | INSERT INTO `civicrm_job` | |
1549 | ( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active ) | |
1550 | VALUES | |
1551 | ( @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), | |
1552 | ( @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), | |
1553 | ( @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), | |
1554 | ( @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), | |
1555 | ( @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 | |
1556 | parse=[1 or 0] required | |
1557 | start=[contact ID] optional-begin with this contact ID | |
1558 | end=[contact ID] optional-process contacts with IDs less than this | |
1559 | throttle=[1 or 0] optional-1 adds five second sleep{/ts}', 0), | |
1560 | ( @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 | |
1561 | gt=[email_greeting or postal_greeting or addressee] required | |
24f77640 | 1562 | force=[0 or 1] optional-0 update contacts with null value, 1 update all |
1563 | limit=Number optional-Limit the number of contacts to update{/ts}', 0), | |
6a488035 TO |
1564 | ( @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 |
1565 | format=[csv or print] optional-output CSV or print-friendly HTML, else PDF{/ts}', 0), | |
1566 | ( @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), | |
1567 | ( @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), | |
1568 | ( @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), | |
1569 | ( @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), | |
1570 | ( @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), | |
1571 | ( @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), | |
1572 | ( @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), | |
1573 | ( @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), | |
1574 | ( @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); | |
1575 | ||
4636d4fd DL |
1576 | SELECT @option_value_rel_id := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Income Account is'; |
1577 | SELECT @option_value_rel_id_exp := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Expense Account is'; | |
1578 | SELECT @option_value_rel_id_ar := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Accounts Receivable Account is'; | |
1579 | SELECT @option_value_rel_id_as := value FROM civicrm_option_value WHERE option_group_id = @option_group_id_arel AND name = 'Asset Account is'; | |
ddaa8ef1 | 1580 | SELECT @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 | 1581 | |
a235e13c | 1582 | SELECT @financial_type_id_dtn := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Donation{/ts}'; |
1583 | SELECT @financial_type_id_md := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Member Dues{/ts}'; | |
1584 | SELECT @financial_type_id_cc := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Campaign Contribution{/ts}'; | |
1585 | SELECT @financial_type_id_ef := max(id) FROM civicrm_financial_type WHERE name = '{ts escape="sql"}Event Fee{/ts}'; | |
4636d4fd DL |
1586 | |
1587 | SELECT @financial_account_id_dtn := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Donation{/ts}'; | |
a235e13c | 1588 | SELECT @financial_account_id_md := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Member Dues{/ts}'; |
1589 | SELECT @financial_account_id_cc := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Campaign Contribution{/ts}'; | |
1590 | SELECT @financial_account_id_ef := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Event Fee{/ts}'; | |
1591 | SELECT @financial_account_id_bf := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Banking Fees{/ts}'; | |
1592 | SELECT @financial_account_id_ap := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Accounts Receivable{/ts}'; | |
4636d4fd DL |
1593 | SELECT @financial_account_id_ar := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Deposit Bank Account{/ts}'; |
1594 | SELECT @financial_account_id_pp := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Payment Processor Account{/ts}'; | |
ddaa8ef1 | 1595 | SELECT @financial_account_id_pr := max(id) FROM civicrm_financial_account WHERE name = '{ts escape="sql"}Premiums{/ts}'; |
6a488035 TO |
1596 | |
1597 | INSERT INTO `civicrm_entity_financial_account` | |
1598 | ( entity_table, entity_id, account_relationship, financial_account_id ) | |
1599 | VALUES | |
1600 | ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id, @financial_account_id_dtn ), | |
1601 | ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_exp, @financial_account_id_bf ), | |
1602 | ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_ar, @financial_account_id_ap ), | |
ddaa8ef1 | 1603 | ( 'civicrm_financial_type', @financial_type_id_dtn, @option_value_rel_id_cg, @financial_account_id_pr ), |
6a488035 TO |
1604 | ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id, @financial_account_id_md ), |
1605 | ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_exp, @financial_account_id_bf ), | |
1606 | ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_ar, @financial_account_id_ap ), | |
ddaa8ef1 | 1607 | ( 'civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_cg, @financial_account_id_pr ), |
6a488035 TO |
1608 | ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id, @financial_account_id_cc ), |
1609 | ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_exp, @financial_account_id_bf ), | |
1610 | ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_ar, @financial_account_id_ap ), | |
ddaa8ef1 | 1611 | ( 'civicrm_financial_type', @financial_type_id_cc, @option_value_rel_id_cg, @financial_account_id_pr ), |
6a488035 TO |
1612 | ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_exp, @financial_account_id_bf ), |
1613 | ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_ar, @financial_account_id_ap ), | |
ddaa8ef1 PN |
1614 | ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id, @financial_account_id_ef ), |
1615 | ( 'civicrm_financial_type', @financial_type_id_ef, @option_value_rel_id_cg, @financial_account_id_pr ); | |
6a488035 TO |
1616 | |
1617 | -- CRM-11516 | |
1618 | INSERT INTO civicrm_entity_financial_account (entity_table, entity_id, account_relationship, financial_account_id) | |
1619 | SELECT 'civicrm_option_value', cov.id, @option_value_rel_id_as, @financial_account_id_ar FROM `civicrm_option_group` cog | |
1620 | LEFT JOIN civicrm_option_value cov ON cog.id = cov.option_group_id | |
1621 | WHERE cog.name = 'payment_instrument' AND cov.name NOT IN ('Credit Card', 'Debit Card'); | |
1622 | ||
1623 | SELECT @option_value_cc_id := max(id) FROM `civicrm_option_value` WHERE `option_group_id` = @option_group_id_pi AND `name` = 'Credit Card'; | |
1624 | SELECT @option_value_dc_id := max(id) FROM `civicrm_option_value` WHERE `option_group_id` = @option_group_id_pi AND `name` = 'Debit Card'; | |
1625 | ||
1626 | INSERT INTO `civicrm_entity_financial_account` | |
1627 | ( entity_table, entity_id, account_relationship, financial_account_id ) | |
1628 | VALUES | |
1629 | ( 'civicrm_option_value', @option_value_cc_id, @option_value_rel_id_as, @financial_account_id_pp), | |
1630 | ( 'civicrm_option_value', @option_value_dc_id, @option_value_rel_id_as, @financial_account_id_pp); | |
1631 | ||
1632 | -- CRM-9714 | |
1633 | ||
1634 | SELECT @financial_type_id := max(id) FROM `civicrm_financial_type` WHERE `name` = 'Member Dues'; | |
1635 | INSERT INTO `civicrm_price_set` ( `name`, `title`, `is_active`, `extends`, `is_quick_config`, `financial_type_id`, `is_reserved` ) | |
1636 | VALUES ( 'default_contribution_amount', 'Contribution Amount', '1', '2', '1', NULL,1), | |
1637 | ( 'default_membership_type_amount', 'Membership Amount', '1', '3', '1', @financial_type_id,1); | |
1638 | ||
1639 | SELECT @setID := max(id) FROM civicrm_price_set WHERE name = 'default_contribution_amount' AND extends = 2 AND is_quick_config = 1 ; | |
1640 | ||
1641 | INSERT INTO `civicrm_price_field` (`price_set_id`, `name`, `label`, `html_type`,`weight`, `is_display_amounts`, `options_per_line`, `is_active`, `is_required`,`visibility_id` ) | |
1642 | VALUES ( @setID, 'contribution_amount', 'Contribution Amount', 'Text', '1', '1', '1', '1', '1', '1' ); | |
1643 | ||
1644 | SELECT @fieldID := max(id) FROM civicrm_price_field WHERE name = 'contribution_amount' AND price_set_id = @setID; | |
1645 | ||
1646 | INSERT INTO `civicrm_price_field_value` ( `price_field_id`, `name`, `label`, `amount`, `weight`, `is_default`, `is_active`, `financial_type_id`) | |
1647 | VALUES ( @fieldID, 'contribution_amount', 'Contribution Amount', '1', '1', '0', '1', 1); | |
1648 | ||
51fa20cb | 1649 | -- CRM-13833 |
1650 | INSERT 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); | |
1651 | ||
1652 | SELECT @option_group_id_soft_credit_type := max(id) from civicrm_option_group where name = 'soft_credit_type'; | |
1653 | ||
1654 | INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `weight`, `is_default`, `is_active`, `is_reserved`) | |
1655 | VALUES | |
1656 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}In Honor of{/ts}'{/localize}, 1, 'in_honor_of', 1, 0, 1, 1), | |
1657 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}In Memory of{/ts}'{/localize}, 2, 'in_memory_of', 2, 0, 1, 1), | |
1658 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Solicited{/ts}'{/localize}, 3, 'solicited', 3, 1, 1, 1), | |
1659 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Household{/ts}'{/localize}, 4, 'household', 4, 0, 1, 0), | |
1660 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Workplace Giving{/ts}'{/localize}, 5, 'workplace', 5, 0, 1, 0), | |
1661 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Foundation Affiliate{/ts}'{/localize}, 6, 'foundation_affiliate', 6, 0, 1, 0), | |
1662 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}3rd-party Service{/ts}'{/localize}, 7, '3rd-party_service', 7, 0, 1, 0), | |
1663 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Donor-advised Fund{/ts}'{/localize}, 8, 'donor-advised_fund', 8, 0, 1, 0), | |
1664 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Matched Gift{/ts}'{/localize}, 9, 'matched_gift', 9, 0, 1, 0), | |
12792976 | 1665 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Personal Campaign Page{/ts}'{/localize}, 10, 'pcp', 10, 0, 1, 1), |
1666 | (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Gift{/ts}'{/localize}, 11, 'gift', 11, 0, 1, 1); |