From 49cdccf48a3460d58ec8c6bf9c794b64221e801d Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Thu, 22 Mar 2018 13:19:00 -0400 Subject: [PATCH] Increment minimum upgradable version --- CRM/Core/BAO/Setting.php | 15 - CRM/Core/I18n/SchemaStructure_2_2_0.php | 69 --- CRM/Core/I18n/SchemaStructure_3_0_alpha1.php | 251 --------- CRM/Core/I18n/SchemaStructure_3_0_beta1.php | 267 --------- CRM/Core/I18n/SchemaStructure_3_0_beta4.php | 280 --------- CRM/Core/I18n/SchemaStructure_3_1_alpha1.php | 284 ---------- CRM/Core/I18n/SchemaStructure_3_1_beta2.php | 287 ---------- CRM/Core/I18n/SchemaStructure_3_2_beta4.php | 288 ---------- CRM/Core/I18n/SchemaStructure_3_3_beta1.php | 296 ---------- CRM/Core/I18n/SchemaStructure_3_4_0.php | 223 -------- CRM/Core/I18n/SchemaStructure_3_4_beta2.php | 296 ---------- CRM/Core/I18n/SchemaStructure_3_4_beta3.php | 223 -------- CRM/Core/I18n/SchemaStructure_4_1_0.php | 229 -------- CRM/Core/I18n/SchemaStructure_4_1_alpha1.php | 226 -------- .../civicrm_msg_template.tpl | 16 - .../contribution_online_receipt_html.tpl | 391 ------------- .../event_online_receipt_html.tpl | 469 ---------------- .../event_online_receipt_text.tpl | 296 ---------- CRM/Upgrade/Form.php | 11 +- CRM/Upgrade/Incremental/php/FourOne.php | 430 -------------- CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl | 8 - CRM/Upgrade/Incremental/sql/4.1.1.mysql.tpl | 20 - CRM/Upgrade/Incremental/sql/4.1.2.mysql.tpl | 22 - CRM/Upgrade/Incremental/sql/4.1.3.mysql.tpl | 5 - .../Incremental/sql/4.1.alpha1.mysql.tpl | 529 ------------------ .../Incremental/sql/4.1.alpha2.mysql.tpl | 12 - .../Incremental/sql/4.1.beta1.mysql.tpl | 11 - .../Incremental/sql/4.1.beta2.mysql.tpl | 119 ---- .../Incremental/sql/4.1.beta3.mysql.tpl | 33 -- Civi/Core/SettingsBag.php | 5 - 30 files changed, 1 insertion(+), 5610 deletions(-) delete mode 100644 CRM/Core/I18n/SchemaStructure_2_2_0.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_0_alpha1.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_0_beta1.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_0_beta4.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_1_alpha1.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_1_beta2.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_2_beta4.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_3_beta1.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_4_0.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_4_beta2.php delete mode 100644 CRM/Core/I18n/SchemaStructure_3_4_beta3.php delete mode 100644 CRM/Core/I18n/SchemaStructure_4_1_0.php delete mode 100644 CRM/Core/I18n/SchemaStructure_4_1_alpha1.php delete mode 100644 CRM/Upgrade/4.1.alpha1.msg_template/civicrm_msg_template.tpl delete mode 100644 CRM/Upgrade/4.1.alpha1.msg_template/message_templates/contribution_online_receipt_html.tpl delete mode 100644 CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_html.tpl delete mode 100644 CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_text.tpl delete mode 100644 CRM/Upgrade/Incremental/php/FourOne.php delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.1.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.2.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.3.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.alpha1.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.alpha2.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.beta1.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.beta2.mysql.tpl delete mode 100644 CRM/Upgrade/Incremental/sql/4.1.beta3.mysql.tpl diff --git a/CRM/Core/BAO/Setting.php b/CRM/Core/BAO/Setting.php index 13e066d461..dc2dd9d523 100644 --- a/CRM/Core/BAO/Setting.php +++ b/CRM/Core/BAO/Setting.php @@ -475,21 +475,6 @@ class CRM_Core_BAO_Setting extends CRM_Core_DAO_Setting { self::setItem($optionValue, $group, $name); } - /** - * Civicrm_setting didn't exist before 4.1.alpha1 and this function helps taking decisions during upgrade - * - * @return bool - */ - public static function isUpgradeFromPreFourOneAlpha1() { - if (CRM_Core_Config::isUpgradeMode()) { - $currentVer = CRM_Core_BAO_Domain::version(); - if (version_compare($currentVer, '4.1.alpha1') < 0) { - return TRUE; - } - } - return FALSE; - } - /** * Check if environment is explicitly set. * diff --git a/CRM/Core/I18n/SchemaStructure_2_2_0.php b/CRM/Core/I18n/SchemaStructure_2_2_0.php deleted file mode 100644 index 9652264a83..0000000000 --- a/CRM/Core/I18n/SchemaStructure_2_2_0.php +++ /dev/null @@ -1,69 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'name' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - ); - } - return $result; - } - - /** - * @return array $result - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_0_beta1.php b/CRM/Core/I18n/SchemaStructure_3_0_beta1.php deleted file mode 100644 index 7a3d298a30..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_0_beta1.php +++ /dev/null @@ -1,267 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'name' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_0_beta4.php b/CRM/Core/I18n/SchemaStructure_3_0_beta4.php deleted file mode 100644 index 458d029461..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_0_beta4.php +++ /dev/null @@ -1,280 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_mailing_component' => array( - 'name' => 'varchar(64)', - 'subject' => 'varchar(255)', - 'body_html' => 'text', - 'body_text' => 'text', - ), - 'civicrm_mailing' => array( - 'name' => 'varchar(128)', - 'from_name' => 'varchar(128)', - 'subject' => 'varchar(128)', - 'body_text' => 'longtext', - 'body_html' => 'longtext', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'name' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_1_alpha1.php b/CRM/Core/I18n/SchemaStructure_3_1_alpha1.php deleted file mode 100644 index 95582b8a1e..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_1_alpha1.php +++ /dev/null @@ -1,284 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_contact_type' => array( - 'label' => 'varchar(64)', - 'description' => 'text', - ), - 'civicrm_mailing_component' => array( - 'name' => 'varchar(64)', - 'subject' => 'varchar(255)', - 'body_html' => 'text', - 'body_text' => 'text', - ), - 'civicrm_mailing' => array( - 'name' => 'varchar(128)', - 'from_name' => 'varchar(128)', - 'subject' => 'varchar(128)', - 'body_text' => 'longtext', - 'body_html' => 'longtext', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'name' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_1_beta2.php b/CRM/Core/I18n/SchemaStructure_3_1_beta2.php deleted file mode 100644 index 1d3acb2aa2..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_1_beta2.php +++ /dev/null @@ -1,287 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_contact_type' => array( - 'label' => 'varchar(64)', - 'description' => 'text', - ), - 'civicrm_mailing_component' => array( - 'name' => 'varchar(64)', - 'subject' => 'varchar(255)', - 'body_html' => 'text', - 'body_text' => 'text', - ), - 'civicrm_mailing' => array( - 'name' => 'varchar(128)', - 'from_name' => 'varchar(128)', - 'subject' => 'varchar(128)', - 'body_text' => 'longtext', - 'body_html' => 'longtext', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'name' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_dashboard' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_2_beta4.php b/CRM/Core/I18n/SchemaStructure_3_2_beta4.php deleted file mode 100644 index 16ee40660c..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_2_beta4.php +++ /dev/null @@ -1,288 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_contact_type' => array( - 'label' => 'varchar(64)', - 'description' => 'text', - ), - 'civicrm_mailing_component' => array( - 'name' => 'varchar(64)', - 'subject' => 'varchar(255)', - 'body_html' => 'text', - 'body_text' => 'text', - ), - 'civicrm_mailing' => array( - 'name' => 'varchar(128)', - 'from_name' => 'varchar(128)', - 'subject' => 'varchar(128)', - 'body_text' => 'longtext', - 'body_html' => 'longtext', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'label' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_dashboard' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'help_pre' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_3_beta1.php b/CRM/Core/I18n/SchemaStructure_3_3_beta1.php deleted file mode 100644 index 5eced3dd9d..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_3_beta1.php +++ /dev/null @@ -1,296 +0,0 @@ - array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contact' => array( - 'sort_name' => 'varchar(128)', - 'display_name' => 'varchar(128)', - 'first_name' => 'varchar(64)', - 'middle_name' => 'varchar(64)', - 'last_name' => 'varchar(64)', - 'email_greeting_display' => 'varchar(255)', - 'postal_greeting_display' => 'varchar(255)', - 'addressee_display' => 'varchar(255)', - 'household_name' => 'varchar(128)', - 'organization_name' => 'varchar(128)', - ), - 'civicrm_contact_type' => array( - 'label' => 'varchar(64)', - 'description' => 'text', - ), - 'civicrm_mailing_component' => array( - 'name' => 'varchar(64)', - 'subject' => 'varchar(255)', - 'body_html' => 'text', - 'body_text' => 'text', - ), - 'civicrm_mailing' => array( - 'name' => 'varchar(128)', - 'from_name' => 'varchar(128)', - 'subject' => 'varchar(128)', - 'body_text' => 'longtext', - 'body_html' => 'longtext', - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => 'varchar(255)', - 'premiums_intro_text' => 'text', - ), - 'civicrm_product' => array( - 'name' => 'varchar(255)', - 'description' => 'text', - 'options' => 'text', - ), - 'civicrm_membership_type' => array( - 'name' => 'varchar(128)', - 'description' => 'varchar(255)', - ), - 'civicrm_membership_status' => array( - 'label' => 'varchar(128)', - ), - 'civicrm_participant_status_type' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_tell_friend' => array( - 'title' => 'varchar(255)', - 'intro' => 'text', - 'suggested_message' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - ), - 'civicrm_price_set' => array( - 'title' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_batch' => array( - 'label' => 'varchar(64)', - 'description' => 'text', - ), - 'civicrm_custom_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_custom_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_dashboard' => array( - 'label' => 'varchar(255)', - ), - 'civicrm_option_value' => array( - 'label' => 'varchar(255)', - 'description' => 'varchar(255)', - ), - 'civicrm_contribution_page' => array( - 'title' => 'varchar(255)', - 'intro_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer' => 'text', - 'for_organization' => 'text', - 'receipt_from_name' => 'varchar(255)', - 'receipt_text' => 'text', - 'footer_text' => 'text', - 'honor_block_title' => 'varchar(255)', - 'honor_block_text' => 'text', - ), - 'civicrm_membership_block' => array( - 'new_title' => 'varchar(255)', - 'new_text' => 'text', - 'renewal_title' => 'varchar(255)', - 'renewal_text' => 'text', - ), - 'civicrm_price_field' => array( - 'label' => 'varchar(255)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_group' => array( - 'title' => 'varchar(64)', - 'help_pre' => 'text', - 'help_post' => 'text', - ), - 'civicrm_uf_field' => array( - 'help_post' => 'text', - 'help_pre' => 'text', - 'label' => 'varchar(255)', - ), - 'civicrm_address' => array( - 'street_address' => 'varchar(96)', - 'supplemental_address_1' => 'varchar(96)', - 'supplemental_address_2' => 'varchar(96)', - 'supplemental_address_3' => 'varchar(96)', - 'city' => 'varchar(64)', - 'name' => 'varchar(255)', - ), - 'civicrm_event' => array( - 'title' => 'varchar(255)', - 'summary' => 'text', - 'description' => 'text', - 'registration_link_text' => 'varchar(255)', - 'event_full_text' => 'text', - 'fee_label' => 'varchar(255)', - 'intro_text' => 'text', - 'footer_text' => 'text', - 'confirm_title' => 'varchar(255)', - 'confirm_text' => 'text', - 'confirm_footer_text' => 'text', - 'confirm_email_text' => 'text', - 'confirm_from_name' => 'varchar(255)', - 'thankyou_title' => 'varchar(255)', - 'thankyou_text' => 'text', - 'thankyou_footer_text' => 'text', - 'pay_later_text' => 'text', - 'pay_later_receipt' => 'text', - 'waitlist_text' => 'text', - 'approval_req_text' => 'text', - 'template_title' => 'varchar(255)', - ), - 'civicrm_price_field_value' => array( - 'label' => 'varchar(255)', - 'description' => 'text', - ), - ); - } - return $result; - } - - /** - * @return array - */ - static public function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - static public function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_4_0.php b/CRM/Core/I18n/SchemaStructure_3_4_0.php deleted file mode 100644 index 7a601c0d62..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_4_0.php +++ /dev/null @@ -1,223 +0,0 @@ - array( - 'label' => "varchar(255)", - 'description' => "varchar(255)", - ), - 'civicrm_contact_type' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => "varchar(255)", - 'premiums_intro_text' => "text", - ), - 'civicrm_product' => array( - 'name' => "varchar(255)", - 'description' => "text", - 'options' => "text", - ), - 'civicrm_membership_type' => array( - 'name' => "varchar(128)", - 'description' => "varchar(255)", - ), - 'civicrm_membership_status' => array( - 'label' => "varchar(128)", - ), - 'civicrm_participant_status_type' => array( - 'label' => "varchar(255)", - ), - 'civicrm_tell_friend' => array( - 'title' => "varchar(255)", - 'intro' => "text", - 'suggested_message' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - ), - 'civicrm_price_set' => array( - 'title' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_batch' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_custom_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_custom_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_dashboard' => array( - 'label' => "varchar(255)", - ), - 'civicrm_option_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_contribution_page' => array( - 'title' => "varchar(255)", - 'intro_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer' => "text", - 'for_organization' => "text", - 'receipt_from_name' => "varchar(255)", - 'receipt_text' => "text", - 'footer_text' => "text", - 'honor_block_title' => "varchar(255)", - 'honor_block_text' => "text", - ), - 'civicrm_membership_block' => array( - 'new_title' => "varchar(255)", - 'new_text' => "text", - 'renewal_title' => "varchar(255)", - 'renewal_text' => "text", - ), - 'civicrm_price_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_price_field_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_uf_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_field' => array( - 'help_post' => "text", - 'help_pre' => "text", - 'label' => "varchar(255)", - ), - 'civicrm_event' => array( - 'title' => "varchar(255)", - 'summary' => "text", - 'description' => "text", - 'registration_link_text' => "varchar(255)", - 'event_full_text' => "text", - 'fee_label' => "varchar(255)", - 'intro_text' => "text", - 'footer_text' => "text", - 'confirm_title' => "varchar(255)", - 'confirm_text' => "text", - 'confirm_footer_text' => "text", - 'confirm_email_text' => "text", - 'confirm_from_name' => "varchar(255)", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'waitlist_text' => "text", - 'approval_req_text' => "text", - 'template_title' => "varchar(255)", - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_4_beta2.php b/CRM/Core/I18n/SchemaStructure_3_4_beta2.php deleted file mode 100644 index 1ae3955613..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_4_beta2.php +++ /dev/null @@ -1,296 +0,0 @@ - array( - 'label' => "varchar(255)", - 'description' => "varchar(255)", - ), - 'civicrm_contact' => array( - 'sort_name' => "varchar(128)", - 'display_name' => "varchar(128)", - 'first_name' => "varchar(64)", - 'middle_name' => "varchar(64)", - 'last_name' => "varchar(64)", - 'email_greeting_display' => "varchar(255)", - 'postal_greeting_display' => "varchar(255)", - 'addressee_display' => "varchar(255)", - 'household_name' => "varchar(128)", - 'organization_name' => "varchar(128)", - ), - 'civicrm_contact_type' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_mailing_component' => array( - 'name' => "varchar(64)", - 'subject' => "varchar(255)", - 'body_html' => "text", - 'body_text' => "text", - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => "varchar(255)", - 'premiums_intro_text' => "text", - ), - 'civicrm_product' => array( - 'name' => "varchar(255)", - 'description' => "text", - 'options' => "text", - ), - 'civicrm_membership_type' => array( - 'name' => "varchar(128)", - 'description' => "varchar(255)", - ), - 'civicrm_membership_status' => array( - 'label' => "varchar(128)", - ), - 'civicrm_participant_status_type' => array( - 'label' => "varchar(255)", - ), - 'civicrm_tell_friend' => array( - 'title' => "varchar(255)", - 'intro' => "text", - 'suggested_message' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - ), - 'civicrm_price_set' => array( - 'title' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_batch' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_custom_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_custom_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_dashboard' => array( - 'label' => "varchar(255)", - ), - 'civicrm_option_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_mailing' => array( - 'name' => "varchar(128)", - 'from_name' => "varchar(128)", - 'subject' => "varchar(128)", - 'body_text' => "longtext", - 'body_html' => "longtext", - ), - 'civicrm_contribution_page' => array( - 'title' => "varchar(255)", - 'intro_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer' => "text", - 'for_organization' => "text", - 'receipt_from_name' => "varchar(255)", - 'receipt_text' => "text", - 'footer_text' => "text", - 'honor_block_title' => "varchar(255)", - 'honor_block_text' => "text", - ), - 'civicrm_membership_block' => array( - 'new_title' => "varchar(255)", - 'new_text' => "text", - 'renewal_title' => "varchar(255)", - 'renewal_text' => "text", - ), - 'civicrm_price_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_price_field_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_uf_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_field' => array( - 'help_post' => "text", - 'help_pre' => "text", - 'label' => "varchar(255)", - ), - 'civicrm_address' => array( - 'street_address' => "varchar(96)", - 'supplemental_address_1' => "varchar(96)", - 'supplemental_address_2' => "varchar(96)", - 'supplemental_address_3' => "varchar(96)", - 'city' => "varchar(64)", - 'name' => "varchar(255)", - ), - 'civicrm_event' => array( - 'title' => "varchar(255)", - 'summary' => "text", - 'description' => "text", - 'registration_link_text' => "varchar(255)", - 'event_full_text' => "text", - 'fee_label' => "varchar(255)", - 'intro_text' => "text", - 'footer_text' => "text", - 'confirm_title' => "varchar(255)", - 'confirm_text' => "text", - 'confirm_footer_text' => "text", - 'confirm_email_text' => "text", - 'confirm_from_name' => "varchar(255)", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'waitlist_text' => "text", - 'approval_req_text' => "text", - 'template_title' => "varchar(255)", - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_contact' => array( - 'index_sort_name' => array( - 'name' => 'index_sort_name', - 'field' => array( - 'sort_name', - ), - ), - 'index_first_name' => array( - 'name' => 'index_first_name', - 'field' => array( - 'first_name', - ), - ), - 'index_last_name' => array( - 'name' => 'index_last_name', - 'field' => array( - 'last_name', - ), - ), - 'index_household_name' => array( - 'name' => 'index_household_name', - 'field' => array( - 'household_name', - ), - ), - 'index_organization_name' => array( - 'name' => 'index_organization_name', - 'field' => array( - 'organization_name', - ), - ), - ), - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - 'civicrm_address' => array( - 'index_city' => array( - 'name' => 'index_city', - 'field' => array( - 'city', - ), - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_3_4_beta3.php b/CRM/Core/I18n/SchemaStructure_3_4_beta3.php deleted file mode 100644 index 289ddcc721..0000000000 --- a/CRM/Core/I18n/SchemaStructure_3_4_beta3.php +++ /dev/null @@ -1,223 +0,0 @@ - array( - 'label' => "varchar(255)", - 'description' => "varchar(255)", - ), - 'civicrm_contact_type' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => "varchar(255)", - 'premiums_intro_text' => "text", - ), - 'civicrm_product' => array( - 'name' => "varchar(255)", - 'description' => "text", - 'options' => "text", - ), - 'civicrm_membership_type' => array( - 'name' => "varchar(128)", - 'description' => "varchar(255)", - ), - 'civicrm_membership_status' => array( - 'label' => "varchar(128)", - ), - 'civicrm_participant_status_type' => array( - 'label' => "varchar(255)", - ), - 'civicrm_tell_friend' => array( - 'title' => "varchar(255)", - 'intro' => "text", - 'suggested_message' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - ), - 'civicrm_price_set' => array( - 'title' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_batch' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_custom_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_custom_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_dashboard' => array( - 'label' => "varchar(255)", - ), - 'civicrm_option_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_contribution_page' => array( - 'title' => "varchar(255)", - 'intro_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer' => "text", - 'for_organization' => "text", - 'receipt_from_name' => "varchar(255)", - 'receipt_text' => "text", - 'footer_text' => "text", - 'honor_block_title' => "varchar(255)", - 'honor_block_text' => "text", - ), - 'civicrm_membership_block' => array( - 'new_title' => "varchar(255)", - 'new_text' => "text", - 'renewal_title' => "varchar(255)", - 'renewal_text' => "text", - ), - 'civicrm_price_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_price_field_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_uf_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_field' => array( - 'help_post' => "text", - 'help_pre' => "text", - 'label' => "varchar(255)", - ), - 'civicrm_event' => array( - 'title' => "varchar(255)", - 'summary' => "text", - 'description' => "text", - 'registration_link_text' => "varchar(255)", - 'event_full_text' => "text", - 'fee_label' => "varchar(255)", - 'intro_text' => "text", - 'footer_text' => "text", - 'confirm_title' => "varchar(255)", - 'confirm_text' => "text", - 'confirm_footer_text' => "text", - 'confirm_email_text' => "text", - 'confirm_from_name' => "varchar(255)", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'waitlist_text' => "text", - 'approval_req_text' => "text", - 'template_title' => "varchar(255)", - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_4_1_0.php b/CRM/Core/I18n/SchemaStructure_4_1_0.php deleted file mode 100644 index dfc3172280..0000000000 --- a/CRM/Core/I18n/SchemaStructure_4_1_0.php +++ /dev/null @@ -1,229 +0,0 @@ - array( - 'display_name' => "varchar(64)", - ), - 'civicrm_option_group' => array( - 'title' => "varchar(255)", - 'description' => "varchar(255)", - ), - 'civicrm_contact_type' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => "varchar(255)", - 'premiums_intro_text' => "text", - ), - 'civicrm_product' => array( - 'name' => "varchar(255)", - 'description' => "text", - 'options' => "text", - ), - 'civicrm_membership_status' => array( - 'label' => "varchar(128)", - ), - 'civicrm_participant_status_type' => array( - 'label' => "varchar(255)", - ), - 'civicrm_tell_friend' => array( - 'title' => "varchar(255)", - 'intro' => "text", - 'suggested_message' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - ), - 'civicrm_price_set' => array( - 'title' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_batch' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_custom_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_custom_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_dashboard' => array( - 'label' => "varchar(255)", - ), - 'civicrm_option_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_contribution_page' => array( - 'title' => "varchar(255)", - 'intro_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer' => "text", - 'for_organization' => "text", - 'receipt_from_name' => "varchar(255)", - 'receipt_text' => "text", - 'footer_text' => "text", - 'honor_block_title' => "varchar(255)", - 'honor_block_text' => "text", - ), - 'civicrm_price_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_field' => array( - 'help_post' => "text", - 'help_pre' => "text", - 'label' => "varchar(255)", - ), - 'civicrm_membership_type' => array( - 'name' => "varchar(128)", - 'description' => "varchar(255)", - ), - 'civicrm_membership_block' => array( - 'new_title' => "varchar(255)", - 'new_text' => "text", - 'renewal_title' => "varchar(255)", - 'renewal_text' => "text", - ), - 'civicrm_price_field_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_pcp_block' => array( - 'link_text' => "varchar(255)", - ), - 'civicrm_event' => array( - 'title' => "varchar(255)", - 'summary' => "text", - 'description' => "text", - 'registration_link_text' => "varchar(255)", - 'event_full_text' => "text", - 'fee_label' => "varchar(255)", - 'intro_text' => "text", - 'footer_text' => "text", - 'confirm_title' => "varchar(255)", - 'confirm_text' => "text", - 'confirm_footer_text' => "text", - 'confirm_email_text' => "text", - 'confirm_from_name' => "varchar(255)", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'waitlist_text' => "text", - 'approval_req_text' => "text", - 'template_title' => "varchar(255)", - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Core/I18n/SchemaStructure_4_1_alpha1.php b/CRM/Core/I18n/SchemaStructure_4_1_alpha1.php deleted file mode 100644 index 1545d5de32..0000000000 --- a/CRM/Core/I18n/SchemaStructure_4_1_alpha1.php +++ /dev/null @@ -1,226 +0,0 @@ - array( - 'display_name' => "varchar(64)", - ), - 'civicrm_option_group' => array( - 'title' => "varchar(255)", - 'description' => "varchar(255)", - ), - 'civicrm_contact_type' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_premiums' => array( - 'premiums_intro_title' => "varchar(255)", - 'premiums_intro_text' => "text", - ), - 'civicrm_product' => array( - 'name' => "varchar(255)", - 'description' => "text", - 'options' => "text", - ), - 'civicrm_membership_status' => array( - 'label' => "varchar(128)", - ), - 'civicrm_participant_status_type' => array( - 'label' => "varchar(255)", - ), - 'civicrm_tell_friend' => array( - 'title' => "varchar(255)", - 'intro' => "text", - 'suggested_message' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - ), - 'civicrm_price_set' => array( - 'title' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_batch' => array( - 'label' => "varchar(64)", - 'description' => "text", - ), - 'civicrm_custom_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_custom_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_dashboard' => array( - 'label' => "varchar(255)", - ), - 'civicrm_option_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_contribution_page' => array( - 'title' => "varchar(255)", - 'intro_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer' => "text", - 'for_organization' => "text", - 'receipt_from_name' => "varchar(255)", - 'receipt_text' => "text", - 'footer_text' => "text", - 'honor_block_title' => "varchar(255)", - 'honor_block_text' => "text", - ), - 'civicrm_price_field' => array( - 'label' => "varchar(255)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_group' => array( - 'title' => "varchar(64)", - 'help_pre' => "text", - 'help_post' => "text", - ), - 'civicrm_uf_field' => array( - 'help_post' => "text", - 'help_pre' => "text", - 'label' => "varchar(255)", - ), - 'civicrm_membership_type' => array( - 'name' => "varchar(128)", - 'description' => "varchar(255)", - ), - 'civicrm_membership_block' => array( - 'new_title' => "varchar(255)", - 'new_text' => "text", - 'renewal_title' => "varchar(255)", - 'renewal_text' => "text", - ), - 'civicrm_price_field_value' => array( - 'label' => "varchar(255)", - 'description' => "text", - ), - 'civicrm_event' => array( - 'title' => "varchar(255)", - 'summary' => "text", - 'description' => "text", - 'registration_link_text' => "varchar(255)", - 'event_full_text' => "text", - 'fee_label' => "varchar(255)", - 'intro_text' => "text", - 'footer_text' => "text", - 'confirm_title' => "varchar(255)", - 'confirm_text' => "text", - 'confirm_footer_text' => "text", - 'confirm_email_text' => "text", - 'confirm_from_name' => "varchar(255)", - 'thankyou_title' => "varchar(255)", - 'thankyou_text' => "text", - 'thankyou_footer_text' => "text", - 'pay_later_text' => "text", - 'pay_later_receipt' => "text", - 'waitlist_text' => "text", - 'approval_req_text' => "text", - 'template_title' => "varchar(255)", - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &indices() { - static $result = NULL; - if (!$result) { - $result = array( - 'civicrm_price_set' => array( - 'UI_title' => array( - 'name' => 'UI_title', - 'field' => array( - 'title', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_group' => array( - 'UI_title_extends' => array( - 'name' => 'UI_title_extends', - 'field' => array( - 'title', - 'extends', - ), - 'unique' => 1, - ), - ), - 'civicrm_custom_field' => array( - 'UI_label_custom_group_id' => array( - 'name' => 'UI_label_custom_group_id', - 'field' => array( - 'label', - 'custom_group_id', - ), - 'unique' => 1, - ), - ), - ); - } - return $result; - } - - /** - * @return array - */ - public static function &tables() { - static $result = NULL; - if (!$result) { - $result = array_keys(self::columns()); - } - return $result; - } - -} diff --git a/CRM/Upgrade/4.1.alpha1.msg_template/civicrm_msg_template.tpl b/CRM/Upgrade/4.1.alpha1.msg_template/civicrm_msg_template.tpl deleted file mode 100644 index 11a9a5c862..0000000000 --- a/CRM/Upgrade/4.1.alpha1.msg_template/civicrm_msg_template.tpl +++ /dev/null @@ -1,16 +0,0 @@ -{php} - $dir = SMARTY_DIR . '/../../CRM/Upgrade/4.1.alpha1.msg_template/message_templates'; - $templates = array(); - foreach (preg_grep('/\.tpl$/', scandir($dir)) as $filename) { - $parts = explode('_', basename($filename, '.tpl')); - $templates[] = array('type' => array_pop($parts), 'name' => implode('_', $parts), 'filename' => "$dir/$filename"); - } - $this->assign('templates', $templates); -{/php} - -{foreach from=$templates item=tpl} - {fetch assign=content file=$tpl.filename} - SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = '{$tpl.name}'; - SELECT @content := msg_{$tpl.type} FROM civicrm_msg_template WHERE workflow_id = @workflow_id AND is_reserved = 1 LIMIT 1; - UPDATE civicrm_msg_template SET msg_{$tpl.type} = '{$content|escape:"quotes"}' WHERE workflow_id = @workflow_id AND (is_reserved = 1 OR (is_default = 1 AND msg_{$tpl.type} = @content)); -{/foreach} diff --git a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/contribution_online_receipt_html.tpl b/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/contribution_online_receipt_html.tpl deleted file mode 100644 index f22d675522..0000000000 --- a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/contribution_online_receipt_html.tpl +++ /dev/null @@ -1,391 +0,0 @@ - - - - - - - - -{capture assign=headerStyle}colspan="2" style="text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;"{/capture} -{capture assign=labelStyle }style="padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;"{/capture} -{capture assign=valueStyle }style="padding: 4px; border-bottom: 1px solid #999;"{/capture} - -
- - - - - - - - - - - -
- - {if $receipt_text} -

{$receipt_text|htmlize}

- {/if} - - {if $is_pay_later} -

{$pay_later_receipt}

{* FIXME: this might be text rather than HTML *} - {else} -

{ts}Please print this confirmation for your records.{/ts}

- {/if} - -
- - - {if $amount} - - - - - - - {if $lineItem and $priceSetID} - - {foreach from=$lineItem item=value key=priceset} - - - - {/foreach} - - - - - - {else} - - - - - - - {/if} - - - {/if} - - - {if $receive_date} - - - - - {/if} - - {if $is_monetary and $trxn_id} - - - - - {/if} - - {if $is_recur} - {if $contributeMode eq 'notify'} - - - - {elseif $contributeMode eq 'directIPN' and $receiptFromEmail} - - - - {/if} - {/if} - - {if $honor_block_is_active} - - - - - - - {if $honor_email} - - - - - {/if} - {/if} - - {if $pcpBlock} - - - - - - - - {if $pcp_roll_nickname} - - - - - {/if} - {if $pcp_personal_note} - - - - - {/if} - {/if} - - {if $onBehalfProfile} - - - - {foreach from=$onBehalfProfile item=onBehalfValue key=onBehalfName} - - - - - {/foreach} - {/if} - - {if $isShare} - - - - {/if} - - {if ! ($contributeMode eq 'notify' OR $contributeMode eq 'directIPN') and $is_monetary} - {if $is_pay_later} - - - - - - - {elseif $amount GT 0} - - - - - - - {/if} - {/if} - - {if $contributeMode eq 'direct' AND !$is_pay_later AND $amount GT 0} - - - - - - - {/if} - - {if $selectPremium} - - - - - - - {if $option} - - - - - {/if} - {if $sku} - - - - - {/if} - {if $start_date} - - - - - {/if} - {if $end_date} - - - - - {/if} - {if $contact_email OR $contact_phone} - - - - {/if} - {if $is_deductible AND $price} - - - - {/if} - {/if} - - {if $customPre} - - - - {foreach from=$customPre item=customValue key=customName} - {if ($trackingFields and ! in_array($customName, $trackingFields)) or ! $trackingFields} - - - - - {/if} - {/foreach} - {/if} - - {if $customPost} - - - - {foreach from=$customPost item=customValue key=customName} - {if ($trackingFields and ! in_array($customName, $trackingFields)) or ! $trackingFields} - - - - - {/if} - {/foreach} - {/if} - -
- {ts}Contribution Information{/ts} -
- {* FIXME: style this table so that it looks like the text version (justification, etc.) *} - - - - - - - {foreach from=$value item=line} - - - - - - - {/foreach} -
{ts}Item{/ts}{ts}Qty{/ts}{ts}Each{/ts}{ts}Total{/ts}
- {if $line.html_type eq 'Text'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description}
{$line.description|truncate:30:"..."}
{/if} - 		- {$line.qty} - - {$line.unit_price|crmMoney:$currency} - - {$line.line_total|crmMoney:$currency} -
-
- {ts}Total Amount{/ts} - - {$amount|crmMoney:$currency} -
- {ts}Amount{/ts} - - {$amount|crmMoney:$currency} {if $amount_level} - {$amount_level}{/if} -
- {ts}Date{/ts} - - {$receive_date|crmDate} -
- {ts}Transaction #{/ts} - - {$trxn_id} -
- {ts 1=$cancelSubscriptionUrl}This is a recurring contribution. You can modify or cancel future contributions by logging in to your account.{/ts} -
- {ts 1=$receiptFromEmail}This is a recurring contribution. To modify or cancel future contributions please contact us at %1.{/ts} -
- {$honor_type} -
- {$honor_prefix} {$honor_first_name} {$honor_last_name} -
- {ts}Honoree Email{/ts} - - {$honor_email} -
- {ts}Personal Campaign Page{/ts} -
- {ts}Display In Honor Roll{/ts} - - {if $pcp_display_in_roll}{ts}Yes{/ts}{else}{ts}No{/ts}{/if} -
- {ts}Nickname{/ts} - - {$pcp_roll_nickname} -
- {ts}Personal Note{/ts} - - {$pcp_personal_note} -
- {$onBehalfProfile_grouptitle} -
- {$onBehalfName} - - {$onBehalfValue} -
- {capture assign=contributionUrl}{crmURL p='civicrm/contribute/transact' q="reset=1&id=`$contributionPageId`" a=true fe=1 h=1}{/capture} - {include file="CRM/common/SocialNetwork.tpl" emailMode=true url=$contributionUrl title=$title pageURL=$contributionUrl} -
- {ts}Registered Email{/ts} -
- {$email} -
- {ts}Billing Name and Address{/ts} -
- {$billingName}
- {$address|nl2br}
- {$email} -
- {ts}Credit Card Information{/ts} -
- {$credit_card_type}
- {$credit_card_number}
- {ts}Expires{/ts}: {$credit_card_exp_date|truncate:7:''|crmDate}
-
- {ts}Premium Information{/ts} -
- {$product_name} -
- {ts}Option{/ts} - - {$option} -
- {ts}SKU{/ts} - - {$sku} -
- {ts}Start Date{/ts} - - {$start_date|crmDate} -
- {ts}End Date{/ts} - - {$end_date|crmDate} -
-

{ts}For information about this premium, contact:{/ts}

- {if $contact_email} -

{$contact_email}

- {/if} - {if $contact_phone} -

{$contact_phone}

- {/if} -
-

{ts 1=$price|crmMoney:$currency}The value of this premium is %1. This may affect the amount of the tax deduction you can claim. Consult your tax advisor for more information.{/ts}

-
- {$customPre_grouptitle} -
- {$customName} - - {$customValue} -
- {$customPost_grouptitle} -
- {$customName} - - {$customValue} -
-
- - - diff --git a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_html.tpl b/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_html.tpl deleted file mode 100644 index 98a9422078..0000000000 --- a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_html.tpl +++ /dev/null @@ -1,469 +0,0 @@ - - - - - - - - -{capture assign=headerStyle}colspan="2" style="text-align: left; padding: 4px; border-bottom: 1px solid #999; background-color: #eee;"{/capture} -{capture assign=labelStyle }style="padding: 4px; border-bottom: 1px solid #999; background-color: #f7f7f7;"{/capture} -{capture assign=valueStyle }style="padding: 4px; border-bottom: 1px solid #999;"{/capture} - -
- - - - - - - - - - - - - - -
-

Dear {contact.display_name},

- - {if $event.confirm_email_text AND (not $isOnWaitlist AND not $isRequireApproval)} -

{$event.confirm_email_text|htmlize}

- - {else} -

Thank you for your participation. This letter is a confirmation that your registration has been received and your status has been updated to {if $isOnWaitlist}waitlisted{else}registered{/if} for the following:

- - {/if} - -

- {if $isOnWaitlist} -

{ts}You have been added to the WAIT LIST for this event.{/ts}

- {if $isPrimary} -

{ts}If space becomes available you will receive an email with a link to a web page where you can complete your registration.{/ts}

- {/if} - {elseif $isRequireApproval} -

{ts}Your registration has been submitted.{/ts}

- {if $isPrimary} -

{ts}Once your registration has been reviewed, you will receive an email with a link to a web page where you can complete the registration process.{/ts}

- {/if} - {elseif $is_pay_later && !$isAmountzero} -

{$pay_later_receipt}

{* FIXME: this might be text rather than HTML *} - {else} -

{ts}Please print this confirmation for your records.{/ts}

- {/if} - -
- - - - - - - - - - {if $conference_sessions} - - - - - - - {/if} - - {if $event.participant_role neq 'Attendee' and $defaultRole} - - - - - {/if} - - {if $isShowLocation} - - - - {/if} - - {if $location.phone.1.phone || $location.email.1.email} - - - - {foreach from=$location.phone item=phone} - {if $phone.phone} - - - - - {/if} - {/foreach} - {foreach from=$location.email item=eventEmail} - {if $eventEmail.email} - - - - - {/if} - {/foreach} - {/if} - - - - {if $event.is_share} - - - - {/if} - {if $email} - - - - - - - {/if} - {if $payer.name} - - - - - - - {/if} - {if $event.is_monetary} - - - - - - {if $lineItem} - {foreach from=$lineItem item=value key=priceset} - {if $value neq 'skip'} - {if $isPrimary} - {if $lineItem|@count GT 1} {* Header for multi participant registration cases. *} - - - - {/if} - {/if} - - - - {/if} - {/foreach} - {/if} - - {if $amount && !$lineItem} - {foreach from=$amount item=amnt key=level} - - - - {/foreach} - {/if} - - {if $isPrimary} - - - - - {if $pricesetFieldsCount } - - - - {/if} - {if $is_pay_later} - - - - {/if} - - {if $register_date} - - - - - {/if} - - {if $receive_date} - - - - - {/if} - - {if $contributionTypeName} - - - - - {/if} - - {if $trxn_id} - - - - - {/if} - - {if $paidBy} - - - - - {/if} - - {if $checkNumber} - - - - - {/if} - - {if $contributeMode ne 'notify' and !$isAmountzero and !$is_pay_later and !$isOnWaitlist and !$isRequireApproval} - - - - - - - {/if} - - {if $contributeMode eq 'direct' and !$isAmountzero and !$is_pay_later and !$isOnWaitlist and !$isRequireApproval} - - - - - - - {/if} - - {/if} - - {/if} {* End of conditional section for Paid events *} - - -{if $customPre} -{foreach from=$customPre item=customPr key=i} - - {foreach from=$customPr item=customValue key=customName} - {if ( $trackingFields and ! in_array( $customName, $trackingFields ) ) or ! $trackingFields} - - - - - {/if} - {/foreach} -{/foreach} -{/if} - -{if $customPost} -{foreach from=$customPost item=customPos key=j} - - {foreach from=$customPos item=customValue key=customName} - {if ( $trackingFields and ! in_array( $customName, $trackingFields ) ) or ! $trackingFields} - - - - -{/if} -{/foreach} -{/foreach} -{/if} - -{if $customProfile} -{foreach from=$customProfile.profile item=eachParticipant key=participantID} - - {foreach from=$eachParticipant item=eachProfile key=pid} - - {foreach from=$eachProfile item=val key=field} - {foreach from=$val item=v key=f} - - - {/foreach} - - {/foreach} -{/foreach} -{/foreach} -{/if} - - {if $customGroup} - {foreach from=$customGroup item=value key=customName} - - - - {foreach from=$value item=v key=n} - - - - - {/foreach} - {/foreach} - {/if} - -
- {ts}Event Information and Location{/ts} -
- {$event.event_title}
- {$event.event_start_date|date_format:"%A"} {$event.event_start_date|crmDate}{if $event.event_end_date}-{if $event.event_end_date|date_format:"%Y%m%d" == $event.event_start_date|date_format:"%Y%m%d"}{$event.event_end_date|crmDate:0:1}{else}{$event.event_end_date|date_format:"%A"} {$event.event_end_date|crmDate}{/if}{/if} -
- {ts}Your schedule:{/ts} -
- {assign var='group_by_day' value='NA'} - {foreach from=$conference_sessions item=session} - {if $session.start_date|date_format:"%Y/%m/%d" != $group_by_day|date_format:"%Y/%m/%d"} - {assign var='group_by_day' value=$session.start_date} - {$group_by_day|date_format:"%m/%d/%Y"}
- {/if} - {$session.start_date|crmDate:0:1}{if $session.end_date}-{$session.end_date|crmDate:0:1}{/if} {$session.title}
- {if $session.location}    {$session.location}
{/if} - {/foreach} -
- {ts}Participant Role{/ts} - - {$event.participant_role} -
- {if $location.address.1.name} - {$location.address.1.name}
- {/if} - {if $location.address.1.street_address} - {$location.address.1.street_address}
- {/if} - {if $location.address.1.supplemental_address_1} - {$location.address.1.supplemental_address_1}
- {/if} - {if $location.address.1.supplemental_address_2} - {$location.address.1.supplemental_address_2}
- {/if} - {if $location.address.1.city} - {$location.address.1.city}, {$location.address.1.state_province} {$location.address.1.postal_code}{if $location.address.1.postal_code_suffix} - {$location.address.1.postal_code_suffix}{/if}
- {/if} -
- {ts}Event Contacts:{/ts} -
- {if $phone.phone_type} - {$phone.phone_type_display} - {else} - {ts}Phone{/ts} - {/if} - - {$phone.phone} -
- {ts}Email{/ts} - - {$eventEmail.email} -
- {capture assign=icalFeed}{crmURL p='civicrm/event/ical' q="reset=1&id=`$event.id`" h=0 a=1 fe=1}{/capture} - {ts}Download iCalendar File{/ts} -
- {capture assign=eventUrl}{crmURL p='civicrm/event/info' q="id=`$event.id`&reset=1" a=true fe=1 h=1}{/capture} - {include file="CRM/common/SocialNetwork.tpl" emailMode=true url=$eventUrl title=$event.title pageURL=$eventUrl} -
- {ts}Registered Email{/ts} -
- {$email} -
- {ts}You were registered by:{/ts} -
- {$payer.name} -
- {$event.fee_label} -
- {ts 1=$priceset+1}Participant %1{/ts} {$part.$priceset.info} -
- {* FIXME: style this table so that it looks like the text version (justification, etc.) *} - - - - - - {if $pricesetFieldsCount }{/if} - - {foreach from=$value item=line} - - - - - - {if $pricesetFieldsCount } {/if} - - {/foreach} -
{ts}Item{/ts}{ts}Qty{/ts}{ts}Each{/ts}{ts}Total{/ts}{ts}Total Participants{/ts}
- {if $line.html_type eq 'Text'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description}
{$line.description|truncate:30:"..."}
{/if} - 		- {$line.qty} - - {$line.unit_price|crmMoney} - - {$line.line_total|crmMoney} - {$line.participant_count}
-
- {$amnt.amount|crmMoney} {$amnt.label} -
- {ts}Total Amount{/ts} - - {$totalAmount|crmMoney} {if $hookDiscount.message}({$hookDiscount.message}){/if} -
- {ts}Total Participants{/ts} - {assign var="count" value= 0} - {foreach from=$lineItem item=pcount} - {assign var="lineItemCount" value=0} - {if $pcount neq 'skip'} - {foreach from=$pcount item=p_count} - {assign var="lineItemCount" value=$lineItemCount+$p_count.participant_count} - {/foreach} - {if $lineItemCount < 1 } - {assign var="lineItemCount" value=1} - {/if} - {assign var="count" value=$count+$lineItemCount} - {/if} - {/foreach} - {$count} -
- {$pay_later_receipt} -
- {ts}Registration Date{/ts} - - {$register_date|crmDate} -
- {ts}Transaction Date{/ts} - - {$receive_date|crmDate} -
- {ts}Contribution Type{/ts} - - {$contributionTypeName} -
- {ts}Transaction #{/ts} - - {$trxn_id} -
- {ts}Paid By{/ts} - - {$paidBy} -
- {ts}Check Number{/ts} - - {$checkNumber} -
- {ts}Billing Name and Address{/ts} -
- {$billingName}
- {$address|nl2br} -
- {ts}Credit Card Information{/ts} -
- {$credit_card_type}
- {$credit_card_number}
- {ts}Expires{/ts}: {$credit_card_exp_date|truncate:7:''|crmDate} -
{$customPre_grouptitle.$i}
{$customName}{$customValue}
{$customPost_grouptitle.$j}
{$customName}{$customValue}
{ts 1=$participantID+2}Participant Information - Participant %1{/ts}
{$customProfile.title.$pid}
{$field}{$v}
- {$customName} -
- {$n} - - {$v} -
-
-
- - - diff --git a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_text.tpl b/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_text.tpl deleted file mode 100644 index e2f6777899..0000000000 --- a/CRM/Upgrade/4.1.alpha1.msg_template/message_templates/event_online_receipt_text.tpl +++ /dev/null @@ -1,296 +0,0 @@ -Dear {contact.display_name}, - -{if $event.confirm_email_text AND (not $isOnWaitlist AND not $isRequireApproval)} -{$event.confirm_email_text} - -{else} -Thank you for your participation. This letter is a confirmation that your registration has been received and your status has been updated to {if $isOnWaitlist}waitlisted{else}registered{/if} for the following: - -{/if} - -{if $isOnWaitlist} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}You have been added to the WAIT LIST for this event.{/ts} - -{if $isPrimary} -{ts}If space becomes available you will receive an email with a link to a web page where you can complete your registration.{/ts} -{/if} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{elseif $isRequireApproval} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}Your registration has been submitted.{/ts} - -{if $isPrimary} -{ts}Once your registration has been reviewed, you will receive an email with a link to a web page where you can complete the registration process.{/ts} - -{/if} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{elseif $is_pay_later && !$isAmountzero} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$pay_later_receipt} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{else} - -{ts}Please print this confirmation for your records.{/ts} -{/if} - - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}Event Information and Location{/ts} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$event.event_title} -{$event.event_start_date|date_format:"%A"} {$event.event_start_date|crmDate}{if $event.event_end_date}-{if $event.event_end_date|date_format:"%Y%m%d" == $event.event_start_date|date_format:"%Y%m%d"}{$event.event_end_date|crmDate:0:1}{else}{$event.event_end_date|date_format:"%A"} {$event.event_end_date|crmDate}{/if}{/if} -{if $conference_sessions} - - -{ts}Your schedule:{/ts} -{assign var='group_by_day' value='NA'} -{foreach from=$conference_sessions item=session} -{if $session.start_date|date_format:"%Y/%m/%d" != $group_by_day|date_format:"%Y/%m/%d"} -{assign var='group_by_day' value=$session.start_date} - -{$group_by_day|date_format:"%m/%d/%Y"} - - -{/if} -{$session.start_date|crmDate:0:1}{if $session.end_date}-{$session.end_date|crmDate:0:1}{/if} {$session.title} -{if $session.location} {$session.location}{/if} -{/foreach} -{/if} - -{if $event.participant_role neq 'Attendee' and $defaultRole} -{ts}Participant Role{/ts}: {$event.participant_role} -{/if} - -{if $isShowLocation} -{if $location.address.1.name} - -{$location.address.1.name} -{/if} -{if $location.address.1.street_address}{$location.address.1.street_address} -{/if} -{if $location.address.1.supplemental_address_1}{$location.address.1.supplemental_address_1} -{/if} -{if $location.address.1.supplemental_address_2}{$location.address.1.supplemental_address_2} -{/if} -{if $location.address.1.city}{$location.address.1.city}, {$location.address.1.state_province} {$location.address.1.postal_code}{if $location.address.1.postal_code_suffix} - {$location.address.1.postal_code_suffix}{/if} -{/if} - -{/if}{*End of isShowLocation condition*} - -{if $location.phone.1.phone || $location.email.1.email} - -{ts}Event Contacts:{/ts} -{foreach from=$location.phone item=phone} -{if $phone.phone} - -{if $phone.phone_type}{$phone.phone_type_display}{else}{ts}Phone{/ts}{/if}: {$phone.phone}{/if} -{/foreach} -{foreach from=$location.email item=eventEmail} -{if $eventEmail.email} - -{ts}Email{/ts}: {$eventEmail.email}{/if}{/foreach} -{/if} - -{capture assign=icalFeed}{crmURL p='civicrm/event/ical' q="reset=1&id=`$event.id`" h=0 a=1 fe=1}{/capture} -{ts}Download iCalendar File:{/ts} {$icalFeed} -{if $email} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}Registered Email{/ts} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$email} -{/if} - -{if $payer.name} -You were registered by: {$payer.name} -{/if} -{if $event.is_monetary} {* This section for Paid events only.*} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$event.fee_label} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{if $lineItem}{foreach from=$lineItem item=value key=priceset} - -{if $value neq 'skip'} -{if $isPrimary} -{if $lineItem|@count GT 1} {* Header for multi participant registration cases. *} -{ts 1=$priceset+1}Participant %1{/ts} {$part.$priceset.info} - -{/if} -{/if} ------------------------------------------------------------{if $pricesetFieldsCount }--------------------{/if} - -{capture assign=ts_item}{ts}Item{/ts}{/capture} -{capture assign=ts_qty}{ts}Qty{/ts}{/capture} -{capture assign=ts_each}{ts}Each{/ts}{/capture} -{capture assign=ts_total}{ts}Total{/ts}{/capture} -{if $pricesetFieldsCount }{capture assign=ts_participant_total}{ts}Total Participants{/ts}{/capture}{/if} -{$ts_item|string_format:"%-30s"} {$ts_qty|string_format:"%5s"} {$ts_each|string_format:"%10s"} {$ts_total|string_format:"%10s"} {$ts_participant_total|string_format:"%10s"} ------------------------------------------------------------{if $pricesetFieldsCount }--------------------{/if} - -{foreach from=$value item=line} -{if $pricesetFieldsCount }{capture assign=ts_participant_count}{$line.participant_count}{/capture}{/if} -{capture assign=ts_item}{if $line.html_type eq 'Text'}{$line.label}{else}{$line.field_title} - {$line.label}{/if} {if $line.description} {$line.description}{/if}{/capture}{$ts_item|truncate:30:"..."|string_format:"%-30s"} {$line.qty|string_format:"%5s"} {$line.unit_price|crmMoney|string_format:"%10s"} {$line.line_total|crmMoney|string_format:"%10s"}{$ts_participant_count|string_format:"%10s"} -{/foreach} -{/if} -{/foreach} -{/if} -{if $amount && !$lineItem} -{foreach from=$amount item=amnt key=level}{$amnt.amount|crmMoney} {$amnt.label} -{/foreach} -{/if} -{if $isPrimary } - -{ts}Total Amount{/ts}: {$totalAmount|crmMoney} {if $hookDiscount.message}({$hookDiscount.message}){/if} - -{if $pricesetFieldsCount } - {assign var="count" value= 0} - {foreach from=$lineItem item=pcount} - {assign var="lineItemCount" value=0} - {if $pcount neq 'skip'} - {foreach from=$pcount item=p_count} - {assign var="lineItemCount" value=$lineItemCount+$p_count.participant_count} - {/foreach} - {if $lineItemCount < 1 } - {assign var="lineItemCount" value=1} - {/if} - {assign var="count" value=$count+$lineItemCount} - {/if} - {/foreach} - -{ts}Total Participants{/ts}: {$count} -{/if} - -{if $is_pay_later} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$pay_later_receipt} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{/if} - -{if $register_date} -{ts}Registration Date{/ts}: {$register_date|crmDate} -{/if} -{if $receive_date} -{ts}Transaction Date{/ts}: {$receive_date|crmDate} -{/if} -{if $contributionTypeName} -{ts}Contribution Type{/ts}: {$contributionTypeName} -{/if} -{if $trxn_id} -{ts}Transaction #{/ts}: {$trxn_id} -{/if} -{if $paidBy} -{ts}Paid By{/ts}: {$paidBy} -{/if} -{if $checkNumber} -{ts}Check Number{/ts}: {$checkNumber} -{/if} -{if $contributeMode ne 'notify' and !$isAmountzero and !$is_pay_later and !$isOnWaitlist and !$isRequireApproval} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}Billing Name and Address{/ts} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$billingName} -{$address} -{/if} - -{if $contributeMode eq 'direct' and !$isAmountzero and !$is_pay_later and !$isOnWaitlist and !$isRequireApproval} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts}Credit Card Information{/ts} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$credit_card_type} -{$credit_card_number} -{ts}Expires{/ts}: {$credit_card_exp_date|truncate:7:''|crmDate} -{/if} -{/if} -{/if} {* End of conditional section for Paid events *} - -{if $customPre} -{foreach from=$customPre item=customPr key=i} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$customPre_grouptitle.$i} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{foreach from=$customPr item=customValue key=customName} -{if ( $trackingFields and ! in_array( $customName, $trackingFields ) ) or ! $trackingFields} - {$customName}: {$customValue} -{/if} -{/foreach} -{/foreach} -{/if} - -{if $customPost} -{foreach from=$customPost item=customPos key=j} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{$customPost_grouptitle.$j} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{foreach from=$customPos item=customValue key=customName} -{if ( $trackingFields and ! in_array( $customName, $trackingFields ) ) or ! $trackingFields} - {$customName}: {$customValue} -{/if} -{/foreach} -{/foreach} -{/if} -{if $customProfile} - -{foreach from=$customProfile.profile item=eachParticipant key=participantID} -==========================================================={if $pricesetFieldsCount }===================={/if} - -{ts 1=$participantID+2}Participant Information - Participant %1{/ts} - -==========================================================={if $pricesetFieldsCount }===================={/if} - -{foreach from=$eachParticipant item=eachProfile key=pid} -----------------------------------------------------------{if $pricesetFieldsCount }--------------------{/if} - -{$customProfile.title.$pid} -----------------------------------------------------------{if $pricesetFieldsCount }--------------------{/if} - -{foreach from=$eachProfile item=val key=field} -{foreach from=$val item=v key=f} -{$field}: {$v} -{/foreach} -{/foreach} -{/foreach} -{/foreach} -{/if} -{if $customGroup} -{foreach from=$customGroup item=value key=customName} -=========================================================={if $pricesetFieldsCount }===================={/if} - -{$customName} -=========================================================={if $pricesetFieldsCount }===================={/if} - -{foreach from=$value item=v key=n} -{$n}: {$v} -{/foreach} -{/foreach} -{/if} diff --git a/CRM/Upgrade/Form.php b/CRM/Upgrade/Form.php index e2246c0e04..8fbc476e7b 100644 --- a/CRM/Upgrade/Form.php +++ b/CRM/Upgrade/Form.php @@ -45,7 +45,7 @@ class CRM_Upgrade_Form extends CRM_Core_Form { /** * Minimum previous CiviCRM version we can directly upgrade from */ - const MINIMUM_UPGRADABLE_VERSION = '4.0.8'; + const MINIMUM_UPGRADABLE_VERSION = '4.1.3'; /** * Minimum php version required to run (equal to or lower than the minimum install version) @@ -336,9 +336,6 @@ SET version = '$version' $sqlFilePattern = '/^((\d{1,2}\.\d{1,2})\.(\d{1,2}\.)?(\d{1,2}|\w{4,7}))\.(my)?sql(\.tpl)?$/i'; foreach ($sqlFiles as $file) { if (preg_match($sqlFilePattern, $file, $matches)) { - if ($matches[2] == '4.0') { - CRM_Core_Error::fatal("4.0.x upgrade files shouldn't exist. Contact Lobo to discuss this. This is related to the issue CRM-7731."); - } if (!in_array($matches[1], $revList)) { $revList[] = $matches[1]; } @@ -533,12 +530,6 @@ SET version = '$version' public static function buildQueue($currentVer, $latestVer, $postUpgradeMessageFile) { $upgrade = new CRM_Upgrade_Form(); - // hack to make 4.0.x (D7,J1.6) codebase go through 3.4.x (d6, J1.5) upgrade files, - // since schema wise they are same - if (CRM_Upgrade_Form::getRevisionPart($currentVer) == '4.0') { - $currentVer = str_replace('4.0.', '3.4.', $currentVer); - } - // Ensure that queue can be created if (!CRM_Queue_BAO_QueueItem::findCreateTable()) { CRM_Core_Error::fatal(ts('Failed to find or create queueing table')); diff --git a/CRM/Upgrade/Incremental/php/FourOne.php b/CRM/Upgrade/Incremental/php/FourOne.php deleted file mode 100644 index 2fe81eedf2..0000000000 --- a/CRM/Upgrade/Incremental/php/FourOne.php +++ /dev/null @@ -1,430 +0,0 @@ -enableComponents)) { - if (!CRM_Core_DAO::checkTriggerViewPermission(TRUE, FALSE)) { - $errors[] = 'CiviCase now requires CREATE VIEW and DROP VIEW permissions for the database user.'; - return FALSE; - } - } - - return TRUE; - } - - /** - * Compute any messages which should be displayed after upgrade. - * - * @param string $postUpgradeMessage - * alterable. - * @param string $rev - * an intermediate version; note that setPostUpgradeMessage is called repeatedly with different $revs. - */ - public function setPostUpgradeMessage(&$postUpgradeMessage, $rev) { - if ($rev == '4.1.alpha1') { - $postUpgradeMessage .= '
' . - ts('WARNING! CiviCRM 4.1 introduces an improved way of handling cron jobs. However the new method is NOT backwards compatible. Please notify your system administrator that all CiviCRM related cron jobs will cease to work, and will need to be re-configured (this includes sending CiviMail mailings, updating membership statuses, etc.). Refer to the online documentation for detailed instructions.', array(1 => 'http://wiki.civicrm.org/confluence/display/CRMDOC41/Managing+Scheduled+Jobs')); - $postUpgradeMessage .= '
' . - ts('The CiviCRM Administration menu structure has been re-organized during this upgrade to make it easier to find things and reduce the number of keystrokes. If you have customized this portion of the navigation menu - you should take a few minutes to review the changes. You may need to reimplement or move your customizations.'); - - $postUpgradeMessage .= '
Yahoo recently discontinued their geocoding and mapping API service. If you previously used Yahoo, you will need to select and configure an alternate service in order to continue using geocoding/mapping tools.'; - - $postUpgradeMessage .= '
' . - ts('We have integrated KCFinder with CKEditor and TinyMCE, which enables user to upload images. Note that all the images uploaded using KCFinder will be public.'); - } - } - - /** - * @param $rev - */ - public function upgrade_4_1_alpha1($rev) { - $config = CRM_Core_Config::singleton(); - if (in_array('CiviCase', $config->enableComponents)) { - if (!CRM_Case_BAO_Case::createCaseViews()) { - $template = CRM_Core_Smarty::singleton(); - $afterUpgradeMessage = ''; - if ($afterUpgradeMessage = $template->get_template_vars('afterUpgradeMessage')) { - $afterUpgradeMessage .= "

"; - } - $afterUpgradeMessage .= - '
' . - ts("There was a problem creating CiviCase database views. Please create the following views manually before using CiviCase:"); - $afterUpgradeMessage .= - '
' . - CRM_Case_BAO_Case::createCaseViewsQuery('upcoming') . '
' . - CRM_Case_BAO_Case::createCaseViewsQuery('recent') . '
' . - '
'; - $template->assign('afterUpgradeMessage', $afterUpgradeMessage); - } - } - - $upgrade = new CRM_Upgrade_Form(); - $upgrade->processSQL($rev); - - $this->transferPreferencesToSettings(); - $this->createNewSettings(); - - // now modify the config so that the directories are now stored in the settings table - // CRM-8780 - $params = array(); - CRM_Core_BAO_ConfigSetting::add($params); - - // also reset navigation - CRM_Core_BAO_Navigation::resetNavigation(); - } - - public function transferPreferencesToSettings() { - // first transfer system preferences - $domainColumnNames = array( - CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME => array( - 'contact_view_options', - 'contact_edit_options', - 'advanced_search_options', - 'user_dashboard_options', - 'address_options', - 'address_format', - 'mailing_format', - 'display_name_format', - 'sort_name_format', - 'editor_id', - 'contact_autocomplete_options', - ), - CRM_Core_BAO_Setting::ADDRESS_STANDARDIZATION_PREFERENCES_NAME => array( - 'address_standardization_provider', - 'address_standardization_userid', - 'address_standardization_url', - ), - CRM_Core_BAO_Setting::MAILING_PREFERENCES_NAME => array( - 'mailing_backend', - ), - ); - - $userColumnNames = array( - self::NAVIGATION_NAME => array( - 'navigation', - ), - ); - - $sql = " -SELECT * -FROM civicrm_preferences -WHERE domain_id = %1 -"; - $params = array(1 => array(CRM_Core_Config::domainID(), 'Integer')); - $dao = CRM_Core_DAO::executeQuery($sql, $params); - - $domainID = CRM_Core_Config::domainID(); - $createdDate = date('YmdHis'); - - while ($dao->fetch()) { - if ($dao->is_domain) { - $values = array(); - foreach ($domainColumnNames as $groupName => $settingNames) { - foreach ($settingNames as $settingName) { - if (empty($dao->$settingName)) { - $value = NULL; - } - else { - if ($settingName == 'mailing_backend') { - $value = $dao->$settingName; - } - else { - $value = serialize($dao->$settingName); - } - } - - if ($value) { - $value = addslashes($value); - } - $value = $value ? "'{$value}'" : 'null'; - $values[] = " ('{$groupName}','{$settingName}', {$value}, {$domainID}, null, 1, '{$createdDate}', null )"; - } - } - } - else { - // this is a user setting - foreach ($userColumnNames as $groupName => $settingNames) { - foreach ($settingNames as $settingName) { - $value = empty($dao->$settingName) ? NULL : serialize($dao->$settingName); - - if ($value) { - $value = addslashes($value); - } - $value = $value ? "'{$value}'" : 'null'; - $values[] = " ('{$groupName}', '{$settingName}', {$value}, {$domainID}, {$dao->contact_id}, 0, '{$createdDate}', null )"; - } - } - } - } - - $sql = " -INSERT INTO civicrm_setting( group_name, name, value, domain_id, contact_id, is_domain, created_date, created_id ) -VALUES -"; - - $sql .= implode(",\n", $values); - CRM_Core_DAO::executeQuery($sql); - - // now drop the civicrm_preferences table - $sql = "DROP TABLE civicrm_preferences"; - CRM_Core_DAO::executeQuery($sql); - } - - public function createNewSettings() { - $domainColumns = array( - CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME => array( - array('contact_ajax_check_similar', 1), - array('activity_assignee_notification', 1), - ), - CRM_Core_BAO_Setting::CAMPAIGN_PREFERENCES_NAME => array( - array('tag_unconfirmed', 'Unconfirmed'), - array('petition_contacts', 'Petition Contacts'), - ), - CRM_Core_BAO_Setting::EVENT_PREFERENCES_NAME => array( - array('enable_cart', 0), - ), - CRM_Core_BAO_Setting::MAILING_PREFERENCES_NAME => array( - array('profile_double_optin', 1), - array('profile_add_to_group_double_optin', 0), - array('track_civimail_replies', 0), - array('civimail_workflow', 0), - array('civimail_server_wide_lock', 0), - ), - CRM_Core_BAO_Setting::MEMBER_PREFERENCES_NAME => array( - array('default_renewal_contribution_page', NULL), - ), - CRM_Core_BAO_Setting::MULTISITE_PREFERENCES_NAME => array( - array('is_enabled', 0), - array('uniq_email_per_site', 0), - array('domain_group_id', 0), - array('event_price_set_domain_id', 0), - ), - CRM_Core_BAO_Setting::DIRECTORY_PREFERENCES_NAME => array( - array('uploadDir', NULL), - array('imageUploadDir', NULL), - array('customFileUploadDir', NULL), - array('customTemplateDir', NULL), - array('customPHPPathDir', NULL), - array('extensionsDir', NULL), - ), - CRM_Core_BAO_Setting::URL_PREFERENCES_NAME => array( - array('userFrameworkResourceURL', NULL), - array('imageUploadURL', NULL), - array('customCSSURL', NULL), - ), - ); - - $domainID = CRM_Core_Config::domainID(); - $createdDate = date('YmdHis'); - - $dbSettings = array(); - self::retrieveDirectoryAndURLPaths($dbSettings); - - foreach ($domainColumns as $groupName => $settings) { - foreach ($settings as $setting) { - - if (isset($dbSettings[$groupName][$setting[0]]) && - !empty($dbSettings[$groupName][$setting[0]]) - ) { - $setting[1] = $dbSettings[$groupName][$setting[0]]; - } - - $value = $setting[1] === NULL ? NULL : serialize($setting[1]); - - if ($value) { - $value = addslashes($value); - } - - $value = $value ? "'{$value}'" : 'null'; - $values[] = "( '{$groupName}', '{$setting[0]}', {$value}, {$domainID}, null, 0, '{$createdDate}', null )"; - } - } - $sql = " -INSERT INTO civicrm_setting( group_name, name, value, domain_id, contact_id, is_domain, created_date, created_id ) -VALUES -"; - $sql .= implode(",\n", $values); - CRM_Core_DAO::executeQuery($sql); - } - - /** - * @param array $params - */ - public static function retrieveDirectoryAndURLPaths(&$params) { - - $sql = " -SELECT v.name as valueName, v.value, g.name as optionName -FROM civicrm_option_value v, - civicrm_option_group g -WHERE ( g.name = 'directory_preferences' -OR g.name = 'url_preferences' ) -AND v.option_group_id = g.id -AND v.is_active = 1 -"; - $dao = CRM_Core_DAO::executeQuery($sql); - while ($dao->fetch()) { - if (!$dao->value) { - continue; - } - - $groupName = CRM_Core_BAO_Setting::DIRECTORY_PREFERENCES_NAME; - if ($dao->optionName == 'url_preferences') { - $groupName = CRM_Core_BAO_Setting::URL_PREFERENCES_NAME; - } - $params[$groupName][$dao->valueName] = $dao->value; - } - } - - /** - * @param $rev - */ - public function upgrade_4_1_alpha2($rev) { - $dao = new CRM_Core_DAO_Setting(); - $dao->group_name = 'Directory Preferences'; - $dao->name = 'customTemplateDir'; - if (!($dao->find(TRUE))) { - $dao->domain_id = CRM_Core_Config::domainID(); - $dao->created_date = date('YmdHis'); - $dao->is_domain = 0; - $dao->save(); - } - $dao->free(); - - // Do the regular upgrade - $upgrade = new CRM_Upgrade_Form(); - $upgrade->processSQL($rev); - } - - /** - * @param $rev - */ - public function upgrade_4_1_beta1($rev) { - //CRM-9311 - $groupNames = array('directory_preferences', 'url_preferences'); - foreach ($groupNames as $groupName) { - CRM_Core_OptionGroup::deleteAssoc($groupName); - } - - $domainCols = array( - CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME => array( - 'contact_ajax_check_similar', - 'activity_assignee_notification', - ), - CRM_Core_BAO_Setting::CAMPAIGN_PREFERENCES_NAME => array( - 'tag_unconfirmed', - 'petition_contacts', - ), - CRM_Core_BAO_Setting::EVENT_PREFERENCES_NAME => array( - 'enable_cart', - ), - CRM_Core_BAO_Setting::MAILING_PREFERENCES_NAME => array( - 'profile_double_optin', - 'profile_add_to_group_double_optin', - 'track_civimail_replies', - 'civimail_workflow', - 'civimail_server_wide_lock', - ), - CRM_Core_BAO_Setting::MEMBER_PREFERENCES_NAME => array( - 'default_renewal_contribution_page', - ), - CRM_Core_BAO_Setting::MULTISITE_PREFERENCES_NAME => array( - 'is_enabled', - 'uniq_email_per_site', - 'domain_group_id', - 'event_price_set_domain_id', - ), - CRM_Core_BAO_Setting::DIRECTORY_PREFERENCES_NAME => array( - 'uploadDir', - 'imageUploadDir', - 'customFileUploadDir', - 'customTemplateDir', - 'customPHPPathDir', - 'extensionsDir', - ), - CRM_Core_BAO_Setting::URL_PREFERENCES_NAME => array( - 'userFrameworkResourceURL', - 'imageUploadURL', - 'customCSSURL', - ), - ); - - $arrGroupNames = array_keys($domainCols); - $groupNames = implode("','", $arrGroupNames); - $arrNames = array(); - foreach ($domainCols as $groupName => $names) { - $arrNames[] = implode("','", $names); - } - $name = implode("','", $arrNames); - - $sql = " - update civicrm_setting set is_domain = 1 where is_domain = 0 and group_name in ( '{$groupNames}' ) and name in ('{$name}')"; - - CRM_Core_DAO::executeQuery($sql); - - $upgrade = new CRM_Upgrade_Form(); - $upgrade->assign('addWightForActivity', !(CRM_Core_DAO::checkFieldExists('civicrm_activity', 'weight'))); - $upgrade->processSQL($rev); - } - - /** - * @param $rev - */ - public function upgrade_4_1_1($rev) { - $upgrade = new CRM_Upgrade_Form(); - $upgrade->assign('addDedupeEmail', !(CRM_Core_DAO::checkFieldExists('civicrm_mailing', 'dedupe_email'))); - - $sql = "SELECT id FROM civicrm_worldregion LIMIT 1"; - $upgrade->assign('worldRegionEmpty', !CRM_Core_DAO::singleValueQuery($sql)); - - $upgrade->processSQL($rev); - } - - /** - * @return string - */ - public function getTemplateMessage() { - return "Blah"; - } - -} diff --git a/CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl deleted file mode 100644 index 1210bad37b..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.0.mysql.tpl +++ /dev/null @@ -1,8 +0,0 @@ - -{if $multilingual} - {foreach from=$locales item=locale} - ALTER TABLE civicrm_pcp_block ADD link_text_{$locale} varchar(255); - UPDATE civicrm_pcp_block SET link_text_{$locale} = link_text; - {/foreach} - ALTER TABLE civicrm_pcp_block DROP link_text; -{/if} \ No newline at end of file diff --git a/CRM/Upgrade/Incremental/sql/4.1.1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.1.mysql.tpl deleted file mode 100644 index 50af4a5df0..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.1.mysql.tpl +++ /dev/null @@ -1,20 +0,0 @@ --- CRM-9699 - -{if $addDedupeEmail} - ALTER TABLE `civicrm_mailing` ADD `dedupe_email` TINYINT( 4 ) NULL DEFAULT '0' COMMENT 'Remove duplicate emails?'; -{/if} - -{if $worldRegionEmpty} - INSERT INTO `civicrm_worldregion` (`id`, `name`) VALUES - (1, 'Europe and Central Asia'), - (2, 'America South, Central, North and Caribbean'), - (3, 'Middle East and North Africa'), - (4, 'Asia-Pacific'), - (5, 'Africa West, East, Central and Southern'), - (99, 'unassigned'); -{/if} - -SELECT @region_id := max(id) from civicrm_worldregion where name = "Africa West, East, Central and Southern"; - -INSERT INTO `civicrm_country` (`name`, `iso_code`, `country_code`, `idd_prefix`, `ndd_prefix`, `region_id`, `is_province_abbreviated`, `address_format_id`) VALUES ('South Sudan', 'SS', NULL, NULL, NULL, @region_id, 0, NULL) ON DUPLICATE KEY UPDATE iso_code='SS'; - diff --git a/CRM/Upgrade/Incremental/sql/4.1.2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.2.mysql.tpl deleted file mode 100644 index 1a2923e247..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.2.mysql.tpl +++ /dev/null @@ -1,22 +0,0 @@ --- CRM-9795 (fix duplicate option values) - -SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type'; -SELECT @maxValue := MAX(ROUND(value)) FROM civicrm_option_value WHERE option_group_id = @option_group_id_act; -SELECT @clientCaseValue := value FROM civicrm_option_value WHERE name = 'Add Client To Case' AND option_group_id = @option_group_id_act; - -UPDATE civicrm_option_value SET value = @maxValue + 1 WHERE name = 'Add Client To Case' AND option_group_id = @option_group_id_act; - -UPDATE civicrm_activity -INNER JOIN civicrm_case_activity ON civicrm_activity.id = civicrm_case_activity.activity_id -SET civicrm_activity.activity_type_id = @maxValue + 1 -WHERE civicrm_activity.activity_type_id = @clientCaseValue; - --- CRM-9868 Force disable jobs that should only be run manually -UPDATE civicrm_job -SET is_active = 0 -WHERE api_action IN ('process_membership_reminder_date','update_greeting'); - -UPDATE civicrm_job -SET description = '{ts escape="sql"}Sets membership renewal reminder dates for current membership records where reminder date is null. This job should never be run automatically as it will cause members to get renewal reminders repeatedly.{/ts}' -WHERE api_action = 'process_membership_reminder_date'; - diff --git a/CRM/Upgrade/Incremental/sql/4.1.3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.3.mysql.tpl deleted file mode 100644 index ff5c018be5..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.3.mysql.tpl +++ /dev/null @@ -1,5 +0,0 @@ --- CRM-10264 -INSERT INTO `civicrm_job` - ( domain_id, run_frequency, last_run, name, description, api_prefix, api_entity, api_action, parameters, is_active ) -VALUES - ( {$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}','civicrm_api3', 'job', 'cleanup', NULL, 0); diff --git a/CRM/Upgrade/Incremental/sql/4.1.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.alpha1.mysql.tpl deleted file mode 100644 index 377e551362..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.alpha1.mysql.tpl +++ /dev/null @@ -1,529 +0,0 @@ -{include file='../CRM/Upgrade/4.1.alpha1.msg_template/civicrm_msg_template.tpl'} - --- get domain id -SELECT @domainID := min(id) FROM civicrm_domain; - --- CRM-8356 --- Add filter column 'filter' for 'civicrm_custom_field' -ALTER TABLE `civicrm_custom_field` ADD `filter` VARCHAR(255) NULL COMMENT 'Stores Contact Get API params contact reference custom fields. May be used for other filters in the future.'; - --- CRM-8062 -ALTER TABLE `civicrm_subscription_history` CHANGE `status` `status` ENUM( 'Added', 'Removed', 'Pending', 'Deleted' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'The state of the contact within the group'; - --- CRM-8510 -ALTER TABLE civicrm_currency -ADD UNIQUE INDEX UI_name ( name ); - --- CRM-8616 -DELETE FROM civicrm_currency WHERE name = 'EEK'; - --- CRM-8769 -INSERT IGNORE INTO civicrm_state_province - (`name`, `abbreviation`, `country_id`) -VALUES - ('Metropolitan Manila' , 'MNL', '1170'); - --- CRM-8902 - UPDATE civicrm_navigation SET permission ='add cases,access all cases and activities', permission_operator = 'OR' - WHERE civicrm_navigation.name= 'New Case'; - --- CRM-8780 - --- add the settings table - CREATE TABLE `civicrm_setting` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `group_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'group name for setting element, useful in caching setting elements', - `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Unique name for setting', - `value` text COLLATE utf8_unicode_ci COMMENT 'data associated with this group / name combo', - `domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this menu item for', - `contact_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact', - `is_domain` tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?', - `component_id` int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to', - `created_date` datetime DEFAULT NULL COMMENT 'When was the setting created', - `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this setting', - PRIMARY KEY (`id`), - KEY `index_group_name` (`group_name`,`name`), - KEY `FK_civicrm_setting_domain_id` (`domain_id`), - KEY `FK_civicrm_setting_contact_id` (`contact_id`), - KEY `FK_civicrm_setting_component_id` (`component_id`), - KEY `FK_civicrm_setting_created_id` (`created_id`), - CONSTRAINT `FK_civicrm_setting_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE CASCADE, - CONSTRAINT `FK_civicrm_setting_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE, - CONSTRAINT `FK_civicrm_setting_component_id` FOREIGN KEY (`component_id`) REFERENCES `civicrm_component` (`id`), - CONSTRAINT `FK_civicrm_setting_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; - --- CRM-8508 - SELECT @caseCompId := id FROM `civicrm_component` where `name` like 'CiviCase'; - - SELECT @option_group_id_activity_type := max(id) from civicrm_option_group where name = 'activity_type'; - SELECT @max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_activity_type; - SELECT @max_wt := max(weight) from civicrm_option_value where option_group_id=@option_group_id_activity_type; - - INSERT INTO civicrm_option_value - (option_group_id, {localize field='label'}label{/localize}, {localize field='description'}description{/localize}, value, name, weight, filter, component_id) - VALUES - (@option_group_id_activity_type, {localize}'Change Custom Data'{/localize},{localize}''{/localize}, (SELECT @max_val := @max_val+1), 'Change Custom Data', (SELECT @max_wt := @max_wt+1), 0, @caseCompId); - --- CRM-8739 - Update civicrm_menu set title = 'Cleanup Caches and Update Paths' where path = 'civicrm/admin/setting/updateConfigBackend'; - --- CRM-8855 - SELECT @option_group_id_udOpt := max(id) from civicrm_option_group where name = 'user_dashboard_options'; - SELECT @max_val := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id = @option_group_id_udOpt; - SELECT @max_wt := max(weight) from civicrm_option_value where option_group_id=@option_group_id_udOpt; - - INSERT INTO civicrm_option_value - (option_group_id, {localize field='label'}label{/localize}, value, name, weight, filter, is_default, component_id) - VALUES - (@option_group_id_udOpt, {localize}'Assigned Activities'{/localize}, (SELECT @max_val := @max_val+1), 'Assigned Activities', (SELECT @max_wt := @max_wt+1), 0, NULL, NULL); - --- CRM-8737 - ALTER TABLE `civicrm_event` ADD `is_share` TINYINT( 4 ) NULL DEFAULT '1' COMMENT 'Can people share the event through social media?'; - ALTER TABLE `civicrm_contribution_page` ADD `is_share` TINYINT(4) NULL DEFAULT '1' COMMENT 'Can people share the contribution page through social media?'; - --- CRM-8357 -ALTER TABLE `civicrm_contact` CHANGE `contact_sub_type` `contact_sub_type` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'May be used to over-ride contact view and edit templates.'; - -UPDATE civicrm_contact SET contact_sub_type = CONCAT('', contact_sub_type, ''); - --- CRM-6811 -INSERT INTO `civicrm_dashboard` - ( `domain_id`, {localize field='label'}`label`{/localize}, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `fullscreen_url`, `is_fullscreen`, `is_reserved`) - VALUES - ( @domainID, {localize}'Case Dashboard Dashlet'{/localize}, 'civicrm/dashlet/casedashboard&reset=1&snippet=4', 'access CiviCase', NULL , 0, 0, 1, 4, 'civicrm/dashlet/casedashboard&reset=1&snippet=4&context=dashletFullscreen', 1, 1); - --- CRM-9059 Admin menu rebuild -SELECT @domainID := min(id) FROM civicrm_domain; -SELECT @adminlastID := id FROM civicrm_navigation where name = 'Administer' AND domain_id = @domainID; -SELECT @customizeOld := id FROM civicrm_navigation where name = 'Customize' AND domain_id = @domainID; -SELECT @configureOld := id FROM civicrm_navigation where name = 'Configure' AND domain_id = @domainID; -SELECT @globalOld := id FROM civicrm_navigation where name = 'Global Settings' AND domain_id = @domainID; -SELECT @manageOld := id FROM civicrm_navigation where name = 'Manage' AND domain_id = @domainID; -SELECT @optionsOld := id FROM civicrm_navigation where name = 'Option Lists' AND domain_id = @domainID; -SELECT @customizeOld := id FROM civicrm_navigation where name = 'Customize' AND domain_id = @domainID; - -DELETE from civicrm_navigation WHERE parent_id = @globalOld; -DELETE from civicrm_navigation WHERE parent_id IN (@customizeOld, @configureOld, @manageOld, @optionsOld); -DELETE from civicrm_navigation WHERE id IN (@customizeOld, @configureOld, @manageOld, @optionsOld); -UPDATE civicrm_navigation SET weight = 9 WHERE name = 'CiviCampaign' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 10 WHERE name = 'CiviCase' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 11 WHERE name = 'CiviContribute' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 12 WHERE name = 'CiviEvent' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 13 WHERE name = 'CiviGrant' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 14 WHERE name = 'CiviMail' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 15 WHERE name = 'CiviMember' AND parent_id = @adminlastID; -UPDATE civicrm_navigation SET weight = 16 WHERE name = 'CiviReport' AND parent_id = @adminlastID; - -DELETE FROM civicrm_navigation WHERE name = 'Administration Console'; - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin&reset=1', '{ts escape="sql" skip="true"}Administration Console{/ts}', 'Administration Console', 'administer CiviCRM', '', @adminlastID, '1', NULL, 1 ); - -SET @adminConsolelastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/configtask&reset=1', '{ts escape="sql" skip="true"}Configuration Checklist{/ts}', 'Configuration Checklist', 'administer CiviCRM', '', @adminConsolelastID, '1', NULL, 1 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Customize Data and Screens{/ts}', 'Customize Data and Screens', 'administer CiviCRM', '', @adminlastID, '1', NULL, 3 ); - -SET @CustomizelastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/custom/group&reset=1', '{ts escape="sql" skip="true"}Custom Fields{/ts}', 'Custom Fields', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/uf/group&reset=1', '{ts escape="sql" skip="true"}Profiles{/ts}', 'Profiles', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 2 ), - ( @domainID, 'civicrm/admin/tag&reset=1', '{ts escape="sql" skip="true"}Tags (Categories){/ts}', 'Tags (Categories)', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 3 ), - ( @domainID, 'civicrm/admin/options/activity_type&reset=1&group=activity_type', '{ts escape="sql" skip="true"}Activity Types{/ts}', 'Activity Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 4 ), - ( @domainID, 'civicrm/admin/reltype&reset=1', '{ts escape="sql" skip="true"}Relationship Types{/ts}', 'Relationship Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/options/subtype&reset=1', '{ts escape="sql" skip="true"}Contact Types{/ts}','Contact Types', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 6 ), - ( @domainID, 'civicrm/admin/setting/preferences/display&reset=1', '{ts escape="sql" skip="true"}Display Preferences{/ts}', 'Display Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 9 ), - ( @domainID, 'civicrm/admin/setting/search&reset=1', '{ts escape="sql" skip="true"}Search Preferences{/ts}', 'Search Preferences', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 10 ), - ( @domainID, 'civicrm/admin/menu&reset=1', '{ts escape="sql" skip="true"}Navigation Menu{/ts}', 'Navigation Menu', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 11 ), - ( @domainID, 'civicrm/admin/options/wordreplacements&reset=1','{ts escape="sql" skip="true"}Word Replacements{/ts}','Word Replacements', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 12 ), - ( @domainID, 'civicrm/admin/options/custom_search&reset=1&group=custom_search', '{ts escape="sql" skip="true"}Manage Custom Searches{/ts}', 'Manage Custom Searches', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 13 ), - ( @domainID, 'civicrm/admin/extensions&reset=1', '{ts escape="sql" skip="true"}Manage Extensions{/ts}', 'Manage Extensions', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 14 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Dropdown Options{/ts}', 'Dropdown Options', 'administer CiviCRM', '', @CustomizelastID, '1', NULL, 8 ); - -SET @optionListlastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/options/gender&reset=1&group=gender', '{ts escape="sql" skip="true"}Gender Options{/ts}', 'Gender Options', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/options/individual_prefix&group=individual_prefix&reset=1', '{ts escape="sql" skip="true"}Individual Prefixes (Ms, Mr...){/ts}', 'Individual Prefixes (Ms, Mr...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 2 ), - ( @domainID, 'civicrm/admin/options/individual_suffix&group=individual_suffix&reset=1', '{ts escape="sql" skip="true"}Individual Suffixes (Jr, Sr...){/ts}', 'Individual Suffixes (Jr, Sr...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 3 ), - ( @domainID, 'civicrm/admin/options/instant_messenger_service&group=instant_messenger_service&reset=1', '{ts escape="sql" skip="true"}Instant Messenger Services{/ts}', 'Instant Messenger Services', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 4 ), - ( @domainID, 'civicrm/admin/locationType&reset=1', '{ts escape="sql" skip="true"}Location Types (Home, Work...){/ts}', 'Location Types (Home, Work...)', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/options/mobile_provider&group=mobile_provider&reset=1', '{ts escape="sql" skip="true"}Mobile Phone Providers{/ts}', 'Mobile Phone Providers', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 6 ), - ( @domainID, 'civicrm/admin/options/phone_type&group=phone_type&reset=1', '{ts escape="sql" skip="true"}Phone Types{/ts}', 'Phone Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 7 ), - ( @domainID, 'civicrm/admin/options/website_type&group=website_type&reset=1', '{ts escape="sql" skip="true"}Website Types{/ts}', 'Website Types', 'administer CiviCRM', '', @optionListlastID, '1', NULL, 8 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Communications{/ts}', 'Communications', 'administer CiviCRM', '', @adminlastID, '1', NULL, 4 ); - -SET @communicationslastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/domain&action=update&reset=1', '{ts escape="sql" skip="true"}Organization Address and Contact Info{/ts}', 'Organization Address and Contact Info', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/options/from_email_address&group=from_email_address&reset=1', '{ts escape="sql" skip="true"}FROM Email Addresses{/ts}', 'FROM Email Addresses', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 2 ), - ( @domainID, 'civicrm/admin/messageTemplates&reset=1', '{ts escape="sql" skip="true"}Message Templates{/ts}', 'Message Templates', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 3 ), - ( @domainID, 'civicrm/admin/scheduleReminders&reset=1', '{ts escape="sql" skip="true"}Schedule Reminders{/ts}', 'Schedule Reminders', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 4 ), - ( @domainID, 'civicrm/admin/options/preferred_communication_method&group=preferred_communication_method&reset=1', '{ts escape="sql" skip="true"}Preferred Communication Methods{/ts}', 'Preferred Communication Methods', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/labelFormats&reset=1', '{ts escape="sql" skip="true"}Label Formats{/ts}', 'Label Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 6 ), - ( @domainID, 'civicrm/admin/pdfFormats&reset=1', '{ts escape="sql" skip="true"}Print Page (PDF) Formats{/ts}', 'Print Page (PDF) Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 7 ), - ( @domainID, 'civicrm/admin/options/email_greeting&group=email_greeting&reset=1', '{ts escape="sql" skip="true"}Email Greeting Formats{/ts}', 'Email Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 8 ), - ( @domainID, 'civicrm/admin/options/postal_greeting&group=postal_greeting&reset=1', '{ts escape="sql" skip="true"}Postal Greeting Formats{/ts}', 'Postal Greeting Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 9 ), - ( @domainID, 'civicrm/admin/options/addressee&group=addressee&reset=1', '{ts escape="sql" skip="true"}Addressee Formats{/ts}', 'Addressee Formats', 'administer CiviCRM', '', @communicationslastID, '1', NULL, 10 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Localization{/ts}', 'Localization', 'administer CiviCRM', '', @adminlastID, '1', NULL, 6 ); - -SET @locallastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/setting/localization&reset=1', '{ts escape="sql" skip="true"}Languages, Currency, Locations{/ts}', 'Languages, Currency, Locations', 'administer CiviCRM', '', @locallastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/setting/preferences/address&reset=1', '{ts escape="sql" skip="true"}Address Settings{/ts}', 'Address Settings', 'administer CiviCRM', '', @locallastID, '1', NULL, 2 ), - ( @domainID, 'civicrm/admin/setting/date&reset=1', '{ts escape="sql" skip="true"}Date Format{/ts}', 'Date Formats', 'administer CiviCRM', '', @locallastID, '1', NULL, 3 ), - ( @domainID, 'civicrm/admin/options/languages&group=languages&reset=1', '{ts escape="sql" skip="true"}Preferred Language Options{/ts}', 'Preferred Language Options', 'administer CiviCRM', '', @locallastID, '1', NULL, 4 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Users and Permissions{/ts}', 'Users and Permissions', 'administer CiviCRM', '', @adminlastID, '1', NULL, 7 ); - -SET @usersPermslastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/access&reset=1', '{ts escape="sql" skip="true"}Permissions (Access Control){/ts}', 'Permissions (Access Control)', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/synchUser&reset=1', '{ts escape="sql" skip="true"}Synchronize Users to Contacts{/ts}', 'Synchronize Users to Contacts', 'administer CiviCRM', '', @usersPermslastID, '1', NULL, 2 ); - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}System Settings{/ts}', 'System Settings', 'administer CiviCRM', '', @adminlastID, '1', NULL, 8 ); - -SET @systemSettingslastID:=LAST_INSERT_ID(); -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/setting/component&reset=1', '{ts escape="sql" skip="true"}Enable CiviCRM Components{/ts}', 'Enable Components', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 1 ), - ( @domainID, 'civicrm/admin/setting/smtp&reset=1', '{ts escape="sql" skip="true"}Outbound Email (SMTP/Sendmail){/ts}', 'Outbound Email', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 2 ), - ( @domainID, 'civicrm/admin/paymentProcessor&reset=1', '{ts escape="sql" skip="true"}Payment Processors{/ts}', 'Payment Processors', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 3 ), - ( @domainID, 'civicrm/admin/setting/mapping&reset=1', '{ts escape="sql" skip="true"}Mapping and Geocoding{/ts}', 'Mapping and Geocoding', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 4 ), - ( @domainID, 'civicrm/admin/setting/misc&reset=1', '{ts escape="sql" skip="true"}Undelete, Logging and ReCAPTCHA{/ts}', 'Undelete, Logging and ReCAPTCHA', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/setting/path&reset=1', '{ts escape="sql" skip="true"}Directories{/ts}', 'Directories', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 6 ), - ( @domainID, 'civicrm/admin/setting/url&reset=1', '{ts escape="sql" skip="true"}Resource URLs{/ts}', 'Resource URLs', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 7 ), - ( @domainID, 'civicrm/admin/setting/updateConfigBackend&reset=1', '{ts escape="sql" skip="true"}Cleanup Caches and Update Paths{/ts}', 'Cleanup Caches and Update Paths', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 8 ), - ( @domainID, 'civicrm/admin/setting/uf&reset=1', '{ts escape="sql" skip="true"}CMS Database Integration{/ts}', 'CMS Integration', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 9 ), - ( @domainID, 'civicrm/admin/options/safe_file_extension&group=safe_file_extension&reset=1', '{ts escape="sql" skip="true"}Safe File Extensions{/ts}', 'Safe File Extensions','administer CiviCRM', '',@systemSettingslastID, '1', NULL, 10 ), - ( @domainID, 'civicrm/admin/options?reset=1', '{ts escape="sql" skip="true"}Option Groups{/ts}', 'Option Groups', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 11 ), - ( @domainID, 'civicrm/admin/mapping&reset=1', '{ts escape="sql" skip="true"}Import/Export Mappings{/ts}', 'Import/Export Mappings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 12 ), - ( @domainID, 'civicrm/admin/setting/debug&reset=1', '{ts escape="sql" skip="true"}Debugging and Error Handling{/ts}','Debugging and Error Handling', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 13 ), - ( @domainID, 'civicrm/admin/setting/preferences/multisite&reset=1', '{ts escape="sql" skip="true"}Multi Site Settings{/ts}', 'Multi Site Settings', 'administer CiviCRM', '', @systemSettingslastID, '1', NULL, 14 ); - -SELECT @campaignAdminID := id FROM civicrm_navigation where name = 'CiviCampaign' AND parent_id = @adminlastID; -SELECT @eventAdminID := id FROM civicrm_navigation where name = 'CiviEvent' AND parent_id = @adminlastID; -SELECT @mailAdminID := id FROM civicrm_navigation where name = 'CiviMail' AND parent_id = @adminlastID; -SELECT @memberAdminID := id FROM civicrm_navigation where name = 'CiviMember' AND parent_id = @adminlastID; - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/setting/preferences/campaign&reset=1', '{ts escape="sql" skip="true"}CiviCampaign Component Settings{/ts}', 'CiviCampaign Component Settings','administer CiviCampaign', '', @campaignAdminID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/setting/preferences/event&reset=1', '{ts escape="sql" skip="true"}CiviEvent Component Settings{/ts}', 'CiviEvent Component Settings','access CiviEvent,administer CiviCRM', 'AND', @eventAdminID, '1', NULL, 13 ), - ( @domainID, 'civicrm/admin/setting/preferences/mailing&reset=1', '{ts escape="sql" skip="true"}CiviMail Component Settings{/ts}', 'CiviMail Component Settings','access CiviMail,administer CiviCRM', 'AND', @mailAdminID, '1', NULL, 6 ), - ( @domainID, 'civicrm/admin/setting/preferences/member&reset=1', '{ts escape="sql" skip="true"}CiviMember Component Settings{/ts}', 'CiviMember Component Settings','access CiviMember,administer CiviCRM', 'AND', @memberAdminID, '1', NULL, 5 ), - ( @domainID, 'civicrm/admin/options/event_badge&group=event_badge&reset=1', '{ts escape="sql" skip="true"}Event Badge Formats{/ts}', 'Event Badge Formats', 'access CiviEvent,administer CiviCRM', 'AND', @eventAdminID, '1', NULL, 11 ); - --- CRM-9113 -ALTER TABLE `civicrm_report_instance` ADD `grouprole` VARCHAR( 1024 ) NULL AFTER `permission`; - --- CRM-8762 Fix option_group table -ALTER TABLE civicrm_option_group CHANGE `is_reserved` `is_reserved` TINYINT DEFAULT 1; -UPDATE civicrm_option_group SET `is_reserved` = 1; -{if $multilingual} - {foreach from=$locales item=locale} - UPDATE civicrm_option_group SET label_{$locale} = description_{$locale} WHERE label_{$locale} IS NULL; - {/foreach} -{else} - UPDATE civicrm_option_group SET `label` = `description` WHERE `label` IS NULL; -{/if} - --- CRM-9112 - ALTER TABLE `civicrm_dedupe_rule_group` ADD `title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Label of the rule group'; - -ALTER TABLE `civicrm_dedupe_rule_group` ADD `is_reserved` TINYINT( 4 ) NULL DEFAULT NULL COMMENT 'Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin'; - -UPDATE `civicrm_dedupe_rule_group` SET `name` = CONCAT( REPLACE( `name`, '-', '' ), '-', id ); - --- the fuzzy default dedupe rules -INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, level, is_default, name, title, is_reserved) -VALUES ('Individual', 20, 'Fuzzy', 1, 'IndividualFuzzy', 'Individual Fuzzy In-built', 1); - -SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; -INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) -VALUES (@drgid, 'civicrm_contact', 'first_name', 5), - (@drgid, 'civicrm_contact', 'last_name', 7), - (@drgid, 'civicrm_email' , 'email', 10); - --- the strict dedupe rules -INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, level, is_default, name, title, is_reserved) -VALUES ('Individual', 10, 'Strict', 1, 'IndividualStrict', 'Individual Strict In-built', 1); - -SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; -INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) -VALUES (@drgid, 'civicrm_email', 'email', 10); - -INSERT INTO civicrm_dedupe_rule_group (contact_type, threshold, level, is_default, name, title, is_reserved) -VALUES ('Individual', 15, 'Strict', 0, 'IndividualComplete', 'Individual Complete Inbuilt', 1); - -SELECT @drgid := MAX(id) FROM civicrm_dedupe_rule_group; -INSERT INTO civicrm_dedupe_rule (dedupe_rule_group_id, rule_table, rule_field, rule_weight) -VALUES (@drgid, 'civicrm_contact', 'first_name', '5'), - (@drgid, 'civicrm_contact', 'last_name', '5'), - (@drgid, 'civicrm_address', 'street_address', '5'), - (@drgid, 'civicrm_contact', 'middle_name', '1'), - (@drgid, 'civicrm_contact', 'suffix_id', '1'); - --- CRM-9120 -{if $multilingual} - {foreach from=$locales item=locale} - ALTER TABLE `civicrm_location_type` ADD display_name_{$locale} VARCHAR( 64 ) DEFAULT NULL COMMENT 'Location Type Display Name.' AFTER `name`; - UPDATE `civicrm_location_type` SET display_name_{$locale} = `name`; - {/foreach} -{else} - ALTER TABLE `civicrm_location_type` ADD `display_name` VARCHAR( 64 ) DEFAULT NULL COMMENT 'Location Type Display Name.' AFTER `name`; - UPDATE `civicrm_location_type` SET `display_name` = `name`; -{/if} - - --- CRM-9125 -ALTER TABLE `civicrm_contribution_recur` ADD `contribution_type_id` int(10) unsigned NULL COMMENT 'FK to Contribution Type'; -ALTER TABLE `civicrm_contribution_recur` ADD CONSTRAINT `FK_civicrm_contribution_recur_contribution_type_id` FOREIGN KEY (`contribution_type_id`) REFERENCES `civicrm_contribution_type` (`id`) ON DELETE SET NULL; - -ALTER TABLE `civicrm_contribution_recur` ADD `payment_instrument_id` int(10) unsigned NULL COMMENT 'FK to Payment Instrument'; -ALTER TABLE `civicrm_contribution_recur` ADD INDEX UI_contribution_recur_payment_instrument_id ( payment_instrument_id ); - -ALTER TABLE `civicrm_contribution_recur` ADD `campaign_id` int(10) unsigned NULL COMMENT 'The campaign for which this contribution has been triggered.'; -ALTER TABLE `civicrm_contribution_recur` ADD CONSTRAINT `FK_civicrm_contribution_recur_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL; - -UPDATE `civicrm_contribution_recur` ccr INNER JOIN `civicrm_contribution` cc ON ccr.id = cc.contribution_recur_id SET ccr.campaign_id = cc.campaign_id, ccr.payment_instrument_id = cc.payment_instrument_id, ccr.contribution_type_id = cc.contribution_type_id; - --- CRM-8962 -INSERT INTO civicrm_action_mapping ( entity, entity_value, entity_value_label, entity_status, entity_status_label, entity_date_start, entity_date_end, entity_recipient ) -VALUES -('civicrm_participant', 'event_type', 'Event Type', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'), -('civicrm_participant', 'civicrm_event', 'Event Name', 'civicrm_participant_status_type', 'Participant Status', 'event_start_date', 'event_end_date', 'event_contacts'); - -INSERT INTO civicrm_option_group - (name, {localize field='label'}label{/localize}, {localize field='description'}description{/localize}, is_reserved, is_active) -VALUES - ('event_contacts', {localize}'{ts escape="sql"}Event Recipients{/ts}'{/localize}, {localize}'{ts escape="sql"}Event Recipients{/ts}'{/localize}, 1, 1), - ('contact_reference_options', {localize}'{ts escape="sql"}Contact Reference Autocomplete Options{/ts}'{/localize}, {localize}'{ts escape="sql"}Contact Reference Autocomplete Options{/ts}'{/localize}, 1, 1); - -SELECT @option_group_id_ere := max(id) from civicrm_option_group where name = 'event_contacts'; - -INSERT INTO civicrm_option_value - (option_group_id, {localize field='label'}label{/localize}, value, name, filter, weight, is_active ) -VALUES - (@option_group_id_ere, {localize}'{ts escape="sql"}Participant Role{/ts}'{/localize}, 1, 'participant_role', 0, 1, 1 ); - -ALTER TABLE civicrm_action_schedule ADD `absolute_date` date DEFAULT NULL COMMENT 'Date on which the reminder be sent.'; -ALTER TABLE civicrm_action_schedule ADD `recipient_listing` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'listing based on recipient field.'; - - --- CRM-8534 -ALTER TABLE civicrm_pcp_block - DROP FOREIGN KEY FK_civicrm_pcp_block_entity_id, - DROP INDEX FK_civicrm_pcp_block_entity_id; - -ALTER TABLE civicrm_pcp - DROP FOREIGN KEY FK_civicrm_pcp_contribution_page_id, - DROP INDEX FK_civicrm_pcp_contribution_page_id; - -ALTER TABLE `civicrm_pcp` - ADD `page_type` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'contribute' AFTER `contribution_page_id`; -ALTER TABLE `civicrm_pcp` - CHANGE `contribution_page_id` `page_id` INT( 10 ) UNSIGNED NOT NULL COMMENT 'The Page which triggered this pcp'; -ALTER TABLE `civicrm_pcp` - ADD `pcp_block_id` int(10) unsigned NOT NULL COMMENT 'The pcp block that this pcp page was created from' AFTER `page_type`; - -UPDATE `civicrm_pcp` - SET `page_type` = 'contribute' WHERE `page_type` = '' OR `page_type` IS NULL; -UPDATE `civicrm_pcp` `pcp` - SET `pcp_block_id` = (SELECT `id` FROM `civicrm_pcp_block` `pb` WHERE `pb`.`entity_id` = `pcp`.`page_id`); - -ALTER TABLE `civicrm_pcp_block` - ADD `target_entity_type` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'contribute' AFTER `entity_id`; -ALTER TABLE `civicrm_pcp_block` - ADD `target_entity_id` int(10) unsigned NOT NULL COMMENT 'The entity that this pcp targets' AFTER `target_entity_type`; -UPDATE `civicrm_pcp_block` - SET `target_entity_id` = `entity_id` WHERE `target_entity_id` = '' OR `target_entity_id` IS NULL; - -ALTER TABLE `civicrm_pcp` DROP COLUMN `referer`; - -UPDATE civicrm_navigation SET url = 'civicrm/admin/pcp?reset=1&page_type=contribute' WHERE url = 'civicrm/admin/pcp&reset=1'; - -SELECT @lastEventId := MAX(id) FROM civicrm_navigation where name = 'Events' AND domain_id = @domainID; -SELECT @adminEventId := MAX(id) FROM civicrm_navigation where name = 'CiviEvent' AND domain_id = @domainID; -SELECT @lastEventIdWeight := MAX(weight)+1 FROM civicrm_navigation where parent_id = @lastEventId; -SELECT @adminEventIdWeight := MAX(weight)+1 FROM civicrm_navigation where parent_id = @adminEventId; - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', '{ts escape="sql" skip="true"}Personal Campaign Pages{/ts}', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @lastEventId, '1', 1, @lastEventIdWeight ), - ( @domainID, 'civicrm/admin/pcp?reset=1&page_type=event', '{ts escape="sql" skip="true"}Personal Campaign Pages{/ts}', 'Personal Campaign Pages', 'access CiviEvent,administer CiviCRM', 'AND', @adminEventId, '1', 1, @adminEventIdWeight ); - --- CRM-8358 - consolidated cron jobs - -CREATE TABLE `civicrm_job` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Job Id', - `domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this scheduled job for', - `run_frequency` enum('Hourly','Daily','Always') COLLATE utf8_unicode_ci DEFAULT 'Daily' COMMENT 'Scheduled job run frequency.', - `last_run` datetime DEFAULT NULL COMMENT 'When was this cron entry last run', - `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Title of the job', - `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Description of the job', - `api_prefix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Prefix of the job api call', - `api_entity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Entity of the job api call', - `api_action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Action of the job api call', - `parameters` text COLLATE utf8_unicode_ci COMMENT 'List of parameters to the command.', - `is_active` tinyint(4) DEFAULT NULL COMMENT 'Is this job active?', - PRIMARY KEY (`id`), - KEY `FK_civicrm_job_domain_id` (`domain_id`), - CONSTRAINT `FK_civicrm_job_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - -CREATE TABLE `civicrm_job_log` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Job log entry Id', - `domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this scheduled job for', - `run_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Log entry date', - `job_id` int(10) unsigned DEFAULT NULL COMMENT 'Pointer to job id - not a FK though, just for logging purposes', - `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Title of the job', - `command` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Full path to file containing job script', - `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Title line of log entry', - `data` text COLLATE utf8_unicode_ci COMMENT 'Potential extended data for specific job run (e.g. tracebacks).', - PRIMARY KEY (`id`), - KEY `FK_civicrm_job_log_domain_id` (`domain_id`), - CONSTRAINT `FK_civicrm_job_log_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - -INSERT INTO `civicrm_job` - ( domain_id, run_frequency, last_run, name, description, api_prefix, api_entity, api_action, parameters, is_active ) -VALUES - ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Mailings scheduler{/ts}', '{ts escape="sql" skip="true"}Sends out scheduled mailings{/ts}', 'civicrm_api3', 'job', 'process_mailing', 'user=USERNAME\r\npassword=PASSWORD\r\nkey=SITE_KEY', 0), - ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Bounces fetcher{/ts}', '{ts escape="sql" skip="true"}Fetches bounces from mailings and writes them to mailing statistics{/ts}', 'civicrm_api3', 'job', 'fetch_bounces', 'user=USERNAME\r\npassword=PASSWORD\r\nkey=SITE_KEY', 0), - ( @domainID, 'Hourly' , NULL, '{ts escape="sql" skip="true"}Activity processor{/ts}', '{ts escape="sql" skip="true"}{/ts}', 'civicrm_api3', 'job', 'fetch_activities', 'user=USERNAME\r\npassword=PASSWORD\r\nkey=SITE_KEY', 0), - ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Pledge record processor{/ts}', '{ts escape="sql" skip="true"}Updates pledge records and sends out reminders{/ts}', 'civicrm_api3', 'job', 'process_pledge', 'version=3\r\n', 0), - ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Address geocoder{/ts}', '{ts escape="sql" skip="true"}Goes through addresses and geocodes them (requires Geocoding API on){/ts}', 'civicrm_api3', 'job', 'geocode', 'version=3\r\n', 0), - ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Greeting updater{/ts}', '{ts escape="sql" skip="true"}Goes through contact records and updates greeting settings{/ts}', 'civicrm_api3', 'job', 'update_greeting', 'version=3\r\n', 0), - ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Report sender{/ts}', '{ts escape="sql" skip="true"}Generates and sends out reports via email{/ts}', 'civicrm_api3', 'job', 'mail_reports', 'version=3\r\n', 0), - ( @domainID, 'Daily' , NULL, '{ts escape="sql" skip="true"}Scheduled reminders sender{/ts}', '{ts escape="sql" skip="true"}Sends out scheduled reminders via email.{/ts}', 'civicrm_api3', 'job', 'send_reminder', 'version=3\r\n', 0), - ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Participant status processor{/ts}','{ts escape="sql" skip="true"}Adjusts event participant statuses based on time{/ts}', 'civicrm_api3', 'job', 'process_participant', 'version=3\r\n', 0), - ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Membership status processor{/ts}', '{ts escape="sql" skip="true"}Adjusts event membership statuses based on time{/ts}', 'civicrm_api3', 'job', 'process_membership', 'version=3\r\n', 0), - ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Membership reminder date processor{/ts}','{ts escape="sql" skip="true"}Adjusts membership reminder dates based on time{/ts}', 'civicrm_api3', 'job', 'process_process_membership_reminder_date', 'version=3\r\n', 0); - ---CRM 9135 -ALTER TABLE civicrm_contribution_recur - ADD is_email_receipt TINYINT (4) COMMENT 'if true, receipt is automatically emailed to contact on each successful payment' AFTER payment_processor_id; - --- /***** Civicrm Multi-Event Registration ***********/ - -CREATE TABLE civicrm_event_carts ( - id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cart Id', - user_id int unsigned COMMENT 'FK to civicrm_contact who created this cart', - coupon_code varchar(255) DEFAULT NULL, - completed tinyint DEFAULT 0, - PRIMARY KEY ( id ), - CONSTRAINT FK_civicrm_event_carts_user_id FOREIGN KEY (user_id) -REFERENCES civicrm_contact(id) ON DELETE SET NULL -) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; - -CREATE TABLE civicrm_events_in_carts ( - id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event In Cart Id', - event_id int unsigned COMMENT 'FK to Event ID', - event_cart_id int unsigned COMMENT 'FK to Event Cart ID', - PRIMARY KEY ( id ), - CONSTRAINT FK_civicrm_events_in_carts_event_id FOREIGN KEY (event_id) -REFERENCES civicrm_event(id) ON DELETE CASCADE, - CONSTRAINT FK_civicrm_events_in_carts_event_cart_id FOREIGN KEY -(event_cart_id) REFERENCES civicrm_event_carts(id) ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; - - -ALTER TABLE civicrm_participant - ADD discount_amount int unsigned DEFAULT 0 COMMENT 'Discount Amount'; -ALTER TABLE civicrm_participant - ADD cart_id int unsigned DEFAULT NULL COMMENT 'FK to civicrm_event_carts'; -ALTER TABLE civicrm_participant - ADD CONSTRAINT FK_civicrm_participant_cart_id FOREIGN KEY (cart_id) - REFERENCES civicrm_event_carts(id) ON DELETE SET NULL; - --- XXX a hint to the payment form. Can someone make this go away? -ALTER TABLE civicrm_participant - ADD must_wait TINYINT DEFAULT 0 COMMENT 'On Waiting List'; - - -SELECT @pending_id := MAX(id) + 1 FROM civicrm_participant_status_type; -INSERT INTO civicrm_participant_status_type - (id, name, {localize field='label'}label{/localize}, class, is_reserved, is_active, is_counted, weight, visibility_id) -VALUES - (@pending_id, 'Pending in cart', {localize}'{ts escape="sql"}Pending in cart{/ts}'{/localize}, 'Pending', 1, 1, 0, @pending_id, 2 ); - - -ALTER TABLE civicrm_event - ADD parent_event_id int unsigned DEFAULT NULL COMMENT 'Implicit FK to civicrm_event: parent event'; -ALTER TABLE civicrm_event - ADD slot_label_id int unsigned DEFAULT NULL COMMENT 'Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.'; - -INSERT INTO - `civicrm_option_group` (`name`, {localize field='label'}`label`{/localize}, {localize field='description'}`description`{/localize}, `is_reserved`, `is_active`) -VALUES - ('conference_slot' , {localize}'{ts escape="sql"}Conference Slot{/ts}'{/localize}, {localize}'{ts escape="sql"}Conference Slot{/ts}'{/localize} , 1, 1); - -SELECT @option_group_id_conference_slot := max(id) from civicrm_option_group where name = 'conference_slot'; - -INSERT INTO - `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, {localize field='description'}`description`{/localize}, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) -VALUES - (@option_group_id_conference_slot, {localize}'{ts escape="sql"}Morning Sessions{/ts}'{/localize}, 1, '{ts escape="sql"}Morning Sessions{/ts}', NULL, 0, NULL, 1, {localize}'{ts escape="sql"}NULL{/ts}'{/localize}, 0, 0, 1, NULL, NULL), - (@option_group_id_conference_slot, {localize}'{ts escape="sql"}Evening Sessions{/ts}'{/localize}, 2, '{ts escape="sql"}Evening Sessions{/ts}', NULL, 0, NULL, 2, {localize}'{ts escape="sql"}NULL{/ts}'{/localize}, 0, 0, 1, NULL, NULL); - -SELECT @msg_tpl_workflow_event := MAX(id) FROM civicrm_option_group WHERE name = 'msg_tpl_workflow_event'; -SELECT @weight := MAX(weight) + 1 FROM civicrm_option_value WHERE option_group_id = @msg_tpl_workflow_event; - -INSERT INTO civicrm_option_value - (option_group_id, name, {localize field='label'}label{/localize}, value, weight) -VALUES - (@msg_tpl_workflow_event, 'event_registration_receipt', {localize}'{ts escape="sql"}Events - Receipt only{/ts}'{/localize}, @weight, @weight); - -{* SELECT @tpl_ovid_$vName := MAX(id) FROM civicrm_option_value WHERE option_group_id = @tpl_ogid_$gName AND name = '$vName'; *} -{* INSERT INTO civicrm_msg_template *} - --- CRM-8532 -UPDATE `civicrm_dashboard` SET url = REPLACE( url, 'snippet=4', 'snippet=5' ), fullscreen_url = REPLACE( fullscreen_url, 'snippet=4', 'snippet=5' ); - -{if $multilingual} - {foreach from=$locales item=locale} - ALTER TABLE civicrm_option_group CHANGE label_{$locale} title_{$locale} varchar(255); - {/foreach} -{else} - ALTER TABLE civicrm_option_group CHANGE label title varchar(255); -{/if} diff --git a/CRM/Upgrade/Incremental/sql/4.1.alpha2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.alpha2.mysql.tpl deleted file mode 100644 index e840272121..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.alpha2.mysql.tpl +++ /dev/null @@ -1,12 +0,0 @@ --- CRM-8356 added missing option values -SELECT @option_group_id_acConRef := max(id) from civicrm_option_group where name = 'contact_reference_options'; - -INSERT INTO civicrm_option_value - (option_group_id, {localize field='label'}label{/localize}, value, name, filter, weight, is_active ) -VALUES - (@option_group_id_acConRef, {localize}'{ts escape="sql"}Email Address{/ts}'{/localize} , 2, 'email' , 0, 2, 1 ), - (@option_group_id_acConRef, {localize}'{ts escape="sql"}Phone{/ts}'{/localize} , 3, 'phone' , 0, 3, 1 ), - (@option_group_id_acConRef, {localize}'{ts escape="sql"}Street Address{/ts}'{/localize} , 4, 'street_address', 0, 4, 1 ), - (@option_group_id_acConRef, {localize}'{ts escape="sql"}City{/ts}'{/localize} , 5, 'city' , 0, 5, 1 ), - (@option_group_id_acConRef, {localize}'{ts escape="sql"}State/Province{/ts}'{/localize} , 6, 'state_province', 0, 6, 1 ), - (@option_group_id_acConRef, {localize}'{ts escape="sql"}Country{/ts}'{/localize} , 7, 'country' , 0, 7, 1 ); diff --git a/CRM/Upgrade/Incremental/sql/4.1.beta1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.beta1.mysql.tpl deleted file mode 100644 index adfd46fe6c..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.beta1.mysql.tpl +++ /dev/null @@ -1,11 +0,0 @@ -{if $addWightForActivity} - ALTER TABLE `civicrm_activity` ADD weight INT( 11 ) NULL DEFAULT NULL; -{/if} - --- CRM-8508 -SELECT @option_group_id_cgeo := max(id) from civicrm_option_group where name = 'cg_extend_objects'; - -INSERT INTO civicrm_option_value - (option_group_id, {localize field='label'}label{/localize}, value, name, grouping, filter, is_default, weight, {localize field='description'}description{/localize}, is_optgroup, is_reserved, is_active, component_id, visibility_id) -VALUES - (@option_group_id_cgeo, {localize}'{ts escape="sql"}Cases{/ts}'{/localize}, 'Case', 'civicrm_case', NULL, 0, NULL, 2, {localize}'CRM_Case_PseudoConstant::caseType;'{/localize}, 0, 0, 1, NULL, NULL); diff --git a/CRM/Upgrade/Incremental/sql/4.1.beta2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.beta2.mysql.tpl deleted file mode 100644 index 375b4443e2..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.beta2.mysql.tpl +++ /dev/null @@ -1,119 +0,0 @@ --- CRM-9384 Add sample CiviMail Newsletter Message Template -INSERT INTO civicrm_msg_template - (msg_title, msg_subject, msg_text, msg_html, workflow_id, is_default, is_reserved) - VALUES - ('Sample CiviMail Newsletter Template', 'Sample CiviMail Newsletter', '', ' - - - - - - - - - - - - - - - -
- - - - - - -
- Replace this logo with the URL to your own -     - Your Newsletter Title -
-
- - - - - -
- - Greetings {literal}{contact.display_name}{/literal}, -

- This is a sample template designed to help you get started creating and sending your own CiviMail messages. This template uses an HTML layout that is generally compatible with the wide variety of email clients that your recipients might be using (e.g. Gmail, Outlook, Yahoo, etc.). -

You can select this "Sample CiviMail Newsletter Template" from the "Use Template" drop-down in Step 3 of creating a mailing, and customize it to your needs. Then check the "Save as New Template" box on the bottom the page to save your customized version for use in future mailings. -

The logo you use must be uploaded to your server. Copy and paste the URL path to the logo into the <img src= tag in the HTML at the top. Click "Source" or the Image button if you are using the text editor. -

- Edit the color of the links and headers using the color button or by editing the HTML. -

- Your newsletter message and donation appeal can go here. Click the link button to create links - remember to use a fully qualified URL starting with http:// in all your links! -

- To use CiviMail: - - Sincerely, -

- Your Team - -
- 		- - - - - -
- - Featured Events
- Fundraising Dinner
- Training Meeting
- Board of Directors Annual Meeting
- -

- Community Events
- Bake Sale
- Charity Auction
- Art Exhibit
- -

- Important Dates
- Tuesday August 27
- Wednesday September 8
- Thursday September 29
- Saturday October 1
- Sunday October 20
- -
-
- - - - -
- - Helpful Tips -

- Tokens
- Click "Insert Tokens" to dynamically insert names, addresses, and other contact data of your recipients. -

- Plain Text Version
- Some people refuse HTML emails altogether. We recommend sending a plain-text version of your important communications to accommodate them. Luckily, CiviCRM accommodates for this! Just click "Plain Text" and copy and paste in some text. Line breaks (carriage returns) and fully qualified URLs like http://www.example.com are all you get, no HTML here! -

- Play by the Rules
- The address of the sender is required by the Can Spam Act law. This is an available token called domain.address. An unsubscribe or opt-out link is also required. There are several available tokens for this. {literal}{action.optOutUrl}{/literal} creates a link for recipients to click if they want to opt out of receiving emails from your organization. {literal}{action.unsubscribeUrl}{/literal} creates a link to unsubscribe from the specific mailing list used to send this message. Click on "Insert Tokens" to find these and look for tokens named "Domain" or "Unsubscribe". This sample template includes both required tokens at the bottom of the message. You can also configure a default Mailing Footer containing these tokens. -

- Composing Offline
- If you prefer to compose an HTML email offline in your own text editor, you can upload this HTML content into CiviMail or simply click "Source" and then copy and paste the HTML in. -

- Images
- Most email clients these days (Outlook, Gmail, etc) block image loading by default. This is to protect their users from annoying or harmful email. Not much we can do about this, so encourage recipients to add you to their contacts or "whitelist". Also use images sparingly, do not rely on images to convey vital information, and always use HTML "alt" tags which describe the image content. -
-
- -
- Click here to unsubscribe from this mailing list.

- Our mailing address is:
- {literal}{domain.address}{/literal} -
', NULL, 1, 0); diff --git a/CRM/Upgrade/Incremental/sql/4.1.beta3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.1.beta3.mysql.tpl deleted file mode 100644 index fd8414b295..0000000000 --- a/CRM/Upgrade/Incremental/sql/4.1.beta3.mysql.tpl +++ /dev/null @@ -1,33 +0,0 @@ --- Fix invalid api actions in Job table and insert missing job -UPDATE `civicrm_job` -SET api_action = 'process_membership_reminder_date' WHERE api_action = 'process_process_membership_reminder_date'; -UPDATE `civicrm_job` -SET api_action = 'mail_report' WHERE api_action = 'mail_reports'; - -SELECT @domainID := min(id) FROM civicrm_domain; -INSERT INTO `civicrm_job` - ( domain_id, run_frequency, last_run, name, description, api_prefix, api_entity, api_action, parameters, is_active ) -VALUES - ( @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}','civicrm_api3', 'job', 'process_respondent','version=3\r\n', 0); - --- Job table was initially delivered with invalid and not-used parameters. Clearing them out. Most jobs do not need any parameters. -UPDATE `civicrm_job` -SET parameters = NULL; - --- Insert Schedule Jobs admin menu item -SELECT @systemSettingsID := id FROM civicrm_navigation where name = 'System Settings' AND domain_id = @domainID; - -INSERT INTO civicrm_navigation - ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -VALUES - ( @domainID, 'civicrm/admin/job&reset=1', '{ts escape="sql" skip="true"}Scheduled Jobs{/ts}', 'Scheduled Jobs', 'administer CiviCRM', '', @systemSettingsID, '1', NULL, 15 ); - --- CRM-9468 --- update Serbia/Montenegro provinces -UPDATE civicrm_state_province SET country_id = 1243 WHERE id = 5112; -UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5113; -UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5114; -UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5115; - --- CRM-9523 -ALTER TABLE `civicrm_note` MODIFY `privacy` VARCHAR(255) COMMENT 'Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)'; diff --git a/Civi/Core/SettingsBag.php b/Civi/Core/SettingsBag.php index 595ce92a9d..f56ac97634 100644 --- a/Civi/Core/SettingsBag.php +++ b/Civi/Core/SettingsBag.php @@ -326,11 +326,6 @@ class SettingsBag { * The new value of the setting. */ protected function setDb($name, $value) { - if (\CRM_Core_BAO_Setting::isUpgradeFromPreFourOneAlpha1()) { - // civicrm_setting table is not going to be present. - return; - } - $fields = array(); $fieldsToSet = \CRM_Core_BAO_Setting::validateSettingsInput(array($name => $value), $fields); //We haven't traditionally validated inputs to setItem, so this breaks things. -- 2.25.1