SetupHtml.sql

--------------------------------------------------------------------------------------
-- Installs EMAIL.QueryToHtml, EMAIL.ConCatHtml and EMAIL.CustomSendMailHelp in the
-- current database, replacing an earlier version. Run it in the database you want them
-- in, as a sysadmin: it adds the assembly to the server's trusted assemblies.
--
-- The assembly is SAFE, so it runs on SQL Server 2017 or later on Windows or Linux. Send
-- the HTML with Database Mail (msdb.dbo.sp_send_dbmail), or on Windows with
-- EMAIL.CLRSendMail from SetupSendMail.sql. Version 1 is the v1-article tag.
--
-- SetupHtml.sql is generated from SetupHtml.template.sql by tools/SetupScript; edit the template.
-- Sources: 0e74b813aa52a8708624b3796911a922e1cff5788bcbf3f6dd0a5d28ff162c84
--------------------------------------------------------------------------------------
SET NOCOUNT ON;
GO
--------------------------------------------------------------------------------------
-- Stop here, installing nothing, if the server can't run the assembly
--------------------------------------------------------------------------------------
IF CAST(SERVERPROPERTY('EngineEdition') AS int) = 5
BEGIN
    RAISERROR(N'Azure SQL Database doesn''t run CLR assemblies. QueryToHtml needs SQL Server 2017 or later, or Azure SQL Managed Instance.', 16, 1);
    SET NOEXEC ON;
END
ELSE IF ISNULL(CAST(SERVERPROPERTY('ProductMajorVersion') AS int), 0) < 14
BEGIN
    RAISERROR(N'QueryToHtml needs SQL Server 2017 or later. For earlier versions, use the v1-article tag of the repository.', 16, 1);
    SET NOEXEC ON;
END
ELSE IF IS_SRVROLEMEMBER(N'sysadmin') = 0
BEGIN
    RAISERROR(N'SetupHtml.sql adds the assembly to the server''s trusted assemblies, which needs a member of sysadmin.', 16, 1);
    SET NOEXEC ON;
END
ELSE IF (SELECT value_in_use FROM sys.configurations WHERE name = N'clr enabled') = 0
    PRINT N'CLR is disabled on this server. The functions are installed, but run only after: EXEC sp_configure ''clr enabled'', 1; RECONFIGURE;';
GO
--------------------------------------------------------------------------------------
-- Remove an earlier version: this assembly, and the HTML functions version 1 had in
-- its assembly SimpleTalk.SQLCLR.SendMail
--------------------------------------------------------------------------------------
DECLARE @drop nvarchar(max) =
(
    SELECT STRING_AGG(CAST(N'DROP FUNCTION ' + QUOTENAME(SCHEMA_NAME(o.schema_id)) + N'.' + QUOTENAME(o.name) + N';' AS nvarchar(max)), NCHAR(10))
    FROM sys.assembly_modules AS m
         JOIN sys.objects AS o ON o.object_id = m.object_id
         JOIN sys.assemblies AS a ON a.assembly_id = m.assembly_id
    WHERE a.name = N'SimpleTalk.SQLCLR.Html'
          OR (a.name = N'SimpleTalk.SQLCLR.SendMail' AND o.name IN (N'QueryToHtml', N'ConCatHtml', N'CustomSendMailHelp', N'CleanMemory'))
);
IF @drop IS NOT NULL
    EXEC sys.sp_executesql @drop;
IF EXISTS (SELECT * FROM sys.assemblies WHERE name = N'SimpleTalk.SQLCLR.Html')
    DROP ASSEMBLY [SimpleTalk.SQLCLR.Html];
IF SCHEMA_ID(N'EMAIL') IS NULL
    EXEC sys.sp_executesql N'CREATE SCHEMA EMAIL';
GO
--------------------------------------------------------------------------------------
-- Trust this build of the assembly. SQL Server 2017's "clr strict security" loads only
-- trusted assemblies, and a trusted assembly needs no key, certificate or login. Earlier
-- builds' hashes are removed once no database uses them.
--------------------------------------------------------------------------------------
DECLARE @hash varbinary(64) = 0xCD619D4442E3C39DE2DAF404D64A5E474B57372B9C4BBEB2928895B07ADFF0A008B2F5DA8A94318449035AD86E89692DF58B9932E4071C17CA460FB12D97DCB9;

-- The builds of the assembly each database has
DECLARE @used TABLE (hash varbinary(64));
DECLARE @sql nvarchar(max) =
(
    SELECT STRING_AGG(CAST(N'SELECT HASHBYTES(''SHA2_512'', f.content) FROM ' + QUOTENAME(name) + N'.sys.assemblies AS a JOIN '
                           + QUOTENAME(name) + N'.sys.assembly_files AS f ON f.assembly_id = a.assembly_id AND f.file_id = 1'
                           + N' WHERE a.name = N''SimpleTalk.SQLCLR.Html''' AS nvarchar(max)), N' UNION ALL ')
    FROM sys.databases
    WHERE state = 0 AND HAS_DBACCESS(name) = 1
);
INSERT INTO @used EXEC sys.sp_executesql @sql;

DECLARE @stale nvarchar(max) =
(
    SELECT STRING_AGG(CAST(N'EXEC sys.sp_drop_trusted_assembly @hash = ' + CONVERT(nvarchar(max), t.hash, 1) + N';' AS nvarchar(max)), NCHAR(10))
    FROM sys.trusted_assemblies AS t
    WHERE t.description LIKE N'simpletalk.sqlclr.html,%'
          AND t.hash <> @hash
          AND NOT EXISTS (SELECT * FROM @used AS u WHERE u.hash = t.hash)
);
IF @stale IS NOT NULL
    EXEC sys.sp_executesql @stale;

IF NOT EXISTS (SELECT * FROM sys.trusted_assemblies WHERE hash = @hash)
    EXEC sys.sp_add_trusted_assembly @hash = @hash, @description = N'simpletalk.sqlclr.html, version=2.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil';
GO
--------------------------------------------------------------------------------------
-- The assembly and its functions
--------------------------------------------------------------------------------------
CREATE ASSEMBLY [SimpleTalk.SQLCLR.Html]
    AUTHORIZATION [dbo]
    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103002569BBE80000000000000000E00022200B013000006800000008000000000000928700000020000000A000000000001000200000000200000400000000000000060000000000000000E000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000408700004F00000000A000005C0400000000000000000000000000000000000000C000000C000000248700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000098670000002000000068000000020000000000000000000000000000200000602E727372630000005C04000000A0000000060000006A0000000000000000000000000000400000402E72656C6F6300000C00000000C000000002000000700000000000000000000000000000400000420000000000000000000000000000000074870000000000004800000002000500A4370000804F000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E02281000000A2A5E02281000000A02178D2E0000012516039C7D010000042A3A02281000000A02037D010000042A3A02281000000A02037D020000042A3A02281000000A02037D030000042A0000001B300500E900000001000011731100000A0A7201000070731200000A0B0207731300000A0C076F1400000A086F1500000A0D096F1600000A398B000000096F1600000A8D3100000113041613072B13110411070911076F1700000AA2110717581307110711048E6932E509730A00000613051104730700000613062B3B11048E698D3100000113081613092B151108110911050911096F0B000006A2110917581309110911088E6932E311066F0900000611086F1800000A096F1900000A2DBD0611066F1A00000A096F1B00000A3A5FFFFFFFDE1E092C06096F1C00000ADC082C06086F1C00000ADC072C06076F1C00000ADC062A0000000128000002002600A3C9000A0000000002001900BAD3000A0000000002001100CCDD000A000000006602731D00000A7D0600000402281E00000A02037D050000042A1E027B050000042A1E027B060000042A0000133004008F0000000200001102281E00000A02036F1600000A8D310000017D0700000402036F1600000A8D330000017D08000004036F1F00000A0A160B2B52027B070000040703076F2000000A6F2100000AA2062D03142B1606282200000A076F2300000A72310000706F2400000A0C027B08000004070875360000012C0908A5360000010D2B031D2B01099E0717580B07036F1600000A32A52A00133006001F0100000300001103046F2500000A0A0675370000012D610675310000010B072D590675190000012C0906A5190000010C2B4A06751A0000012C0906A51A0000010D2B5B06751B0000012C0A06A51B00000113042B7206750300001B130511053AA500000006751C000001130611063A9E00000038A7000000142A072A1202027B07000004049A027B080000040494280C000006282600000A282700000A2A1203724B000070027B080000040494280D0000067273000070282800000A282600000A282900000A2A1204727D000070027B08000004049416300772930000702B1972950000701F66027B080000040494732A00000A282B00000A282B00000A282600000A282C00000A2A1105280E0000062A110614282600000A6F2D00000A2A066F2E00000A2A00133002004C0000000000000002729B000070282F00000A2D1C0272A5000070282F00000A2D150272C1000070282F00000A2D0E2B1D72D50000702A724B0000702A724B00007003280D000006282B00000A2A72EB0000702A760216300672930000702A721B0100701F6602732A00000A282B00000A2A0000133004004A0000000400001118028E69185A58733000000A721F010070283100000A0A020B160C2B200708910D0612037225010070282600000A283200000A6F3100000A260817580C08078E6932DA066F2E00000A2A00001B3003007F010000050000110F00283300000A2C02032A0F01283300000A2C02022A0F00283400000A722B01007028100000060A0F01283400000A723901007028100000060B067247010070283500000A6F3600000A0C082D177247010070283500000A733700000A0C06086F3800000A077247010070283500000A6F3600000A0D09399E000000097251010070283500000A6F3900000A6F3A00000A13052B6E11056F3B00000A1306161307087251010070283500000A6F3900000A6F3A00000A13082B2111086F3B00000A1309110711096F3C00000A11066F3C00000A282F00000A60130711086F3D00000A2DD6DE0C11082C0711086F1C00000ADC11072D0D081106733E00000A6F3F00000A11056F3D00000A2D89DE0C11052C0711056F1C00000ADC06725D010070283500000A6F3600000A130407725D010070283500000A6F3600000A6F4000000A6F4100000A130A2B12110A6F4200000A130B1104110B6F3F00000A110A6F3D00000A2DE5DE0C110A2C07110A6F1C00000ADC06281B000006284300000A2A00012800000200B8002EE6000C00000000020093007B0E010C00000000020048011F67010C000000001B3003005D0000000600001102284400000A0ADE180B037267010070076F4500000A282800000A73180000067A066F4600000A6F4700000A72C3010070284800000A2D1206725D010070283500000A6F3600000A2D110372CD010070282B00000A73180000067A062A00000001100000000000000909001824000001760F00283300000A2D090F00283400000A2B05729300007028130000062A0000133002002C0000000700001102A50800001B0A031200284900000A284300000A8120000001041200284A00000A284300000A81200000012A13300500FC02000008000011734B00000A0A02727402007072930000706F4C00000A727802007072930000706F4C00000A6F4D00000A6F2100000A0B07727C0200701A6F4E00000A2C1107727C020070284F00000A6F5000000A0B07728A020070282F00000A2D350772A2020070282F00000A3A2A0100000772BA020070282F00000A3ACF0100000772D2020070282F00000A3A31020000384E0200000672E8020070720203007028140000060672C103007072D10300702814000006067274040070728E040070281400000606720E050070722205007028140000060672B705007072D1050070281400000606724B060070726506007028140000060672FE060070720E07007028140000060672CD07007072E907007028140000060672B408007072D00800702814000006067257090070727909007028140000060672D40A007072FC0A007028140000060672C30B007072EF0B007028140000060672C60C007072E00C0070281400000606726F0D007072890D007028140000060672F70D0070720B0E007028140000060672710E007072890E0070281400000638640100000672E802007072760F00702814000006067211100070722510007028140000060672471000707253100070281400000606722C110070724211007028140000060672F311007072071200702814000006067277120070728B1200702814000006067204140070721E1400702814000006067276140070729E1400702814000006067202150070723015007028140000060672EF15007072FF1500702814000006067279160070728B160070281400000638AF000000067216170070722417007028140000060672A118007072B1180070281400000606726A190070727C19007028140000060672A819007072B8190070281400000606721A1A007072221A007028140000060672DF1A007072E91A007028140000060672141C007072221C007028140000062B3D06722B010070722D1D00702814000006067239010070728B1D007028140000062B1B0672FF1D0070720B1E00700272491E0070282800000A2814000006062A3A020304735100000A6F5200000A2A001B300500D8010000090000110F00283300000A2D130F00283400000A6F4D00000A6F4F00000A2D0B726B1E007073180000067A0F04285300000A2D090F04285400000A2B01160A061632040618311672931E0070068C33000001285500000A73180000067A0F06283300000A2D090F06283400000A2B0114282B0000060B0F01283300000A2D320F01283400000A6F4D00000A6F4F00000A2C1F72701F00700F01283400000A72821F00700F00283400000A285600000A2B070F00283400000A2816000006256F5700000A2D0B72881F007073180000067A0728190000060C6F5800000A0D38D20000001203285900000A130406182E230617331C11046F090000066F5A00000A11046F080000066F5B00000AFE042B04162B01172C380F05285300000A2D0A0F05285400000A152E1C11040F05285300000A2D090F05285400000A2B0116281F0000062B0B110428200000062B02110413050F03283300000A2D390F03283400000A72D41F0070282F00000A2D090F03283400000A2B1E72D81F007011046F090000066F5A00000A8C33000001285500000A2B011413060811050F02283300000A2D090F02283400000A2B0114110607281A0000061203285C00000A3A22FFFFFFDE0E1203FE160A00001B6F1C00000ADC08281B000006284300000A2A011000000200D900E5BE010E000000001B300200220000000A0000110228060000060ADE170B7200200070076F4500000A282B00000A73180000067A062A00000110000000000000090900172A0000011E02281E00000A2A220203285D00000A2A00000013300500780000000B0000117247010070283500000A7226200070283500000A7230200070283500000A7240200070735E00000A735F00000A735F00000A0A026F240000062C1106026F24000006281D0000066F3F00000A72C3010070283500000A188D12000001251606A22517725D010070283500000A733700000AA2736000000A2A1B300900860200000C000011724C200070283500000A0E046F26000006281C000006735F00000A0A0E046F250000062C1C067258200070283500000A0E046F25000006735E00000A6F3F00000A04286100000A2D33067264200070283500000A188D1200000125160E046F27000006281C000006A2251704281E000006A2736000000A6F3F00000A7274200070283500000A733700000A0B036F080000066F6200000A0D2B3C096F6300000A130407727A200070283500000A188D1200000125160E046F28000006281C000006A225171104281E000006A2736000000A6F3F00000A096F3D00000A2DBCDE0A092C06096F1C00000ADC067280200070283500000A07735F00000A6F3F00000A728C200070283500000A733700000A0C1613052B7F7274200070283500000A733700000A1306036F0900000611056F6400000A13071613082B44110711089A130911067298200070283500000A188D1200000125160E0411056F29000006281C000006A225171109281E000006A2736000000A6F3F00000A110817581308110811078E6932B40811066F3F00000A1105175813051105036F090000066F5A00000A3F6FFFFFFF06086F3F00000A05286100000A2D7306729E200070283500000A7274200070283500000A7298200070283500000A198D1200000125160E046F2A000006281C000006A2251772AA200070283500000A036F080000066F5B00000A8C33000001735E00000AA2251805281E000006A2736000000A735F00000A735F00000A6F3F00000A02725D010070283500000A6F3600000A0E046F240000062C03062B3C72BA200070283500000A188D1200000125167258200070283500000A72C22000700E046F23000006282B00000A735E00000AA2251706A2736000000A6F3F00000A2A0000011000000200980048E0000A000000002202176F6500000A2A5A022C117251010070283500000A02735E00000A2A142A1B3003004900000006000011026F4D00000A284400000A256F4600000A6F4700000A7251010070284800000A2C0B72D420007073180000067A0ADE170B725D210070076F4500000A282B00000A73180000067A062A0000000110000000000000303000172400000113300400990000000D000011022D0672930000702A026F4F00000A733000000A0A160B160C2B6902086F6600000A0D09286700000A2C35081758026F4F00000A2F2A020817586F6600000A286800000A2C1A06096F6900000A02081758250C6F6600000A6F6900000A262B2009286A00000A2C0A06096F6900000A262B0E0620FDFF00006F6900000A26170B0817580C08026F4F00000A328E072D02022A066F2E00000A2A00000013300400C30000000E0000110316320E03026F080000066F5B00000A322872B7210070038C33000001026F080000066F5B00000A17598C33000001286B00000A73180000067A026F090000066F5A00000A17588D310000010A0616026F08000006036F6C00000AA2160C2B2006081758026F09000006086F6400000A039A252D06267293000070A20817580C08026F090000066F5A00000A32D20673070000060B160D2B1A09032E12076F09000006020928210000066F1800000A0917580D09026F080000066F5B00000A32D8072A0013300400820000000E000011026F090000066F5A00000A17588D310000010A06167270220070A2160C2B2406081758082C1372782200701202286D00000A282B00000A2B057278220070A20817580C08026F090000066F5A00000A32CE0673070000060B160D2B16076F09000006020928210000066F1800000A0917580D09026F080000066F5B00000A32DC072A0000133004004D0000000F000011026F090000066F5A00000A17588D310000010A0616026F08000006036F6C00000AA2160B2B1706071758026F09000006076F6400000A039AA20717580B07026F090000066F5A00000A32DB062A9202281E00000A02037D0D00000402047D0E00000402057D0F000004020E047D0C0000042A1E027B0D0000042A1E027B0E0000042A1E027B0F0000042A42027B0C0000042C0672842200702A142A00133004004A00000000000000027B0C0000042C401B8D310000012516724D230070A22517027B0C0000046F35000006A225187273230070A22519027B0C0000046F36000006A2251A7287230070A2286E00000A2A142A0000133004006000000000000000027B0C0000042C561D8D310000012516724D230070A22517027B0C0000046F2F000006A225187273230070A22519027B0C0000046F30000006A2251A7224240070A2251B027B0C0000046F31000006A2251C7274240070A2286E00000A2A142A133006007400000000000000027B0C0000042C6A1C8D31000001251672EA240070A22517027B0C0000046F32000006A2251872FA240070A22519027B0C0000046F33000006A2251A7274240070A2251B03185D172E0772930000702B1A7224250070027B0C0000046F34000006724C250070282800000AA2286E00000A2A142A133004004A00000000000000027B0C0000042C401B8D31000001251672EA240070A22517027B0C0000046F32000006A2251872FA240070A22519027B0C0000046F33000006A2251A7250250070A2286E00000A2A142A0000133004008D00000010000011022C0D026F4D00000A6F4F00000A2D0772E925007010000272F92500701B6F6F00000A16321372072600700202282C0000061473220000062A026F4D00000A6F7000000A0A282D0000060B067215260070282F00000A2C0A0614141473220000062A070612026F7100000A2D16722B26007002723D260070282800000A73180000067A0614140873220000062A00000013300400660000001100001102724C2700701B6F6F00000A0A06162F02142A06724C270070284F00000A580B070C2B040817580C08026F4F00000A2F2402086F6600000A287200000A2DE502086F6600000A1F5F2EDA02086F6600000A1F2D2ECF08073002142A02070807596F7300000A2A000013300B008E01000000000000737400000A2572E9250070725A270070726A270070727A270070728A270070729A270070729A270070729A270070728A270070732E0000066F7500000A2572AA27007072B8270070726A27007072C827007072D827007072E827007072E827007072E827007072D8270070732E0000066F7500000A2572F8270070720A280070726A270070720A280070721A280070722A280070723A280070723A280070721A280070732E0000066F7500000A25724A280070725A280070726A270070726A280070727A280070728A280070729A280070729A280070727A280070732E0000066F7500000A2572AA28007072BC280070726A27007072CC28007072DC28007072EC28007072FC28007072FC28007072DC280070732E0000066F7500000A25720C290070721E290070726A270070722E290070723E290070724E290070725E290070725E290070723E290070732E0000066F7500000A25726E2900707282290070729229007072A2290070729229007072A2290070726A270070726A2700707292290070732E0000066F7500000A2A000013300200440000000000000002281E00000A02037D1000000402047D1100000402057D12000004020E047D13000004020E057D14000004020E067D15000004020E077D16000004020E087D170000042A1E027B100000042A1E027B110000042A1E027B120000042A1E027B130000042A1E027B140000042A1E027B150000042A1E027B160000042A1E027B170000042A42534A4201000100000000000C00000076342E302E33303331390000000005006C000000440E0000237E0000B00E0000800C000023537472696E677300000000301B0000B429000023555300E4440000100000002347554944000000F44400008C0A000023426C6F620000000000000002000001571DA2090902000000FA01330016000001000000420000000E00000017000000360000004100000075000000040000005D000000110000000300000011000000110000000F00000001000000040000000100000000007C0601000000000006003F05A0090600C505A00906003D048D090F00C009000006007A041A060600AC057D070600D6047D07060078057D0706000A057D07060093047D070600B0047D0706005F057D07060063047D0706000A04A0090600D90521070600930A21070600250421070600D70A210706002C0084000A00AE07680B0A00FF01680B0A00A408680B06002B0084000A008F026A000600620321070600080B21070600300721070600C60221070600DE08DB0B0A00F50452090A00170252090A003406DD090E007E0B720806001D0084000E00560272081200E207AE060600AE023B0A0600390084000A00110252090A005500DD094F007C0900000A00FD07680B0600000821070E00ED0372080600480084000600E30521070A00A1071F080A0097081F080600490621070600BA0221070600330021070A008F076A000A002B0C6A0006005800210706009C06210706004B085F070600CE0821070E00E40272080E001C09720806000100840006006D093B0A06003208210706000F0084000E00630A72080600870821071200BE0BAE06000000005E00000000000100010000011000F803100A3D0001000100000110005104A0093D0001000200000110009305A0093D0002000400000110002705A0093D000300050080011000880AD00649000400060001011000A202D006490005000700000110004309D006490007000A00010010004E0AD006490009000F0001211000EF07D006AD000900180080011000870BD006490009001900800110005607D006490009001F0000011000D302D00649000900220003011000DC030000490010002E002600020A140426001506180426004E071B045180BC071E0421006501210421007E0128042100F20930042100D50934045680330B1E045180A00B1E04518097061E042100E40338042100CB001E04210094011E042100E1001E04210017011E042100E3011E04210047011E042100B0011E0421002F011E042100FC001E042100A8001E042100C6011E045020000000008618870906000100582000000000861887093C04010070200000000086188709410401007F2000000000861887093C0401008E20000000008618870901000100A020000000009600A40A47040100C021000000008618870951040200DA21000000008608270A5A040300E221000000008608B80A62040300EC2100000000861887096B0404008822000000008600D00A71040500B423000000009100C80A780408000C2400000000910074077E040A002C240000000096003E0683040B008424000000009600FF0689040C003826000000009100920395040E00B42600000000960057089D041000D426000000009100330CA60411000C270000000096006A08B3041400142A000000009100A400C2041600242A000000009600ED06D3041900182C000000009100430847042000582C000000008618870906002100602C0000000086188709100021006C2C0000000096009803EE042200F02C0000000096009902F6042300942F000000009600D603030528009D2F000000009100D8020A052900B42F000000009100ED0A84012A001C30000000009100210C11052B00C4300000000096003E0716052C009431000000009600FE051E052E0024320000000091006B0325052F007D3200000000811887092D053200A232000000008608EA026E003600AA32000000008608DE0A6E003600B2320000000086082D036E003600BA3200000000860876026E003600CC32000000008608CE076E00360024330000000086088C086E003600903300000000860071004B003600103400000000860831096E003700683400000000960092033605370004350000000091003B03110538007835000000009100F9093C053A001437000000008618870947053A0064370000000086088C086E0042006C370000000086080C0C6E0042007437000000008608F7086E0042007C37000000008608E70B6E0042008437000000008608EC086E0042008C37000000008608BE036E004200943700000000860826026E0042009C37000000008608F00B6E004200000001005A0600000100330A00000000000000000100C70800000000000000000100C70800000200760600000100700300000200700200000100700200000100670000000100E70600000200F906000001000A07000002002709000001000303000001007806020002001F03020003000A08000000000000000001000303000001007600000002004B0C000003000706000001004F0C00000200790A00000300DA07000004003C09000005002D0700000600470800000700DE02000001005A0600000100680200000100DE02000001000A0700000200CD0200000300DA07000004003C0900000500DE02000001000A0700000100840A00000100FD0A00000100070600000100CD0200000200470800000100CD0200000000000000000100CD02000002004707000001005D0300000200FD0A000003004B0300000400E503000001003F0C00000100DE0200000000000000000100DE0200000100C008000002001B0C00000300080900000400260C00000500150900000600CC03000007003C0200000800000C090087090100110087090600190087090A00290087091000310087091000390087091000410087091000490087091000510087091000590087091000610087091000690087091000710087090600890087091500F100870906007900870906000C0087090600A10087091000A90087093B00790139070600A900B20842008101AF0B4700810155034B001400A400570081019F005D000C00A400570081013B0B5D0091018A0306001400870906009100870906008101800269008101F3024B008901570B6E00C100B80A7200A1010F077800A9010F077F008101F5059300C10175039B00C9004706A1008901C10AA900D1004706A10089018709B0008901C10AB600D9004706A100E1004706A100910047066E008901550CBC00E90087090100E9000A02CB0071014706A1000101A3065D000101E8056E00D101170B0501D9017F0B0C01090187091501D901C90B1C01D901AF0A21012400790938012C00940B4B010901E8056E00E901D20B5D00090187095001D901A4001C01D901CF0957013400790938013C00940B4B010101170B740109019203840159015C026E000901EA028B01D10111036E008901610CBC004400430C4B014400E805A3014C008709060089014E02C301890128076E0089016B06C901890160064700890150064B0044008709D1014C00A40057004101A3065D004101E805EE018901D00AF2018901C10AF8010C00A50B47000C00790900025400940B4B011400A50B47005C00A50B47005400D20B5D00590187091000610187092B02090187092B0209018709330289016F0C57026400790938016C00940B4B0114000F076A0219014706700289016F0A7F0209029F0384020902AF038402E9000A0289021102820884028901D00A980274000F076A02990147066E008901C10AAB0289010D06BF028901460B6E007C00F205D0020902230B840289015006DF027C00870906007C001807D1010E001000EE020E0024001D030E0028002C030E002C00A30327002A00810A2E000B0068052E00130071052E001B0090052E00230099052E002B00E3052E003300F9052E003B00E3052E00430006062E004B0034062E00530041062E005B0075062E006300810643006B009D0643000A009D0649001A00E20963006B009D0663000A009D0663007300EE0964001A00E20969001200D60983006B009D0683000A009D0683007300150AA1006B009D06A3006B009D06A3000A009D06A30073003C0AA4001200DC09C1001A00E209C1006B009D06C3002200D609C3001200630AE3002200D609E3001200630A00016B009D0603012200D60903011200630A20016B009D0621011200D60923012200D60923011200630A41011200D60961011200D60963012200D60963011200630A83012200D60983011200630AA1011200D609A1016B009D06A3012200DC09A3011200630AC1016B009D06C3012200D609C3011200630AE0017B00A206E1016B009D0601026B009D0620027B00580721026B009D0641026B009D0661026B009D0681026B009D0684021A00690AA0027B008808A1026B009D06C1026B009D06C4021A00690AE1026B009D0600032200D60980032200DC0960042200D60960046B009D0680046B009D06A0046B009D06A4041200DC09C4041200DC0960052200D60964051200DC0980052200D609A0052200D609E0056B009D06E4051A00760A00066B009D0620066B009D0640066B009D0644061200D60960066B009D0680066B009D06A0066B009D06C0066B009D06E4061200DC0904071200DC091B0061008400C200D1007B019101A801D901190225023C0277028F02A502B102D902070001000D0003000E000A0000002B0A53050000BC0A5B050000580364050000F20A64050000410364050000A80264050000D20764050000900864050000350964050000900864050000100C64050000FB0864050000210C640500000E0964050000C203640500002A0264050000F40B6405020008000300020009000500020023000700020024000900020025000B00020026000D00020027000F0002002800110002002A00130002002F001500020030001700020031001900020032001B00020033001D00020034001F000200350021000200360023003400500098002F01420162016B019B01B7010A0212025C0263029F02C702048000000200000000000000000000000000B9060000040000000000000000000000E5027B0000000000040000000000000000000000E5026A0000000000040000000000000000000000E502720800000000040000000000000000000000E502AE06000000000E000D00000000000049456E756D657261626C6560310049436F6C6C656374696F6E60310049456E756D657261746F72603100494C697374603100496E743332004B657956616C75655061697260320044696374696F6E61727960320053716C496E743136003C4D6F64756C653E0062610053797374656D2E446174610064617461006D73636F726C69620053797374656D2E436F6C6C656374696F6E732E47656E65726963005265616400416464003C43617074696F6E4261636B67726F756E643E6B5F5F4261636B696E674669656C64003C4E616D653E6B5F5F4261636B696E674669656C64003C436C6173734E616D653E6B5F5F4261636B696E674669656C64003C416C7465726E6174653E6B5F5F4261636B696E674669656C64003C4865616465723E6B5F5F4261636B696E674669656C64003C426F726465723E6B5F5F4261636B696E674669656C64003C486561646572426F726465723E6B5F5F4261636B696E674669656C64003C436F6C756D6E733E6B5F5F4261636B696E674669656C64003C526F77733E6B5F5F4261636B696E674669656C64003C5374796C6553686565743E6B5F5F4261636B696E674669656C64003C546578743E6B5F5F4261636B696E674669656C64003C43617074696F6E546578743E6B5F5F4261636B696E674669656C64003C486561646572546578743E6B5F5F4261636B696E674669656C640053716C436F6D6D616E6400417070656E640053797374656D446174614163636573734B696E64006765745F43617074696F6E4261636B67726F756E640063617074696F6E4261636B67726F756E64005265706C61636500584E6F6465006765745F4D657373616765006D657373616765007363616C65006765745F5461626C6500476574536368656D615461626C6500446174615461626C65004164645461626C6500526573756C745461626C650049456E756D657261626C650049446973706F7361626C650049466F726D61747461626C65005461626C655374796C65007374796C6500584E616D65006765745F4E616D650047657444617461547970654E616D650070726F6365647572654E616D65006765745F4C6F63616C4E616D6500706172616D657465724E616D65006765745F436C6173734E616D6500437573746F6D436C6173734E616D6500636C6173734E616D65004765744E616D65006E616D65004461746554696D65004C696E650074797065006765745F496E76617269616E7443756C7475726500446973706F73650050617273650043726561746500497348696768537572726F676174650049734C6F77537572726F67617465006765745F416C7465726E61746500616C7465726E6174650057726974650050616C65747465005F70616C65747465005841747472696275746500456D62656464656441747472696275746500436F6D70696C657247656E6572617465644174747269627574650041747472696275746555736167654174747269627574650044656275676761626C65417474726962757465004E756C6C61626C6541747472696275746500417373656D626C795469746C65417474726962757465005461726765744672616D65776F726B41747472696275746500417373656D626C7946696C6556657273696F6E41747472696275746500417373656D626C79496E666F726D6174696F6E616C56657273696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E4174747269627574650053716C46756E6374696F6E41747472696275746500417373656D626C794465736372697074696F6E4174747269627574650052656653616665747952756C657341747472696275746500436F6D70696C6174696F6E52656C61786174696F6E7341747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F70797269676874417474726962757465004E756C6C61626C65436F6E7465787441747472696275746500417373656D626C79436F6D70616E794174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650042797465006765745F56616C75650054727947657456616C7565004B657956616C75650076616C756500496E6465784F6600466C61670053797374656D2E52756E74696D652E56657273696F6E696E670053716C537472696E6700427974654172726179546F537472696E6700537562737472696E67006261746368006765745F4C656E67746800537461727473576974680069006F626A0053696D706C6554616C6B2E53514C434C522E48746D6C2E646C6C0043656C6C0044424E756C6C006765745F49734E756C6C0053797374656D2E586D6C0053696D706C6554616C6B2E53514C434C522E48746D6C0053696D706C6554616C6B2E53716C436C722E48746D6C006D48746D6C005175657279546F48746D6C007348746D6C00436F6E43617448746D6C0068746D6C006765745F4974656D007365745F4974656D0053797374656D005472696D00726D0054696D655370616E004F70656E004F6E436F6C756D6E00636F6C756D6E0056657273696F6E00526F746174696F6E0053797374656D2E476C6F62616C697A6174696F6E004672616374696F6E0053797374656D2E5265666C656374696F6E0044617461526F77436F6C6C656374696F6E004462436F6E6E656374696F6E0053716C436F6E6E656374696F6E00436F6E74657874436F6E6E656374696F6E006765745F43617074696F6E0063617074696F6E00586D6C457863657074696F6E0048746D6C457863657074696F6E0053716C457863657074696F6E00706172616D657465724465736372697074696F6E0053797374656D2E446174612E436F6D6D6F6E00537472696E67436F6D70617269736F6E0052756E0072636F0043756C74757265496E666F00437573746F6D53656E644D61696C48656C700047657448656C700053797374656D2E586D6C2E4C696E71004973586D6C43686172006765745F486561646572004462446174615265616465720053716C44617461526561646572004578656375746552656164657200686561646572007265616465720049466F726D617450726F766964657200537472696E674275696C646572006765745F426F72646572006765745F486561646572426F7264657200686561646572426F7264657200626F726465720058436F6E7461696E657200706172616D65746572006765745F466F6F74657200666F6F7465720056616C7565466F726D6174746572004D6963726F736F66742E53716C5365727665722E5365727665720049456E756D657261746F7200476574456E756D657261746F72002E63746F720053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F646573004E6F646573005F7363616C65730053797374656D2E446174612E53716C5479706573005F74797065730050616C6574746573004E756C6C61626C65466C616773004D6963726F736F66742E436F6465416E616C79736973006765745F436F6C756D6E7300636F6C756D6E730053797374656D2E436F6C6C656374696F6E730055736572446566696E656446756E6374696F6E7300536176654F7074696F6E73006765745F436861727300706172616D6574657273006373730044617461416363657373004174747269627574655461726765747300476574526573756C747300456C656D656E7473006765745F526F777300436F6E636174004461746554696D65466F726D6174004F626A656374006765745F5374796C6553686565740050617273655374796C655368656574007374796C655368656574004461746554696D654F6666736574006F705F496D706C696369740049734C65747465724F7244696769740044656661756C74004E657874526573756C7400546F5570706572496E76617269616E7400546F4C6F776572496E76617269616E740053797374656D2E446174612E53716C436C69656E740058456C656D656E740048746D6C446F63756D656E74006765745F43757272656E7400466F6E74006765745F436F756E74006765745F4669656C64436F756E7400586D6C436F6E76657274004164644669727374004D6F76654E6578740053797374656D2E54657874006765745F54657874006765745F43617074696F6E546578740063617074696F6E54657874006765745F48656164657254657874006865616465725465787400746578740044617461526F770046696C6C48656C70526F7700726F77006765745F4B6579006B6579007175657279006F705F457175616C697479006F705F496E657175616C6974790049734E756C6C4F72456D70747900000000002F63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D00740072007500650000194E0075006D0065007200690063005300630061006C006500002779007900790079002D004D004D002D00640064002000480048003A006D006D003A0073007300010920007A007A007A000015680068005C003A006D006D005C003A0073007300000100055C002E0000096400610074006500001B73006D0061006C006C006400610074006500740069006D00650000136400610074006500740069006D0065003200001579007900790079002D004D004D002D0064006400012F79007900790079002D004D004D002D00640064002000480048003A006D006D003A00730073002E0066006600660001032E00000530007800000558003200000D40006D00480074006D006C00000D40007300480074006D006C0000096800650061006400000B7300740079006C006500000962006F0064007900005B20006900730020006E006F0074002000480054004D004C002000660072006F006D0020005100750065007200790054006F00480074006D006C0020006F007200200043006F006E00430061007400480074006D006C003A0020000009680074006D006C000080A520006900730020006E006F0074002000480054004D004C002000660072006F006D0020005100750065007200790054006F00480074006D006C0020006F007200200043006F006E00430061007400480074006D006C003A0020006900740020006E006500650064007300200061006E002000680074006D006C00200065006C0065006D0065006E0074002000770069007400680020006100200062006F00640079002E0000035B0000035D00000D65006D00610069006C002E00001763006C007200730065006E0064006D00610069006C0000177300610076006500700072006F00660069006C00650000177100750065007200790074006F00680074006D006C00001563006F006E00630061007400680074006D006C0000194000700072006F00660069006C0065004E0061006D0065000080BD5400680065002000700072006F00660069006C006500200069006E00200045004D00410049004C002E00500072006F00660069006C0065007300200074006F002000730065006E006400200074006800650020006D00650073007300610067006500200077006900740068003A002000690074007300200053004D00540050002000730065007200760065007200200061006E00640020006100630063006F0075006E0074002E002000520065007100750069007200650064002E00000F40006D00610069006C0054006F000080A141002000730065006D00690063006F006C006F006E002D00640065006C0069006D00690074006500640020006C0069007300740020006F006600200065002D006D00610069006C002000610064006400720065007300730065007300200074006F002000730065006E006400200074006800650020006D00650073007300610067006500200074006F002E002000520065007100750069007200650064002E00011940006D00610069006C005300750062006A00650063007400007F54006800650020007300750062006A006500630074002C0020006E007600610072006300680061007200280032003500350029002E002000440065006600610075006C00740020006900730020002700530051004C0043004C005200200053006500720076006500720020004D0065007300730061006700650027002E00011340006D00610069006C0042006F0064007900008093540068006500200062006F00640079002C0020006E00760061007200630068006100720028006D006100780029002C002000730075006300680020006100730020007400680065002000480054004D004C0020006F006600200045004D00410049004C002E005100750065007200790054006F00480074006D006C002E002000520065007100750069007200650064002E0000194000660072006F006D00410064006400720065007300730000795400680065002000660072006F006D00200061006400640072006500730073002C00200069006E007300740065006100640020006F00660020007400680065002000700072006F00660069006C006500270073002E002000440065006600610075006C00740020006900730020006E0075006C006C002E000119400064006900730070006C00610079004E0061006D0065000080975400680065002000660072006F006D002000610064006400720065007300730027007300200064006900730070006C006100790020006E0061006D0065002C00200069006E007300740065006100640020006F00660020007400680065002000700072006F00660069006C006500270073002E002000440065006600610075006C00740020006900730020006E0075006C006C002E00010F40006D00610069006C00430063000080BD41002000730065006D00690063006F006C006F006E002D00640065006C0069006D00690074006500640020006C0069007300740020006F006600200065002D006D00610069006C002000610064006400720065007300730065007300200074006F00200063006100720062006F006E00200063006F0070007900200074006800650020006D00650073007300610067006500200074006F002E002000440065006600610075006C00740020006900730020006E0075006C006C002E00011B400062006C0069006E00640043006F00700079005200650063000080C941002000730065006D00690063006F006C006F006E002D00640065006C0069006D00690074006500640020006C0069007300740020006F006600200065002D006D00610069006C002000610064006400720065007300730065007300200074006F00200062006C0069006E006400200063006100720062006F006E00200063006F0070007900200074006800650020006D00650073007300610067006500200074006F002E002000440065006600610075006C00740020006900730020006E0075006C006C002E00011B40007200650070006C007900410064006400720065007300730000808541002000730065006D00690063006F006C006F006E002D00640065006C0069006D00690074006500640020006C0069007300740020006F00660020007200650070006C0079002D0074006F0020006100640064007200650073007300650073002E002000440065006600610075006C00740020006900730020006E0075006C006C002E0001214000660069006C0065004100740074006100630068006D0065006E007400730000815941002000730065006D00690063006F006C006F006E002D00640065006C0069006D00690074006500640020006C0069007300740020006F0066002000660069006C0065007300200074006F0020006100740074006100630068002C002000610073002000660075006C006C0020007000610074006800730020007400680065002000530051004C0020005300650072007600650072002000730065007200760069006300650020006100630063006F0075006E0074002000630061006E00200072006500610064002C00200069006E0020006100200066006F006C0064006500720020006F0066002000740068006500200063006F006E00660069006700750072006100740069006F006E002700730020004100740074006100630068006D0065006E00740046006F006C0064006500720073002E002000440065006600610075006C00740020006900730020006E0075006C006C002E00012740007200650071007500650073007400520065006100640052006500630065006900700074000080C53100200074006F002000610073006B00200066006F0072002000610020007200650061006400200072006500630065006900700074002C002000730065006E007400200074006F00200074006800650020006600690072007300740020007200650070006C0079002D0074006F002000610064006400720065007300730020006F00720020007400680065002000660072006F006D00200061006400640072006500730073002E002000440065006600610075006C007400200069007300200030002E00012B4000640065006C00690076006500720079004E006F00740069006600690063006100740069006F006E000080D5440065006C0069007600650072007900200073007400610074007500730020006E006F00740069006600690063006100740069006F006E0073003A002000300020006E006F006E0065002C002000310020006F006E00200073007500630063006500730073002C002000320020006F006E0020006600610069006C007500720065002C002000340020006F006E002000640065006C00610079002C0020006F0072002000740068006500690072002000730075006D002E002000440065006600610075006C007400200069007300200030002E0000194000730065006E007300690074006900760069007400790000808D2D00310020006E006F006E0065002C0020003000200050006500720073006F006E0061006C002C0020003100200050007200690076006100740065002C0020003200200043006F006D00700061006E0079002D0043006F006E0066006900640065006E007400690061006C002E002000440065006600610075006C00740020006900730020002D0031002E00011940006D00610069006C005000720069006F00720074007900006D540068006500200069006D0070006F007200740061006E00630065003A002000300020006E006F0072006D0061006C002C002000310020006C006F0077002C0020003200200068006900670068002E002000440065006600610075006C007400200069007300200030002E000013400062006F0064007900480074006D006C000065310020007700680065006E002000740068006500200062006F00640079002000690073002000480054004D004C002C0020003000200066006F007200200074006500780074002E002000440065006600610075006C007400200069007300200031002E000017400063006F006E006600690067004E0061006D0065000080EB540068006500200063006F006E00660069006700750072006100740069006F006E00200069006E00200045004D00410049004C002E0043006F006E00660069006700750072006100740069006F006E0073003A0020006100740074006100630068006D0065006E00740020006C0069006D006900740073002C0020006C006F006700670069006E006700200061006E006400200077006800610074002000690073002000730061007600650064002E002000440065006600610075006C007400200069007300200074006800650020006200750069006C0074002D0069006E0020006F006E0065002E000180995400680065002000700072006F00660069006C0065002700730020006E0061006D0065002C00200075007000200074006F00200032003000200063006800610072006100630074006500720073002E00200041002000700072006F00660069006C00650020006F0066002000740068006100740020006E0061006D00650020006900730020007200650070006C0061006300650064002E000113400068006F00730074004E0061006D0065000021540068006500200053004D005400500020007300650072007600650072002E00000B400070006F00720074000080D7540068006500200053004D0054005000200070006F00720074003A00200035003800370020006F0072002000320035002E00200050006F007200740020003400360035002000280054004C0053002000660072006F006D002000740068006500200073007400610072007400290020006900730020006E006F007400200073007500700070006F00720074006500640020006200790020002E004E004500540020004600720061006D00650077006F0072006B002E002000440065006600610075006C00740020006900730020003500380037002E000015400065006E00610062006C006500530073006C000080AF3100200074006F002000730077006900740063006800200074006F00200054004C0053002000770069007400680020005300540041005200540054004C0053003B00200074006800650020007300650072007600650072002700730020006300650072007400690066006900630061007400650020006D007500730074002000620065002000760061006C00690064002E002000440065006600610075006C007400200069007300200031002E000113400075007300650072004E0061006D006500006F54006800650020006100630063006F0075006E007400200074006F0020007300690067006E00200069006E00200077006900740068002E002000440065006600610075006C00740020006900730020006E0075006C006C002C00200066006F00720020006E006F006E0065002E0000134000700061007300730077006F007200640000817754006800650020006100630063006F0075006E007400270073002000700061007300730077006F00720064002C00200075007000200074006F002000310032003000200063006800610072006100630074006500720073002C0020006B00650070007400200065006E00630072007900700074006500640020007700690074006800200074006800650020006400610074006100620061007300650027007300200063006500720074006900660069006300610074006500200045006D00610069006C00500072006F00660069006C00650073002E0020004E0075006C006C0020006B00650065007000730020007400680065002000700072006F00660069006C006500270073002000700061007300730077006F00720064003B00200061006E00200065006D00700074007900200073007400720069006E0067002000720065006D006F007600650073002000690074002E002000440065006600610075006C00740020006900730020006E0075006C006C002E0001194000640065006600610075006C007400460072006F006D0000575400680065002000660072006F006D002000610064006400720065007300730020006F00660020007400680065002000700072006F00660069006C0065002700730020006D0065007300730061006700650073002E0001274000640065006600610075006C00740044006900730070006C00610079004E0061006D00650000635400680065002000660072006F006D002000610064006400720065007300730027007300200064006900730070006C006100790020006E0061006D0065002E002000440065006600610075006C00740020006900730020006E0075006C006C002E00012D4000750073006500440065006600610075006C007400430072006500640065006E007400690061006C0073000080BD3100200074006F0020007300690067006E00200069006E0020006100730020007400680065002000530051004C0020005300650072007600650072002000730065007200760069006300650020006100630063006F0075006E007400200069006E007300740065006100640020002800570069006E0064006F00770073002000610075007400680065006E007400690063006100740069006F006E0029002E002000440065006600610075006C007400200069007300200030002E00000F400064006F006D00610069006E00007954006800650020006100630063006F0075006E007400270073002000570069006E0064006F0077007300200064006F006D00610069006E002C00200066006F0072002000450078006300680061006E00670065002E002000440065006600610075006C00740020006900730020006E0075006C006C002E0001114000740069006D0065006F007500740000808948006F00770020006C006F006E006700200074006F0020007700610069007400200066006F007200200074006800650020007300650072007600650072002C00200069006E0020006D0069006C006C0069007300650063006F006E00640073002E002000440065006600610075006C00740020006900730020003100300030003000300030002E00000D40007100750065007200790000817B5400680065002000710075006500720079002000770068006F0073006500200072006500730075006C007400730020006200650063006F006D0065002000480054004D004C0020007400610062006C00650073002E00200041002000660075006E006300740069006F006E002000630061006E002000720075006E0020006E006F002000730074006F007200650064002000700072006F0063006500640075007200650020006200750074002000610020006600650077002000730079007300740065006D0020006F006E00650073003A002000700075007400200061002000700072006F0063006500640075007200650027007300200072006500730075006C007400200069006E00200061002000740065006D0070006F00720061007200790020007400610062006C00650020007700690074006800200049004E00530045005200540020002E002E002E00200045005800450043002C00200061006E006400200071007500650072007900200074006800610074002E00010F400050006100720061006D0073000080B754006800650020007100750065007200790027007300200070006100720061006D00650074006500720073002C0020006400650063006C006100720065006400200061007300200069006E0020004400450043004C004100520045003A002000400069006400200069006E00740020003D00200031002C00200040006E0061006D00650020006E007600610072006300680061007200280035003000290020003D0020004E002700420069006B006500730027002E0001114000630061007000740069006F006E00002B450061006300680020007400610062006C006500270073002000630061007000740069006F006E002E00010F400066006F006F007400650072000061450061006300680020007400610062006C00650027007300200066006F006F007400650072003B0020002300200067006900760065007300200074006800650020006E0075006D0062006500720020006F006600200072006F00770073002E000107400072006D000080BB52006F00740061007400650020006D006F00640065003A002000300020006E006F00200072006F0074006100740069006F006E002C0020003100200072006F00740061007400650020007700680065006E002000740068006500720065002000610072006500200066006500770065007200200072006F007700730020007400680061006E00200063006F006C0075006D006E0073002C0020003200200061006C007700610079007300200072006F0074006100740065002E0000094000720063006F0000812952006F007400610074006500200063006F006C0075006D006E0020006F007200640069006E0061006C003A002000740068006500200063006F006C0075006D006E002C00200063006F0075006E007400650064002000660072006F006D00200030002C002000770068006F00730065002000760061006C0075006500730020006200650063006F006D006500200074006800650020006800650061006400650072002C0020006F00720020002D003100200066006F0072002000610020004B00650079002C002000560061006C007500650020006800650061006400650072002E002000550073006500640020006F006E006C00790020007700680065006E002000610020007400610062006C006500200069007300200072006F00740061007400650064002E00010D40007300740079006C006500008109530054005F0042004C00550045002C002000530054005F005200450044002C002000530054005F0047005200450045004E002C002000530054005F0052004F00530045002C002000530054005F00420052004F0057004E002C002000530054005F0042004C00410043004B002C002000530054005F00530049004D0050004C00450020006F0072002000530054005F004E004F005300540059004C0045002C0020006F0072002000610020007300740079006C006500200065006C0065006D0065006E00740020006F006600200079006F007500720020006F0077006E002E002000440065006600610075006C0074002000690073002000530054005F0042004C00550045002E00005D54006800650020006D00610069006E002000480054004D004C002C002000660072006F006D0020005100750065007200790054006F00480074006D006C0020006F007200200043006F006E00430061007400480074006D006C002E0000735400680065002000480054004D004C00200074006F0020006100640064002000610066007400650072002000690074002C002000660072006F006D0020005100750065007200790054006F00480074006D006C0020006F007200200043006F006E00430061007400480074006D006C002E00000B4500720072006F007200003D5400680065002000700072006F0063006500640075007200650020006F00720020007400680065002000660075006E006300740069006F006E0020000021200064006F006500730020006E006F007400200065007800690073007400210000274000710075006500720079002000690073002000720065007100750069007200650064002E000080DB400072006D0020006900730020007B0030007D003A00200075007300650020003000200066006F00720020006E006F00200072006F0074006100740069006F006E002C0020003100200074006F00200072006F00740061007400650020007700680065006E002000740068006500720065002000610072006500200066006500770065007200200072006F007700730020007400680061006E00200063006F006C0075006D006E0073002C0020006F00720020003200200074006F00200061006C007700610079007300200072006F0074006100740065002E0000114400450043004C00410052004500200000053B000A00004B5400680065002000710075006500720079002000720065007400750072006E006500640020006E006F00200072006500730075006C007400200074006F002000730068006F0077002E0000032300002754006F00740061006C0020007200650063006F0072006400730020003A0020007B0030007D00002554006800650020007100750065007200790020006600610069006C00650064003A00200000096D00650074006100000F6300680061007200730065007400000B7500740066002D003800010B7400610062006C006500000B63006C00610073007300000F630061007000740069006F006E00000574007200000574006800000B74006800650061006400000B740062006F0064007900000574006400000B740066006F006F007400000F63006F006C007300700061006E00000764006900760000116400610074006100670072006900640000808740007300740079006C00650020006D007500730074002000620065002000610020007300740079006C006500200065006C0065006D0065006E0074003A0020003C007300740079006C006500200074007900700065003D00220074006500780074002F0063007300730022003E002E002E002E003C002F007300740079006C0065003E002E00005940007300740079006C00650020006D00750073007400200062006500200061002000770065006C006C002D0066006F0072006D006500640020007300740079006C006500200065006C0065006D0065006E0074003A0020000180B74000720063006F0020006900730020007B0030007D002C0020006200750074002000740068006500200072006500730075006C00740027007300200063006F006C0075006D006E007300200061007200650020006E0075006D006200650072006500640020003000200074006F0020007B0031007D002C0020006F00720020002D003100200066006F0072002000610020004B00650079002C002000560061006C007500650020006800650061006400650072002E0001074B0065007900000B560061006C00750065000080C762006F0072006400650072002D0063006F006C006C0061007000730065003A00200063006F006C006C0061007000730065003B002000770069006400740068003A00200031003000300025003B00200066006F006E0074002D00660061006D0069006C0079003A00200041007200690061006C002C002000480065006C007600650074006900630061002C002000730061006E0073002D00730065007200690066003B00200066006F006E0074002D00730069007A0065003A00200031003200700078003B0001256200610063006B00670072006F0075006E0064002D0063006F006C006F0072003A00200001133B00200063006F006C006F0072003A00200000809B3B00200066006F006E0074002D007700650069006700680074003A00200062006F006C0064003B002000700061006400640069006E0067003A00200032007000780020003400700078003B00200074006500780074002D0061006C00690067006E003A0020006C006500660074003B00200076006500720074006900630061006C002D0061006C00690067006E003A00200074006F0070003B00014F3B00200066006F006E0074002D007700650069006700680074003A00200062006F006C0064003B00200062006F0072006400650072003A002000310070007800200073006F006C0069006400200001753B002000700061006400640069006E0067003A00200032007000780020003400700078003B00200074006500780074002D0061006C00690067006E003A0020006C006500660074003B00200076006500720074006900630061006C002D0061006C00690067006E003A00200074006F0070003B00010F63006F006C006F0072003A00200000293B00200062006F0072006400650072003A002000310070007800200073006F006C00690064002000002720006200610063006B00670072006F0075006E0064002D0063006F006C006F0072003A00200001033B000080973B00200066006F006E0074002D00730069007A0065003A00200031003100700078003B002000700061006400640069006E0067003A00200032007000780020003400700078003B00200074006500780074002D0061006C00690067006E003A0020006C006500660074003B00200076006500720074006900630061006C002D0061006C00690067006E003A00200074006F0070003B00010F530054005F0042004C0055004500000D3C007300740079006C006500000D43005500530054004F004D000015530054005F004E004F005300540059004C004500001140007300740079006C0065002000270001810D270020006900730020006E006F0074002000610020007300740079006C0065003A0020007500730065002000530054005F0042004C00550045002C002000530054005F005200450044002C002000530054005F0047005200450045004E002C002000530054005F0052004F00530045002C002000530054005F00420052004F0057004E002C002000530054005F0042004C00410043004B002C002000530054005F00530049004D0050004C00450020006F0072002000530054005F004E004F005300540059004C0045002C0020006F0072002000610020007300740079006C006500200065006C0065006D0065006E00740020006F006600200079006F007500720020006F0077006E002E00010D7400610062006C0065002E00000F2300300030003600360039003900000F2300460046004600460046004600000F2300300030003700300041003800000F2300300030003500350037004600000F2300450031004500450046003400000D530054005F00520045004400000F2300390039003100380032003100000F2300420030003100430032003600000F2300380030003100340031004300000F23004600370043004400430044000011530054005F0047005200450045004E00000F2300330036003700350032004400000F2300320037003500340032003000000F2300430036004600460043003200000F2300440046004600460044004500000F530054005F0052004F0053004500000F2300360035003200320039003900000F2300370031003400330039003900000F2300340044003100410037003500000F2300450037004200440046004600000F23004600340045003300460046000011530054005F00420052004F0057004E00000F2300410036003500420031004100000F2300420046003600390031004500000F2300370046003400360031003400000F2300440039004300460042003800000F23004600300045003500430043000011530054005F0042004C00410043004B00000F2300380043003800430038004300000F2300410033004100330041003300000F2300370044003700440037004400000F2300440042004400420044004200000F23004500420045004200450042000013530054005F00530049004D0050004C004500000F2300440045004400450044004500000F2300330033003300330033003300000F230036003600360036003600360000000010A7E20514063944B6959535F5DE6F8400042001010803200001052001011111042001010E05200101114118070A15124D01121C1251125512591D0E1220121C081D0E080615124D01121C062002010E12510420001259032000080420010E080615124D011D0E052001011300032000020707041261081C0604200012610320000E0520001280D10620011280D5080420011C0E0E07071C0E11651169116D1D0512710420011C08021D050500001280E10720020E0E1280E50600030E0E0E0E0520020103080500020E0E0E050002020E0E08070412751D05080505200112750E33070C1280851280851280851280851280851512808901128085128085021512808901128085128085151280890112808D12808D0600011280E90E0820011280851280E9062001011280E9042001011C0D2001151280F1011280851280E908151280F101128085092000151280890113000815128089011280850420001300062001011280850A2000151280F10112808D08151280F10112808D08151280890112808D0600011180810E0807021280851280910600011280850E0520001280E909070115118099020E0E0715118099020E0E04200013010E070215124D0115118099020E0E0E0B15124D0115118099020E0E0520020E0E0E072002020E1180F90720020113001301140707081234128085151180A501121C121C121C0E032000060500020E0E1C0700040E0E0E0E0E092000151180A501130007151180A501121C06151280FD010E0B070215124D01121C1280A9050701128085072002011280E91C082002011280E91D1C1A070A12808512808512808515128089010E0E081280851D0E080E040001020E06151280F1010E0615128089010E0520011300080620010E1181010707041275020803042001030804000102030520011275030807041D0E121C08080600030E0E1C1C0515125D010E0507021D0E080500010E1D0E0D07030E151280B5020E12381238072002080E1180F908151280B5020E12380820020213001013010507030808080520020E080808B77A5C561934E0892E63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D0074007200750065000E530054005F0042004C00550045007666006F006E0074002D00660061006D0069006C0079003A00200041007200690061006C002C002000480065006C007600650074006900630061002C002000730061006E0073002D00730065007200690066003B00200066006F006E0074002D00730069007A0065003A00200031003200700078003B0070700061006400640069006E0067003A00200032007000780020003400700078003B00200074006500780074002D0061006C00690067006E003A0020006C006500660074003B00200076006500720074006900630061006C002D0061006C00690067006E003A00200074006F0070003B0003061D0502060502060802060E060615125D010E070615124D011D0E03061D0E03061D08030612380420010105052001011D0509000115124D01121C0E0820010115125D010E07200015125D010E08200015124D011D0E0520010112590620020E1259080500020E0E080400010E080500010E1D050B00021180811180811180810700021280850E0E0800011280951180810C0003011C10118081101180810E000115124D0115118099020E0E0E1000030115124D0115118099020E0E0E0E1A00071180811180811180811180811180811180A11180A111808107000112808512340C000501128085121C0E0E12340600010E1280850600011280B10E0400010E0E070002121C121C08060001121C121C0700021D0E121C08082004010E0E0E123805000112340E0A0000151280B5020E12380B2008010E0E0E0E0E0E0E0E07280015125D010E08280015124D011D0E0328000E0801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010801000200000000004901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E380100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E38150100104461726B6F204D617274696E6F76696300000C01000752656C6561736500002D010028517565727920726573756C74732061732048544D4C207461626C657320666F7220652D6D61696C7300000C010007322E302E302E3000003301002E322E302E302B3738376133346237646433613639646534616361373334313363356663356437306361623334633600000B01000653514C434C5200001B01001653696D706C6554616C6B2E53514C434C522E48746D6C0000040100000080B401000300540E044E616D650A436F6E43617448746D6C5455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A446174614163636573730000000054020F497344657465726D696E697374696301812E01000500540E044E616D6512437573746F6D53656E644D61696C48656C70540E1146696C6C526F774D6574686F644E616D650B46696C6C48656C70526F775455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A446174614163636573730000000054020F497344657465726D696E697374696301540E0F5461626C65446566696E6974696F6E3F506172616D657465724E616D65206E7661726368617228313030292C20506172616D657465724465736372697074696F6E206E76617263686172286D617829814C01000400540E044E616D650B5175657279546F48746D6C5455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A446174614163636573730100000054557F4D6963726F736F66742E53716C5365727665722E5365727665722E53797374656D446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038391053797374656D446174614163636573730100000054020F497344657465726D696E6973746963000501000100000501000200000B0100030000000101020000260100846B0000020054020D416C6C6F774D756C7469706C6500540209496E68657269746564002601004C140000020054020D416C6C6F774D756C7469706C6500540209496E686572697465640026010002000000020054020D416C6C6F774D756C7469706C6500540209496E68657269746564000501000000000C0100040000000100010100000A010002000000010200000801000B00000000000000000000000000000000000000100000000000000000000000000000006887000000000000000000008287000000200000000000000000000000000000000000000000000074870000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058A00000000400000000000000000000000434000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000002000000000000000200000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00460030000010053007400720069006E006700460069006C00650049006E0066006F0000003C03000001003000300030003000300034006200300000006A002900010043006F006D006D0065006E0074007300000051007500650072007900200072006500730075006C00740073002000610073002000480054004D004C0020007400610062006C0065007300200066006F007200200065002D006D00610069006C0073000000000042001100010043006F006D00700061006E0079004E0061006D006500000000004400610072006B006F0020004D0061007200740069006E006F0076006900630000000000560017000100460069006C0065004400650073006300720069007000740069006F006E0000000000530069006D0070006C006500540061006C006B002E00530051004C0043004C0052002E00480074006D006C0000000000300008000100460069006C006500560065007200730069006F006E000000000032002E0030002E0030002E003000000056001B00010049006E007400650072006E0061006C004E0061006D0065000000530069006D0070006C006500540061006C006B002E00530051004C0043004C0052002E00480074006D006C002E0064006C006C00000000004600110001004C006500670061006C0043006F00700079007200690067006800740000004400610072006B006F0020004D0061007200740069006E006F00760069006300000000005E001B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530069006D0070006C006500540061006C006B002E00530051004C0043004C0052002E00480074006D006C002E0064006C006C00000000002E0007000100500072006F0064007500630074004E0061006D00650000000000530051004C0043004C0052000000000082002F000100500072006F006400750063007400560065007200730069006F006E00000032002E0030002E0030002B0037003800370061003300340062003700640064003300610036003900640065003400610063006100370033003400310033006300350066006300350064003700300063006100620033003400630036000000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000032002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000C000000943700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    WITH PERMISSION_SET = SAFE;
GO
CREATE FUNCTION [EMAIL].[QueryToHtml]
(
    @query [nvarchar](max),
    @Params [nvarchar](4000),
    @caption [nvarchar](200),
    @footer [nvarchar](1000),
    @rm [smallint],
    @rco [smallint],
    @style [nvarchar](4000)
)
RETURNS [nvarchar](max)
AS EXTERNAL NAME [SimpleTalk.SQLCLR.Html].[SimpleTalk.SqlClr.Html.UserDefinedFunctions].[QueryToHtml];
GO
CREATE FUNCTION [EMAIL].[ConCatHtml] (@mHtml [nvarchar](max), @sHtml [nvarchar](max))
RETURNS [nvarchar](max)
AS EXTERNAL NAME [SimpleTalk.SQLCLR.Html].[SimpleTalk.SqlClr.Html.UserDefinedFunctions].[ConCatHtml];
GO
CREATE FUNCTION [EMAIL].[CustomSendMailHelp] (@ProcedureName [nvarchar](max))
RETURNS TABLE
(
    [ParameterName] [nvarchar](100) NULL,
    [ParameterDescription] [nvarchar](max) NULL
)
AS EXTERNAL NAME [SimpleTalk.SQLCLR.Html].[SimpleTalk.SqlClr.Html.UserDefinedFunctions].[CustomSendMailHelp];
GO
SET NOEXEC OFF;
GO