Scalr\Upgrade\Updates\Update20151222172257::run6 PHP Method

    protected function run6($stage)
    {
        $this->console->out("Add ACL permission to update Farms Projects");
        foreach ([Acl::RESOURCE_FARMS, Acl::RESOURCE_TEAM_FARMS, Acl::RESOURCE_OWN_FARMS] as $resourceId) {
            $this->db->Execute("\n                INSERT IGNORE INTO `acl_role_resource_permissions` (`role_id`, `resource_id`, `perm_id`, `granted`)\n                VALUES (?, ?, ?, 1)\n            ", [Acl::ROLE_ID_FULL_ACCESS, $resourceId, Acl::PERM_FARMS_PROJECTS]);
            $this->db->Execute("\n                INSERT IGNORE INTO `acl_account_role_resource_permissions` (`account_role_id`, `resource_id`, `perm_id`, `granted`)\n                SELECT `account_role_id`, `resource_id`, ?, `granted` FROM `acl_account_role_resource_permissions`\n                WHERE `resource_id` = ? AND `perm_id` = ?\n            ", [Acl::PERM_FARMS_PROJECTS, $resourceId, Acl::PERM_FARMS_UPDATE]);
        }
    }