$this->addTask('Upgrade mailing foreign key constraints', 'upgradeMailingFKs');
}
+ /**
+ * Upgrade function.
+ *
+ * @param string $rev
+ */
+ public function upgrade_4_7_10($rev) {
+ $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
+ $this->addTask(ts('Upgrade Add Help Pre and Post Fields to price value table'), 'addHelpPreAndHelpPostFieldsPriceFieldValue');
+ $this->addTask(ts('Alter index and type for image URL'), 'alterIndexAndTypeForImageURL');
+ }
+
+ /**
+ * Upgrade function.
+ *
+ * @param string $rev
+ */
+ public function upgrade_4_7_11($rev) {
+ $this->addTask(ts('Upgrade DB to %1: SQL', array(1 => $rev)), 'runSql', $rev);
+ $this->addTask('Dashboard schema updates', 'dashboardSchemaUpdate');
+ }
+
/*
* Important! All upgrade functions MUST call the 'runSql' task.
* Uncomment and use the following template for a new upgrade version
CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_setting DROP INDEX index_group_name');
CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_setting DROP COLUMN group_name');
+
+ // Handle Strange activity_tab_filter settings.
+ CRM_Core_DAO::executeQuery('CREATE TABLE civicrm_activity_setting LIKE civicrm_setting');
+ CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_activity_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name)');
+ CRM_Core_DAO::executeQuery('INSERT INTO civicrm_activity_setting (name, contact_id, domain_id, value)
+ SELECT DISTINCT name, contact_id, domain_id, value
+ FROM civicrm_setting
+ WHERE name = "activity_tab_filter"
+ AND value is not NULL');
+ CRM_Core_DAO::executeQuery('DELETE FROM civicrm_setting WHERE name = "activity_tab_filter"');
+
+ $date = CRM_Utils_Time::getTime('Y-m-d H:i:s');
CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name)');
+ CRM_Core_DAO::executeQuery("INSERT INTO civicrm_setting (name, contact_id, domain_id, value, is_domain, created_id, created_date)
+ SELECT name, contact_id, domain_id, value, 0, contact_id,'$date'
+ FROM civicrm_activity_setting
+ WHERE name = 'activity_tab_filter'
+ AND value is not NULL"
+ );
+ CRM_Core_DAO::executeQuery('DROP TABLE civicrm_activity_setting');
$domainDao = CRM_Core_DAO::executeQuery('SELECT id, config_backend FROM civicrm_domain');
while ($domainDao->fetch()) {
}
/**
- * Remove a foreign key from a table if it exists
+ * CRM-12252 Add Help Pre and Help Post Fields for Price Field Value Table.
+ *
+ * @param \CRM_Queue_TaskContext $ctx
*
- * @param $table_name
- * @param $constraint_name
+ * @return bool
*/
- public function safeRemoveFK($table_name, $constraint_name) {
-
- $config = CRM_Core_Config::singleton();
- $dbUf = DB::parseDSN($config->dsn);
- $query = "
- SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
- WHERE TABLE_SCHEMA = %1
- AND TABLE_NAME = %2
- AND CONSTRAINT_NAME = %3
- AND CONSTRAINT_TYPE = 'FOREIGN KEY'
- ";
- $params = array(
- 1 => array($dbUf['database'], 'String'),
- 2 => array($table_name, 'String'),
- 3 => array($constraint_name, 'String'),
- );
- $dao = CRM_Core_DAO::executeQuery($query, $params);
-
- if ($dao->fetch()) {
- CRM_Core_DAO::executeQuery("ALTER TABLE {$table_name} DROP FOREIGN KEY {$constraint_name}", array());
+ public function addHelpPreAndHelpPostFieldsPriceFieldValue(CRM_Queue_TaskContext $ctx) {
+ $domain = new CRM_Core_DAO_Domain();
+ $domain->find(TRUE);
+ if ($domain->locales) {
+ $locales = explode(CRM_Core_DAO::VALUE_SEPARATOR, $domain->locales);
+ foreach ($locales as $locale) {
+ if (!CRM_Core_BAO_SchemaHandler::checkIfFieldExists("civicrm_price_field_value", "help_pre_{$locale}")) {
+ CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_price_field_value`
+ ADD COLUMN `help_pre_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'", array(), TRUE, NULL, FALSE, FALSE);
+ }
+ if (!CRM_Core_BAO_SchemaHandler::checkIfFieldExists("civicrm_price_field_value", "help_post_{$locale}")) {
+ CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_price_field_value`
+ ADD COLUMN `help_post_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option post help text.'", array(), TRUE, NULL, FALSE, FALSE);
+ }
+ }
+ CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales, NULL);
}
-
+ else {
+ if (!CRM_Core_BAO_SchemaHandler::checkIfFieldExists('civicrm_price_field_value', 'help_pre')) {
+ CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_price_field_value`
+ ADD COLUMN `help_pre` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'");
+ }
+ if (!CRM_Core_BAO_SchemaHandler::checkIfFieldExists('civicrm_price_field_value', 'help_post')) {
+ CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_price_field_value`
+ ADD COLUMN `help_post` text COLLATE utf8_unicode_ci COMMENT 'Price field option post help text.'");
+ }
+ }
+ return TRUE;
}
/**
public function upgradeMailingFKs(CRM_Queue_TaskContext $ctx) {
// Safely drop the foreign keys
- self::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_email_id');
- self::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_phone_id');
- self::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_email_id');
- self::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_phone_id');
+ CRM_Core_BAO_SchemaHandler::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_email_id');
+ CRM_Core_BAO_SchemaHandler::safeRemoveFK('civicrm_mailing_event_queue', 'FK_civicrm_mailing_event_queue_phone_id');
+ CRM_Core_BAO_SchemaHandler::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_email_id');
+ CRM_Core_BAO_SchemaHandler::safeRemoveFK('civicrm_mailing_recipients', 'FK_civicrm_mailing_recipients_phone_id');
// Set up the new foreign keys
CRM_Core_DAO::executeQuery("SET FOREIGN_KEY_CHECKS = 0;");
return TRUE;
}
+ /**
+ * CRM-17663 - Dashboard schema changes
+ *
+ * @param \CRM_Queue_TaskContext $ctx
+ *
+ * @return bool
+ */
+ public function dashboardSchemaUpdate(CRM_Queue_TaskContext $ctx) {
+ if (!CRM_Core_BAO_SchemaHandler::checkIfIndexExists('civicrm_dashboard_contact', 'index_dashboard_id_contact_id')) {
+ // Delete any stray duplicate rows and add unique index to prevent new dupes and enable INSERT/UPDATE combo query
+ CRM_Core_DAO::executeQuery('DELETE c1 FROM civicrm_dashboard_contact c1, civicrm_dashboard_contact c2 WHERE c1.contact_id = c2.contact_id AND c1.dashboard_id = c2.dashboard_id AND c1.id > c2.id');
+ CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_dashboard_contact ADD UNIQUE INDEX index_dashboard_id_contact_id (dashboard_id, contact_id);');
+ }
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard_contact', 'content');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard_contact', 'is_minimized');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard_contact', 'is_fullscreen');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard_contact', 'created_date');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard', 'is_fullscreen');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard', 'is_minimized');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard', 'column_no');
+ CRM_Core_BAO_SchemaHandler::dropColumn('civicrm_dashboard', 'weight');
+
+ CRM_Core_DAO::executeQuery('UPDATE civicrm_dashboard SET url = REPLACE(url, "&snippet=5", ""), fullscreen_url = REPLACE(fullscreen_url, "&snippet=5", "")');
+
+ if (!CRM_Core_BAO_SchemaHandler::checkIfFieldExists('civicrm_dashboard', 'cache_minutes')) {
+ CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_dashboard ADD COLUMN cache_minutes int unsigned NOT NULL DEFAULT 60 COMMENT "Number of minutes to cache dashlet content in browser localStorage."');
+ }
+
+ CRM_Core_DAO::executeQuery('UPDATE civicrm_dashboard SET cache_minutes = 1440 WHERE name = "blog"');
+ CRM_Core_DAO::executeQuery('UPDATE civicrm_dashboard SET cache_minutes = 7200 WHERE name IN ("activity","getting-started")');
+ return TRUE;
+ }
+
+ /**
+ * CRM-19100 - Alter Index and Type for Image URL
+ * @return bool
+ */
+ public static function alterIndexAndTypeForImageURL() {
+ $length = array();
+ CRM_Core_BAO_SchemaHandler::dropIndexIfExists('civicrm_contact', 'index_image_url');
+ 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.'");
+
+ $length['civicrm_contact']['image_URL'] = 128;
+ CRM_Core_BAO_SchemaHandler::createIndexes(array('civicrm_contact' => array('image_URL')), 'index', $length);
+
+ return TRUE;
+ }
+
}