CRM_Core_I18n_Schema::makeSinglelingual('en_US');
$logging = new CRM_Logging_Schema();
$logging->dropAllLogTables();
+ \Civi::$statics['CRM_Logging_Schema']['columnSpecs'] = array();
parent::tearDown();
}
$logging->disableLogging();
}
-
/**
* Test creating logging schema when database is in multilingual mode.
* Also test altering a multilingual table.
$logging->enableLogging();
$value = CRM_Core_DAO::singleValueQuery("SELECT id FROM log_civicrm_contact LIMIT 1", array(), FALSE, FALSE);
$this->assertNotNull($value, 'Logging not enabled successfully');
- $logging->disableLogging();
- CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_option_value` ADD COLUMN `logging_test` INT DEFAULT NULL", array(), FALSE, NULL, FALSE, FALSE);
+ CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_option_value` ADD COLUMN `logging_test` INT DEFAULT '0'", array(), FALSE, NULL, FALSE, FALSE);
CRM_Core_I18n_Schema::rebuildMultilingualSchema(array('en_US'));
- $logging->enableLogging();
+ \Civi::$statics['CRM_Logging_Schema']['columnSpecs'] = array();
+ $logging->fixSchemaDifferencesFor('civicrm_option_value', array(), TRUE);
$query = CRM_Core_DAO::executeQuery("SHOW CREATE TABLE `log_civicrm_option_value`", array(), TRUE, NULL, FALSE, FALSE);
$query->fetch();
$create = explode("\n", $query->Create_Table);
+ $this->assertTrue(in_array(" `logging_test` int(11) DEFAULT '0'", $create));
+ $create = explode("\n", $query->Create_Table);
CRM_Core_DAO::executeQuery("ALTER TABLE `civicrm_option_value` DROP COLUMN `logging_test`", array(), FALSE, NULL, FALSE, FALSE);
- $this->assertTrue(in_array(" `logging_test` int(11) DEFAULT NULL", $create));
+ $query = CRM_Core_DAO::executeQuery("SHOW CREATE TABLE `log_civicrm_option_value`", array(), TRUE, NULL, FALSE, FALSE);
+ $query->fetch();
+ $domain = new CRM_Core_DAO_Domain();
+ $domain->find(TRUE);
+ $locales = explode(CRM_Core_DAO::VALUE_SEPARATOR, $domain->locales);
+ \Civi::$statics['CRM_Logging_Schema']['columnSpecs'] = array();
+ CRM_Core_I18n_Schema::rebuildMultilingualSchema($locales);
+ $logging->fixSchemaDifferencesFor('civicrm_option_value', array(), TRUE);
+ $this->assertTrue(in_array(" `logging_test` int(11) DEFAULT '0'", $create));
$logging->disableLogging();
}