-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathBigVariant.Install.SqlCmd.sql
131 lines (89 loc) · 37.7 KB
/
BigVariant.Install.SqlCmd.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
/*
Deployment script for PxtlCa.BigVariant.PublishDatabase
This code was generated by a tool.
Changes to this file may cause incorrect behavior and will be lost if
the code is regenerated.
*/
GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
SET NUMERIC_ROUNDABORT OFF;
GO
:setvar DatabaseName "PxtlCa.BigVariant.PublishDatabase"
GO
:on error exit
GO
/*
Detect SQLCMD mode and disable script execution if SQLCMD mode is not supported.
To re-enable the script after enabling SQLCMD mode, execute the following:
SET NOEXEC OFF;
*/
:setvar __IsSqlCmdEnabled "True"
GO
IF N'$(__IsSqlCmdEnabled)' NOT LIKE N'True'
BEGIN
PRINT N'SQLCMD mode must be enabled to successfully execute this script.';
SET NOEXEC ON;
END
GO
USE [$(DatabaseName)];
GO
PRINT N'Creating [PxtlCa.BigVariant.Core]...';
GO
CREATE ASSEMBLY [PxtlCa.BigVariant.Core]
AUTHORIZATION [dbo]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030076311C570000000000000000E00022200B013000003C00000008000000000000AA5A000000200000006000000000001000200000000200000400000000000000040000000000000000A0000000020000524E0000030040850000100000100000000010000010000000000000100000000000000000000000585A00004F000000006000003404000000000000000000000000000000000000008000000C000000205900001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B03A000000200000003C000000020000000000000000000000000000200000602E72737263000000340400000060000000060000003E0000000000000000000000000000400000402E72656C6F6300000C00000000800000000200000044000000000000000000000000000040000042000000000000000000000000000000008C5A0000000000004800000002000500743100002C27000009000000000000000000000000000000A0580000800000000000000000000000000000000000000000000000000000000000000000000000F20002037D0200000402032C180375130000012C0D0374130000016F1300000A2B01162B01177D0300000402036F1400000A28150000067D010000042A000000133001000C0000000100001100027B010000040A2B00062A1330010011000000020000110002280200000628140000060A2B00062A000000133001000C0000000300001100027B020000040A2B00062A1E027B030000042A133001000C00000004000011000228050000060A2B00062A133001001A00000005000011000228020000060A1200FE16030000026F1500000A0B2B00072A0000133001000C00000003000011000228040000060A2B00062A13300100110000000600001100022804000006A51100001B0A2B00062A00000013300100110000000700001100022804000006741A0000010A2B00062A00000013300100110000000800001100022804000006A51B0000010A2B00062A00000013300100110000000900001100022804000006A51C0000010A2B00062A000000133001000F0000000A000011001200FE1502000002060B2B00072A0013300200170000000B000011000228030000060228040000066F190000060A2B00062A00133002006D0000000C000011000228060000062C1E032C180375130000012C0D0374130000016F1300000A2B01162B01172B01160A062C0500170B2B3A03750200000214FE030C082C1D0003A5020000020D022804000006120328040000066F1600000A0B2B1000022804000006036F1600000A0B2B00072A000000133001001C0000000D000011000228060000062D0D0228040000066F1700000A2B01160A2B00062A13300100110000000E00001100028C1B00000173010000060A2B00062A820002036F1800000A7D0100000402022803000006036F180000067D020000042A8E0003022802000006D26F1900000A00022803000006030228040000066F17000006002A000013300300220100000F00001100020A06451100000005000000100000001B0000002600000031000000520000005A000000620000006A000000720000007A000000820000008A000000920000009A0000003C00000047000000389D00000073210000060B38C3000000732E0000060B38B8000000733A0000060B38AD00000073340000060B38A200000073400000060B389700000073460000060B388C000000734C0000060B388100000073520000060B2B7973580000060B2B71735E0000060B2B69736A0000060B2B6173700000060B2B5973760000060B2B5173640000060B2B4973820000060B2B41737C0000060B2B3973880000060B2B31720100007072550000707269000070281A00000A0F00FE16030000026F1500000A281B00000A7281000070731C00000A7A072A0000133002004D010000100000110002D01C000001281D00000A3B1001000002D023000001281D00000A3BFD00000002D022000001281D00000A3BEA00000002D024000001281D00000A3BD700000002D019000001281D00000A3BC300000002D026000001281D00000A3BAF00000002D028000001281D00000A3B9C00000002D02A000001281D00000A3B8900000002D02B000001281D00000A2E7902D02E000001281D00000A2E6902D02F000001281D00000A2E5802D030000001281D00000A2E4702D02D000001281D00000A2E3602D031000001281D00000A2E2502D01B000001281D00000A2E1402D01A000001281D00000A2E03162B021F0E2B021F0D2B021F0C2B021F0B2B021F0A2B021F092B011E2B011D2B011C2B011B2B021F102B021F0F2B011A2B01192B01182B01170A0616FE010B072C1C00728B000070026F1E00000A281F00000A7281000070731C00000A7A060C2B00082A2202282000000A002A000013300100070000000100001100160A2B00062A0013300100070000000300001100140A2B00062A0A002A0000133001000B0000000B0000110072E50000700A2B00062A0013300100070000000D00001100160A2B00062A2202281B000006002A4200020304A51200001B6F2100000A002A00000013300200120000000B000011000203A51200001B6F2200000A0A2B00062A000013300100130000000B000011000F01FE161200001B6F1500000A0A2B00062A0013300200120000000D000011000203A51200001B6F2300000A0A2B00062A000013300100070000000100001100170A2B00062A00133003002E000000030000110003036F2400000A6F2500000A036F2400000A6F2600000A59696F2700000A282800000A8C1C0000010A2B00062A4200030F02282900000A6F2A00000A002A0013300100120000000B000011000F01282900000A6F1500000A0A2B00062A000013300100120000000D000011000F01282900000A6F1700000A0A2B00062A2202282B00000A002A0013300100070000000100001100190A2B00062A0013300100160000000300001100036F1800000A282C00000A8C220000010A2B00062A4200030F02282D00000A6F1900000A002A00133001001500000011000011000F01282D00000A0A1200282E00000A0B2B00072A000000133001001500000012000011000F01282D00000A0A1200282F00000A0B2B00072A2202283000000A002A000013300100070000000100001100180A2B00062A0013300100160000000300001100036F3100000A283200000A8C230000010A2B00062A4200030F02283300000A6F3400000A002A00133001001500000013000011000F01283300000A0A1200283500000A0B2B00072A000000133001001500000014000011000F01283300000A0A1200283600000A0B2B00072A2202283700000A002A0000133001000700000001000011001A0A2B00062A0013300200200000001500001100036F3800000A0A036F3800000A0B0607733900000A8C240000010C2B00082A7A00030F02283A00000A6F3B00000A00030F02283C00000A6F3B00000A002A00133001001B00000016000011000F01283D00000A0A1200FE16190000016F1500000A0B2B00072A00133001001B00000017000011000F01283D00000A0A1200FE16190000016F1700000A0B2B00072A2202283E00000A002A133001000800000001000011001F0F0A2B00062A13300200200000001800001100036F3F00000A0A036F3800000A0B0607734000000A8C190000010C2B00082A7A00030F02284100000A6F4200000A00030F02284300000A6F3B00000A002A0013300100130000000B000011000F01FE16190000016F1500000A0A2B00062A0013300100130000000D000011000F01FE16190000016F1700000A0A2B00062A2202284400000A002A133001000800000001000011001F100A2B00062A13300200260000001900001100036F3F00000A0A1201036F3F00000A284500000A0607734600000A8C260000010C2B00082A000013300200260000001A00001100030F02284700000A6F4200000A00030F02284800000A0A1200284900000A6F4200000A002A000013300100130000000B000011000F01FE16260000016F1500000A0A2B00062A0013300100130000000D000011000F01FE16260000016F1700000A0A2B00062A2202284A00000A002A133001000700000001000011001B0A2B00062A0013300400560000001B00001100036F1800000A0A036F1800000A0B036F3100000A0C1A8D3A0000010D0916036F3800000A9E0917036F3800000A9E0918036F3800000A9E0919036F3800000A9E06070809734B00000A8C2800000113042B0011042A000013300200510000001C00001100030F02284C00000A6F1900000A00030F02284D00000A6F1900000A00030F02284E00000A6F3400000A00000F02284F00000A0A160B2B120607940C0003086F3B00000A00000717580B07068E6932E82A00000013300100150000001D000011000F01285000000A0A1200285100000A0B2B00072A00000013300100150000001E000011000F01285000000A0A1200285200000A0B2B00072A2202285300000A002A0000133001000700000001000011001C0A2B00062A0013300100160000000300001100036F5400000A285500000A8C2A0000010A2B00062A4200030F02285600000A6F5700000A002A0013300100150000001F000011000F01285600000A0A1200285800000A0B2B00072A000000133001001500000020000011000F01285600000A0A1200285900000A0B2B00072A2202285A00000A002A0000133001000700000001000011001D0A2B00062A0013300200180000000300001100031F106F2700000A735B00000A8C2B0000010A2B00062A4200030F02285C00000A6F2A00000A002A000000133001001B00000021000011000F01285D00000A0A1200FE162C0000016F1500000A0B2B00072A00133001001B00000022000011000F01285D00000A0A1200FE162C0000016F1700000A0B2B00072A2202285E00000A002A133001000800000001000011001F0B0A2B00062A13300100160000000300001100036F5F00000A286000000A8C2D0000010A2B00062A4200030F02286100000A6F6200000A002A0013300100150000001D000011000F01286100000A0A1200285100000A0B2B00072A00000013300100150000001E000011000F01286100000A0A1200285200000A0B2B00072A2202286300000A002A0000133001000700000001000011001E0A2B00062A0013300100160000000300001100036F6400000A286500000A8C2E0000010A2B00062A4200030F02286600000A6F6700000A002A00133001001500000023000011000F01286600000A0A1200286800000A0B2B00072A000000133001001500000024000011000F01286600000A0A1200286900000A0B2B00072A2202286A00000A002A0000133001000800000001000011001F090A2B00062A13300100160000000300001100036F3800000A286B00000A8C2F0000010A2B00062A4200030F02286C00000A6F3B00000A002A00133001001500000025000011000F01286C00000A0A1200286D00000A0B2B00072A000000133001001500000026000011000F01286C00000A0A1200286E00000A0B2B00072A2202286F00000A002A0000133001000800000001000011001F0A0A2B00062A13300100160000000300001100036F3F00000A287000000A8C300000010A2B00062A4200030F02287100000A6F4200000A002A00133001001500000027000011000F01287100000A0A1200287200000A0B2B00072A000000133001001500000028000011000F01287100000A0A1200287300000A0B2B00072A2202287400000A002A0000133001000800000001000011001F0D0A2B00062A13300100160000000300001100036F7500000A737600000A8C1B0000010A2B00062A3E000304287700000A6F7800000A002A0000133001000D0000000B000011000F01287900000A0A2B00062A00000013300100120000000D000011000F01287900000A6F1700000A0A2B00062A2202287A00000A002A00133001000800000001000011001F0C0A2B00062A13300100160000000300001100036F7B00000A287C00000A8C310000010A2B00062A4200030F02287D00000A6F7E00000A002A00133001001500000029000011000F01287D00000A0A1200287F00000A0B2B00072A00000013300100150000002A000011000F01287D00000A0A1200288000000A0B2B00072A2202288100000A002A0000133001000800000001000011001F0E0A2B00062A13300100160000000300001100036F2400000A738200000A738300000A0A2B00062A660004036F8400000A288500000A738600000A6F8700000A002A133001000C0000000B00001100036F8800000A0A2B00062A13300100110000000D00001100036F8800000A6F1700000A0A2B00062A2202288900000A002A0000133001000C0000000E000011000273010000060A2B00062A133001000C0000000E000011000273010000060A2B00062A13300100110000000E00001100028C1100001B73010000060A2B00062A00000013300100110000000E00001100028C1B00000173010000060A2B00062A00000013300100110000000E00001100028C1C00000173010000060A2B00062A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000014150000237E0000801500001009000023537472696E677300000000901E0000F000000023555300801F0000100000002347554944000000901F00009C07000023426C6F620000000000000002000001571FA2090904000000FA013300160000010000004400000018000000150000008D0000006E000000020000008900000011000000220000002A000000130000001E0000001E000000130000000100000003000000010000000000900401000000000006001D039A070600C2039A0706003B0268070F00BA07000006007E029E05060000039E050600CC029E050600A9039E05060063039E0506008E039E050600B1029E0506006A027B0706002D027B0706003D0300090A00420847070A00950247070600A20140050A00100447070A001B01C907060049084005060012029A070600F501680706004F0268070600010040050600900140050A00E704C9070A003504C9070A00D408C9070A007C0347070600F2058B0006003A078B000600520540050600CE0140050A00E903C9070A006305C9070A008D01C9070600EC00400506005B08400506006E0540050A008504C9070600880440050A004101C9070A00C200C9070600C50040050A00CB08C9070A007900C9070A002B00C9070A006600C9070A007A01C9070A00EB0247070600630440050600BD05400506004B0140050600CF059E05060039058B000600EC03400506006605400506002E00400506004401400506007C00400506006900400506007D0140050E00E405D3040E00DA05D30406002104B1080E002C07D3040E00250185050E002207D3040000000082000000000001000100090110008208D801450001000100010100004B05D801810004001400810110001408D801510016001400810010007B06D80151001600160001001000B806D801140016001C00810010000C00D801140016002200010010001207D801060016002900010010008906D8010A0016002F0001001000D306D8010E0016003500010010005A06D801120016003B00010010005D06D80116001600410001001000EE06D8011A001600470001001000A706D8011E0016004D00010010003A06D801220016005300010010002C06D801260016005900010010000307D8012A0016005F00010010001D06D8012E001600650001001000FF05D801320016006B00010010000E06D801360016007100010010009706D8013A0016007700010010004A06D8013E0016007D0001001000C606D801420016008300810110002608D80151001600890001004A05ED030100F403F1032100CA00F40306069700F7035680B404ED035680D408ED0356806305ED035680E903ED0356808D01ED0356808504ED0356804101ED035680C200ED0356807900ED0356802B00ED0356806600ED035680CB08ED0356807A01ED0356803504ED035680E704ED0356809001ED0356805B08ED0350200000000086186207FA03010090200000000083084705FF030200A8200000000083086C0604040200C820000000008308F10309040200E020000000008108BC04A2000200E82000000000E609C804A200020000210000000086089901C40002002821000000008608A3080904020040210000000086084C000D040200602100000000860800051604020080210000000086085D041B040200A021000000008608F30820040200C021000000009608AB0425040200DC2100000000C6005404C4000200002200000000C6000D08FA0002007C2200000000C600F90003010300A422000000009600EF012A040300C12200000000E601BD0031040400E22200000000E6010C02370405000823000000009600E4063D0406003824000000009600B80144040700000000000000C60DAC01FF030800000000000000C6050C024C040800000000000000C605BD0053040A00000000000000C605540459040B00000000000000C605F9005E040C009125000000008418620706000D009C2500000000C608AC01FF030D00B02500000000C600BD0053040D00C32500000000C6000C024C040E00C82500000000C600540459041000E02500000000C600F9005E041100F325000000008618620706001200FC2500000000C6000C024C041200000000000000C4051A0550011400102600000000C600540459041600302600000000C401240558011700502600000000C600F9005E041800000000000000C4050A055E011900F325000000008418620706001A00702600000000C608AC01FF031A00842600000000C600BD0053041A00BE2600000000C4001A0563041B00D02600000000C40024056B041D00F02600000000C4000A0571041E000E27000000008618620706001F00182700000000C608AC01FF031F002C2700000000C600BD0053041F004E2700000000C4001A0577042000602700000000C400240580042200842700000000C4000A0587042300A527000000008618620706002400B02700000000C608AC01FF032400C42700000000C600BD0053042400E62700000000C4001A058E042500F82700000000C4002405970427001C2800000000C4000A059E0428003D28000000008618620706002900482800000000C608AC01FF0329005C2800000000C600BD0053042900882800000000C4001A05A5042A00A82800000000C4002405AE042C00D02800000000C4000A05B5042D00F728000000008618620706002E00002900000000C608AC01FF032E00142900000000C600BD0053042E00402900000000C4001A05BC042F00602900000000C4002405C4043100802900000000C4000A05CA0432009F29000000008618620706003300A82900000000C608AC01FF033300BC2900000000C600BD0053043300F02900000000C4001A05D0043400242A00000000C4002405D9043600442A00000000C4000A05E0043700632A0000000086186207060038006C2A00000000C608AC01FF033800802A00000000C600BD0053043800E42A00000000C4001A05E7043900442B00000000C4002405F0043B00682B00000000C4000A05F7043C00892B000000008618620706003D00942B00000000C608AC01FF033D00A82B00000000C600BD0053043D00CA2B00000000C4001A05FE043E00DC2B00000000C400240507054000002C00000000C4000A050E054100212C0000000086186207060042002C2C00000000C608AC01FF034200402C00000000C600BD0053044200642C00000000C4001A0515054300782C00000000C40024051E054500A02C00000000C4000A0525054600C72C000000008618620706004700D02C00000000C608AC01FF034700E42C00000000C600BD0053044700062D00000000C4001A052C054800182D00000000C400240535054A003C2D00000000C4000A053C054B005D2D000000008618620706004C00682D00000000C608AC01FF034C007C2D00000000C600BD0053044C009E2D00000000C4001A0543054D00B02D00000000C40024054C054F00D42D00000000C4000A0553055000F52D000000008618620706005100002E00000000C608AC01FF035100142E00000000C600BD0053045100362E00000000C4001A055A055200482E00000000C4002405630554006C2E00000000C4000A056A0555008D2E000000008618620706005600982E00000000C608AC01FF035600AC2E00000000C600BD0053045600CE2E00000000C4001A0571055700E02E00000000C40024057A055900042F00000000C4000A0581055A00252F000000008618620706005B00302F00000000C608AC01FF035B00442F00000000C600BD0053045B00662F00000000C4001A0588055C00782F00000000C400240590055E00942F00000000C4000A0596055F00B22F000000008618620706006000BC2F00000000C608AC01FF036000D02F00000000C600BD0053046000F22F00000000C4001A059C056100043000000000C4002405A5056300283000000000C4000A05AC0564004930000000008618620706006500543000000000C608AC01FF036500683000000000C600BD00530465008A3000000000C4001A05B3056600A43000000000C4002405BB056800BC3000000000C4000A05C1056900D930000000008618620706006A00E430000000009600EE04C7056A00FC300000000096008D08CE056B0014310000000096003400D4056C0034310000000096003F042A046D005431000000009600DE08DF056E0000000100FB0300000100750400000100FB0300000100660700000100BD0800000100D30100000100D30100000100BD0800000200FB0300000100660700000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100BD0800000200FB0300000100BD0800000200FB0300000100FB0300000100FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100660700000100BD0800000200FB0300000100FB0300000100FB0300000100FB0300000100FB0300000100FB0300000100FB0300000100FB030200490002004D00090062070100110062070600190062070A00290062071000310062071000390062071000410062071000490062071000510062071000590062071000610062071500690062071000710062070600810062071A00A90062070600B90062072000E900620706009101620706009900C804A200A100CB01A600A1005404C400A1000D08FA00A100F9000301F100E0030C01F9000C021001990142081C0199013B082301A1016207290109015D013701B1018401C400990142084001A100620706009C001A0550019C00240558019C000A055E01F10031056401B9016A046A01B901B0056A01F100DE076E01E1006A087401E100F1037B01F9000C0280010C006207060011016A0886011101F1030C01C1015404C400C101F9000301140062070600F1005705A20019016A0897011901F103A200F9000C021500C9015404C400C901F90003011C0062070600F1002100030121016207AE01210100080301F9000C0201002101F20703012101F103BA01240062070600F1005C006A01C9006207CD01C900E8076A01F9000C02D501C900E300DA012C006207060039016207D50131016207E8013101E8076A0131015008F6013901E8076A01340062070600410162070502410177050C01410111010C0141010104A2004101AB0015024101F103210249015404C4004901F90003013C0062070600F10036012E0251016A0832025101F1032E02F9000C023902D9015404C400D901F90003014400620706005901620780015901BF087B015901F1034F024C0062070600F1007904210269016A085C026901F1032102F9000C026502540062070600F1006F006C0271016A0870027101F1036C02F9000C027702E1015404C400E101F90003015C006207060079016A0886027901F1030301D1015404C400D101F900030164006207060081016A0897028101F1036A01E9015404C400E901F90003016C0062070600F1002A04C400D90062071000D9007608A802F9000C021000D900F103C400740062070600F1006F01AE0289016A08B2028901F103AE02F9000C02B902F1015404C400F101F90003017C0062070600F9016207C802D1006207CF02F9003105640109020501D60211026207DC021902DE04E602D100F103C400840062070600080014009803080018009D0308001C00A20308002000A70308002400AC0308002800B10308002C00B60308003000BB0308003400C00308003800C50308003C00CA0308004000CF0308004400D40308004800D90308004C00DE0308005000E30308005400E8032E000B0019062E00130022062E001B0041062E0023004A062E002B0066062E00330066062E003B0066062E0043004A062E004B006C062E00530066062E005B0066062E00630091062E006B009D0343007300C40661007B009D0361008300BB0664008B00F006A0007B009D03C9008B007507E9008B00220709018B00880729018B00220749018B00F00669018B00F006440D8B002207640D8B002207840D8B003507A40D8B005407C40D8B005407201193009D03401193009D03601193009D03801193009D03A01193009D03AC00B100B600BA00BE00C800D800DD00E200E700EE00F200FF00070115012F018D0192019E01A301A801B401BF01C501E001F001FC010E021A0227023E024302480255027C0281028D0292029E02A302BE02C3020200010005000D0006000E0008000F00090010000A0011000B0012000C0013000D0014000E0015000F00160010001700110018001200190013001A0014001B0015001C0016001D0017001E0000004B05E60500007E06EB050000F503F0050000CB04F4050000CC04F4050000CE01F8050000A708F00500005000FC05000004050506000061040A060000F7080F060000CE0414060000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E6050000B001E605020002000300020003000500020004000700020005000900020006000B00020007000D00020008000F0002000900110002000A00130002000B00150002000C00170002000D001900020016001B0002001C001D00020029001F0002002F00210002003500230002003B00250002004100270002004700290002004D002B00020053002D00020059002F0002005F00310002006500330002006B00350002007100370002007700390002007D003B00020083003D0026002D0035003D0045004C0054005C0064006C0074007C0084008C0093009B00D10046014901048000000000010045171B9F01000000F602D8010000020000000000000000000000ED02B40000000000020000000000000000000000ED029F0000000000020000000000000000000000ED02D30400000000000000000E0095000000004E756C6C61626C65603100547970656453716C5479706548656C70657260310052656164496E7433320053716C496E7433320042696756617269616E7446726F6D4461746554696D6532006765745F41734461746554696D65320052656164496E7436340053716C496E7436340052656164496E7431360053716C496E743136003C4D6F64756C653E0053797374656D2E494F00540076616C75655F5F0053797374656D2E44617461006765745F44617461006D73636F726C696200526561640053716C47756964003C5F49734E756C6C3E6B5F5F4261636B696E674669656C64006765745F4B696E64004461746554696D654B696E640047657448617368436F6465006765745F556E69636F6465006765745F5363616C6500494E756C6C61626C650049586D6C53657269616C697A61626C650052656164446F75626C650053716C446F75626C650052756E74696D655479706548616E646C65004765745479706546726F6D48616E646C65005265616453696E676C650053716C53696E676C65006765745F4E616D650053716C4461746554696D65006765745F547970650056616C756554797065006765745F53716C547970650047657453716C5479706546726F6D5479706500476574547970650074797065005078746C43612E42696756617269616E742E436F726500506172736500446562756767657242726F777361626C65537461746500577269746500436F6D70696C657247656E65726174656441747472696275746500477569644174747269627574650044656275676761626C6541747472696275746500446562756767657242726F777361626C6541747472696275746500436F6D56697369626C6541747472696275746500417373656D626C795469746C654174747269627574650053716C55736572446566696E65645479706541747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C79436F6E66696775726174696F6E4174747269627574650053716C46756E6374696F6E41747472696275746500417373656D626C794465736372697074696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F6E7341747472696275746500416C6C6F775061727469616C6C795472757374656443616C6C65727341747472696275746500417373656D626C7950726F647563744174747269627574650053716C466163657441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C79436F6D70616E794174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650052656164427974650053716C42797465006765745F56616C75650076616C7565006765745F4973506F736974697665004942696E61727953657269616C697A6500456E636F64696E670052656164537472696E670053716C537472696E670042696756617269616E7446726F6D537472696E6700546F537472696E67006765745F4173537472696E67006765745F4C656E677468006F626A0052656164446563696D616C0053716C446563696D616C005078746C43612E42696756617269616E742E436F72652E646C6C006765745F4E756C6C0053716C4E756C6C006765745F5F49734E756C6C006765745F49734E756C6C0053797374656D2E586D6C005772697465586D6C0053716C586D6C0042696756617269616E7446726F6D586D6C006765745F4173586D6C0047657448617368436F6465496D706C005772697465496D706C00546F537472696E67496D706C006765745F4261736553747265616D0053797374656D006765745F53716C54797065456E756D0052656164426F6F6C65616E0053716C426F6F6C65616E0054696D655370616E006765745F507265636973696F6E0053797374656D2E586D6C2E53657269616C697A6174696F6E0053797374656D2E5265666C656374696F6E006765745F506F736974696F6E00417267756D656E74457863657074696F6E004D656D626572496E666F00586D6C52656164657200586D6C546578745265616465720042696E6172795265616465720053716C496E74333248656C7065720053716C496E74363448656C7065720053716C496E74313648656C7065720053716C4775696448656C7065720053716C446F75626C6548656C7065720053716C53696E676C6548656C7065720053716C4461746554696D6548656C706572006765745F5479706548656C7065720053716C5479706548656C7065720053716C4279746548656C7065720053716C537472696E6748656C7065720053716C446563696D616C48656C7065720053716C4E756C6C48656C7065720053716C586D6C48656C7065720053716C426F6F6C65616E48656C7065720047657448656C706572004461746554696D654F666673657448656C7065720053716C4D6F6E657948656C7065720053716C42696E61727948656C70657200586D6C57726974657200586D6C546578745772697465720042696E617279577269746572004D6963726F736F66742E53716C5365727665722E536572766572002E63746F720053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E496E7465726F7053657276696365730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F6465730053797374656D2E446174612E53716C547970657300526561644279746573006765745F5469636B73006765745F54696D655469636B73006765745F4461795469636B7300457175616C730053716C54797065457874656E73696F6E730055736572446566696E656446756E6374696F6E7300436F6E63617400466F726D6174004F626A656374006765745F4F6666736574004461746554696D654F6666736574006F705F496D706C69636974006F705F4578706C696369740042696756617269616E740042696756617269616E7446726F6D56617269616E74006765745F417356617269616E740053797374656D2E54657874007700546F4279746541727261790053716C4D6F6E65790053716C42696E6172790042696756617269616E7446726F6D42696E617279006765745F417342696E6172790053797374656D2E53656375726974790000537B0030007D00200068006100730020006E006F0020006300610073006500200074006F002000680061006E0064006C006500200074006800650020007B0031007D002000760061006C00750065003A0020000013470065007400480065006C007000650072000017530071006C00540079007000650045006E0075006D0000097400790070006500005922007B0030007D00220020006900730020006E006F007400200061002000760061006C00690064002000530051004C0020007400790070006500200066006F0072002000420069006700560061007200690061006E00740000094E0055004C004C000000C5501D404A733D418706B82A6DDC3B5600042001010803200001052001011111042001010E042001010205200101113D0520010111590615121C0111710715121C011180890715121C0111808D0715121C011180910615121C0111650715121C011180990715121C011180A10715121C011180A90715121C011180AD0715121C011180B50715121C011180B90715121C011180BD0715121C011180C10615121C01116D0715121C011180C50615121C01126903200002052000128085040701110C04070112140307011C03070102050702110C0E0320000E080701151161011165061511610111650407011269040701116D0407011171060702110811080307010E0707040202021108042001021C03070108032000080407011108032000050420010105060702110C12140600030E0E1C1C0500020E0E0E052002010E0E070703110C02110C0800011280851180D50500020E0E1C0213000615121C01130007200201127D13000520010E13000520010813000520001280DD0320000A0520011D050806000111711D050420001D05052001011D0506000111808905040702050E040702050806000111808D02040702020E040702020805070308081C05200201080805070211650E04200011650507021165080707030A1180951C072002010A118095042001010A0520001180950707030A11809D1C072002010A11809D05070111809D05200011809D0807050505021D081C082004010505021D080607031D0808080420001D080607021180A50E0520001180A50607021180A5080320000D0600011180A90D042001010D0407020D0E0407020D080607021180B10E0520001180B10607021180B1080800011180B51180A5062001011180A5032000060600011180B9060420010106040702060E04070206080600011180BD08040702080E04070208080600011180C10A0407020A0E0407020A080500010E116D0320000C0600011180C50C042001010C0407020C0E0407020C08062001011280DD06200101128101050000128105092002011280DD1281050620010112811108B77A5C561934E08980A000240000048000009400000006020000002400005253413100040000010001008D378587D237D6A99FC9D6FC67EBEECF7BD0031ECF28E6B831B6E0D78E099C1F1E0D89579389299289869FA0D64FC946965E78010F3A24ED3F34620843FCF7CF96F291870D395DE1DC61D6EE82FA89CCD7FDE046B42E6B79B68B6896B7522577D82944695F837B406715426BA070D2A8D7A164C9BDB3DE5FFD6B9A8F5DB5B5D20400000000040100000004020000000403000000040400000004050000000406000000040700000004080000000409000000040A000000040B000000040C000000040D000000040E000000040F00000004100000000306110C02061C020602020608042001011C042000110C04200012140320001C0820001511610111650420001269042000116D042000117104000011080600011108116D05200101127905200101127D0600011214110C070001110C12808506200201127D1C0520011C12790420010E1C042001081C07200201127D11710520010E117105200108117108200201127D1180890620010E1180890620010811808908200201127D11808D0620010E11808D0620010811808D08200201127D1180910620010E1180910620010811809107200201127D11650520010E116505200108116508200201127D1180990620010E1180990620010811809908200201127D1180A10620010E1180A1062001081180A108200201127D1180A90620010E1180A9062001081180A908200201127D1180AD0620010E1180AD062001081180AD08200201127D1180B50620010E1180B5062001081180B508200201127D1180B90620010E1180B9062001081180B908200201127D1180BD0620010E1180BD062001081180BD08200201127D1180C10620010E1180C1062001081180C107200201127D116D0520010E116D05200108116D08200201127D1180C50620010E1180C5062001081180C507200201127D12690520010E12690520010812690600011108126905000111081C0A0001110815116101116506000111081171042800110C04280012140328001C032800020328000E0828001511610111650428001269042800116D042800117104080011080801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010801000701000000001B0100165078746C43612E42696756617269616E742E436F726500000501000000002401001F436F7079726967687420C2A9204D617274696E205A6172617465203230313600002901002436303334336138362D323061392D346137342D626237662D66623361343630333163343000000801000000000000002B010002000000020054020D497346697865644C656E6774680054080B4D61784279746553697A65FFFFFFFF310100030054020D497346697865644C656E6774680054020A49734E756C6C61626C65015408074D617853697A65FFFFFFFF120100010054020A49734E756C6C61626C65011E0100020054020A49734E756C6C61626C65015408055363616C650700000020010002005408074D617853697A65FFFFFFFF54020A49734E756C6C61626C6501120100010054020A49734E756C6C61626C650010010001005408055363616C65070000000000005BCC8C2A6D704BC5315444D28B084BA698C47A8B6145E0B94BB7456ED0CCAB471FCAF64D5D6015A27A8BD39ABDE50A7F5E7DE4F5FCB22EEEADB7E8872E7D896CFFB05A9E63511963763CB8EF231F7DF7FB2FCE4009A258F79B3EE20D74C805CC3BA4B8B5F117DB531F16EDFC0DD66063135F8B890283345A92EEB87EBF294BCD0000000076311C5700000000020000001C0100003C5900003C3B000052534453F3018E6D39962448AFBC196DACD90E4401000000433A5C55736572735C4D617274696E5C44726F70626F785C50726F6A656374735C4769744875625C42696756617269616E745C5078746C43612E42696756617269616E742E436F72655C6F626A5C44656275675C5078746C43612E42696756617269616E742E436F72652E706462000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000805A000000000000000000009A5A00000020000000000000000000000000000000000000000000008C5A0000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058600000D60300000000000000000000D60334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100010000001B9F4517010000001B9F45173F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00436030000010053007400720069006E006700460069006C00650049006E0066006F0000001203000001003000300030003000300034006200300000001A000100010043006F006D006D0065006E007400730000000000000022000100010043006F006D00700061006E0079004E0061006D0065000000000000000000560017000100460069006C0065004400650073006300720069007000740069006F006E00000000005000780074006C00430061002E00420069006700560061007200690061006E0074002E0043006F0072006500000000003E000F000100460069006C006500560065007200730069006F006E000000000030002E0031002E0035003900350037002E00340030003700330031000000000056001B00010049006E007400650072006E0061006C004E0061006D00650000005000780074006C00430061002E00420069006700560061007200690061006E0074002E0043006F00720065002E0064006C006C000000000062001F0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D0061007200740069006E0020005A006100720061007400650020003200300031003600000000002A00010001004C006500670061006C00540072006100640065006D00610072006B00730000000000000000005E001B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000005000780074006C00430061002E00420069006700560061007200690061006E0074002E0043006F00720065002E0064006C006C00000000004E0017000100500072006F0064007500630074004E0061006D006500000000005000780074006C00430061002E00420069006700560061007200690061006E0074002E0043006F00720065000000000042000F000100500072006F006400750063007400560065007200730069006F006E00000030002E0031002E0035003900350037002E00340030003700330031000000000046000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0031002E0035003900350037002E0034003000370033003100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000C000000AC3A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000;
GO
PRINT N'Creating [dbo].[BigVariant]...';
GO
CREATE TYPE [dbo].[BigVariant]
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.BigVariant];
GO
PRINT N'Creating [dbo].[BigVariantFromBinary]...';
GO
CREATE FUNCTION [dbo].[BigVariantFromBinary]
(@value VARBINARY (MAX))
RETURNS [dbo].[BigVariant]
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromBinary]
GO
PRINT N'Creating [dbo].[BigVariantFromDateTime2]...';
GO
CREATE FUNCTION [dbo].[BigVariantFromDateTime2]
(@value DATETIME)
RETURNS [dbo].[BigVariant]
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromDateTime2]
GO
PRINT N'Creating [dbo].[BigVariantFromString]...';
GO
CREATE FUNCTION [dbo].[BigVariantFromString]
(@value NVARCHAR (MAX))
RETURNS [dbo].[BigVariant]
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromString]
GO
PRINT N'Creating [dbo].[BigVariantFromVariant]...';
GO
CREATE FUNCTION [dbo].[BigVariantFromVariant]
(@value SQL_VARIANT)
RETURNS [dbo].[BigVariant]
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromVariant]
GO
PRINT N'Creating [dbo].[BigVariantFromXml]...';
GO
CREATE FUNCTION [dbo].[BigVariantFromXml]
(@value XML)
RETURNS [dbo].[BigVariant]
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromXml]
GO
--SSDT/SQLCLR fails at DateTime2, must redefine f'n to use DateTime2.
ALTER FUNCTION [dbo].[BigVariantFromDateTime2](@value [datetime2])
RETURNS [dbo].[BigVariant] WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [PxtlCa.BigVariant.Core].[PxtlCa.BigVariant.Core.UserDefinedFunctions].[BigVariantFromDateTime2]
GO
GO
PRINT N'Update complete.';
GO