public static function wasDimensionMovedFromCoreToPlugin($name, $version)
{
// maps names of core dimension columns that were part of the original dimension refactor with their
// initial "version" strings. The '1' that is sometimes appended to the end of the string (sometimes seen as
// NULL1) is from individual dimension "versioning" logic (eg, see VisitDimension::getVersion())
$initialCoreDimensionVersions = array('log_visit.config_resolution' => 'VARCHAR(9) NOT NULL', 'log_visit.config_device_brand' => 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL', 'log_visit.config_device_model' => 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL', 'log_visit.config_windowsmedia' => 'TINYINT(1) NOT NULL', 'log_visit.config_silverlight' => 'TINYINT(1) NOT NULL', 'log_visit.config_java' => 'TINYINT(1) NOT NULL', 'log_visit.config_gears' => 'TINYINT(1) NOT NULL', 'log_visit.config_pdf' => 'TINYINT(1) NOT NULL', 'log_visit.config_quicktime' => 'TINYINT(1) NOT NULL', 'log_visit.config_realplayer' => 'TINYINT(1) NOT NULL', 'log_visit.config_device_type' => 'TINYINT( 100 ) NULL DEFAULT NULL', 'log_visit.visitor_localtime' => 'TIME NOT NULL', 'log_visit.location_region' => 'char(2) DEFAULT NULL1', 'log_visit.visitor_days_since_last' => 'SMALLINT(5) UNSIGNED NOT NULL', 'log_visit.location_longitude' => 'float(10, 6) DEFAULT NULL1', 'log_visit.visit_total_events' => 'SMALLINT(5) UNSIGNED NOT NULL', 'log_visit.config_os_version' => 'VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL', 'log_visit.location_city' => 'varchar(255) DEFAULT NULL1', 'log_visit.location_country' => 'CHAR(3) NOT NULL1', 'log_visit.location_latitude' => 'float(10, 6) DEFAULT NULL1', 'log_visit.config_flash' => 'TINYINT(1) NOT NULL', 'log_visit.config_director' => 'TINYINT(1) NOT NULL', 'log_visit.visit_total_time' => 'SMALLINT(5) UNSIGNED NOT NULL', 'log_visit.visitor_count_visits' => 'SMALLINT(5) UNSIGNED NOT NULL1', 'log_visit.visit_entry_idaction_name' => 'INTEGER(11) UNSIGNED NOT NULL', 'log_visit.visit_entry_idaction_url' => 'INTEGER(11) UNSIGNED NOT NULL', 'log_visit.visitor_returning' => 'TINYINT(1) NOT NULL1', 'log_visit.visitor_days_since_order' => 'SMALLINT(5) UNSIGNED NOT NULL1', 'log_visit.visit_goal_buyer' => 'TINYINT(1) NOT NULL', 'log_visit.visit_first_action_time' => 'DATETIME NOT NULL', 'log_visit.visit_goal_converted' => 'TINYINT(1) NOT NULL', 'log_visit.visitor_days_since_first' => 'SMALLINT(5) UNSIGNED NOT NULL1', 'log_visit.visit_exit_idaction_name' => 'INTEGER(11) UNSIGNED NOT NULL', 'log_visit.visit_exit_idaction_url' => 'INTEGER(11) UNSIGNED NULL DEFAULT 0', 'log_visit.config_browser_version' => 'VARCHAR(20) NOT NULL', 'log_visit.config_browser_name' => 'VARCHAR(10) NOT NULL', 'log_visit.config_browser_engine' => 'VARCHAR(10) NOT NULL', 'log_visit.location_browser_lang' => 'VARCHAR(20) NOT NULL', 'log_visit.config_os' => 'CHAR(3) NOT NULL', 'log_visit.config_cookie' => 'TINYINT(1) NOT NULL', 'log_visit.referer_url' => 'TEXT NOT NULL', 'log_visit.visit_total_searches' => 'SMALLINT(5) UNSIGNED NOT NULL', 'log_visit.visit_total_actions' => 'SMALLINT(5) UNSIGNED NOT NULL', 'log_visit.referer_keyword' => 'VARCHAR(255) NULL1', 'log_visit.referer_name' => 'VARCHAR(70) NULL1', 'log_visit.referer_type' => 'TINYINT(1) UNSIGNED NULL1', 'log_visit.user_id' => 'VARCHAR(200) NULL', 'log_link_visit_action.idaction_name' => 'INTEGER(10) UNSIGNED', 'log_link_visit_action.idaction_url' => 'INTEGER(10) UNSIGNED DEFAULT NULL', 'log_link_visit_action.server_time' => 'DATETIME NOT NULL', 'log_link_visit_action.time_spent_ref_action' => 'INTEGER(10) UNSIGNED NOT NULL', 'log_link_visit_action.idaction_event_action' => 'INTEGER(10) UNSIGNED DEFAULT NULL', 'log_link_visit_action.idaction_event_category' => 'INTEGER(10) UNSIGNED DEFAULT NULL', 'log_conversion.revenue_discount' => 'float default NULL', 'log_conversion.revenue' => 'float default NULL', 'log_conversion.revenue_shipping' => 'float default NULL', 'log_conversion.revenue_subtotal' => 'float default NULL', 'log_conversion.revenue_tax' => 'float default NULL');
if (!array_key_exists($name, $initialCoreDimensionVersions)) {
return false;
}
return strtolower($initialCoreDimensionVersions[$name]) === strtolower($version);
}
