BcContainerHelper

6.1.20-preview3009061

Bacpac/Restore-DatabasesInNavContainer.ps1

                                <# 

 .Synopsis

  Restore databases in a NAV/BC Container from .bak files

 .Description

  If the Container is multi-tenant, this command will restore an app.bak and a number of tenant databases

  If the Container is single-tenant, this command will restore one .bak file called database.bak.

 .Parameter containerName

  Name of the container in which you want to restore databases

 .Parameter bakFolder

  The folder to which the bak files are exported (default is the container folder c:\programdata\bccontainerhelper\extensions\<containername>)

 .Parameter tenant

  The tenant database(s) to restore, only applies to multi-tenant containers. Omit to restore all tenants

 .Parameter sqlTimeout

  SQL Timeout for database restore operations

 .Example

  Restore-DatabasesInBcContainer -containerName test

 .Example

  Restore-DatabasesInBcContainer -containerName test -tenant @("default")

 .Example

  Restore-DatabasesInBCContainer -containerName test -bakFile C:\ProgramData\bccontainerhelper\mydb.bak -databaseFolder "c:\databases\mydb"

#>

function Restore-DatabasesInBcContainer {

    Param(

        [string] $containerName = $bcContainerHelperConfig.defaultContainerName, 

        [string] $bakFolder = "",

        [string] $bakFile = "",

        [string] $databaseName = "",

        [string[]] $tenant,

        [Parameter(Mandatory=$false)]

        [string] $databaseFolder = "c:\databases",

        [int] $sqlTimeout = 300

    )

$telemetryScope = InitTelemetryScope -name $MyInvocation.InvocationName -parameterValues $PSBoundParameters -includeParameters @()

try {

    $containerBakFile = ""

    $containerBakFolder = ""

    if ($bakFile) {

        if ($bakFolder) {

            throw "You cannot specify bakFolder when you specify bakFile"

        }

        if ($tenant) {

            throw "You cannot specify tenant when you specify bakFile"

        }

        $containerBakFile = Get-BcContainerPath -containerName $containerName -path $bakFile -throw

        if (-not $databaseName) {

            $databaseName = [System.IO.Path]::GetFileNameWithoutExtension($bakFile)

        }

    }

    elseif ($databaseName) {

        throw "You need to specify bakFile when you specify databaseName"

    }

    else {

        $containerFolder = Join-Path $bcContainerHelperConfig.hostHelperFolder "Extensions\$containerName"

        if ("$bakFolder" -eq "") {

            $bakFolder = $containerFolder

        }

        elseif (!$bakFolder.Contains('\')) {

            $navversion = Get-BcContainerNavversion -containerOrImageName $containerName

            $inspect = docker inspect $containerName | ConvertFrom-Json

            $isBcSandbox = $inspect.Config.Env | Where-Object { $_ -eq "IsBcSandbox=Y" }

            if ($isBcSandbox) {

                $folderPrefix = "sandbox"

            }

            else {

                $folderPrefix = "onprem"

            }

            $bakFolder = Join-Path $bcContainerHelperConfig.hostHelperFolder "$folderPrefix-$NavVersion-bakFolders\$bakFolder"

        }

        $containerBakFolder = Get-BcContainerPath -containerName $containerName -path $bakFolder -throw

    }

    Invoke-ScriptInBCContainer -containerName $containerName -scriptblock { Param($bakFolder, $bakFile, $databaseName, $tenant, $databaseFolder, $sqlTimeout)

        function Restore {

            Param (

                [string] $databaseServer,

                [string] $databaseInstance,

                [string] $databaseName,

                [string] $bakFile,

                [string] $databaseFolder,

                [int] $sqlTimeout

            )

            if (!(Test-Path -Path $bakFile -PathType Leaf)) {

                throw "Database backup $bakFile not found"

            }

            if (Test-NavDatabase -DatabaseServer $databaseServer `

                                 -DatabaseInstance $databaseInstance `

                                 -DatabaseName $databaseName) {

                Remove-NavDatabase -DatabaseServer $databaseServer `

                                   -DatabaseInstance $databaseInstance `

                                   -DatabaseName $databaseName

            }

            Write-Host "Restoring $bakFile to $databaseName"

            New-NAVDatabase -DatabaseServer $databaseServer `

                            -DatabaseInstance $databaseInstance `

                            -DatabaseName $databaseName `

                            -FilePath $bakFile `

                            -DestinationPath $databaseFolder `

                            -Timeout $SqlTimeout | Out-Null

        }

        $customConfigFile = Join-Path (Get-Item "C:\Program Files\Microsoft Dynamics NAV\*\Service").FullName "CustomSettings.config"

        [xml]$customConfig = [System.IO.File]::ReadAllText($customConfigFile)

        $multitenant = ($customConfig.SelectSingleNode("//appSettings/add[@key='Multitenant']").Value -eq "true")

        $databaseServer = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseServer']").Value

        $databaseInstance = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseInstance']").Value

        if ($bakFile) {

            Restore -databaseServer $databaseServer -databaseInstance $databaseInstance -databaseName $DatabaseName -bakFile $bakFile -databaseFolder $databaseFolder -sqlTimeout $sqlTimeout

        }

        else {

            $databaseName = $customConfig.SelectSingleNode("//appSettings/add[@key='DatabaseName']").Value

            if ($multitenant -and !($tenant)) {

                $tenant = @(get-navtenant $serverInstance | % { $_.Id }) + "tenant"

            }

            Set-NavServerInstance -ServerInstance $serverInstance -stop

            if ($multitenant) {

                Restore -databaseServer $databaseServer -databaseInstance $databaseInstance -databaseName $DatabaseName -bakFile (Join-Path $bakFolder "app.bak") -databaseFolder $databaseFolder -sqlTimeout $sqlTimeout

                $tenant | ForEach-Object {

                    Restore -databaseServer $databaseServer -databaseInstance $databaseInstance -databaseName $_ -bakFile (Join-Path $bakFolder "$_.bak") -databaseFolder $databaseFolder -sqlTimeout $sqlTimeout

                }

            } else {

                Restore -databaseServer $databaseServer -databaseInstance $databaseInstance -databaseName $DatabaseName -bakFile (Join-Path $bakFolder "database.bak") -databaseFolder $databaseFolder -sqlTimeout $sqlTimeout

            }

            Set-NavServerInstance -ServerInstance $serverInstance -start

            $boo = $true

            while (Get-NAVServerInstance | Get-NavTenant | Where-Object { $_.State -eq "Mounting" }) {

                if ($boo) { Write-Host "Waiting for tenants to be mounted"; $boo = $false }

                Start-Sleep -Seconds 1

            }

        }

    } -argumentList $containerBakFolder, $containerBakFile, $databaseName, $tenant, $databaseFolder, $sqlTimeout

    if (Test-Path -Path "C:\ProgramData\BcContainerHelper\Extensions\$containerName\PsTestTool-*") {

        Get-Item -Path "C:\ProgramData\BcContainerHelper\Extensions\$containerName\PsTestTool-*" | % {

            Remove-Item -Path $_.FullName -Force -Recurse

        }

    }

}

catch {

    TrackException -telemetryScope $telemetryScope -errorRecord $_

    throw

}

finally {

    TrackTrace -telemetryScope $telemetryScope

}

}

Set-Alias -Name Restore-DatabasesInNavContainer -Value Restore-DatabasesInBcContainer

Export-ModuleMember -Function Restore-DatabasesInBcContainer -Alias Restore-DatabasesInNavContainer

# SIG # Begin signature block

# MIIncAYJKoZIhvcNAQcCoIInYTCCJ10CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCBQoekGl7zPjxg+

# ddJuLwvymk/UCPRwDXgh5gXYiITIhKCCDMkwggYEMIID7KADAgECAhMzAAACHPrN

# xZvoL37EAAAAAAIcMA0GCSqGSIb3DQEBCwUAMFcxCzAJBgNVBAYTAlVTMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBD

# b2RlIFNpZ25pbmcgUENBIDIwMjQwHhcNMjYwNDE2MTg1OTQxWhcNMjcwNDE1MTg1

# OTQxWjB0MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYD

# VQQDExVNaWNyb3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IB

# DwAwggEKAoIBAQDVsZfgOKmM31HPfoWOoNEiw0SlCiIxUMC0I9NMWbucKOw/e9lP

# oAoehQVu6SG65V4EPzrYsnBnFPNoi4/HoOdjhz1qkrEt4I6tEcxXU6oOeY9zGveC

# /3iBeuhLYxM3M/PkcUoebF+Nednm8OkdSPoDu8imViHPQq/8CQUu0WRR4rE+dMRf

# rpVqfmNi2qWCX94T4MsepijGVkwE//tJg0ryAiYdHT34LSnlG/RSBZmQRGWZ5g8j

# qnKjRParSqMft1gvjuUTVgtWNZfgcLFSK5Wa0myrq8OPcgTGGsRgun+tnSS+IxDT

# xVsAPH1OzvPjwomguByhUe/OcvUN0D5Wmp7xAgMBAAGjggGqMIIBpjAOBgNVHQ8B

# Af8EBAMCB4AwHwYDVR0lBBgwFgYKKwYBBAGCN0wIAQYIKwYBBQUHAwMwHQYDVR0O

# BBYEFNoH7a2YDjOSwpkp6DHcmUS7J+0yMFQGA1UdEQRNMEukSTBHMS0wKwYDVQQL

# EyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxFjAUBgNVBAUT

# DTIzMDAxMis1MDc1NjkwHwYDVR0jBBgwFoAUf1k/VCHarU/vBeXmo9ctBpQSCDEw

# YAYDVR0fBFkwVzBVoFOgUYZPaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9w

# cy9jcmwvTWljcm9zb2Z0JTIwQ29kZSUyMFNpZ25pbmclMjBQQ0ElMjAyMDI0LmNy

# bDBtBggrBgEFBQcBAQRhMF8wXQYIKwYBBQUHMAKGUWh0dHA6Ly93d3cubWljcm9z

# b2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwQ29kZSUyMFNpZ25pbmcl

# MjBQQ0ElMjAyMDI0LmNydDAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBCwUAA4IC

# AQAUnEqhaRXe0T3hIJjvdQErEkrA/7bByjn6t5IArODkkRjzkYwtKMc2yYj2quaN

# rLutWw2YZcngKPy1b71YyDJQTy4NDRwaSh9Tw5thrk3NmcPrAHia5vtcBJ1CgtKK

# 7mQbIcQ22d/N3813ayCDDFewu1+jsZmX+r/aTEqaOM4TVxVtRSkuCy8nAXKuChOK

# Li/zA4XuH8iEYqIsj2YoNaeSxVmeGiERXpKdo3dDmYi0kO5w2D8VS4c3+9h6gElY

# BaAAg/dYErBg27qT3vv0zRDJhJufvCNylA8S7/+8H5E/PV5cng6na9VV/w9OV3qu

# uND6zdGa2EX38Glp50F9AIQk3p2xXmcvorDeM4XJ7UlWYBi6g80J1SSOQnInCYFE

# msfUNn3+1AaTJKSJL83quKArTac2pKhu0Yzzzrzo6HrsRiQKzpnRBb1/dMa6P3hz

# 75XbMRBctNsFhZC07WCmjExdLg2eHW5uV0TY8D5+6wozJf7vF3+WHkYPO85Z+BC6

# U4FkNbYNycZ9cE4j1tXRdyDCfml6c0HWPHjNVDObrv9lKt3qUqFpX38VCqVCyNOO

# 1UcXfQiVjJw32U2WUKZjt/neJKHEBsm9kFsLuWzkQ53+qcaSaytmsCnk2gOglrlD

# 5d3kKyvvAw+rzm0lT8K38P6PLxfZQHhu4W8dV7Av8N2ZmDCCBr0wggSloAMCAQIC

# EzMAAAA5O7Y3Gb8GHWcAAAAAADkwDQYJKoZIhvcNAQEMBQAwgYgxCzAJBgNVBAYT

# AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBS

# b290IENlcnRpZmljYXRlIEF1dGhvcml0eSAyMDExMB4XDTI0MDgwODIwNTQxOFoX

# DTM2MDMyMjIyMTMwNFowVzELMAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29m

# dCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9zb2Z0IENvZGUgU2lnbmluZyBQ

# Q0EgMjAyNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBANgBnB7jOMeq

# lRYHNa265v4IY9fH8TKhemHfPINe1gpLaV3dhg324WwH06LcHbpnsBukCDNitryo

# 0dtS/EW6I/yEL/bLSY8hKpbfQuWusBPr9qazYcDxCW/qnjb5JsI1s8bNOg3bVATv

# QVL4tcf03aTycsz8QeCdM0l/yHRObJ9QqazM1r6VPEOJ7LL+uEEb73w6QCuhs89a

# 1uv1zerOYMnsneRRwCbpyW11IcggU0cRKDDq1pjVJzIbIF6+oiXXbReOsgeI8zu1

# FyQfK0fVkaya8SmVHQ/tOf23mZ4W9k0Ri22QW9p3UgSC5OUDktKxxcCmGL6tXLfO

# GSWHIIV4YrTJTT6PNty5REojHJuZHArkF9VnHTERWoTjAzfI3kP+5b4alUdhgAZ7

# ttOu1bVnXfHaqPYl2rPs20ji03LOVWsh/radgE17es5hL+t6lV0eVHrVhsssROWJ

# uz2MXMCt7iw7lFPG9LXKGjsmonn2gotGdHIuEg5JnJMJVmixd5LRlkmgYRZKzhxS

# CwyoGIq0PhaA7Y+VPct5pCHkijcIIDm0nlkK+0KyepolcqGm0T/GYQRMhHJlGOOm

# VQop36wUVUYklUy++vDWeEgEo4s7hxN6mIbf2MSIQ/iIfMZgJxC69oukMUXCrOC3

# SkE/xIkgpfl22MM1itkZ35nNXkMolU1lAgMBAAGjggFOMIIBSjAOBgNVHQ8BAf8E

# BAMCAYYwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFH9ZP1Qh2q1P7wXl5qPX

# LQaUEggxMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMA8GA1UdEwEB/wQFMAMB

# Af8wHwYDVR0jBBgwFoAUci06AjGQQ7kUBU7h6qfHMdEjiTQwWgYDVR0fBFMwUTBP

# oE2gS4ZJaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMv

# TWljUm9vQ2VyQXV0MjAxMV8yMDExXzAzXzIyLmNybDBeBggrBgEFBQcBAQRSMFAw

# TgYIKwYBBQUHMAKGQmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMv

# TWljUm9vQ2VyQXV0MjAxMV8yMDExXzAzXzIyLmNydDANBgkqhkiG9w0BAQwFAAOC

# AgEAFJQfOChP7onn6fLIMKrSlN1WYKwDFgAddymOUO3FrM8d7B/W/iQ6DxXsDn7D

# 5W4wMwYeLystcEqfkjz4NURRgazyMu5yRzQh4LqjA4tStTcJh1opExo7nn5PuPBY

# nbu0+THSuVHTe0VTTPVhily/piFrDo3axQ9P4C+Ol5yet+2gTfekICS5xS+cYfSI

# vgn0JksVBVMYVI5QFu/qhnLhsEFEUzG8fvv0hjgkO+lkpV9ty6GkN4vdnd7ya6Q6

# aR9y34aiM1qmxaxBi6OUnyNl6fkuun/diTFnYDLTppOkr/mg5WSfCiDVMNCxtj4w

# PKC5OmHm1DQIt/MNokbbH3UGsFP1QbzsLocuSqLCvH09Io3fDPTmscR9Y75G4qX7

# RTX8AdBPo0I6OEojf39zuFZt0qOHm65YWQE69cZM2ueE1MB05dNNgHK9gTE7zKvK

# /fg8B2qjW88MT/WF5V5uvZGtqa9FSL2RazArA+rDPuf6JGYz4HpgMZHB4S6szWSK

# YBv0VisCzfxgeU+dquXW9bd0auYlOB58DPcOYKdc3Se94g+xL4pcEhbB54JOgAkw

# YTu/9dLeH2pDqeJZAABVDWRQCaXfO5LgyKwKCLYXpigrZYCjUSBcr+Ve8PFWMhVT

# Ql0v4q8J/AUmQN5W4n101cY2L4A7GTQG1h32HHAvfQESWP0xghn9MIIZ+QIBATBu

# MFcxCzAJBgNVBAYTAlVTMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24x

# KDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMjQCEzMAAAIc

# +s3Fm+gvfsQAAAAAAhwwDQYJYIZIAWUDBAIBBQCgga4wGQYJKoZIhvcNAQkDMQwG

# CisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZI

# hvcNAQkEMSIEIPpGGOGjN+TMvCf52lPE3Ezb68QI0DPKkoiCSklMtjF4MEIGCisG

# AQQBgjcCAQwxNDAyoBSAEgBNAGkAYwByAG8AcwBvAGYAdKEagBhodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20wDQYJKoZIhvcNAQEBBQAEggEAsL6s2n8g7upp8vZ819TV

# c1yGXw7L50Z6MVvc2n8OuCwwepHnXI5amytkQrkXMha9KHe6tZzAU04PnRLfcQXK

# UHMjlF3i4uB6ZVVIjjiXI5GQUhclwotdDmDEP+nwLW39Ru9tASbdFKOXhOqamESo

# KpJQIJL1dA5bLsa9Ed5UYyZh81b6Jp7PC17xxyJ5iMsrZM/xYFK1z7LOsahtuq50

# 4fotBrfBwmXMfoxk4MFCJl1T2vHvC7ZIF1ZJG8OdsHsrRY8MmGP9+9ohccTbcB7F

# S8+oEeL/7D3RbcnxRnWP2fRS5/rk8XtuA+awtduWmyD/2QVK0C2BstD6e+QX96Of

# fqGCF68wgherBgorBgEEAYI3AwMBMYIXmzCCF5cGCSqGSIb3DQEHAqCCF4gwgheE

# AgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFaBgsqhkiG9w0BCRABBKCCAUkEggFFMIIB

# QQIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFlAwQCAQUABCDlpMVyzLmuNlkmvfZZ

# mlbqULVl7K1IVLmUTWqr97r8oAIGauvjhJ5VGBMyMDI2MTEwNTEwMjA0OS4zMDNa

# MASAAgH0oIHZpIHWMIHTMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0

# ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjo1OTFBLTA1RTAtRDk0NzElMCMG

# A1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaCCEf0wggcoMIIFEKAD

# AgECAhMzAAACOPeExYQrvuTkAAEAAAI4MA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29m

# dCBUaW1lLVN0YW1wIFBDQSAyMDEwMB4XDTI2MTAxNTE4Mzc0N1oXDTI4MDExMTE4

# Mzc0N1owgdMxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD

# VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xLTAr

# BgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJhdGlvbnMgTGltaXRlZDEnMCUG

# A1UECxMeblNoaWVsZCBUU1MgRVNOOjU5MUEtMDVFMC1EOTQ3MSUwIwYDVQQDExxN

# aWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNlMIICIjANBgkqhkiG9w0BAQEFAAOC

# Ag8AMIICCgKCAgEA2MOivQEGtNYbHgPy00WxDXNmTiCuVc4GmuX93fCp++unuNZb

# Jiapk46/m7ew099uVq+gGyxjONiUyhtz2RT7nUeZJfH+XRdestUV+ARUZKwfza81

# YtaoCggv2b6G74j2xjv+Vlzjghxm52ur6th3/O3x/QP01fU48MNYhzmWSt89Poo8

# RfazS22BbccRgznMI//jSlcj9O3EnmJiwvN2WYpdJQ11nKZlJv8P+kBPdDp80IT5

# ew1ESWdIVol/IdOQ0RiMEkLG9dEU2LyAj/DUDLw3DHrjev+TdhJJ3UloT0orv/0D

# ic2onOLqKtV56HC/tzrEYNMbJU6PCfQ4jmd6S+wfp+QP0xk95evu7OJ331eYmKCe

# ANmI/vkFS1R72sEcQr5kUKLgY+7ZgLVTm88hHb7W3bLVn+2mPta49ZYQoap2mJHT

# WA8EaMVUh8hX/WTAvDyCD6ImqPWtEQFS40ZyTIrZkCiwnhY+3Pg1HmEfrFHsBuHv

# AVQlKel6x/NPAHPnysDtlLlJWfFbVPZ76pCA9X0DKMQZq9a/wJtdK7ij7TVXn+3F

# DPt3h1PPJbazRkrkNfI/ZxG+0ZsRXHhZ+LjgMaIfNru6h70Qis5p9shoXniwDBqE

# 6FLM44OUyYCaIdu7lR61s0QPD4zxoudVtMSK9Trzi/St5ljBwIpoUKv1wTECAwEA

# AaOCAUkwggFFMB0GA1UdDgQWBBRNlXqM3IU6RTBleg/8dkZfV0LsujAfBgNVHSME

# GDAWgBSfpxVdAF5iXYP05dJlpxtTNRnpcjBfBgNVHR8EWDBWMFSgUqBQhk5odHRw

# Oi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNyb3NvZnQlMjBUaW1l

# LVN0YW1wJTIwUENBJTIwMjAxMCgxKS5jcmwwbAYIKwYBBQUHAQEEYDBeMFwGCCsG

# AQUFBzAChlBodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01p

# Y3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0ElMjAyMDEwKDEpLmNydDAMBgNVHRMB

# Af8EAjAAMBYGA1UdJQEB/wQMMAoGCCsGAQUFBwMIMA4GA1UdDwEB/wQEAwIHgDAN

# BgkqhkiG9w0BAQsFAAOCAgEAYOPgwQS3fsWuTAjWtVEfANixy5SxCbC0tCBEuTHH

# r17RVpCrxUtLq+medVrelcLCe2nlnCtsb8wAmt8S0A7NjTBUp8TAMgqTTeW+ILam

# zRZhAtCtk9mvlzPGn29flXKNiV7Ag39A5LH97/2MbKG2KprF6F1BUtQO0Lw6Vg0T

# U9tZh3weqDzBp5M+WY0tV9cj9hTO9A9RnJNWjLkVW5+a1igErtUaPEj7j6jtT7MJ

# iecBO7Me1uMf8dU1lzdyX60S2nsVlHgSi/g6LQbZvIUYNwcWPWDIBloPxXS5uXdr

# Hen4nd33GYsszLBUo/WNy+rxdWwGkPyMFeZDMEnMfFpW6U2S+rWvY2cTGkOi0x7K

# 6b24eHNXBXJDahLfwV4g+11y2uKVJqhlpJrrCJb6FtCb8TMuzaDh5LVPkjVwhRJW

# dCbJ4NuqRawgVQ0uejIFdqQtkFXRq3ZoePoNym1vAm0P1/r2rmpiXlTuk8B/sUxa

# f/9VCa0VV3lBeoYZh+1j6ODgbZpymM8FcZtkDt4NDzXTQTbhceBZR0Og0v50IIAL

# inMkFfOehpsHA6YAHQTaAZja3VXs0GWuCfguVo3S7gXiFJGij34VSfreEZHNocpO

# rj6mKmDto+Wn4m2KQFPJn5fZAe3b2i2/WNnIroOCxRMI24NkJpRc+9e/vSk2ai1S

# piEwggdxMIIFWaADAgECAhMzAAAAFcXna54Cm0mZAAAAAAAVMA0GCSqGSIb3DQEB

# CwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTIwMAYD

# VQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAxMDAe

# Fw0yMTA5MzAxODIyMjVaFw0zMDA5MzAxODMyMjVaMHwxCzAJBgNVBAYTAlVTMRMw

# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN

# aWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0

# YW1wIFBDQSAyMDEwMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA5OGm

# TOe0ciELeaLL1yR5vQ7VgtP97pwHB9KpbE51yMo1V/YBf2xK4OK9uT4XYDP/XE/H

# ZveVU3Fa4n5KWv64NmeFRiMMtY0Tz3cywBAY6GB9alKDRLemjkZrBxTzxXb1hlDc

# wUTIcVxRMTegCjhuje3XD9gmU3w5YQJ6xKr9cmmvHaus9ja+NSZk2pg7uhp7M62A

# W36MEBydUv626GIl3GoPz130/o5Tz9bshVZN7928jaTjkY+yOSxRnOlwaQ3KNi1w

# jjHINSi947SHJMPgyY9+tVSP3PoFVZhtaDuaRr3tpK56KTesy+uDRedGbsoy1cCG

# MFxPLOJiss254o2I5JasAUq7vnGpF1tnYN74kpEeHT39IM9zfUGaRnXNxF803RKJ

# 1v2lIH1+/NmeRd+2ci/bfV+AutuqfjbsNkz2K26oElHovwUDo9Fzpk03dJQcNIIP

# 8BDyt0cY7afomXw/TNuvXsLz1dhzPUNOwTM5TI4CvEJoLhDqhFFG4tG9ahhaYQFz

# ymeiXtcodgLiMxhy16cg8ML6EgrXY28MyTZki1ugpoMhXV8wdJGUlNi5UPkLiWHz

# NgY1GIRH29wb0f2y1BzFa/ZcUlFdEtsluq9QBXpsxREdcu+N+VLEhReTwDwV2xo3

# xwgVGD94q0W29R6HXtqPnhZyacaue7e3PmriLq0CAwEAAaOCAd0wggHZMBIGCSsG

# AQQBgjcVAQQFAgMBAAEwIwYJKwYBBAGCNxUCBBYEFCqnUv5kxJq+gpE8RjUpzxD/

# LwTuMB0GA1UdDgQWBBSfpxVdAF5iXYP05dJlpxtTNRnpcjBcBgNVHSAEVTBTMFEG

# DCsGAQQBgjdMg30BATBBMD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29m

# dC5jb20vcGtpb3BzL0RvY3MvUmVwb3NpdG9yeS5odG0wEwYDVR0lBAwwCgYIKwYB

# BQUHAwgwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0PBAQDAgGGMA8G

# A1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9lJBb186aGMQw

# VgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9j

# cmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3JsMFoGCCsGAQUF

# BwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3Br

# aS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwDQYJKoZIhvcNAQEL

# BQADggIBAJ1VffwqreEsH2cBMSRb4Z5yS/ypb+pcFLY+TkdkeLEGk5c9MTO1OdfC

# cTY/2mRsfNB1OW27DzHkwo/7bNGhlBgi7ulmZzpTTd2YurYeeNg2LpypglYAA7AF

# vonoaeC6Ce5732pvvinLbtg/SHUB2RjebYIM9W0jVOR4U3UkV7ndn/OOPcbzaN9l

# 9qRWqveVtihVJ9AkvUCgvxm2EhIRXT0n4ECWOKz3+SmJw7wXsFSFQrP8DJ6LGYnn

# 8AtqgcKBGUIZUnWKNsIdw2FzLixre24/LAl4FOmRsqlb30mjdAy87JGA0j3mSj5m

# O0+7hvoyGtmW9I/2kQH2zsZ0/fZMcm8Qq3UwxTSwethQ/gpY3UA8x1RtnWN0SCyx

# TkctwRQEcb9k+SS+c23Kjgm9swFXSVRk2XPXfx5bRAGOWhmRaw2fpCjcZxkoJLo4

# S5pu+yFUa2pFEUep8beuyOiJXk+d0tBMdrVXVAmxaQFEfnyhYWxz/gq77EFmPWn9

# y8FBSX5+k77L+DvktxW/tM4+pTFRhLy/AsGConsXHRWJjXD+57XQKBqJC4822rpM

# +Zv/Cuk0+CQ1ZyvgDbjmjJnW4SLq8CdCPSWU5nR0W2rRnj7tfqAxM328y+l7vzhw

# RNGQ8cirOoo6CGJ/2XBjU02N7oJtpQUQwXEGahC0HVUzWLOhcGbyoYIDWDCCAkAC

# AQEwggEBoYHZpIHWMIHTMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0

# ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjo1OTFBLTA1RTAtRDk0NzElMCMG

# A1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIjCgEBMAcGBSsOAwIa

# AxUAXPgoYQ+rQcHbG0c5gV8e8Qwz2+WggYMwgYCkfjB8MQswCQYDVQQGEwJVUzET

# MBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMV

# TWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1T

# dGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQsFAAIFAO6WYfwwIhgPMjAyNjExMDUw

# MjAxMzJaGA8yMDI2MTEwNjAyMDEzMlowdjA8BgorBgEEAYRZCgQBMS4wLDAKAgUA

# 7pZh/AIBADAJAgEAAgEQAgH/MAcCAQACAhA/MAoCBQDul7N8AgEAMDYGCisGAQQB

# hFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEAAgMHoSChCjAIAgEAAgMBhqAw

# DQYJKoZIhvcNAQELBQADggEBAHj2LTeoMyavLW5Z/qPz6CimckZjsjAT0VxmR2a7

# uXLTgTLnmA4oO4gQBC5HILUV1QOv+SyerwVTCk+bNss9OezCtaPUurmYP8LDBN8h

# 9eEWF8F9vMhdkY0kCRBlbITnmcI+SJsZ1x3O1LhznHJ804+NJDMn/wrOK8EhEJ5P

# x0viLEguH5mpTXSx5GQ7y3gjMBncOe4tLYORw2hpnZUANUnS8z8LpsqVvYoKGg4B

# owEfvmu3lDRPJsSKcF2UJly8zkbK2JPoQaL+XnrInbA6WssEKVpjPiYeefa5c+EX

# 3Efwo7mbN8xTMv5buMnH677hhoAHGNSkGVzDynpX5mg8RN4xggQNMIIECQIBATCB

# kzB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMAITMwAAAjj3hMWEK77k5AAB

# AAACODANBglghkgBZQMEAgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJ

# EAEEMC8GCSqGSIb3DQEJBDEiBCCcrhCRsriAmDzywejhJ2MlM0pY+DhhdPWuSyLF

# ZJz++jCB+gYLKoZIhvcNAQkQAi8xgeowgecwgeQwgb0EIA56xCA0DqqhO7f128Pw

# Q+63r8p/rY2B0q5Y8YtbCeK1MIGYMIGApH4wfDELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAg

# UENBIDIwMTACEzMAAAI494TFhCu+5OQAAQAAAjgwIgQgu0LqzWe0F1Yr6s905I8H

# yEwRA0y42wAedB7xWbHaf3MwDQYJKoZIhvcNAQELBQAEggIAKeZGnu0y1mu6RB7v

# os/Lp4YrVvX/5i/cwdiK6Vlv9RwzFoaZB+tpsCRa0fiYZpu9KtneIs7VOeiUoIxG

# as/x8dVdQlfmtJOl02775Q0UkgjbCPWQMVKkwbGcKkOe2OqJvGNq1iuG83P/B/AB

# QV93eym1kd28eGkvPAibkAehauEoa0JK7aCscEM0sTMOOOjVI1JEy2VqYg4bpvYz

# OVoaelEcJZCrDOA+fFUY1dTtltV5Mfmn+M7nKYEFK/vJ7iuad4Sw4P2CPSMYMrSt

# x47Gq0A/lLs3WwhoYzFsdep6AfOjadH6JmC0B4YpDtAKOPWDdplgrDLOQKo47YpX

# TlNdpOjC9N8vcBORhZpAulIO0ZO4iOBGL+ssaaHoR85tlClASsVfCYsVrx9dxhkr

# w5nW3HmsXLFu5llIJDA+BOcScSUuuIF8R0YkZtNhKXspVGn6E6J1qJ1Rwq76evZc

# 4nxv885c+FBAQWI7DHoe2Cj9ZXb1RDjiCY0mSYCzeVyW+PSUtOln4mPbg1IQVqya

# N02uKkDdXVrjMi7AGELz/BXqXZ5tLitopUYVRmwIqGQzt+yttnibN1AdAio80fo0

# /vGhkt4MJKfD4/pYlXkV882k4sUZdNBMjBVFe8uVzxkYxI7AOnxf2mkuENxnETMM

# 13EZqehBYzVstwV2V/Hm4vVZ4e4=

# SIG # End signature block