-- +--------------------------------------------------------------------+
--- | CiviCRM version 4.4 |
+-- | CiviCRM version 4.5 |
-- +--------------------------------------------------------------------+
--- | Copyright CiviCRM LLC (c) 2004-2013 |
+-- | Copyright CiviCRM LLC (c) 2004-2014 |
-- +--------------------------------------------------------------------+
-- | This file is a part of CiviCRM. |
-- | |
-- 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),
- ('honor_type' , '{ts escape="sql"}Honor 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';
SELECT @option_group_id_gType := max(id) from civicrm_option_group where name = 'group_type';
SELECT @option_group_id_grantSt := max(id) from civicrm_option_group where name = 'grant_status';
SELECT @option_group_id_grantTyp := max(id) from civicrm_option_group where name = 'grant_type';
-SELECT @option_group_id_honorTyp := max(id) from civicrm_option_group where name = 'honor_type';
SELECT @option_group_id_csearch := max(id) from civicrm_option_group where name = 'custom_search';
SELECT @option_group_id_acs := max(id) from civicrm_option_group where name = 'activity_status';
SELECT @option_group_id_ct := max(id) from civicrm_option_group where name = 'case_type';
(@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),
(@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),
(@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),
- (@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),
+ (@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),
-- Activity Types for case activities
(@option_group_id_act, '{ts escape="sql"}Open Case{/ts}', 13, 'Open Case', NULL, 0, 0, 13, '', 0, 1, 1, @caseCompId, NULL),
(@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),
(@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),
+
+ -- Activity types for particial payment
+ (@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),
+ (@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),
+
+ -- for selection changes
+ (@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),
+
(@option_group_id_gender, '{ts escape="sql"}Female{/ts}', 1, 'Female', NULL, 0, NULL, 1, NULL, 0, 0, 1, NULL, NULL),
(@option_group_id_gender, '{ts escape="sql"}Male{/ts}', 2, 'Male', NULL, 0, NULL, 2, NULL, 0, 0, 1, NULL, NULL),
(@option_group_id_gender, '{ts escape="sql"}Transgender{/ts}', 3, 'Transgender', NULL, 0, NULL, 3, NULL, 0, 0, 1, NULL, NULL),
(@option_group_id_cs, '{ts escape="sql"}In Progress{/ts}', 5, 'In Progress', NULL, 0, NULL, 5, NULL, 0, 1, 1, NULL, NULL),
(@option_group_id_cs, '{ts escape="sql"}Overdue{/ts}' , 6, 'Overdue' , NULL, 0, NULL, 6, NULL, 0, 1, 1, NULL, NULL),
(@option_group_id_cs, '{ts escape="sql"}Refunded{/ts}' , 7, 'Refunded' , NULL, 0, NULL, 7, NULL, 0, 1, 1, NULL, NULL),
+ (@option_group_id_cs, '{ts escape="sql"}Partially paid{/ts}', 8, 'Partially paid', NULL, 0, NULL, 8, NULL, 0, 1, 1, NULL, NULL),
+ (@option_group_id_cs, '{ts escape="sql"}Pending refund{/ts}', 9, 'Pending refund', NULL, 0, NULL, 9, NULL, 0, 1, 1, NULL, NULL),
(@option_group_id_pcp, '{ts escape="sql"}Waiting Review{/ts}', 1, 'Waiting Review', NULL, 0, NULL, 1, NULL, 0, 1, 1, NULL, NULL),
(@option_group_id_pcp, '{ts escape="sql"}Approved{/ts}' , 2, 'Approved' , NULL, 0, NULL, 2, NULL, 0, 1, 1, NULL, NULL),
(@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_honorTyp, '{ts escape="sql"}In Honor of{/ts}' , 1, 'In Honor of' , NULL, 0, 1, 1, NULL, 0, 1, 1, NULL, NULL),
- (@option_group_id_honorTyp, '{ts escape="sql"}In Memory of{/ts}' , 2, 'In Memory of' , 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"}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),
(9, 'on_behalf_organization', 'Contact,Organization','{ts escape="sql"}On Behalf Of Organization{/ts}', 0, 1, NULL),
(10, 'contribution_batch_entry', 'Contribution', '{ts escape="sql"}Contribution Bulk Entry{/ts}' , 0, 1, NULL),
(11, 'membership_batch_entry', 'Membership', '{ts escape="sql"}Membership Bulk Entry{/ts}' , 0, 1, NULL),
- (12, 'event_registration', 'Individual, Contact', '{ts escape="sql"}Your Registration Info{/ts}', 0, 0, NULL),
- (13, 'honoree_individual', 'Individual, Contact', '{ts escape="sql"}Honoree Individual{/ts}', 0, 1, NULL);
+ (12, 'event_registration', 'Individual,Contact', '{ts escape="sql"}Your Registration Info{/ts}', 0, 0, NULL),
+ (13, 'honoree_individual', 'Individual,Contact', '{ts escape="sql"}Honoree Individual{/ts}', 0, 1, NULL);
INSERT INTO civicrm_uf_join
(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
(10, 'Pending from approval', '{ts escape="sql"}Pending from approval{/ts}', 'Pending', 1, 0, 1, 10, 2 ),
(11, 'Rejected', '{ts escape="sql"}Rejected{/ts}', 'Negative', 1, 0, 0, 11, 2 ),
(12, 'Expired', '{ts escape="sql"}Expired{/ts}', 'Negative', 1, 1, 0, 12, 2 ),
- (13, 'Pending in cart', '{ts escape="sql"}Pending in cart{/ts}', 'Pending', 1, 1, 0, 13, 2 );
+ (13, 'Pending in cart', '{ts escape="sql"}Pending in cart{/ts}', 'Pending', 1, 1, 0, 13, 2 ),
+ (14, 'Partially paid', '{ts escape="sql"}Partially paid{/ts}', 'Positive', 1, 1, 1, 14, 2 ),
+ (15, 'Pending refund', '{ts escape="sql"}Pending refund{/ts}', 'Positive', 1, 1, 1, 14, 2 );
+
-- CRM-8150
(@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}3rd-party Service{/ts}'{/localize}, 7, '3rd-party_service', 7, 0, 1, 0),
(@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Donor-advised Fund{/ts}'{/localize}, 8, 'donor-advised_fund', 8, 0, 1, 0),
(@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Matched Gift{/ts}'{/localize}, 9, 'matched_gift', 9, 0, 1, 0),
- (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}PCP{/ts}'{/localize}, 10, 'pcp', 10, 0, 1, 1);
+ (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Personal Campaign Page{/ts}'{/localize}, 10, 'pcp', 10, 0, 1, 1),
+ (@option_group_id_soft_credit_type , {localize}'{ts escape="sql"}Gift{/ts}'{/localize}, 11, 'gift', 11, 0, 1, 1);
+