3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License along with this program; if not, contact CiviCRM LLC |
21 | at info[AT]civicrm[DOT]org. If you have questions about the |
22 | GNU Affero General Public License or the licensing of CiviCRM, |
23 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
24 +--------------------------------------------------------------------+
28 * Upgrade logic for 4.7
30 class CRM_Upgrade_Incremental_php_FourSeven
extends CRM_Upgrade_Incremental_Base
{
33 * Compute any messages which should be displayed beforeupgrade.
35 * Note: This function is called iteratively for each upcoming
36 * revision to the database.
38 * @param string $preUpgradeMessage
40 * a version number, e.g. '4.4.alpha1', '4.4.beta3', '4.4.0'.
41 * @param null $currentVer
43 public function setPreUpgradeMessage(&$preUpgradeMessage, $rev, $currentVer = NULL) {
44 if ($rev == '4.7.alpha1') {
45 // CRM-16478 Remove custom fatal error template path option
46 $config = CRM_Core_Config
::singleton();
47 if (!empty($config->fatalErrorTemplate
) && $config->fatalErrorTemplate
!= 'CRM/common/fatal.tpl') {
48 $preUpgradeMessage .= '<p>' . ts('The custom fatal error template setting will be removed during the upgrade. You are currently using this custom template: %1 . Following the upgrade you will need to use the standard approach to overriding template files, as described in the documentation.', array(1 => $config->fatalErrorTemplate
)) . '</p>';
51 if ($rev == '4.7.alpha4') {
52 // CRM-17004 Warn of Moneris removal
54 // Query only works in 4.3+
55 if (version_compare($currentVer, "4.3.0") > 0) {
56 $count = CRM_Core_DAO
::singleValueQuery("SELECT COUNT(id) FROM civicrm_payment_processor WHERE payment_processor_type_id IN (SELECT id FROM civicrm_payment_processor_type WHERE name = 'Moneris')");
58 if ($count && !function_exists('moneris_civicrm_managed')) {
59 $preUpgradeMessage .= '<p>' . ts('The %1 payment processor is no longer bundled with CiviCRM. After upgrading you will need to install the extension to continue using it.', array(1 => 'Moneris')) . '</p>';
65 * Compute any messages which should be displayed after upgrade.
67 * @param string $postUpgradeMessage
70 * an intermediate version; note that setPostUpgradeMessage is called repeatedly with different $revs.
72 public function setPostUpgradeMessage(&$postUpgradeMessage, $rev) {
73 if ($rev == '4.7.alpha1') {
74 $config = CRM_Core_Config
::singleton();
75 // FIXME: Performing an upgrade step during postUpgrade message phase is probably bad
76 $editor_id = self
::updateWysiwyg();
78 $ext_href = 'href="' . CRM_Utils_System
::url('civicrm/admin/extensions', 'reset=1') . '"';
79 $dsp_href = 'href="' . CRM_Utils_System
::url('civicrm/admin/setting/preferences/display', 'reset=1') . '"';
80 $blog_href = 'href="https://civicrm.org/blogs/colemanw/big-changes-wysiwyg-editing-47"';
84 $msg = ts('Your configured editor "TinyMCE" is no longer part of the main CiviCRM download. To continue using it, visit the <a %1>Manage Extensions</a> page to download and install the TinyMCE extension.', array(1 => $ext_href));
87 // Drupal/Joomla editor
90 $msg = ts('CiviCRM no longer integrates with the "%1 Default Editor." Your wysiwyg setting has been reset to the built-in CKEditor. <a %2>Learn more...</a>', array(1 => $config->userFramework
, 2 => $blog_href));
94 $postUpgradeMessage .= '<p>' . $msg . '</p>';
96 $postUpgradeMessage .= '<p>' . ts('CiviCRM now includes the easy-to-use CKEditor Configurator. To customize the features and display of your wysiwyg editor, visit the <a %1>Display Preferences</a> page. <a %2>Learn more...</a>', array(1 => $dsp_href, 2 => $blog_href)) . '</p>';
98 $postUpgradeMessage .= '<br /><br />' . ts('Default version of the following System Workflow Message Templates have been modified: <ul><li>Personal Campaign Pages - Owner Notification</li></ul> If you have modified these templates, please review the new default versions and implement updates as needed to your copies (Administer > Communications > Message Templates > System Workflow Messages).');
100 $postUpgradeMessage .= '<p>' . ts('The custom fatal error template setting has been removed.') . '</p>';
109 public function upgrade_4_7_alpha1($rev) {
110 $this->addTask('Migrate \'on behalf of\' information to module_data', 'migrateOnBehalfOfInfo');
111 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
112 $this->addTask(ts('Migrate Settings to %1', array(1 => $rev)), 'migrateSettings', $rev);
113 $this->addTask('Add Getting Started dashlet', 'addGettingStartedDashlet', $rev);
121 public function upgrade_4_7_alpha4($rev) {
122 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
123 $this->addTask(ts('Remove %1', array(1 => 'Moneris')), 'removePaymentProcessorType', 'Moneris');
124 $this->addTask('Update Smart Groups', 'fixContactTypeInSmartGroups');
132 public function upgrade_4_7_beta2($rev) {
133 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
134 $this->addTask('Delete unused file', 'deleteVersionCheckCacheFile');
142 public function upgrade_4_7_beta6($rev) {
143 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
144 $this->addTask('Disable flexible jobs extension', 'disableFlexibleJobsExtension');
145 $this->addTask('Add Index to financial_trxn trxn_id field', 'addIndexFinancialTrxnTrxnID');
153 public function upgrade_4_7_1($rev) {
154 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
155 $this->addTask('Add Index to civicrm_contribution creditnote_id field', 'addIndexContributionCreditNoteID');
163 public function upgrade_4_7_2($rev) {
164 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
165 $this->addTask('Fix Index on civicrm_financial_item combined entity_id + entity_table', 'addCombinedIndexFinancialItemEntityIDEntityType');
166 $this->addTask('enable financial account relationships for chargeback & refund', 'addRefundAndChargeBackAccountsIfNotExist');
167 $this->addTask('Add Index to civicrm_contribution.source', 'addIndexContributionSource');
175 public function upgrade_4_7_3($rev) {
176 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
177 $this->addTask('Add Index to civicrm_contribution.total_amount', 'addIndexContributionAmount');
185 public function upgrade_4_7_4($rev) {
186 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
187 $this->addTask('Add Contact Deleted by Merge Activity Type', 'addDeletedByMergeActivityType');
195 public function upgrade_4_7_7($rev) {
196 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
197 // https://issues.civicrm.org/jira/browse/CRM-18006
198 if (CRM_Core_DAO
::checkTableExists('civicrm_install_canary')) {
199 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_install_canary ENGINE=InnoDB');
208 public function upgrade_4_7_8($rev) {
209 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
210 $this->addTask('Upgrade mailing foreign key constraints', 'upgradeMailingFKs');
218 public function upgrade_4_7_10($rev) {
219 $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
220 $this->addTask(ts('Upgrade Add Help Pre and Post Fields to price value table'), 'addHelpPreAndHelpPostFieldsPriceFieldValue');
221 $this->addTask(ts('Alter index and type for image URL'), 'alterIndexAndTypeForImageURL');
225 * Important! All upgrade functions MUST call the 'runSql' task.
226 * Uncomment and use the following template for a new upgrade version
227 * (change the x in the function name):
231 // * Upgrade function.
233 // * @param string $rev
235 // public function upgrade_4_7_x($rev) {
236 // $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
237 // // Additional tasks here...
245 public static function updateWysiwyg() {
246 $editorID = Civi
::settings()->get('editor_id');
247 // Previously a numeric value indicated one of 4 wysiwyg editors shipped in core, and no value indicated 'Textarea'
248 // Now the options are "Textarea", "CKEditor", and the rest have been dropped from core.
249 $newEditor = $editorID ?
"CKEditor" : "Textarea";
250 Civi
::settings()->set('editor_id', $newEditor);
256 * Migrate any last remaining options from `civicrm_domain.config_backend` to `civicrm_setting`.
257 * Cleanup setting schema.
259 * @param CRM_Queue_TaskContext $ctx
262 public function migrateSettings(CRM_Queue_TaskContext
$ctx) {
263 // Tip: If there are problems with adding the new uniqueness index, try inspecting:
264 // SELECT name, domain_id, contact_id, count(*) AS dupes FROM civicrm_setting cs GROUP BY name, domain_id, contact_id HAVING dupes > 1;
266 // Nav records are expendable. https://forum.civicrm.org/index.php?topic=36933.0
267 CRM_Core_DAO
::executeQuery('DELETE FROM civicrm_setting WHERE contact_id IS NOT NULL AND name = "navigation"');
269 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_setting DROP INDEX index_group_name');
270 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_setting DROP COLUMN group_name');
272 // Handle Strange activity_tab_filter settings.
273 CRM_Core_DAO
::executeQuery('CREATE TABLE civicrm_activity_setting LIKE civicrm_setting');
274 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_activity_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name)');
275 CRM_Core_DAO
::executeQuery('INSERT INTO civicrm_activity_setting (name, contact_id, domain_id, value)
276 SELECT DISTINCT name, contact_id, domain_id, value
278 WHERE name = "activity_tab_filter"
279 AND value is not NULL');
280 CRM_Core_DAO
::executeQuery('DELETE FROM civicrm_setting WHERE name = "activity_tab_filter"');
282 $date = CRM_Utils_Time
::getTime('Y-m-d H:i:s');
283 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name)');
284 CRM_Core_DAO
::executeQuery("INSERT INTO civicrm_setting (name, contact_id, domain_id, value, is_domain, created_id, created_date)
285 SELECT name, contact_id, domain_id, value, 0, contact_id,'$date'
286 FROM civicrm_activity_setting
287 WHERE name = 'activity_tab_filter'
288 AND value is not NULL"
290 CRM_Core_DAO
::executeQuery('DROP TABLE civicrm_activity_setting');
292 $domainDao = CRM_Core_DAO
::executeQuery('SELECT id, config_backend FROM civicrm_domain');
293 while ($domainDao->fetch()) {
294 $settings = CRM_Upgrade_Incremental_php_FourSeven
::convertBackendToSettings($domainDao->id
, $domainDao->config_backend
);
295 CRM_Core_Error
::debug_var('convertBackendToSettings', array(
296 'domainId' => $domainDao->id
,
297 'backend' => $domainDao->config_backend
,
298 'settings' => $settings,
301 foreach ($settings as $name => $value) {
303 1 => array($domainDao->id
, 'Positive'),
304 2 => array($name, 'String'),
305 3 => array(serialize($value), 'String'),
307 $settingId = CRM_Core_DAO
::singleValueQuery(
308 'SELECT id FROM civicrm_setting WHERE domain_id = %1 AND name = %2',
311 CRM_Core_DAO
::executeQuery(
312 'INSERT INTO civicrm_setting (domain_id, name, value, is_domain) VALUES (%1,%2,%3,1)',
318 CRM_Core_DAO
::executeQuery('ALTER TABLE civicrm_domain DROP COLUMN config_backend');
324 * Take a config_backend blob and produce an equivalent list of settings.
326 * @param int $domainId
328 * @param string $config_backend
332 public static function convertBackendToSettings($domainId, $config_backend) {
333 if (!$config_backend) {
337 $backend = unserialize($config_backend);
342 $mappings = \CRM_Core_Config_MagicMerge
::getPropertyMap();
344 foreach ($backend as $propertyName => $propertyValue) {
345 if (isset($mappings[$propertyName][0]) && preg_match('/^setting/', $mappings[$propertyName][0])) {
346 // $mapping format: $propertyName => Array(0 => $type, 1 => $setting|NULL).
347 $settingName = isset($mappings[$propertyName][1]) ?
$mappings[$propertyName][1] : $propertyName;
348 $settings[$settingName] = $propertyValue;
356 * Add Getting Started dashlet to dashboard
358 * @param \CRM_Queue_TaskContext $ctx
362 public function addGettingStartedDashlet(CRM_Queue_TaskContext
$ctx) {
363 $sql = "SELECT count(*) FROM civicrm_dashboard WHERE name='getting-started'";
364 $res = CRM_Core_DAO
::singleValueQuery($sql);
365 $domainId = CRM_Core_Config
::domainID();
367 $sql = "INSERT INTO `civicrm_dashboard`
368 ( `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `is_active`, `weight`, `fullscreen_url`, `is_fullscreen`, `is_reserved`) VALUES ( {$domainId}, 'getting-started', 'Getting Started', 'civicrm/dashlet/getting-started?reset=1&snippet=5', 'access CiviCRM', NULL, 0, 0, 1, 0, 'civicrm/dashlet/getting-started?reset=1&snippet=5&context=dashletFullscreen', 1, 1)";
369 CRM_Core_DAO
::executeQuery($sql);
370 // Add default position for Getting Started Dashlet ( left column)
371 $sql = "INSERT INTO `civicrm_dashboard_contact` (dashboard_id, contact_id, column_no, is_active)
372 SELECT (SELECT MAX(id) FROM `civicrm_dashboard`), contact_id, 0, IF (SUM(is_active) > 0, 1, 0)
373 FROM `civicrm_dashboard_contact` JOIN `civicrm_contact` WHERE civicrm_dashboard_contact.contact_id = civicrm_contact.id GROUP BY contact_id";
374 CRM_Core_DAO
::executeQuery($sql);
380 * Migrate on-behalf information to uf_join.module_data as on-behalf columns will be dropped
383 * @param CRM_Queue_TaskContext $ctx
388 public static function migrateOnBehalfOfInfo(CRM_Queue_TaskContext
$ctx) {
389 $domain = new CRM_Core_DAO_Domain();
392 // fetch onBehalf entry in UFJoin table
393 $ufGroupDAO = new CRM_Core_DAO_UFJoin();
394 $ufGroupDAO->module
= 'OnBehalf';
395 $ufGroupDAO->find(TRUE);
397 $forOrgColums = array();
398 if ($domain->locales
) {
399 $locales = explode(CRM_Core_DAO
::VALUE_SEPARATOR
, $domain->locales
);
400 foreach ($locales as $locale) {
401 $forOrgColums[] = "for_organization_{$locale}";
405 $forOrgColums[] = "for_organization";
409 SELECT " . implode(", ", $forOrgColums) . ", uj.id as join_id, uj.uf_group_id as uf_group_id
410 FROM civicrm_contribution_page cp
411 INNER JOIN civicrm_uf_join uj ON uj.entity_id = cp.id AND uj.module = 'OnBehalf'";
412 $dao = CRM_Core_DAO
::executeQuery($query, array(), TRUE, NULL, FALSE, FALSE);
415 while ($dao->fetch()) {
416 $onBehalfParams['on_behalf'] = array('is_for_organization' => $dao->is_for_organization
);
417 if ($domain->locales
) {
418 foreach ($locales as $locale) {
419 $for_organization = "for_organization_{$locale}";
420 $onBehalfParams['on_behalf'] +
= array(
422 'for_organization' => $dao->$for_organization,
428 $onBehalfParams['on_behalf'] +
= array(
430 'for_organization' => $dao->for_organization
,
434 $ufJoinParam = array(
435 'id' => $dao->join_id
,
436 'module' => 'on_behalf',
437 'uf_group_id' => $dao->uf_group_id
,
438 'module_data' => json_encode($onBehalfParams),
440 CRM_Core_BAO_UFJoin
::create($ufJoinParam);
448 * CRM-11782 - Get rid of VALUE_SEPARATOR character in saved search form values
450 * @param \CRM_Queue_TaskContext $ctx
454 public function fixContactTypeInSmartGroups(CRM_Queue_TaskContext
$ctx) {
455 $sep = CRM_Core_DAO
::VALUE_SEPARATOR
;
456 $dao = CRM_Core_DAO
::executeQuery("SELECT id, form_values FROM civicrm_saved_search WHERE form_values LIKE '%$sep%'");
457 while ($dao->fetch()) {
458 $formValues = unserialize($dao->form_values
);
459 if (isset($formValues['contact_type']) && is_array($formValues['contact_type'])) {
461 foreach ($formValues['contact_type'] as $key => $val) {
462 $newVals[str_replace($sep, '__', $key)] = is_string($val) ?
str_replace($sep, '__', $val) : $val;
464 $formValues['contact_type'] = $newVals;
466 CRM_Core_DAO
::executeQuery("UPDATE civicrm_saved_search SET form_values = %1 WHERE id = {$dao->id}", array(1 => array(serialize($formValues), 'String')));
473 * CRM-17637 - Ths file location has been moved; delete the old one
475 * @param \CRM_Queue_TaskContext $ctx
479 public function deleteVersionCheckCacheFile(CRM_Queue_TaskContext
$ctx) {
480 $config = CRM_Core_Config
::singleton();
481 $cacheFile = $config->uploadDir
. 'version-info-cache.json';
482 if (file_exists($cacheFile)) {
489 * CRM-17669 and CRM-17686, make scheduled jobs more flexible, disable the 4.6 extension if installed
491 * @param \CRM_Queue_TaskContext $ctx
495 public function disableFlexibleJobsExtension(CRM_Queue_TaskContext
$ctx) {
497 civicrm_api3('Extension', 'disable', array('key' => 'com.klangsoft.flexiblejobs'));
499 catch (CiviCRM_API3_Exception
$e) {
500 // just ignore if the extension isn't installed
507 * CRM-17752 add index to civicrm_financial_trxn.trxn_id (deliberately non-unique).
509 * @param \CRM_Queue_TaskContext $ctx
513 public function addIndexFinancialTrxnTrxnID(CRM_Queue_TaskContext
$ctx) {
514 $tables = array('civicrm_financial_trxn' => array('trxn_id'));
515 CRM_Core_BAO_SchemaHandler
::createIndexes($tables);
520 * CRM-17882 Add index to civicrm_contribution.credit_note_id.
522 * @param \CRM_Queue_TaskContext $ctx
526 public function addIndexContributionCreditNoteID(CRM_Queue_TaskContext
$ctx) {
527 $tables = array('civicrm_contribution' => array('creditnote_id'));
528 CRM_Core_BAO_SchemaHandler
::createIndexes($tables);
533 * CRM-17775 Add correct index for table civicrm_financial_item.
535 * Note that the entity ID should always precede the entity_table as
536 * it is more unique. This is better for performance and does not cause fallback
537 * to no index if table it omitted.
541 public function addCombinedIndexFinancialItemEntityIDEntityType() {
542 CRM_Core_BAO_SchemaHandler
::dropIndexIfExists('civicrm_financial_item', 'UI_id');
543 CRM_Core_BAO_SchemaHandler
::dropIndexIfExists('civicrm_financial_item', 'IX_Entity');
544 CRM_Core_BAO_SchemaHandler
::createIndexes(array(
545 'civicrm_financial_item' => array(array('entity_id', 'entity_table')),
551 * CRM-17951 Add accounts option values for refund and chargeback.
553 * Add Chargeback contribution status and Chargeback and Contra account relationships,
554 * checking first if one exists.
556 public function addRefundAndChargeBackAccountsIfNotExist() {
557 // First we enable and edit the record for Credit contra - this exists but is disabled for most sites.
558 // Using the ensure function (below) will not enabled a disabled option (by design).
559 CRM_Core_DAO
::executeQuery("UPDATE civicrm_option_value v
560 INNER JOIN civicrm_option_group g on v.option_group_id=g.id and g.name='account_relationship'
561 SET v.is_active=1, v.label='Credit/Contra Revenue Account is', v.name='Credit/Contra Revenue Account is', v.description='Credit/Contra Revenue Account is'
562 WHERE v.name = 'Credit/Contra Account is';");
564 CRM_Core_BAO_OptionValue
::ensureOptionValueExists(array(
565 'option_group_id' => 'account_relationship',
566 'name' => 'Chargeback Account is',
567 'label' => ts('Chargeback Account is'),
569 'component_id' => 'CiviContribute',
572 CRM_Core_BAO_OptionValue
::ensureOptionValueExists(array(
573 'option_group_id' => 'contribution_status',
574 'name' => 'Chargeback',
575 'label' => ts('Chargeback'),
577 'component_id' => 'CiviContribute',
583 * CRM-17999 Add index to civicrm_contribution.source.
585 * @param \CRM_Queue_TaskContext $ctx
589 public function addIndexContributionSource(CRM_Queue_TaskContext
$ctx) {
590 CRM_Core_BAO_SchemaHandler
::createIndexes(array('civicrm_contribution' => array('source')));
595 * CRM-18124 Add index to civicrm_contribution.total_amount.
597 * Note that I made this a combined index with receive_date because the issue included
598 * both criteria and they seemed likely to be used in conjunction to me in other cases.
600 * @param \CRM_Queue_TaskContext $ctx
604 public function addIndexContributionAmount(CRM_Queue_TaskContext
$ctx) {
605 CRM_Core_BAO_SchemaHandler
::createIndexes(array(
606 'civicrm_contribution' => array(array('total_amount', 'receive_date')),
612 * CRM-18124 Add index to civicrm_contribution.total_amount.
614 * Note that I made this a combined index with receive_date because the issue included
615 * both criteria and they seemed likely to be used in conjunction to me in other cases.
617 * @param \CRM_Queue_TaskContext $ctx
621 public function addDeletedByMergeActivityType(CRM_Queue_TaskContext
$ctx) {
622 CRM_Core_BAO_OptionValue
::ensureOptionValueExists(array(
623 'option_group_id' => 'activity_type',
624 'name' => 'Contact Deleted by Merge',
625 'label' => ts('Contact Deleted by Merge'),
626 'description' => ts('Contact was merged into another contact'),
634 * CRM-12252 Add Help Pre and Help Post Fields for Price Field Value Table.
636 * @param \CRM_Queue_TaskContext $ctx
640 public function addHelpPreAndHelpPostFieldsPriceFieldValue(CRM_Queue_TaskContext
$ctx) {
641 $domain = new CRM_Core_DAO_Domain();
643 if ($domain->locales
) {
644 $locales = explode(CRM_Core_DAO
::VALUE_SEPARATOR
, $domain->locales
);
645 foreach ($locales as $locale) {
646 if (!CRM_Core_BAO_SchemaHandler
::checkIfFieldExists("civicrm_price_field_value", "help_pre_{$locale}")) {
647 CRM_Core_DAO
::executeQuery("ALTER TABLE `civicrm_price_field_value`
648 ADD COLUMN `help_pre_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'", array(), TRUE, NULL, FALSE, FALSE);
650 if (!CRM_Core_BAO_SchemaHandler
::checkIfFieldExists("civicrm_price_field_value", "help_post_{$locale}")) {
651 CRM_Core_DAO
::executeQuery("ALTER TABLE `civicrm_price_field_value`
652 ADD COLUMN `help_post_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option post help text.'", array(), TRUE, NULL, FALSE, FALSE);
655 CRM_Core_I18n_Schema
::rebuildMultilingualSchema($locales, NULL);
658 if (!CRM_Core_BAO_SchemaHandler
::checkIfFieldExists('civicrm_price_field_value', 'help_pre')) {
659 CRM_Core_DAO
::executeQuery("ALTER TABLE `civicrm_price_field_value`
660 ADD COLUMN `help_pre` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'");
662 if (!CRM_Core_BAO_SchemaHandler
::checkIfFieldExists('civicrm_price_field_value', 'help_post')) {
663 CRM_Core_DAO
::executeQuery("ALTER TABLE `civicrm_price_field_value`
664 ADD COLUMN `help_post` text COLLATE utf8_unicode_ci COMMENT 'Price field option post help text.'");
671 * CRM-18345 Don't delete mailing data on email/phone deletion
672 * Implemented here in CRM-18526
674 * @param \CRM_Queue_TaskContext $ctx
678 public function upgradeMailingFKs(CRM_Queue_TaskContext
$ctx) {
680 // Safely drop the foreign keys
681 CRM_Core_BAO_SchemaHandler
::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_email_id');
682 CRM_Core_BAO_SchemaHandler
::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_phone_id');
683 CRM_Core_BAO_SchemaHandler
::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_email_id');
684 CRM_Core_BAO_SchemaHandler
::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_phone_id');
686 // Set up the new foreign keys
687 CRM_Core_DAO
::executeQuery("SET FOREIGN_KEY_CHECKS = 0;");
689 CRM_Core_DAO
::executeQuery("
690 ALTER TABLE `civicrm_mailing_event_queue`
691 ADD CONSTRAINT `FK_civicrm_mailing_event_queue_email_id`
692 FOREIGN KEY (`email_id`)
693 REFERENCES `civicrm_email`(`id`)
698 CRM_Core_DAO
::executeQuery("
699 ALTER TABLE `civicrm_mailing_event_queue`
700 ADD CONSTRAINT `FK_civicrm_mailing_event_queue_phone_id`
701 FOREIGN KEY (`phone_id`)
702 REFERENCES `civicrm_phone`(`id`)
707 CRM_Core_DAO
::executeQuery("
708 ALTER TABLE `civicrm_mailing_recipients`
709 ADD CONSTRAINT `FK_civicrm_mailing_recipients_email_id`
710 FOREIGN KEY (`email_id`)
711 REFERENCES `civicrm_email`(`id`)
716 CRM_Core_DAO
::executeQuery("
717 ALTER TABLE `civicrm_mailing_recipients`
718 ADD CONSTRAINT `FK_civicrm_mailing_recipients_phone_id`
719 FOREIGN KEY (`phone_id`)
720 REFERENCES `civicrm_phone`(`id`)
725 CRM_Core_DAO
::executeQuery("SET FOREIGN_KEY_CHECKS = 1;");
731 * CRM-19100 - Alter Index and Type for Image URL
734 public static function alterIndexAndTypeForImageURL() {
736 CRM_Core_BAO_SchemaHandler
::dropIndexIfExists('civicrm_contact', 'index_image_url');
737 CRM_Core_DAO
::executeQuery("ALTER TABLE `civicrm_contact` CHANGE `image_URL` `image_URL` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'optional URL for preferred image (photo, logo, etc.) to display for this contact.'");
739 $length['civicrm_contact']['image_URL'] = 128;
740 CRM_Core_BAO_SchemaHandler
::createIndexes(array('civicrm_contact' => array('image_URL')), 'index', $length);