protected function run1($stage)
{
$this->console->out("Initializing missing fields with data from server_properties.");
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.instance_type_name = sp.value\n WHERE sh.instance_type_name IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", ['info.instance_type_name']);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.role_id = sp.value\n WHERE sh.role_id IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", [\SERVER_PROPERTIES::ROLE_ID]);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.farm_created_by_id = sp.value\n WHERE sh.farm_created_by_id IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", [\SERVER_PROPERTIES::FARM_CREATED_BY_ID]);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.project_id = UNHEX(REPLACE(sp.value, '-', ''))\n WHERE sh.project_id IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", [\SERVER_PROPERTIES::FARM_PROJECT_ID]);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.cc_id = UNHEX(REPLACE(sp.value, '-', ''))\n WHERE sh.cc_id IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", [\SERVER_PROPERTIES::ENV_CC_ID]);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN server_properties sp\n ON sp.server_id = sh.server_id AND sp.name = ?\n SET sh.os_type = sp.value\n WHERE sh.os_type IS NULL AND sp.value IS NOT NULL AND sp.value <> ''\n ", [\SERVER_PROPERTIES::OS_TYPE]);
$this->db->Execute("\n UPDATE servers_history sh\n JOIN servers s\n ON s.server_id = sh.server_id\n SET sh.env_id = s.env_id\n WHERE sh.env_id IS NULL AND s.env_id IS NOT NULL\n ");
$this->db->Execute("\n UPDATE servers_history sh\n JOIN servers s\n ON s.server_id = sh.server_id\n SET sh.farm_id = s.farm_id\n WHERE sh.farm_id IS NULL AND s.farm_id IS NOT NULL\n ");
$this->db->Execute("\n UPDATE servers_history sh\n JOIN servers s\n ON s.server_id = sh.server_id\n SET sh.farm_roleid = s.farm_roleid\n WHERE sh.farm_roleid IS NULL AND s.farm_roleid IS NOT NULL\n ");
$this->db->Execute("\n UPDATE servers_history sh\n JOIN servers s\n ON s.server_id = sh.server_id\n SET sh.server_index = s.`index`\n WHERE sh.server_index IS NULL AND s.`index` IS NOT NULL\n ");
}