public function getMigrations(Updater $updater)
{
$defaultTimezone = 'UTC';
$defaultCurrency = 'USD';
return array($this->migration->db->changeColumnType('user', 'date_registered', 'TIMESTAMP NULL'), $this->migration->db->changeColumnType('site', 'ts_created', 'TIMESTAMP NULL'), $this->migration->db->addColumn('site', 'timezone', 'VARCHAR( 50 ) NOT NULL', 'ts_created'), $this->migration->db->sql('UPDATE ' . Common::prefixTable('site') . ' SET `timezone` = "' . $defaultTimezone . '";', Migration\Db::ERROR_CODE_DUPLICATE_COLUMN), $this->migration->db->addColumn('site', 'currency', 'CHAR( 3 ) NOT NULL', 'timezone'), $this->migration->db->sql('UPDATE ' . Common::prefixTable('site') . ' SET `currency` = "' . $defaultCurrency . '";', Migration\Db::ERROR_CODE_DUPLICATE_COLUMN), $this->migration->db->addColumn('site', 'excluded_ips', 'TEXT NOT NULL', 'currency'), $this->migration->db->addColumn('site', 'excluded_parameters', 'VARCHAR( 255 ) NOT NULL', 'excluded_ips'), $this->migration->db->addIndex('log_visit', array('idsite', 'visit_last_action_time', 'config_md5config(8)'), 'index_idsite_datetime_config'), $this->migration->db->addIndex('log_visit', array('idsite', 'idvisit')), $this->migration->db->dropIndex('log_conversion', 'index_idsite_date'), $this->migration->db->dropColumn('log_conversion', 'visit_server_date'), $this->migration->db->addIndex('log_conversion', array('idsite', 'server_time'), 'index_idsite_datetime'));
}