xml/dbatools.Types.ps1xml

<?xml version="1.0" encoding="utf-8" ?>
<Types>
<!--Microsoft.SqlServer.Management.Smo.Database -->
<Type>
<Name>Microsoft.SqlServer.Management.Smo.Database</Name>
<Members>
<ScriptMethod>
<Name>Query</Name>
<Script>
param (
    $Query,
    $AllTables = $false
)
 
# ExecuteWithResults does not run on a private connection: the execution manager of a database is the
# connection context of the parent server, which belongs to the caller. It issues a USE and never switches
# back, so the previous database is put back here. See #10555.
$connectionContext = $this.Parent.ConnectionContext
$previousDatabase = $connectionContext.CurrentDatabase
 
try {
    if ($AllTables) { ($this.ExecuteWithResults($Query)).Tables }
    else { ($this.ExecuteWithResults($Query)).Tables[0] }
} finally {
    # The comparison is case sensitive on purpose. Database names use the collation of the instance, so
    # on a case sensitive instance AppDb and appdb are two different databases, and -ne would report
    # them as equal and skip the restore. It cannot restore needlessly: both sides are read from the
    # same property, so the same database always spells itself the same way.
    if ($previousDatabase -and $connectionContext.CurrentDatabase -cne $previousDatabase) {
        $escapedDatabase = $previousDatabase.Replace("]", "]]")
        try {
            $null = $connectionContext.ExecuteNonQuery("USE [$escapedDatabase]")
        } catch {
            # Putting the database back is housekeeping and must never become the outcome of the call.
            # A query that makes the previous database unreachable - taking it offline, dropping it,
            # renaming it, revoking access - would otherwise throw here although it succeeded, and the
            # caller would read that as "it did not run" and might do it a second time. A query that
            # failed would have its own error replaced by this one, which is just as misleading.
            # Write-Warning obeys the caller's $WarningPreference, and Stop turns it into a terminating
            # error - which would hand the outcome of the call back to the housekeeping, the very thing
            # this catch exists to prevent. Inquire stops just as dead where nobody can answer it. Only
            # those two are neutralised, and only for this one call: a caller that asked for silence
            # still gets silence, which passing -WarningAction Continue would have taken away.
            if ($WarningPreference -notin "SilentlyContinue", "Continue") { $WarningPreference = "Continue" }
            Write-Warning "The database context could not be restored to [$previousDatabase]: $($_.Exception.Message)"
        }
    }
}
</Script>
</ScriptMethod>
<ScriptMethod>
<Name>Invoke</Name>
<Script>
param (
    $Command
)
 
# See the comment on Query above: this leaves the connection of the caller in this database, so the
# previous database is put back afterwards. See #10555.
$connectionContext = $this.Parent.ConnectionContext
$previousDatabase = $connectionContext.CurrentDatabase
 
try {
    $this.ExecuteNonQuery($Command)
} finally {
    # See the comment on Query above for why this is case sensitive and why a failing restore only warns.
    if ($previousDatabase -and $connectionContext.CurrentDatabase -cne $previousDatabase) {
        $escapedDatabase = $previousDatabase.Replace("]", "]]")
        try {
            $null = $connectionContext.ExecuteNonQuery("USE [$escapedDatabase]")
        } catch {
            # See the comment on Query above for why the warning preference is neutralised first.
            if ($WarningPreference -notin "SilentlyContinue", "Continue") { $WarningPreference = "Continue" }
            Write-Warning "The database context could not be restored to [$previousDatabase]: $($_.Exception.Message)"
        }
    }
}
</Script>
</ScriptMethod>
</Members>
</Type>
 
<!--Microsoft.SqlServer.Management.Smo.Server -->
<Type>
<Name>Microsoft.SqlServer.Management.Smo.Server</Name>
<Members>
<ScriptMethod>
<Name>Query</Name>
<Script>
param (
    [string]$Query,
    [string]$Database,
    [bool]$AllTables
)
 
try {
    if ($Database) {
        # Going through the database object leaves the connection of the caller in that database, so the
        # previous database is put back afterwards. This does not go through Database.Query, so it needs the
        # same treatment of its own. See #10555.
        $connectionContext = $this.ConnectionContext
        $previousDatabase = $connectionContext.CurrentDatabase
        try {
            $dataSet = $this.Databases[$Database].ExecuteWithResults($Query)
        } finally {
            # See the comment on Database.Query for why this is case sensitive and why a failing restore only warns.
            if ($previousDatabase -and $connectionContext.CurrentDatabase -cne $previousDatabase) {
                $escapedDatabase = $previousDatabase.Replace("]", "]]")
                try {
                    $null = $connectionContext.ExecuteNonQuery("USE [$escapedDatabase]")
                } catch {
                    # See the comment on Database.Query for why the warning preference is neutralised first.
                    if ($WarningPreference -notin "SilentlyContinue", "Continue") { $WarningPreference = "Continue" }
                    Write-Warning "The database context could not be restored to [$previousDatabase]: $($_.Exception.Message)"
                }
            }
        }
    } else {
        $dataSet = $this.ConnectionContext.ExecuteWithResults($Query)
    }
    if ($AllTables) {
        $dataSet.Tables
    } else {
        $dataSet.Tables[0]
    }
} catch {
    $message = ''
    $innerException = $_.Exception.InnerException
    while ($innerException.InnerException) {
        $message += $innerException.Message
        $innerException = $innerException.InnerException
    }
    $message += $innerException.Message
    throw $message
}
</Script>
</ScriptMethod>
<ScriptMethod>
<Name>Invoke</Name>
<Script>
param (
    [string]$Command,
    [string]$Database
)
 
try {
    if ($Database) {
        # See the comment on Query above: this does not go through Database.Invoke either, so the previous
        # database is put back here as well. See #10555.
        $connectionContext = $this.ConnectionContext
        $previousDatabase = $connectionContext.CurrentDatabase
        try {
            $this.Databases[$Database].ExecuteNonQuery($Command)
        } finally {
            # See the comment on Database.Query for why this is case sensitive and why a failing restore only warns.
            if ($previousDatabase -and $connectionContext.CurrentDatabase -cne $previousDatabase) {
                $escapedDatabase = $previousDatabase.Replace("]", "]]")
                try {
                    $null = $connectionContext.ExecuteNonQuery("USE [$escapedDatabase]")
                } catch {
                    # See the comment on Database.Query for why the warning preference is neutralised first.
                    if ($WarningPreference -notin "SilentlyContinue", "Continue") { $WarningPreference = "Continue" }
                    Write-Warning "The database context could not be restored to [$previousDatabase]: $($_.Exception.Message)"
                }
            }
        }
    } else {
        $this.ConnectionContext.ExecuteNonQuery($Command)
    }
} catch {
    $message = ''
    $innerException = $_.Exception.InnerException
    while ($innerException.InnerException) {
        $message += $innerException.Message
        $innerException = $innerException.InnerException
    }
    $message += $innerException.Message
    throw $message
}
</Script>
</ScriptMethod>
</Members>
</Type>
<Type>
<Name>Dataplat.Dbatools.dbaSystem.DbatoolsException</Name>
<Members>
<MemberSet>
<Name>PSStandardMembers</Name>
<Members>
<NoteProperty>
<Name>SerializationDepth</Name>
<Value>2</Value>
</NoteProperty>
</Members>
</MemberSet>
</Members>
</Type>
<Type>
<Name>Dataplat.Dbatools.dbaSystem.DbatoolsExceptionRecord</Name>
<Members>
<MemberSet>
<Name>PSStandardMembers</Name>
<Members>
<NoteProperty>
<Name>SerializationDepth</Name>
<Value>2</Value>
</NoteProperty>
</Members>
</MemberSet>
</Members>
</Type>
</Types>
<!-- SIG # Begin signature block -->
<!-- MIItZQYJKoZIhvcNAQcCoIItVjCCLVICAQMxDTALBglghkgBZQMEAgEwewYKKwYB -->
<!-- BAGCNwIBBKBtBGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG -->
<!-- KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCDhZCIp048T2b7k -->
<!-- p6QPlQcdfYVGqZekWLYbcbV/cUTbYaCCFWUwggaTMIIEe6ADAgECAhMzAAq+zyCi -->
<!-- gw4nxSDPAAAACr7PMA0GCSqGSIb3DQEBDAUAMFoxCzAJBgNVBAYTAlVTMR4wHAYD -->
<!-- VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKzApBgNVBAMTIk1pY3Jvc29mdCBJ -->
<!-- RCBWZXJpZmllZCBDUyBFT0MgQ0EgMDQwHhcNMjYxMTIwMDE1ODU4WhcNMjYxMTIz -->
<!-- MDE1ODU4WjBXMQswCQYDVQQGEwJVUzERMA8GA1UECBMIVmlyZ2luaWExDzANBgNV -->
<!-- BAcTBlZpZW5uYTERMA8GA1UEChMIZGJhdG9vbHMxETAPBgNVBAMTCGRiYXRvb2xz -->
<!-- MIIBojANBgkqhkiG9w0BAQEFAAOCAY8AMIIBigKCAYEAp1NMOASMcwjK/+t8I6IS -->
<!-- 18Po4e16Lw1lKovuaMPMVJyql1cxptaVcRFCCM6giB7GDmBqX3r+ffB4PVlyRh0K -->
<!-- LjXqubAH6eSNAAg+ZDS4bY8pqO19MXuSJ61NY3s5AJfCD5JLspey7R53+wN7kHRy -->
<!-- 5VxouUfrRXCHvN6F+K3yqc6azLwfx/JAI2njJRJ+opU16dQkbfXhPQijrCHfB9Xl -->
<!-- kr5OSrHcxlQGPfb33VAEb5HdBjRzf7OH2rylC9wEKbxnjLe5QcVCavW4BzT/2SdX -->
<!-- asxllTyJPyv6huyNyl/axdDYFs2nStB8+n5MVUBTFNvjc/w/6yBwSOu3SNFGxuQD -->
<!-- nbmDX949fvFdMsIi/vCEHQO3zk/rT27pkkYPVF0wYifg1zjusr0CdHKqx9gTKHaR -->
<!-- i4kncNPntpl0K1ZETILJCjbOeksZjn01MsmbcqEEdNqi6x+CGmhAQDQe8/uu8ENO -->
<!-- eA5/iYcN+qv3ENh+gkAiDlBmQwN0X255jn+dKNXCDswLAgMBAAGjggHTMIIBzzAM -->
<!-- BgNVHRMBAf8EAjAAMA4GA1UdDwEB/wQEAwIHgDA6BgNVHSUEMzAxBgorBgEEAYI3 -->
<!-- YQEABggrBgEFBQcDAwYZKwYBBAGCN2H5+cEspPS4DoOuxLIcm56wGDAdBgNVHQ4E -->
<!-- FgQUvDZzaB4nC5Cp1Qp+yeWHHpi1L6IwHwYDVR0jBBgwFoAUmvFUd3UMhxY3RqCs -->
<!-- 3nn59H/BeOkwZwYDVR0fBGAwXjBcoFqgWIZWaHR0cDovL3d3dy5taWNyb3NvZnQu -->
<!-- Y29tL3BraW9wcy9jcmwvTWljcm9zb2Z0JTIwSUQlMjBWZXJpZmllZCUyMENTJTIw -->
<!-- RU9DJTIwQ0ElMjAwNC5jcmwwdAYIKwYBBQUHAQEEaDBmMGQGCCsGAQUFBzAChlho -->
<!-- dHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY3Jvc29mdCUy -->
<!-- MElEJTIwVmVyaWZpZWQlMjBDUyUyMEVPQyUyMENBJTIwMDQuY3J0MFQGA1UdIARN -->
<!-- MEswSQYEVR0gADBBMD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5j -->
<!-- b20vcGtpb3BzL0RvY3MvUmVwb3NpdG9yeS5odG0wDQYJKoZIhvcNAQEMBQADggIB -->
<!-- AFaWcAEF3DY1FU2MyzdQQLJP52EqOSQt5+zohpRczuOnBypN55ZuEC0BcoRAHOjq -->
<!-- w8cssB/L3//iVDT6hp9uhfV8WILtoQi9BJZaRGMeEgI2p4fyyCN5xwWsJS7Yrz9m -->
<!-- PNCULm9Vk02J1uojcH+y11BevSrmjPzjMLs3KBfotp3kqn10QkDskVaz1xD7rZxH -->
<!-- xIqqcgJZQ3mi3FePHX02H8KOg6hmnsChwaAZljgT6Mo2gVDJEPjFOi/SZcBihSDl -->
<!-- Tg+7nlT/4KqZZFLmx3To1291uAHcZGFWmA3lKpd4VEoApG7Baecz4telMOgCY7q/ -->
<!-- reE/8VC6Ta9bxq9blSChaFxEjP0yI4+ZaE7fP7ugVdOeEesjGp1gQzeI0lX+t0ct -->
<!-- rOxNijoGihDuGCcavR1f8ZgCf+Ff3n655yDRCxhNWNhSKLwPibvTJHA/ieRmsp8k -->
<!-- ENy3vcj/TkO7sCHZjgTRRWacUQ2DbnopHxLcfUkva7+AnCdxmw4vW2FTKW6ZtiF4 -->
<!-- PZUqt99dN1qeFrJkxz9YKe3WCWadBs8c+MenXL6C73lkdLiOYqp/wllyNmjEJF6c -->
<!-- cHPo6tdiItdGMuefI6V3lgasSraXjJvFl7bO1A67t2X0zY9S692NxprarBsp7eNE -->
<!-- 8OMAx75IKqYdgjv+2pYRuyIztVgyUGEh1EuHaZmHlLysMIIHKDCCBRCgAwIBAgIT -->
<!-- MwAAABcnRQkLi4evxgAAAAAAFzANBgkqhkiG9w0BAQwFADBjMQswCQYDVQQGEwJV -->
<!-- UzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTQwMgYDVQQDEytNaWNy -->
<!-- b3NvZnQgSUQgVmVyaWZpZWQgQ29kZSBTaWduaW5nIFBDQSAyMDIxMB4XDTI2MDMy -->
<!-- NjE4MTEzMVoXDTMxMDMyNjE4MTEzMVowWjELMAkGA1UEBhMCVVMxHjAcBgNVBAoT -->
<!-- FU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjErMCkGA1UEAxMiTWljcm9zb2Z0IElEIFZl -->
<!-- cmlmaWVkIENTIEVPQyBDQSAwNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC -->
<!-- ggIBAILHZP4DD2YqAZXMn5OrQ8yfj0beK0ixilvHsKUtJEcV7VEQt09xnWwipY6G -->
<!-- xJ/LrLKoRqkKUYf0l70VcDVxCBm++lBuSD5AidUuv/QQ+tUELCsz3qVtEjY/E14L -->
<!-- Bcb0uzJbaEbopCCKe0OY0IGjjOkMivfvumVV1KWJmbpQHusfCa8GdHTZBPq2eupa -->
<!-- raKHMHqVElVMTO6HQ5p/Mgx4ydgzT7H697kQ4sd1+Kr4deIx/0lvtgse1iDIciIk -->
<!-- DttNYuoVIsZpOHtmVvFuwtcD3U46ugSm/s6PMW67e2SkL0V+UDgOnYS6rj6o+bFS -->
<!-- p8an5NfSAtEmn00k7PMguNxMPeuQUUVvFS/XHKDpq+K8UMu2goGEzZN3Xfy6YTWk -->
<!-- 05pxqe5Ji08ch5AeYHqFoWLrhq8sEvBNMCb9FuK3zrRwVdHvbCr7lCHiFKZ7Meop -->
<!-- cRFY+lUF74A+sngipz5o94yYiSgJZlA7bYecs0VQVJeOLDIhuC+Uf8sgAkSpNp9P -->
<!-- PENmAqGUtTvOvqDCyrdY2lxhAjo27FafCHdVUMPIXuidCoqzkuXtuV5U3RjxW+qA -->
<!-- TjmmnIFu/Co39G6fl8wIJHPdpgxjSRmEo73Z4/u3jMepnltAwCBnS0TY/P+NvTCL -->
<!-- KRQX89yg6qqTe9UuJENiy3q93cYQw3MylRS9By8Ebjr4I4hvAgMBAAGjggHcMIIB -->
<!-- 2DAOBgNVHQ8BAf8EBAMCAYYwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFJrx -->
<!-- VHd1DIcWN0agrN55+fR/wXjpMFQGA1UdIARNMEswSQYEVR0gADBBMD8GCCsGAQUF -->
<!-- BwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL0RvY3MvUmVwb3Np -->
<!-- dG9yeS5odG0wGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwEgYDVR0TAQH/BAgw -->
<!-- BgEB/wIBADAfBgNVHSMEGDAWgBTZQSmwDw9jbO9p1/XNKZ6kSGow5jBwBgNVHR8E -->
<!-- aTBnMGWgY6Bhhl9odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9N -->
<!-- aWNyb3NvZnQlMjBJRCUyMFZlcmlmaWVkJTIwQ29kZSUyMFNpZ25pbmclMjBQQ0El -->
<!-- MjAyMDIxLmNybDB9BggrBgEFBQcBAQRxMG8wbQYIKwYBBQUHMAKGYWh0dHA6Ly93 -->
<!-- d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwSUQlMjBW -->
<!-- ZXJpZmllZCUyMENvZGUlMjBTaWduaW5nJTIwUENBJTIwMjAyMS5jcnQwDQYJKoZI -->
<!-- hvcNAQEMBQADggIBAJB1Whn9TSbfyXaIppkWWzFq+m2mg4vJpHVr1krZNIXWQ6cU -->
<!-- mEwOx7oqQKCy96iISNdNVzpe3zogoefvo2TmpkHQFe/aIxFDaCIAmZi9lyay2hmp -->
<!-- 8HYzcp3nCcmFQk60X9voeypJ6VjqeGsXTrOivWUOYNCLEFlwsH3NHX5EpCyjWN6Q -->
<!-- 3Fi5ST4do3eTVLnuqTQ7/9huTBTSYQsJbTg3m8gIxnHlPlzs2r/u4u9tWEJ0Pt/Z -->
<!-- tmkDhTu86QHWigHgBoRHemOgnQxp3ksXKLo1r2n1m7+Gst46NTkUi1LljGyq+V9f -->
<!-- EBOEnXvoKaRiy0pGbK1IdnsmEpF9Xp71l+2T84Nv8IrikZUBWqw5/jffttAas4cc -->
<!-- JDci832CadS4OHwl29uF6hY8fEg3UYHmxSJjnzi1c3vF0PwsJKxGom9Dx7treBlZ -->
<!-- OBWK6BGzVBar43Qb02N7okeU3UKMl6GB74fk8aS0mNr6O4YSvQ/66RKRwvqppnEV -->
<!-- BOHdIMjvWW9b77duX8TN3pI7w31R3D6t6jK9EcLJOJKymVlBIFNUl0+ajeoKka7I -->
<!-- cW0+jkIGff8U9OKol3cz0Eeiop3Qb0qaDp8ZwC8XCcs1cDaSi/vbvBGWMvfKl+ov -->
<!-- uIBP9ienG6XpHAdGVw5/10MaDVFG+v3Y0/8JZVchvryB5Hau9T82x+a2MXXAMIIH -->
<!-- njCCBYagAwIBAgITMwAAAAeHozSje6WOHAAAAAAABzANBgkqhkiG9w0BAQwFADB3 -->
<!-- MQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMUgw -->
<!-- RgYDVQQDEz9NaWNyb3NvZnQgSWRlbnRpdHkgVmVyaWZpY2F0aW9uIFJvb3QgQ2Vy -->
<!-- dGlmaWNhdGUgQXV0aG9yaXR5IDIwMjAwHhcNMjEwNDAxMjAwNTIwWhcNMzYwNDAx -->
<!-- MjAxNTIwWjBjMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBv -->
<!-- cmF0aW9uMTQwMgYDVQQDEytNaWNyb3NvZnQgSUQgVmVyaWZpZWQgQ29kZSBTaWdu -->
<!-- aW5nIFBDQSAyMDIxMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAsvDA -->
<!-- rxmIKOLdVHpMSWxpCFUJtFL/ekr4weslKPdnF3cpTeuV8veqtmKVgok2rO0D05Bp -->
<!-- yvUDCg1wdsoEtuxACEGcgHfjPF/nZsOkg7c0mV8hpMT/GvB4uhDvWXMIeQPsDgCz -->
<!-- UGzTvoi76YDpxDOxhgf8JuXWJzBDoLrmtThX01CE1TCCvH2sZD/+Hz3RDwl2MsvD -->
<!-- SdX5rJDYVuR3bjaj2QfzZFmwfccTKqMAHlrz4B7ac8g9zyxlTpkTuJGtFnLBGaso -->
<!-- Onn5NyYlf0xF9/bjVRo4Gzg2Yc7KR7yhTVNiuTGH5h4eB9ajm1OCShIyhrKqgOkc -->
<!-- 4smz6obxO+HxKeJ9bYmPf6KLXVNLz8UaeARo0BatvJ82sLr2gqlFBdj1sYfqOf00 -->
<!-- Qm/3B4XGFPDK/H04kteZEZsBRc3VT2d/iVd7OTLpSH9yCORV3oIZQB/Qr4nD4YT/ -->
<!-- lWkhVtw2v2s0TnRJubL/hFMIQa86rcaGMhNsJrhysLNNMeBhiMezU1s5zpusf54q -->
<!-- lYu2v5sZ5zL0KvBDLHtL8F9gn6jOy3v7Jm0bbBHjrW5yQW7S36ALAt03QDpwW1JG -->
<!-- 1Hxu/FUXJbBO2AwwVG4Fre+ZQ5Od8ouwt59FpBxVOBGfN4vN2m3fZx1gqn52Gvai -->
<!-- Bz6ozorgIEjn+PhUXILhAV5Q/ZgCJ0u2+ldFGjcCAwEAAaOCAjUwggIxMA4GA1Ud -->
<!-- DwEB/wQEAwIBhjAQBgkrBgEEAYI3FQEEAwIBADAdBgNVHQ4EFgQU2UEpsA8PY2zv -->
<!-- adf1zSmepEhqMOYwVAYDVR0gBE0wSzBJBgRVHSAAMEEwPwYIKwYBBQUHAgEWM2h0 -->
<!-- dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvRG9jcy9SZXBvc2l0b3J5Lmh0 -->
<!-- bTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTAPBgNVHRMBAf8EBTADAQH/MB8G -->
<!-- A1UdIwQYMBaAFMh+0mqFKhvKGZgEByfPUBBPaKiiMIGEBgNVHR8EfTB7MHmgd6B1 -->
<!-- hnNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNyb3NvZnQl -->
<!-- MjBJZGVudGl0eSUyMFZlcmlmaWNhdGlvbiUyMFJvb3QlMjBDZXJ0aWZpY2F0ZSUy -->
<!-- MEF1dGhvcml0eSUyMDIwMjAuY3JsMIHDBggrBgEFBQcBAQSBtjCBszCBgQYIKwYB -->
<!-- BQUHMAKGdWh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY2VydHMvTWlj -->
<!-- cm9zb2Z0JTIwSWRlbnRpdHklMjBWZXJpZmljYXRpb24lMjBSb290JTIwQ2VydGlm -->
<!-- aWNhdGUlMjBBdXRob3JpdHklMjAyMDIwLmNydDAtBggrBgEFBQcwAYYhaHR0cDov -->
<!-- L29uZW9jc3AubWljcm9zb2Z0LmNvbS9vY3NwMA0GCSqGSIb3DQEBDAUAA4ICAQB/ -->
<!-- JSqe/tSr6t1mCttXI0y6XmyQ41uGWzl9xw+WYhvOL47BV09Dgfnm/tU4ieeZ7NAR -->
<!-- 5bguorTCNr58HOcA1tcsHQqt0wJsdClsu8bpQD9e/al+lUgTUJEV80Xhco7xdgRr -->
<!-- ehbyhUf4pkeAhBEjABvIUpD2LKPho5Z4DPCT5/0TlK02nlPwUbv9URREhVYCtsDM -->
<!-- +31OFU3fDV8BmQXv5hT2RurVsJHZgP4y26dJDVF+3pcbtvh7R6NEDuYHYihfmE2H -->
<!-- dQRq5jRvLE1Eb59PYwISFCX2DaLZ+zpU4bX0I16ntKq4poGOFaaKtjIA1vRElIta -->
<!-- OKcwtc04CBrXSfyL2Op6mvNIxTk4OaswIkTXbFL81ZKGD+24uMCwo/pLNhn7VHLf -->
<!-- nxlMVzHQVL+bHa9KhTyzwdG/L6uderJQn0cGpLQMStUuNDArxW2wF16QGZ1NtBWg -->
<!-- KA8Kqv48M8HfFqNifN6+zt6J0GwzvU8g0rYGgTZR8zDEIJfeZxwWDHpSxB5FJ1VV -->
<!-- U1LIAtB7o9PXbjXzGifaIMYTzU4YKt4vMNwwBmetQDHhdAtTPplOXrnI9SI6HeTt -->
<!-- jDD3iUN/7ygbahmYOHk7VB7fwT4ze+ErCbMh6gHV1UuXPiLciloNxH6K4aMfZN1o -->
<!-- LVk6YFeIJEokuPgNPa6EnTiOL60cPqfny+Fq8UiuZzGCF1YwghdSAgEBMHEwWjEL -->
<!-- MAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjErMCkG -->
<!-- A1UEAxMiTWljcm9zb2Z0IElEIFZlcmlmaWVkIENTIEVPQyBDQSAwNAITMwAKvs8g -->
<!-- ooMOJ8UgzwAAAAq+zzALBglghkgBZQMEAgGgfDAQBgorBgEEAYI3AgEMMQIwADAZ -->
<!-- BgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4wDAYKKwYB -->
<!-- BAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg0S3bGrBkrNbWgjW8u89Vt7Q6L/OwVbca -->
<!-- vIuG/LQPd+YwCwYJKoZIhvcNAQEBBIIBgJF8dDykzFViwIEl15uVHZnBZa/M/fas -->
<!-- apPO2/4fz33D+9h/aadWw3TJ1tCQJhvVmsmSm6yRFSqOnEad6ewzmU+bW1bjVYQx -->
<!-- AbqOG52hg4M+V3I6axyeYK7YWI3CL+XAZmHjvO9LZrxFJQAxYavQhfOyy1XBE/oR -->
<!-- mPDjde0S9frm/eQ+A2ozk9JC6zhWZ0oxioiU+awWrwaeehNiSFD8X3AojMsG5UEC -->
<!-- 7auta7CxEHteXKbXwcrUhcBg95PN9OlhO9fdsiWK5K955qmyiWBk9s3cQre+KD6n -->
<!-- u8brGV1qjluCwGeV24mFuvdaiJB6eFl/24dsFGR61KergcNcaxQT6Y4kJfkWQyKb -->
<!-- 9qYQ24q7qVaTEYMJx+Ls+AyXIG+64kCaltiKH1Qd9gayc6eiG8mh+4U0wqRFrMaH -->
<!-- LDNjI3+L9tWIfT21Rl5C5aqr9tK4ngC6pcC64FbueaU+FeylQPxeNtxWs41O0mf8 -->
<!-- OgXMi4kI08ITmdb6LMsyqgZO4EGO1kRgQaGCFLwwghS4BgorBgEEAYI3AwMBMYIU -->
<!-- qDCCFKQGCSqGSIb3DQEHAqCCFJUwghSRAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggF0 -->
<!-- BgsqhkiG9w0BCRABBKCCAWMEggFfMIIBWwIBAQYKKwYBBAGEWQoDATAxMA0GCWCG -->
<!-- SAFlAwQCAQUABCBCMdEOegutzdsQMe6JweIbrsQMSzklT/IkR9JlNZPX9wIGavNL -->
<!-- ROK3GBIyMDI2MTEyMjAxMTgzNy4wMlowBIACAfQCCQDhqscl4UXnNaCB6aSB5jCB -->
<!-- 4zELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1Jl -->
<!-- ZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMk -->
<!-- TWljcm9zb2Z0IElyZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMScwJQYDVQQLEx5u -->
<!-- U2hpZWxkIFRTUyBFU046N0ExQS0wNUUwLUQ5NDcxNTAzBgNVBAMTLE1pY3Jvc29m -->
<!-- dCBQdWJsaWMgUlNBIFRpbWUgU3RhbXBpbmcgQXV0aG9yaXR5oIIPKTCCB4IwggVq -->
<!-- oAMCAQICEzMAAAAF5c8P/2YuyYcAAAAAAAUwDQYJKoZIhvcNAQEMBQAwdzELMAkG -->
<!-- A1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjFIMEYGA1UE -->
<!-- AxM/TWljcm9zb2Z0IElkZW50aXR5IFZlcmlmaWNhdGlvbiBSb290IENlcnRpZmlj -->
<!-- YXRlIEF1dGhvcml0eSAyMDIwMB4XDTIwMTExOTIwMzIzMVoXDTM1MTExOTIwNDIz -->
<!-- MVowYTELMAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv -->
<!-- bjEyMDAGA1UEAxMpTWljcm9zb2Z0IFB1YmxpYyBSU0EgVGltZXN0YW1waW5nIENB -->
<!-- IDIwMjAwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCefOdSY/3gxZ8F -->
<!-- fWO1BiKjHB7X55cz0RMFvWVGR3eRwV1wb3+yq0OXDEqhUhxqoNv6iYWKjkMcLhEF -->
<!-- xvJAeNcLAyT+XdM5i2CgGPGcb95WJLiw7HzLiBKrxmDj1EQB/mG5eEiRBEp7dDGz -->
<!-- xKCnTYocDOcRr9KxqHydajmEkzXHOeRGwU+7qt8Md5l4bVZrXAhK+WSk5CihNQsW -->
<!-- bzT1nRliVDwunuLkX1hyIWXIArCfrKM3+RHh+Sq5RZ8aYyik2r8HxT+l2hmRllBv -->
<!-- E2Wok6IEaAJanHr24qoqFM9WLeBUSudz+qL51HwDYyIDPSQ3SeHtKog0ZubDk4hE -->
<!-- LQSxnfVYXdTGncaBnB60QrEuazvcob9n4yR65pUNBCF5qeA4QwYnilBkfnmeAjRN -->
<!-- 3LVuLr0g0FXkqfYdUmj1fFFhH8k8YBozrEaXnsSL3kdTD01X+4LfIWOuFzTzuosl -->
<!-- BrBILfHNj8RfOxPgjuwNvE6YzauXi4orp4Sm6tF245DaFOSYbWFK5ZgG6cUY2/bU -->
<!-- q3g3bQAqZt65KcaewEJ3ZyNEobv35Nf6xN6FrA6jF9447+NHvCjeWLCQZ3M8lgeC -->
<!-- cnnhTFtyQX3XgCoc6IRXvFOcPVrr3D9RPHCMS6Ckg8wggTrtIVnY8yjbvGOUsAdZ -->
<!-- beXUIQAWMs0d3cRDv09SvwVRd61evQIDAQABo4ICGzCCAhcwDgYDVR0PAQH/BAQD -->
<!-- AgGGMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRraSg6NS9IY0DPe9ivSek+ -->
<!-- 2T3bITBUBgNVHSAETTBLMEkGBFUdIAAwQTA/BggrBgEFBQcCARYzaHR0cDovL3d3 -->
<!-- dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnkuaHRtMBMGA1Ud -->
<!-- JQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMA8GA1Ud -->
<!-- EwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAUyH7SaoUqG8oZmAQHJ89QEE9oqKIwgYQG -->
<!-- A1UdHwR9MHsweaB3oHWGc2h0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMv -->
<!-- Y3JsL01pY3Jvc29mdCUyMElkZW50aXR5JTIwVmVyaWZpY2F0aW9uJTIwUm9vdCUy -->
<!-- MENlcnRpZmljYXRlJTIwQXV0aG9yaXR5JTIwMjAyMC5jcmwwgZQGCCsGAQUFBwEB -->
<!-- BIGHMIGEMIGBBggrBgEFBQcwAoZ1aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3Br -->
<!-- aW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBJZGVudGl0eSUyMFZlcmlmaWNhdGlvbiUy -->
<!-- MFJvb3QlMjBDZXJ0aWZpY2F0ZSUyMEF1dGhvcml0eSUyMDIwMjAuY3J0MA0GCSqG -->
<!-- SIb3DQEBDAUAA4ICAQBfiHbHfm21WhV150x4aPpO4dhEmSUVpbixNDmv6TvuIHv1 -->
<!-- xIs174bNGO/ilWMm+Jx5boAXrJxagRhHQtiFprSjMktTliL4sKZyt2i+SXncM23g -->
<!-- RezzsoOiBhv14YSd1Klnlkzvgs29XNjT+c8hIfPRe9rvVCMPiH7zPZcw5nNjthDQ -->
<!-- +zD563I1nUJ6y59TbXWsuyUsqw7wXZoGzZwijWT5oc6GvD3HDokJY401uhnj3ubB -->
<!-- hbkR83RbfMvmzdp3he2bvIUztSOuFzRqrLfEvsPkVHYnvH1wtYyrt5vShiKheGpX -->
<!-- a2AWpsod4OJyT4/y0dggWi8g/tgbhmQlZqDUf3UqUQsZaLdIu/XSjgoZqDjamzCP -->
<!-- JtOLi2hBwL+KsCh0Nbwc21f5xvPSwym0Ukr4o5sCcMUcSy6TEP7uMV8RX0eH/4JL -->
<!-- EpGyae6Ki8JYg5v4fsNGif1OXHJ2IWG+7zyjTDfkmQ1snFOTgyEX8qBpefQbF0fx -->
<!-- 6URrYiarjmBprwP6ZObwtZXJ23jK3Fg/9uqM3j0P01nzVygTppBabzxPAh/hHhhl -->
<!-- s6kwo3QLJ6No803jUsZcd4JQxiYHHc+Q/wAMcPUnYKv/q2O444LO1+n6j01z5mgg -->
<!-- CSlRwD9faBIySAcA9S8h22hIAcRQqIGEjolCK9F6nK9ZyX4lhthsGHumaABdWzCC -->
<!-- B58wggWHoAMCAQICEzMAAABbSrWNQTJt3HQAAAAAAFswDQYJKoZIhvcNAQEMBQAw -->
<!-- YTELMAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEy -->
<!-- MDAGA1UEAxMpTWljcm9zb2Z0IFB1YmxpYyBSU0EgVGltZXN0YW1waW5nIENBIDIw -->
<!-- MjAwHhcNMjYwMTA4MTg1OTA1WhcNMjcwMTA3MTg1OTA1WjCB4zELMAkGA1UEBhMC -->
<!-- VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV -->
<!-- BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IEly -->
<!-- ZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBF -->
<!-- U046N0ExQS0wNUUwLUQ5NDcxNTAzBgNVBAMTLE1pY3Jvc29mdCBQdWJsaWMgUlNB -->
<!-- IFRpbWUgU3RhbXBpbmcgQXV0aG9yaXR5MIICIjANBgkqhkiG9w0BAQEFAAOCAg8A -->
<!-- MIICCgKCAgEAkFTMFtueUNd57QHQoPkbj/jvm2EXJ9y0LK4RJNZBe+UuLhbH+13a -->
<!-- pR16riJ156DpVaGI4d+7fAlXhNQZJG2qH0JyvUGaIEq/2K4WmAfIgG7lDHfxmzHC -->
<!-- UV5dVL5mokkqddFsM1B1xhKgL/pzSFAn88fnQMFENCQ9dXDIWLMutEf0CWsl5SDs -->
<!-- Ep5PbfN+1Lz8o4ku8QRsc4XqlI5jdlWmtlRZtaNbBFOagdpD8Ty+ta0s3IQn5vTz -->
<!-- 1VbUiStre3gZMHlZvLcIvUrbNicDEEi9p+wowXKP065cdxM8owOgVIx5qYb0wo4x -->
<!-- vq6gbU+N2cOCws/oQ4xFLOssvuMQPWZsH1FJ31+G3L4dCvq9mCwGfqhTL5hOk1Uu -->
<!-- yTB21QzzZZgCQ/O2U63cCIvSrJXv9TeP+6re8cyM8zTDTfjQzns16LSDgEJwy3R1 -->
<!-- uqhz3VWAJvf/fqwdAA2ie2fUc4XaguTzX3RBFLjeKwdWtrwfyx/n4aWohixiIIpf -->
<!-- TgdmI7NlbzbqdUjp377yXJN5aamP3RRr249smFWPATeiHq07nXTJKqZIxIsQ3Tun -->
<!-- cht7cToEBvbD3etbNvbr52lK2FsoXiQCmh+oGxY9fgwS0cpI5+0+ZVMJDju2CGtW -->
<!-- 4eJr2Nj4eyPTWbgpbha2SZWbcvqExkQIxriyMzEBfP5tf8AmFZN7pNkCAwEAAaOC -->
<!-- AcswggHHMB0GA1UdDgQWBBTv8upSVZZiFcl1fCBgrHhvwa/StjAfBgNVHSMEGDAW -->
<!-- gBRraSg6NS9IY0DPe9ivSek+2T3bITBsBgNVHR8EZTBjMGGgX6BdhltodHRwOi8v -->
<!-- d3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNyb3NvZnQlMjBQdWJsaWMl -->
<!-- MjBSU0ElMjBUaW1lc3RhbXBpbmclMjBDQSUyMDIwMjAuY3JsMHkGCCsGAQUFBwEB -->
<!-- BG0wazBpBggrBgEFBQcwAoZdaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9w -->
<!-- cy9jZXJ0cy9NaWNyb3NvZnQlMjBQdWJsaWMlMjBSU0ElMjBUaW1lc3RhbXBpbmcl -->
<!-- MjBDQSUyMDIwMjAuY3J0MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYB -->
<!-- BQUHAwgwDgYDVR0PAQH/BAQDAgeAMGYGA1UdIARfMF0wUQYMKwYBBAGCN0yDfQEB -->
<!-- MEEwPwYIKwYBBQUHAgEWM2h0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMv -->
<!-- RG9jcy9SZXBvc2l0b3J5Lmh0bTAIBgZngQwBBAIwDQYJKoZIhvcNAQEMBQADggIB -->
<!-- AAAf7N35cqHg7FdgxYWa2CKVcBAZy06MJQHXD+4GIL85dwfchrj9dt1SErMVtqJN -->
<!-- sgTq9hkp3Wni7uco4uRrDKYAxXK47stKXqssq21kjIuFaNMrTNc7PS7jEur35tG0 -->
<!-- EQom8DqwPmcnAfUg7rPViLPK4hGhqUwKdutSLF9bFCfhMCY3u326T5fYVROERrd7 -->
<!-- DNHCG0b7HBoBssyTFGZHbgmd9d3VXEqj3T6btbO6i/3pS6DHnBl17CIgibVlZOPi -->
<!-- UIke6nrv0tw5ru0DEkyKlVpKW1Af1+b1M4pzOV/G1a4FwtTh25l+rCCwguwfs8yR -->
<!-- xfXPBDNAPTIC0+GdjP0o0bXbltf6KKU57VLxEeq/ZtsGkylqjiRxS9Ajp0yApG8W -->
<!-- abV4tuFI05CmUMxMYPW01V00aQj3qNS762uhSNYwyLjpNB8EAfG0NOlGEi7/zu8B -->
<!-- VDxnpEeEXF6zPgR3klOFohBEDLoZw78mT5DMPOhnRqtEiQiwYnutmA5UCPH1y1/D -->
<!-- yUf1F+NzAHfB0YFg0w1UmpClRqLZNp11/mlfNNkQciosQXndKsGMh4iehCs/tTlW -->
<!-- VeIxCzF7At0g2sATaXZNHcoGKRv5FBHKBtOnyOPbKILQ0JTAb4r6d2CU3lExteMV -->
<!-- bpoprn1er5vxfMr8Mr4Am2A6keAm/xCuTrYD63A5Us6mMYID1DCCA9ACAQEweDBh -->
<!-- MQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTIw -->
<!-- MAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBUaW1lc3RhbXBpbmcgQ0EgMjAy -->
<!-- MAITMwAAAFtKtY1BMm3cdAAAAAAAWzANBglghkgBZQMEAgEFAKCCAS0wGgYJKoZI -->
<!-- hvcNAQkDMQ0GCyqGSIb3DQEJEAEEMC8GCSqGSIb3DQEJBDEiBCATNMIvlgp1sE0Y -->
<!-- gJjVgD/grEiTL8TaGvFXD7P39nkUzjCB3QYLKoZIhvcNAQkQAi8xgc0wgcowgccw -->
<!-- gaAEIC8xA1VdnRvTHGUbDxf/cgTJs5u5PprlbV3rUJb5wYPvMHwwZaRjMGExCzAJ -->
<!-- BgNVBAYTAlVTMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xMjAwBgNV -->
<!-- BAMTKU1pY3Jvc29mdCBQdWJsaWMgUlNBIFRpbWVzdGFtcGluZyBDQSAyMDIwAhMz -->
<!-- AAAAW0q1jUEybdx0AAAAAABbMCIEIPIO+DlR+IEUZgCgZG3b6skjtri8z0jCSpZx -->
<!-- 0590zj6zMA0GCSqGSIb3DQEBCwUABIICAIJhalxNonJtdIHn1GiJrfFCbaKCM2ii -->
<!-- wBXTe04YNl3ZgsscxU4GwgETm/4HkPg0U/x6pk+xGEv7xjqCWps337ewvOWtW/H4 -->
<!-- PuT426ZXS2daQuJGPkGP+8yA3tdjDRC7Y8gYCg6eQpmKQJY0ns6fSjmU4niZL8wd -->
<!-- nkiCaFnziUr2Hi6U5ci/0sSH2Tv12jv9Pb4MB4Ly70qL0PSBIqbDLChTiado1kWM -->
<!-- HdJUvs+8BUK8InqyUkS+wYszOuMS2IisgIWYOSIDXRoQZFJx1U+LAVIRKYMJLUmP -->
<!-- dlEDmf6HsJd2zoU2yNX9elRXqQ0GWjAvplqa+cAe/Yr6L+jgBJU+O8uvg741VdQ1 -->
<!-- 0T0sraj0tjDgtOpHunrTUdpnf3901jYg0I37yw0iH0AXF/JV7hnm3WYOdJb39LHp -->
<!-- m2Sjohm3W7eXnsD1Oe7JNfUHauxPoaUT7VXC7THjYaJyoUSJcgzVvzGF8Cc27UAc -->
<!-- MSSN/+of0KRfTWySU1DyZLis1LyVyQlEgV2gY8hr/8TyM6w3U/PmJj+X1UTQQIWE -->
<!-- pSCSjyEsbHLHDYCxiOA3VW9bjS6gzZXGGO8BJGVnZy6NHVp0lMCGzSwtthCZcgaX -->
<!-- XjfoEtKKRF7aps8dRHHnVeP0INvNMLQlowf7HNf/lLUBvKx/wkCf6UGC1yW5BFsz -->
<!-- ODptszXFEmSx -->
<!-- SIG # End signature block -->