-- option groups and values for 'preferred communication methods' , 'activity types', 'gender', etc.
INSERT INTO
- `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`)
+ `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`)
VALUES
- ('preferred_communication_method', '{ts escape="sql"}Preferred Communication Method{/ts}' , 1, 1),
- ('activity_type' , '{ts escape="sql"}Activity Type{/ts}' , 1, 1),
- ('gender' , '{ts escape="sql"}Gender{/ts}' , 1, 1),
- ('instant_messenger_service' , '{ts escape="sql"}Instant Messenger (IM) screen-names{/ts}', 1, 1),
- ('mobile_provider' , '{ts escape="sql"}Mobile Phone Providers{/ts}' , 1, 1),
- ('individual_prefix' , '{ts escape="sql"}Individual contact prefixes{/ts}' , 1, 1),
- ('individual_suffix' , '{ts escape="sql"}Individual contact suffixes{/ts}' , 1, 1),
- ('acl_role' , '{ts escape="sql"}ACL Role{/ts}' , 1, 1),
- ('accept_creditcard' , '{ts escape="sql"}Accepted Credit Cards{/ts}' , 1, 1),
- ('payment_instrument' , '{ts escape="sql"}Payment Instruments{/ts}' , 1, 1),
- ('contribution_status' , '{ts escape="sql"}Contribution Status{/ts}' , 1, 1),
- ('pcp_status' , '{ts escape="sql"}PCP Status{/ts}' , 1, 1),
- ('participant_role' , '{ts escape="sql"}Participant Role{/ts}' , 1, 1),
- ('event_type' , '{ts escape="sql"}Event Type{/ts}' , 1, 1),
- ('contact_view_options' , '{ts escape="sql"}Contact View Options{/ts}' , 1, 1),
- ('contact_smart_group_display' , '{ts escape="sql"}Contact Smart Group View Options{/ts}' , 1, 1),
- ('contact_edit_options' , '{ts escape="sql"}Contact Edit Options{/ts}' , 1, 1),
- ('advanced_search_options' , '{ts escape="sql"}Advanced Search Options{/ts}' , 1, 1),
- ('user_dashboard_options' , '{ts escape="sql"}User Dashboard Options{/ts}' , 1, 1),
- ('address_options' , '{ts escape="sql"}Addressing Options{/ts}' , 1, 1),
- ('group_type' , '{ts escape="sql"}Group Type{/ts}' , 1, 1),
- ('grant_status' , '{ts escape="sql"}Grant status{/ts}' , 1, 1),
- ('grant_type' , '{ts escape="sql"}Grant Type{/ts}' , 1, 1),
- ('custom_search' , '{ts escape="sql"}Custom Search{/ts}' , 1, 1),
- ('activity_status' , '{ts escape="sql"}Activity Status{/ts}' , 1, 1),
- ('case_type' , '{ts escape="sql"}Case Type{/ts}' , 1, 1),
- ('case_status' , '{ts escape="sql"}Case Status{/ts}' , 1, 1),
- ('participant_listing' , '{ts escape="sql"}Participant Listing{/ts}' , 1, 1),
- ('safe_file_extension' , '{ts escape="sql"}Safe File Extension{/ts}' , 1, 1),
- ('from_email_address' , '{ts escape="sql"}From Email Address{/ts}' , 1, 1),
- ('mapping_type' , '{ts escape="sql"}Mapping Type{/ts}' , 1, 1),
- ('wysiwyg_editor' , '{ts escape="sql"}WYSIWYG Editor{/ts}' , 1, 1),
- ('recur_frequency_units' , '{ts escape="sql"}Recurring Frequency Units{/ts}' , 1, 1),
- ('phone_type' , '{ts escape="sql"}Phone Type{/ts}' , 1, 1),
- ('custom_data_type' , '{ts escape="sql"}Custom Data Type{/ts}' , 1, 1),
- ('visibility' , '{ts escape="sql"}Visibility{/ts}' , 1, 1),
- ('mail_protocol' , '{ts escape="sql"}Mail Protocol{/ts}' , 1, 1),
- ('priority' , '{ts escape="sql"}Priority{/ts}' , 1, 1),
- ('redaction_rule' , '{ts escape="sql"}Redaction Rule{/ts}' , 1, 1),
- ('report_template' , '{ts escape="sql"}Report Template{/ts}' , 1, 1),
- ('email_greeting' , '{ts escape="sql"}Email Greeting Type{/ts}' , 1, 1),
- ('postal_greeting' , '{ts escape="sql"}Postal Greeting Type{/ts}' , 1, 1),
- ('addressee' , '{ts escape="sql"}Addressee Type{/ts}' , 1, 1),
- ('contact_autocomplete_options' , '{ts escape="sql"}Autocomplete Contact Search{/ts}' , 1, 1),
- ('contact_reference_options' , '{ts escape="sql"}Contact Reference Autocomplete Options{/ts}', 1, 1),
- ('website_type' , '{ts escape="sql"}Website Type{/ts}' , 1, 1),
- ('tag_used_for' , '{ts escape="sql"}Tag Used For{/ts}' , 1, 1),
- ('currencies_enabled' , '{ts escape="sql"}Currencies Enabled{/ts}' , 1, 1),
- ('event_badge' , '{ts escape="sql"}Event Name Badge{/ts}' , 1, 1),
- ('note_privacy' , '{ts escape="sql"}Privacy levels for notes{/ts}' , 1, 1),
- ('campaign_type' , '{ts escape="sql"}Campaign Type{/ts}' , 1, 1),
- ('campaign_status' , '{ts escape="sql"}Campaign Status{/ts}' , 1, 1),
- ('system_extensions' , '{ts escape="sql"}CiviCRM Extensions{/ts}' , 1, 1),
- ('mail_approval_status' , '{ts escape="sql"}CiviMail Approval Status{/ts}' , 1, 1),
- ('engagement_index' , '{ts escape="sql"}Engagement Index{/ts}' , 1, 1),
- ('cg_extend_objects' , '{ts escape="sql"}Objects a custom group extends to{/ts}' , 1, 1),
- ('paper_size' , '{ts escape="sql"}Paper Size{/ts}' , 1, 1),
- ('pdf_format' , '{ts escape="sql"}PDF Page Format{/ts}' , 1, 1),
- ('label_format' , '{ts escape="sql"}Mailing Label Format{/ts}' , 1, 1),
- ('activity_contacts' , '{ts escape="sql"}Activity Contacts{/ts}' , 1, 1),
- ('account_relationship' , '{ts escape="sql"}Account Relationship{/ts}' , 1, 1),
- ('event_contacts' , '{ts escape="sql"}Event Recipients{/ts}' , 1, 1),
- ('conference_slot' , '{ts escape="sql"}Conference Slot{/ts}' , 1, 1),
- ('batch_type' , '{ts escape="sql"}Batch Type{/ts}' , 1, 1),
- ('batch_mode' , '{ts escape="sql"}Batch Mode{/ts}' , 1, 1),
- ('batch_status' , '{ts escape="sql"}Batch Status{/ts}' , 1, 1),
- ('sms_api_type' , '{ts escape="sql"}Api Type{/ts}' , 1, 1),
- ('sms_provider_name' , '{ts escape="sql"}Sms Provider Internal Name{/ts}' , 1, 1),
- ('auto_renew_options' , '{ts escape="sql"}Auto Renew Options{/ts}' , 1, 1),
- ('financial_account_type' , '{ts escape="sql"}Financial Account Type{/ts}' , 1, 1),
- ('financial_item_status' , '{ts escape="sql"}Financial Item Status{/ts}' , 1, 1),
- ('label_type' , '{ts escape="sql"}Label Type{/ts}' , 1, 1),
- ('name_badge' , '{ts escape="sql"}Name Badge Format{/ts}' , 1, 1),
- ('communication_style' , '{ts escape="sql"}Communication Style{/ts}' , 1, 1),
- ('msg_mode' , '{ts escape="sql"}Message Mode{/ts}' , 1, 1);
+ ('preferred_communication_method', '{ts escape="sql"}Preferred Communication Method{/ts}' , 1, 1, 0),
+ ('activity_type' , '{ts escape="sql"}Activity Type{/ts}' , 1, 1, 0),
+ ('gender' , '{ts escape="sql"}Gender{/ts}' , 1, 1, 0),
+ ('instant_messenger_service' , '{ts escape="sql"}Instant Messenger (IM) screen-names{/ts}', 1, 1, 0),
+ ('mobile_provider' , '{ts escape="sql"}Mobile Phone Providers{/ts}' , 1, 1, 0),
+ ('individual_prefix' , '{ts escape="sql"}Individual contact prefixes{/ts}' , 1, 1, 0),
+ ('individual_suffix' , '{ts escape="sql"}Individual contact suffixes{/ts}' , 1, 1, 0),
+ ('acl_role' , '{ts escape="sql"}ACL Role{/ts}' , 1, 1, 0),
+ ('accept_creditcard' , '{ts escape="sql"}Accepted Credit Cards{/ts}' , 1, 1, 0),
+ ('payment_instrument' , '{ts escape="sql"}Payment Instruments{/ts}' , 1, 1, 0),
+ ('contribution_status' , '{ts escape="sql"}Contribution Status{/ts}' , 1, 1, 1),
+ ('pcp_status' , '{ts escape="sql"}PCP Status{/ts}' , 1, 1, 1),
+ ('participant_role' , '{ts escape="sql"}Participant Role{/ts}' , 1, 1, 0),
+ ('event_type' , '{ts escape="sql"}Event Type{/ts}' , 1, 1, 0),
+ ('contact_view_options' , '{ts escape="sql"}Contact View Options{/ts}' , 1, 1, 1),
+ ('contact_smart_group_display' , '{ts escape="sql"}Contact Smart Group View Options{/ts}' , 1, 1, 1),
+ ('contact_edit_options' , '{ts escape="sql"}Contact Edit Options{/ts}' , 1, 1, 1),
+ ('advanced_search_options' , '{ts escape="sql"}Advanced Search Options{/ts}' , 1, 1, 1),
+ ('user_dashboard_options' , '{ts escape="sql"}User Dashboard Options{/ts}' , 1, 1, 1),
+ ('address_options' , '{ts escape="sql"}Addressing Options{/ts}' , 1, 1, 0),
+ ('group_type' , '{ts escape="sql"}Group Type{/ts}' , 1, 1, 0),
+ ('grant_status' , '{ts escape="sql"}Grant status{/ts}' , 1, 1, 0),
+ ('grant_type' , '{ts escape="sql"}Grant Type{/ts}' , 1, 1, 0),
+ ('custom_search' , '{ts escape="sql"}Custom Search{/ts}' , 1, 1, 0),
+ ('activity_status' , '{ts escape="sql"}Activity Status{/ts}' , 1, 1, 0),
+ ('case_type' , '{ts escape="sql"}Case Type{/ts}' , 1, 1, 0),
+ ('case_status' , '{ts escape="sql"}Case Status{/ts}' , 1, 1, 0),
+ ('participant_listing' , '{ts escape="sql"}Participant Listing{/ts}' , 1, 1, 0),
+ ('safe_file_extension' , '{ts escape="sql"}Safe File Extension{/ts}' , 1, 1, 0),
+ ('from_email_address' , '{ts escape="sql"}From Email Address{/ts}' , 1, 1, 0),
+ ('mapping_type' , '{ts escape="sql"}Mapping Type{/ts}' , 1, 1, 1),
+ ('wysiwyg_editor' , '{ts escape="sql"}WYSIWYG Editor{/ts}' , 1, 1, 0),
+ ('recur_frequency_units' , '{ts escape="sql"}Recurring Frequency Units{/ts}' , 1, 1, 0),
+ ('phone_type' , '{ts escape="sql"}Phone Type{/ts}' , 1, 1, 0),
+ ('custom_data_type' , '{ts escape="sql"}Custom Data Type{/ts}' , 1, 1, 0),
+ ('visibility' , '{ts escape="sql"}Visibility{/ts}' , 1, 1, 0),
+ ('mail_protocol' , '{ts escape="sql"}Mail Protocol{/ts}' , 1, 1, 0),
+ ('priority' , '{ts escape="sql"}Priority{/ts}' , 1, 1, 0),
+ ('redaction_rule' , '{ts escape="sql"}Redaction Rule{/ts}' , 1, 1, 0),
+ ('report_template' , '{ts escape="sql"}Report Template{/ts}' , 1, 1, 0),
+ ('email_greeting' , '{ts escape="sql"}Email Greeting Type{/ts}' , 1, 1, 0),
+ ('postal_greeting' , '{ts escape="sql"}Postal Greeting Type{/ts}' , 1, 1, 0),
+ ('addressee' , '{ts escape="sql"}Addressee Type{/ts}' , 1, 1, 0),
+ ('contact_autocomplete_options' , '{ts escape="sql"}Autocomplete Contact Search{/ts}' , 1, 1, 1),
+ ('contact_reference_options' , '{ts escape="sql"}Contact Reference Autocomplete Options{/ts}', 1, 1, 1),
+ ('website_type' , '{ts escape="sql"}Website Type{/ts}' , 1, 1, 0),
+ ('tag_used_for' , '{ts escape="sql"}Tag Used For{/ts}' , 1, 1, 1),
+ ('currencies_enabled' , '{ts escape="sql"}Currencies Enabled{/ts}' , 1, 1, 0),
+ ('event_badge' , '{ts escape="sql"}Event Name Badge{/ts}' , 1, 1, 0),
+ ('note_privacy' , '{ts escape="sql"}Privacy levels for notes{/ts}' , 1, 1, 0),
+ ('campaign_type' , '{ts escape="sql"}Campaign Type{/ts}' , 1, 1, 0),
+ ('campaign_status' , '{ts escape="sql"}Campaign Status{/ts}' , 1, 1, 0),
+ ('system_extensions' , '{ts escape="sql"}CiviCRM Extensions{/ts}' , 1, 1, 0),
+ ('mail_approval_status' , '{ts escape="sql"}CiviMail Approval Status{/ts}' , 1, 1, 0),
+ ('engagement_index' , '{ts escape="sql"}Engagement Index{/ts}' , 1, 1, 0),
+ ('cg_extend_objects' , '{ts escape="sql"}Objects a custom group extends to{/ts}' , 1, 1, 0),
+ ('paper_size' , '{ts escape="sql"}Paper Size{/ts}' , 1, 1, 0),
+ ('pdf_format' , '{ts escape="sql"}PDF Page Format{/ts}' , 1, 1, 0),
+ ('label_format' , '{ts escape="sql"}Mailing Label Format{/ts}' , 1, 1, 0),
+ ('activity_contacts' , '{ts escape="sql"}Activity Contacts{/ts}' , 1, 1, 1),
+ ('account_relationship' , '{ts escape="sql"}Account Relationship{/ts}' , 1, 1, 0),
+ ('event_contacts' , '{ts escape="sql"}Event Recipients{/ts}' , 1, 1, 0),
+ ('conference_slot' , '{ts escape="sql"}Conference Slot{/ts}' , 1, 1, 0),
+ ('batch_type' , '{ts escape="sql"}Batch Type{/ts}' , 1, 1, 1),
+ ('batch_mode' , '{ts escape="sql"}Batch Mode{/ts}' , 1, 1, 1),
+ ('batch_status' , '{ts escape="sql"}Batch Status{/ts}' , 1, 1, 1),
+ ('sms_api_type' , '{ts escape="sql"}Api Type{/ts}' , 1, 1, 0),
+ ('sms_provider_name' , '{ts escape="sql"}Sms Provider Internal Name{/ts}' , 1, 1, 0),
+ ('auto_renew_options' , '{ts escape="sql"}Auto Renew Options{/ts}' , 1, 1, 1),
+ ('financial_account_type' , '{ts escape="sql"}Financial Account Type{/ts}' , 1, 1, 0),
+ ('financial_item_status' , '{ts escape="sql"}Financial Item Status{/ts}' , 1, 1, 1),
+ ('label_type' , '{ts escape="sql"}Label Type{/ts}' , 1, 1, 0),
+ ('name_badge' , '{ts escape="sql"}Name Badge Format{/ts}' , 1, 1, 0),
+ ('communication_style' , '{ts escape="sql"}Communication Style{/ts}' , 1, 1, 0),
+ ('msg_mode' , '{ts escape="sql"}Message Mode{/ts}' , 1, 1, 0);
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';
(@option_group_id_gType, 'Access Control' , 1, NULL, NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
(@option_group_id_gType, 'Mailing List' , 2, NULL, NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Submitted{/ts}', 1, 'Submitted', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Approved{/ts}', 2, 'Approved', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Rejected{/ts}', 3, 'Rejected', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Paid{/ts}', 4, 'Paid', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Awaiting Information'{/ts}', 5, 'Awaiting Information', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_grantSt, '{ts escape="sql"}Withdrawn{/ts}', 6, 'Withdrawn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Submitted{/ts}', 1, 'Submitted', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Eligible{/ts}', 2, 'Eligible', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Ineligible{/ts}', 3, 'Ineligible', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Paid{/ts}', 4, 'Paid', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Awaiting Information{/ts}', 5, 'Awaiting Information', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_grantSt, '{ts escape="sql"}Withdrawn{/ts}', 6, 'Withdrawn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
+ (@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),
(@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),
(@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),
(@option_group_id_addressee, '{literal}Customized{/literal}', '4', '{literal}Customized{/literal}', NULL , 0 , '0', '4', NULL , '0', '1', '1', NULL , NULL),
-- website type
- (@option_group_id_website, 'Home', 1, 'Home', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_website, 'Work', 2, 'Work', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Work', 1, 'Work', NULL, 0, 1, 1, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Main', 2, 'Main', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
(@option_group_id_website, 'Facebook', 3, 'Facebook', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_website, 'Twitter', 4, 'Twitter', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_website, 'MySpace', 5, 'MySpace', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
- (@option_group_id_website, 'Main', 6, 'Main', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Google+', 4, 'Google_', NULL, 0, NULL, 4, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Instagram', 5, 'Instagram', NULL, 0, NULL, 5, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'LinkedIn', 6, 'LinkedIn', NULL, 0, NULL, 6, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'MySpace', 7, 'MySpace', NULL, 0, NULL, 7, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Pinterest', 8, 'Pinterest', NULL, 0, NULL, 8, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'SnapChat', 9, 'SnapChat', NULL, 0, NULL, 9, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Tumblr', 10, 'Tumblr', NULL, 0, NULL, 10, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Twitter', 11, 'Twitter', NULL, 0, NULL, 11, NULL, 0, 0, 1, NULL, NULL),
+ (@option_group_id_website, 'Vine', 12, 'Vine ', NULL, 0, NULL, 12, NULL, 0, 0, 1, NULL, NULL),
-- Tag used for
(@option_group_id_tuf, 'Contacts', 'civicrm_contact', 'Contacts', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
(1, 'User Account', NULL, NULL, 1, 1),
(1, 'Profile', NULL, NULL, 1, 1),
(1, 'Profile', NULL, NULL, 2, 2),
- (1, 'Profile', NULL, NULL, 3, 4),
- (1, 'Profile', NULL, NULL, 4, 5),
- (1, 'Profile', NULL, NULL, 5, 6),
- (1, 'Profile', NULL, NULL, 6, 7),
- (1, 'Profile', NULL, NULL, 7, 8),
- (1, 'Profile', NULL, NULL, 8, 9),
- (1, 'Profile', NULL, NULL, 9, 10),
- (1, 'Profile', NULL, NULL, 10, 11),
- (1, 'Profile', NULL, NULL, 11, 12),
- (1, 'Profile', NULL, NULL, 12, 13);
+ (1, 'Profile', NULL, NULL, 11, 12);
INSERT INTO civicrm_uf_field
( 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
projects / civicrm-core.git / blobdiff