protected function run2($stage)
{
$this->console->out("Initialize new fields with data from server_properties.");
$this->db->Execute("\n UPDATE servers_history sh\n LEFT JOIN server_properties sp1\n ON sp1.server_id = sh.server_id AND sp1.name = ?\n LEFT JOIN server_properties sp2\n ON sp2.server_id = sh.server_id AND sp2.name = ?\n LEFT JOIN server_properties sp3\n ON sp3.server_id = sh.server_id AND sp3.name = ?\n LEFT JOIN server_properties sp4\n ON sp4.server_id = sh.server_id AND sp4.name = ?\n LEFT JOIN server_properties sp5\n ON sp5.server_id = sh.server_id AND sp5.name = ?\n SET sh.project_id = UNHEX(REPLACE(sp1.value, '-', '')),\n sh.cc_id = UNHEX(REPLACE(sp2.value, '-', '')),\n sh.instance_type_name = sp3.value,\n sh.role_id = sp4.value,\n sh.farm_created_by_id = sp5.value\n ", [\SERVER_PROPERTIES::FARM_PROJECT_ID, \SERVER_PROPERTIES::ENV_CC_ID, 'info.instance_type_name', \SERVER_PROPERTIES::ROLE_ID, \SERVER_PROPERTIES::FARM_CREATED_BY_ID]);
}