From aa2422438fa6679c9f92757dbee71d8d4777af0e Mon Sep 17 00:00:00 2001 From: Aidan Saunders Date: Fri, 9 Dec 2022 12:37:02 +0000 Subject: [PATCH] Change description field to text Add Option Group descriptions from templates/CRM/Admin/Page/Options.tpl --- .../Incremental/php/FiveFiftyEight.php | 59 ++++++ xml/schema/Core/OptionGroup.xml | 3 +- xml/templates/civicrm_data.tpl | 179 ++++++++++-------- 3 files changed, 155 insertions(+), 86 deletions(-) diff --git a/CRM/Upgrade/Incremental/php/FiveFiftyEight.php b/CRM/Upgrade/Incremental/php/FiveFiftyEight.php index 9133a57085..e8c12fb884 100644 --- a/CRM/Upgrade/Incremental/php/FiveFiftyEight.php +++ b/CRM/Upgrade/Incremental/php/FiveFiftyEight.php @@ -29,6 +29,65 @@ class CRM_Upgrade_Incremental_php_FiveFiftyEight extends CRM_Upgrade_Incremental */ public function upgrade_5_58_alpha1($rev): void { $this->addTask(ts('Upgrade DB to %1: SQL', [1 => $rev]), 'runSql', $rev); + $this->addTask('Add option group descriptions', 'addOptionGroupDescriptions'); + } + + public static function addOptionGroupDescriptions($ctx): bool { + CRM_Core_DAO::executeQuery('ALTER TABLE `civicrm_option_group` MODIFY COLUMN `description` TEXT'); + $values = [ + [ + 'group' => 'gender', + 'description' => '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual gender (Male, Female, Other). Modify these options as needed for your installation.{/ts}', + ], + [ + 'group' => 'individual_prefix', + 'description' => '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual contact prefixes (Ms., Mr., Dr. etc.). Customize these options and add new ones as needed for your installation.{/ts}', + ], + [ + 'group' => 'mobile_provider', + 'description' => '{ts escape="sql"}When recording mobile phone numbers for contacts, it may be useful to include the Mobile Phone Service Provider (e.g. Cingular, Sprint, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.{/ts}', + ], + [ + 'group' => 'instant_messenger_service', + 'description' => '{ts escape="sql"}When recording Instant Messenger (IM) \'screen names\' for contacts, it is useful to include the IM Service Provider (e.g. AOL, Yahoo, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.{/ts}', + ], + [ + 'group' => 'individual_suffix', + 'description' => '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual contact name suffixes (Jr., Sr., II etc.). Customize these options and add new ones as needed for your installation.{/ts}', + ], + [ + 'group' => 'activity_type', + 'description' => '{ts escape="sql"}Activities are \'interactions with contacts\' which you want to record and track. This list is sorted by component and then by weight within the component.{/ts}', + ], + [ + 'group' => 'payment_instrument', + 'description' => '{ts escape="sql"}You may choose to record the payment method used for each contribution and fee. Reserved payment methods are required - you may modify their labels but they can not be deleted (e.g. Check, Credit Card, Debit Card). If your site requires additional payment methods, you can add them here. You can associate each payment method with a Financial Account which specifies where the payment is going (e.g. a bank account for checks and cash).{/ts}', + ], + [ + 'group' => 'accept_creditcard', + 'description' => '{ts escape="sql"}The following credit card options will be offered to contributors using Online Contribution pages. You will need to verify which cards are accepted by your chosen Payment Processor and update these entries accordingly.{/ts}

' + . '{ts escape="sql"}IMPORTANT: This page does NOT control credit card/payment method choices for sites and/or contributors using the PayPal Express service (e.g. where billing information is collected on the Payment Processor\'s website).{/ts}', + ], + [ + 'group' => 'event_type', + 'description' => '{ts escape="sql"}Use Event Types to categorize your events. Event feeds can be filtered by Event Type and participant searches can use Event Type as a criteria.{/ts}', + ], + [ + 'group' => 'participant_role', + 'description' => '{ts escape="sql"}Define participant roles for events here (e.g. Attendee, Host, Speaker...). You can then assign roles and search for participants by role.{/ts}', + ], + [ + 'group' => 'from_email_address', + 'description' => '{ts escape="sql"}By default, CiviCRM uses the primary email address of the logged in user as the FROM address when sending emails to contacts. However, you can use this page to define one or more general Email Addresses that can be selected as an alternative. EXAMPLE: "Client Services" <clientservices@example.org>{/ts}', + ], + ]; + foreach ($values as $value) { + CRM_Core_DAO::executeQuery('UPDATE `civicrm_option_group` SET `description` = %1 WHERE `name` = %2', [ + 1 => [$value['description'], 'String'], + 2 => [$value['group'], 'String'], + ]); + } + return TRUE; } } diff --git a/xml/schema/Core/OptionGroup.xml b/xml/schema/Core/OptionGroup.xml index ae12e22995..f4e3f62031 100644 --- a/xml/schema/Core/OptionGroup.xml +++ b/xml/schema/Core/OptionGroup.xml @@ -42,8 +42,7 @@ description Option Group Description - varchar - 255 + text true Option group description. 1.5 diff --git a/xml/templates/civicrm_data.tpl b/xml/templates/civicrm_data.tpl index 2012ca4755..b3b40fc40a 100644 --- a/xml/templates/civicrm_data.tpl +++ b/xml/templates/civicrm_data.tpl @@ -119,91 +119,102 @@ VALUES -- option groups and values for 'preferred communication methods' , 'activity types', 'gender', etc. INSERT INTO - `civicrm_option_group` (`name`, `title`, `data_type`, `is_reserved`, `is_active`, `is_locked`, `option_value_fields`) + `civicrm_option_group` (`name`, `title`, `data_type`, `is_reserved`, `is_active`, `is_locked`, `option_value_fields`, `description`) VALUES - ('preferred_communication_method', '{ts escape="sql"}Preferred Communication Method{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('activity_type' , '{ts escape="sql"}Activity Type{/ts}' , 'Integer', 1, 1, 0, 'name,label,description,icon'), - ('gender' , '{ts escape="sql"}Gender{/ts}' , 'Integer', 1, 1, 0, 'name,label,description'), - ('instant_messenger_service' , '{ts escape="sql"}Instant Messenger (IM) screen-names{/ts}', NULL, 1, 1, 0, 'name,label,description'), - ('mobile_provider' , '{ts escape="sql"}Mobile Phone Providers{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('individual_prefix' , '{ts escape="sql"}Individual contact prefixes{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('individual_suffix' , '{ts escape="sql"}Individual contact suffixes{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('acl_role' , '{ts escape="sql"}ACL Role{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('accept_creditcard' , '{ts escape="sql"}Accepted Credit Cards{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('payment_instrument' , '{ts escape="sql"}Payment Methods{/ts}' , 'Integer', 1, 1, 0, 'name,label,description'), - ('contribution_status' , '{ts escape="sql"}Contribution Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('pcp_status' , '{ts escape="sql"}PCP Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('pcp_owner_notify' , '{ts escape="sql"}PCP owner notifications{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('participant_role' , '{ts escape="sql"}Participant Role{/ts}' , 'Integer', 1, 1, 0, 'name,label,description'), - ('event_type' , '{ts escape="sql"}Event Type{/ts}' , 'Integer', 1, 1, 0, 'name,label,description'), - ('contact_view_options' , '{ts escape="sql"}Contact View Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('contact_smart_group_display' , '{ts escape="sql"}Contact Smart Group View Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('contact_edit_options' , '{ts escape="sql"}Contact Edit Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('advanced_search_options' , '{ts escape="sql"}Advanced Search Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('user_dashboard_options' , '{ts escape="sql"}User Dashboard Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('address_options' , '{ts escape="sql"}Addressing Options{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('group_type' , '{ts escape="sql"}Group Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('custom_search' , '{ts escape="sql"}Custom Search{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('activity_status' , '{ts escape="sql"}Activity Status{/ts}' , 'Integer', 1, 1, 0, 'name,label,description,color'), - ('case_type' , '{ts escape="sql"}Case Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('case_status' , '{ts escape="sql"}Case Status{/ts}' , NULL, 1, 1, 0, 'name,label,description,color'), - ('participant_listing' , '{ts escape="sql"}Participant Listing{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('safe_file_extension' , '{ts escape="sql"}Safe File Extension{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('from_email_address' , '{ts escape="sql"}From Email Address{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('mapping_type' , '{ts escape="sql"}Mapping Type{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('wysiwyg_editor' , '{ts escape="sql"}WYSIWYG Editor{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('recur_frequency_units' , '{ts escape="sql"}Recurring Frequency Units{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('phone_type' , '{ts escape="sql"}Phone Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('custom_data_type' , '{ts escape="sql"}Custom Data Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('visibility' , '{ts escape="sql"}Visibility{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('mail_protocol' , '{ts escape="sql"}Mail Protocol{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('priority' , '{ts escape="sql"}Priority{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('redaction_rule' , '{ts escape="sql"}Redaction Rule{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('report_template' , '{ts escape="sql"}Report Template{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('email_greeting' , '{ts escape="sql"}Email Greeting Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('postal_greeting' , '{ts escape="sql"}Postal Greeting Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('addressee' , '{ts escape="sql"}Addressee Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('contact_autocomplete_options' , '{ts escape="sql"}Autocomplete Contact Search{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('contact_reference_options' , '{ts escape="sql"}Contact Reference Autocomplete Options{/ts}', NULL, 1, 1, 1, 'name,label,description'), - ('website_type' , '{ts escape="sql"}Website Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('tag_used_for' , '{ts escape="sql"}Tag Used For{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('note_used_for' , '{ts escape="sql"}Note Used For{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('currencies_enabled' , '{ts escape="sql"}Currencies Enabled{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('event_badge' , '{ts escape="sql"}Event Name Badge{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('note_privacy' , '{ts escape="sql"}Privacy levels for notes{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('campaign_type' , '{ts escape="sql"}Campaign Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('campaign_status' , '{ts escape="sql"}Campaign Status{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('system_extensions' , '{ts escape="sql"}CiviCRM Extensions{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('mail_approval_status' , '{ts escape="sql"}CiviMail Approval Status{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('engagement_index' , '{ts escape="sql"}Engagement Index{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('cg_extend_objects' , '{ts escape="sql"}Objects a custom group extends to{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('paper_size' , '{ts escape="sql"}Paper Size{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('pdf_format' , '{ts escape="sql"}PDF Page Format{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('label_format' , '{ts escape="sql"}Mailing Label Format{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('activity_contacts' , '{ts escape="sql"}Activity Contacts{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('account_relationship' , '{ts escape="sql"}Account Relationship{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('event_contacts' , '{ts escape="sql"}Event Recipients{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('conference_slot' , '{ts escape="sql"}Conference Slot{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('batch_type' , '{ts escape="sql"}Batch Type{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('batch_mode' , '{ts escape="sql"}Batch Mode{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('batch_status' , '{ts escape="sql"}Batch Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('sms_api_type' , '{ts escape="sql"}Api Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('sms_provider_name' , '{ts escape="sql"}Sms Provider Internal Name{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('auto_renew_options' , '{ts escape="sql"}Auto Renew Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('financial_account_type' , '{ts escape="sql"}Financial Account Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('financial_item_status' , '{ts escape="sql"}Financial Item Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('label_type' , '{ts escape="sql"}Label Type{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('name_badge' , '{ts escape="sql"}Name Badge Format{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('communication_style' , '{ts escape="sql"}Communication Style{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('msg_mode' , '{ts escape="sql"}Message Mode{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('contact_date_reminder_options' , '{ts escape="sql"}Contact Date Reminder Options{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('wysiwyg_presets' , '{ts escape="sql"}WYSIWYG Editor Presets{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('relative_date_filters' , '{ts escape="sql"}Relative Date Filters{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('pledge_status' , '{ts escape="sql"}Pledge Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('contribution_recur_status' , '{ts escape="sql"}Recurring Contribution Status{/ts}' , NULL, 1, 1, 1, 'name,label,description'), - ('environment' , '{ts escape="sql"}Environment{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('activity_default_assignee' , '{ts escape="sql"}Activity default assignee{/ts}' , NULL, 1, 1, 0, 'name,label,description'), - ('entity_batch_extends' , '{ts escape="sql"}Entity Batch Extends{/ts}' , NULL, 1, 1, 0, 'name,label,description'); + ('preferred_communication_method', '{ts escape="sql"}Preferred Communication Method{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('activity_type' , '{ts escape="sql"}Activity Type{/ts}' , 'Integer', 1, 1, 0, 'name,label,description,icon', + '{ts escape="sql"}Activities are \'interactions with contacts\' which you want to record and track. This list is sorted by component and then by weight within the component.{/ts}'), + ('gender' , '{ts escape="sql"}Gender{/ts}' , 'Integer', 1, 1, 0, 'name,label,description', + '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual gender (Male, Female, Other). Modify these options as needed for your installation.{/ts}'), + ('instant_messenger_service' , '{ts escape="sql"}Instant Messenger (IM) screen-names{/ts}', NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}When recording Instant Messenger (IM) \'screen names\' for contacts, it is useful to include the IM Service Provider (e.g. AOL, Yahoo, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.{/ts}'), + ('mobile_provider' , '{ts escape="sql"}Mobile Phone Providers{/ts}' , NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}When recording mobile phone numbers for contacts, it may be useful to include the Mobile Phone Service Provider (e.g. Cingular, Sprint, etc.). CiviCRM is installed with the most commonly encountered service providers. Administrators may define as many additional providers as needed.{/ts}'), + ('individual_prefix' , '{ts escape="sql"}Individual contact prefixes{/ts}' , NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual contact prefixes (Ms., Mr., Dr. etc.). Customize these options and add new ones as needed for your installation.{/ts}'), + ('individual_suffix' , '{ts escape="sql"}Individual contact suffixes{/ts}' , NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}CiviCRM is pre-configured with standard options for individual contact name suffixes (Jr., Sr., II etc.). Customize these options and add new ones as needed for your installation.{/ts}'), + ('acl_role' , '{ts escape="sql"}ACL Role{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('accept_creditcard' , '{ts escape="sql"}Accepted Credit Cards{/ts}' , NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}The following credit card options will be offered to contributors using Online Contribution pages. You will need to verify which cards are accepted by your chosen Payment Processor and update these entries accordingly.{/ts}

{ts escape="sql"}IMPORTANT: This page does NOT control credit card/payment method choices for sites and/or contributors using the PayPal Express service (e.g. where billing information is collected on the Payment Processor\'s website).{/ts}'), + ('payment_instrument' , '{ts escape="sql"}Payment Methods{/ts}' , 'Integer', 1, 1, 0, 'name,label,description', + '{ts escape="sql"}You may choose to record the payment method used for each contribution and fee. Reserved payment methods are required - you may modify their labels but they can not be deleted (e.g. Check, Credit Card, Debit Card). If your site requires additional payment methods, you can add them here. You can associate each payment method with a Financial Account which specifies where the payment is going (e.g. a bank account for checks and cash).{/ts}'), + ('contribution_status' , '{ts escape="sql"}Contribution Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('pcp_status' , '{ts escape="sql"}PCP Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('pcp_owner_notify' , '{ts escape="sql"}PCP owner notifications{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('participant_role' , '{ts escape="sql"}Participant Role{/ts}' , 'Integer', 1, 1, 0, 'name,label,description', + '{ts escape="sql"}Define participant roles for events here (e.g. Attendee, Host, Speaker...). You can then assign roles and search for participants by role.{/ts}'), + ('event_type' , '{ts escape="sql"}Event Type{/ts}' , 'Integer', 1, 1, 0, 'name,label,description', + '{ts escape="sql"}Use Event Types to categorize your events. Event feeds can be filtered by Event Type and participant searches can use Event Type as a criteria.{/ts}'), + ('contact_view_options' , '{ts escape="sql"}Contact View Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('contact_smart_group_display' , '{ts escape="sql"}Contact Smart Group View Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('contact_edit_options' , '{ts escape="sql"}Contact Edit Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('advanced_search_options' , '{ts escape="sql"}Advanced Search Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('user_dashboard_options' , '{ts escape="sql"}User Dashboard Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('address_options' , '{ts escape="sql"}Addressing Options{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('group_type' , '{ts escape="sql"}Group Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('custom_search' , '{ts escape="sql"}Custom Search{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('activity_status' , '{ts escape="sql"}Activity Status{/ts}' , 'Integer', 1, 1, 0, 'name,label,description,color', NULL), + ('case_type' , '{ts escape="sql"}Case Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('case_status' , '{ts escape="sql"}Case Status{/ts}' , NULL, 1, 1, 0, 'name,label,description,color', NULL), + ('participant_listing' , '{ts escape="sql"}Participant Listing{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('safe_file_extension' , '{ts escape="sql"}Safe File Extension{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('from_email_address' , '{ts escape="sql"}From Email Address{/ts}' , NULL, 1, 1, 0, 'name,label,description', + '{ts escape="sql"}By default, CiviCRM uses the primary email address of the logged in user as the FROM address when sending emails to contacts. However, you can use this page to define one or more general Email Addresses that can be selected as an alternative. EXAMPLE: "Client Services" <clientservices@example.org>{/ts}'), + ('mapping_type' , '{ts escape="sql"}Mapping Type{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('wysiwyg_editor' , '{ts escape="sql"}WYSIWYG Editor{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('recur_frequency_units' , '{ts escape="sql"}Recurring Frequency Units{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('phone_type' , '{ts escape="sql"}Phone Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('custom_data_type' , '{ts escape="sql"}Custom Data Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('visibility' , '{ts escape="sql"}Visibility{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('mail_protocol' , '{ts escape="sql"}Mail Protocol{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('priority' , '{ts escape="sql"}Priority{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('redaction_rule' , '{ts escape="sql"}Redaction Rule{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('report_template' , '{ts escape="sql"}Report Template{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('email_greeting' , '{ts escape="sql"}Email Greeting Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('postal_greeting' , '{ts escape="sql"}Postal Greeting Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('addressee' , '{ts escape="sql"}Addressee Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('contact_autocomplete_options' , '{ts escape="sql"}Autocomplete Contact Search{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('contact_reference_options' , '{ts escape="sql"}Contact Reference Autocomplete Options{/ts}', NULL, 1, 1, 1, 'name,label,description', NULL), + ('website_type' , '{ts escape="sql"}Website Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('tag_used_for' , '{ts escape="sql"}Tag Used For{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('note_used_for' , '{ts escape="sql"}Note Used For{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('currencies_enabled' , '{ts escape="sql"}Currencies Enabled{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('event_badge' , '{ts escape="sql"}Event Name Badge{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('note_privacy' , '{ts escape="sql"}Privacy levels for notes{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('campaign_type' , '{ts escape="sql"}Campaign Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('campaign_status' , '{ts escape="sql"}Campaign Status{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('system_extensions' , '{ts escape="sql"}CiviCRM Extensions{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('mail_approval_status' , '{ts escape="sql"}CiviMail Approval Status{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('engagement_index' , '{ts escape="sql"}Engagement Index{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('cg_extend_objects' , '{ts escape="sql"}Objects a custom group extends to{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('paper_size' , '{ts escape="sql"}Paper Size{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('pdf_format' , '{ts escape="sql"}PDF Page Format{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('label_format' , '{ts escape="sql"}Mailing Label Format{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('activity_contacts' , '{ts escape="sql"}Activity Contacts{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('account_relationship' , '{ts escape="sql"}Account Relationship{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('event_contacts' , '{ts escape="sql"}Event Recipients{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('conference_slot' , '{ts escape="sql"}Conference Slot{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('batch_type' , '{ts escape="sql"}Batch Type{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('batch_mode' , '{ts escape="sql"}Batch Mode{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('batch_status' , '{ts escape="sql"}Batch Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('sms_api_type' , '{ts escape="sql"}Api Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('sms_provider_name' , '{ts escape="sql"}Sms Provider Internal Name{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('auto_renew_options' , '{ts escape="sql"}Auto Renew Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('financial_account_type' , '{ts escape="sql"}Financial Account Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('financial_item_status' , '{ts escape="sql"}Financial Item Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('label_type' , '{ts escape="sql"}Label Type{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('name_badge' , '{ts escape="sql"}Name Badge Format{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('communication_style' , '{ts escape="sql"}Communication Style{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('msg_mode' , '{ts escape="sql"}Message Mode{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('contact_date_reminder_options' , '{ts escape="sql"}Contact Date Reminder Options{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('wysiwyg_presets' , '{ts escape="sql"}WYSIWYG Editor Presets{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('relative_date_filters' , '{ts escape="sql"}Relative Date Filters{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('pledge_status' , '{ts escape="sql"}Pledge Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('contribution_recur_status' , '{ts escape="sql"}Recurring Contribution Status{/ts}' , NULL, 1, 1, 1, 'name,label,description', NULL), + ('environment' , '{ts escape="sql"}Environment{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('activity_default_assignee' , '{ts escape="sql"}Activity default assignee{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL), + ('entity_batch_extends' , '{ts escape="sql"}Entity Batch Extends{/ts}' , NULL, 1, 1, 0, 'name,label,description', NULL); SELECT @option_group_id_pcm := max(id) from civicrm_option_group where name = 'preferred_communication_method'; SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type'; -- 2.25.1