Scalr\Upgrade\Updates\Update20150827140744::run2 PHP Метод

    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]);
    }