ALTER TABLE [dbo].[patientcareplan] ADD [NAASwabLoc] [varchar](max) ALTER TABLE [dbo].[patientcareplan] ADD [PlanOfCare] [varchar](max) DECLARE @var0 nvarchar(128) SELECT @var0 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'GonCult'; IF @var0 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var0) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [GonCult] DECLARE @var1 nvarchar(128) SELECT @var1 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'GonCultLoc'; IF @var1 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var1) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [GonCultLoc] DECLARE @var2 nvarchar(128) SELECT @var2 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'GonCultDesc'; IF @var2 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var2) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [GonCultDesc] DECLARE @var3 nvarchar(128) SELECT @var3 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'WetPrep'; IF @var3 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var3) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [WetPrep] DECLARE @var4 nvarchar(128) SELECT @var4 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'WetPrepDesc'; IF @var4 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var4) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [WetPrepDesc] DECLARE @var5 nvarchar(128) SELECT @var5 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'OthCultTak'; IF @var5 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var5) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [OthCultTak] DECLARE @var6 nvarchar(128) SELECT @var6 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'OthTestPer'; IF @var6 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var6) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [OthTestPer] DECLARE @var7 nvarchar(128) SELECT @var7 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'Serology'; IF @var7 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var7) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [Serology] DECLARE @var8 nvarchar(128) SELECT @var8 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'SerolDesc'; IF @var8 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var8) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [SerolDesc] DECLARE @var9 nvarchar(128) SELECT @var9 = name FROM sys.default_constraints WHERE parent_object_id = object_id(N'dbo.patientcareplan') AND col_name(parent_object_id, parent_column_id) = 'POCAddCom'; IF @var9 IS NOT NULL EXECUTE('ALTER TABLE [dbo].[patientcareplan] DROP CONSTRAINT ' + @var9) ALTER TABLE [dbo].[patientcareplan] DROP COLUMN [POCAddCom] INSERT INTO [__MigrationHistory] ([MigrationId], [Model], [ProductVersion]) VALUES ('201811291931204_Various', 0x1F8B0800000000000400E55DDD72E3B895BEDFAABC834BF76975F764B2C9943B2959B2A75D69DB2AC9DD7D4D4BB0CD8C442A24D563EFABEDC53ED2BE42001200F14712878008A67C671F91DF0140FC1C1E80DFF7FFFFFB7FE77F7FD9EFCE7EA02C8FD3E4D3E4C3BBF79333946CD26D9C3C7D9A1C8BC73FFE65F2F7BFFDE1BFCE2FB7FB97B36FECBA8FE43A7C67927F9A3C17C5E197E934DF3CA37D94BFDBC79B2CCDD3C7E2DD26DD4FA36D3AFDF8FEFD5FA61FDE4F11869860ACB3B3F3D53129E23D2AFFC1FFCED364830EC531DADDA45BB4CBA91DFFB22E51CF6EA33DCA0FD1067D9A2CD1365ECF6E2F97595AA49B7437399BEDE20897638D768FC042BDFF2B29D484BBC30E2F71C18AD7FBD7032A9D1AFC0957E3EBFF815E250336E12B0F282B5E57E8B101E37A31399BCA38531588C3B46090627E9A5C27C54F1F2767B7C7DD2E7AD861C363B4CBD1E4ECF0E75FD6459AA15F5182B2A840DB65541428C38FEF7A8BCA6AD2E6FAE5F067BB16FBEBF4FD47D262D32849D2222A705F902B723EADDBAFB55557E829CE8BAC82E8D1A2E2FD7D5A53BD7F742DA91779916E8E7BECADBBB8ED38B327E406709F1EA2FF59C74F0C655D6478B6989C5DC52F68FB05254FC53347BA895E9805FF3939FB9AC47872C13715D911899EABFFED1C5FEF9FBEC7DBE23964013EA3F8E9B9387109AC87D375F29866FBDEA349B8BDCF60526E7F43630937E1C5EBE0DDB0F44AFE1CDCF375B259E06736FCC0DBE3A8A0C061C2A9479CA1AB146899A11F972FFBC15D5FBE44FB2FE96670BF5FA287FC3E43D1F08D7DB35CCF2EE79F034CEC2FEB021D06F77B15EFD0F6E70FB3E17BF57A7D777535FCCC7528EED3DF9300332609F6E2533BB65EAFD7E9268E769F71089A66AF7D566C09A0CF9AAD01BCA9553B3FCCB6DB6CF06EF839DDA30FB71FC2F89D05F2BB0AE4F7F663A0760EE47715C8EFED4F81DA3990DF5520BFB77F0AD4CE81FCAE02F9BDFD39503B07F2BB3AB55FEBA8E8066DE38D53582423F4898B74843714182DE7CBC1FB20F6B97C4E93E1730AD8310902878F4EB0E32FDFF2002FD7687B573CA3E1C3DEEBFD7E81F2E1F3189F97DFBE45C3BB5DE286C6A687E11D7F4EF3C3E56278BFEB6336FC6EC0F23AF9E7310B907DC57EC374E7F52C88DF1B94DC25390A3061956E6F7976EC224D77284AC0CB1AAE403E3F66992BCE979BE197475C76EC36C8739FED76287B8A513EB867F2B0F0247A6AC7D681E902FD40BBF440422CA7F0D484D327486DC27943A12A6E82D9E1E03CA41738220A33B88A22D9AE37C3EF61FF9A45DBE183EDAABA871015C63E9728233BD4C3CF638B8B0C450142FDF9E25BF414275100C74B94C401568CC50A6D8AE3F08F98CC43DB2D39013196C56A857EC4E8F7BBC7F56B5EA07DBFC3552242BFE3552AC21B5A9A7025E222C54D30FCDCCE3C0759D2B0F740950E55E3CBDBFB1035AEDC06A931D93A0D5165EA37489DE751B68D838C67EE39CC78C6914B16661E639EC3E43B8EF9E618A2DACC71905AAF7F8B834CDFD46F903ADFA263980ECE1C0F506BEBB8F10A07533B548610D18E1C3DEC133A6A207DA24723C81B0A20BF440F37D13F431CFBC46E830C44E2FAE4A7F39ADC86092A3EA7E9368CD720F5C5637A1E0FBFF558B90D52E36F282FE287E36EF8641BF11CA4CA5F33543C67C3679D4ABF61BA759AE7D16D347C04513A0E52E5E5FC2A3D0E3F922BB7614672985C2A761B669FF915073161BC86ABEFFA393A0C3F53D7AE4375EC459C07D893218EC3845D28FB11BF04721B2AF0C22F457727FF5AD6FA3D73F9FC9A9323967D5F31C5FB7B7D48AFDCFF865E2C07F9685977FB3D8CDB7BB41FFE8BBECFAB30B9F1105FE55E0C7F1C0A0FC3D9E180A200DF6E5D5EDEDE87F11A6CA767FE2D90DB3047721EB66988C8B7F41B26F42D771C7681DC06DBE608E234CC06358E714E1FFA19965E1CDBA0EC2290DFE5A90904AC63DD59923EB96DA8C8087DE25D1DE10D45BCCB0CE58BB2ED071F7ACB348FABAA06F11C66BEB941C573807D8DD26F981A5FFEEB180FFF9A51B91DD3F6319E25623C60E7518696BBA8170D9502D1EBE55E877843B3DDFAFE3A79BC477931FC01DCCA75A05DA73841F7212ACD3C0FFFCE5F790E93427DDECD8FBB0067DA2BBF2108B1A8EB30679466B3F5EFD1F01F9352BF219A9BBA0E9304D86ED7285BA1009E2BBF616ABDBE0FB36CCCEEE33D0AE89AB0190EEFFA066DAFD25D80BC4BE57711A0CAEB643B8FF2E173D4D46FC0B964F8B321D46F98D32138EABE7B24F1F7585E4CE6CFF16E8BE369B2058B7EEFF35E2223F4792DD111DED05B099E75F0BB0139681062C223AEC3B02610D7E5831FDC77E97841D8E2C73208AF934D4C7A6EF9A1648F2128DEDF8FA25ABEFF0D0DBF75B619E0F3545393175F7314A2F317E48F107EBF4449001E1C941D825498385EA1E1A358E257103118F0015773C858E6D45992928FDE9DF6966A809E5B4B32C01B9A562F8E45916E7E1BFE4D8A380EF33A931C03BCA563A7615E64829C1458063B2A30FB86B200936AE536507F8E768B3890DB316DDDDDB87FF779E3FED5A701E20D2D27F3389B07A0AFF91AE6FC3FC9F8064842FE1A869CA8721BEA8BBCA878BE09A1E5F235236EC3E45EAAA964441F3D0813DB2CCF519E9339A3CF446B04EA33DD3602BDA1491757E2F2A5ACFD58FA499D3E9FED48B3E2E6F8817A9DA53101F53A51D304F486FAC9F83635CA653BC2913349ED39769526AC5ECCA42D586FA8C3906608CE0948E4F2A218B7262DD4E341D5905D3C906BD08BBA1255F7AF51C1336EF27D78BAAC1D7F2A9577DFE9BABCD376505182D5042849C47681091294262C511FB30B4A54C62AC98F353459BDAB0B4F529430032AC2175D8806FA5F33AE91B7B8FBB988DC8DE62723314C76016A743E264C9D7DA80B56FC8ED3D821C5EF4CBBC0E443F22638E5287F67E9E483A8C6022A2766BB20E54D6413A2B2D5DD3D68EA4D31F3A81136ED2C5AB0CE053734A090AEEE1C35DD5D464D5B74411A235E13B03958EF7CE2A640C9F8DC8D315EE7A06F58598DE3BE293A30AE1E7C9DE0BF9D4F2BDD756A389F3608B49FDF4487035ED804C1766A395B576AEDF33FAEE19AECFB0A63BAC90DD2ECBCB4DC139ED5A227A4FC8A5DE3925EC5595E2CA2227A28CF1ECDB77BEDB21EAB22F3DCB438AA2157FD7CD89DE46FF3DDFA3AAAA0D56D7C85AB4D7A66D9028897AE4BB29E82ACF1D41865DAD69A2E323F4F77C77DD2FCFB542FE05429A1DA2053AD459430536D6AAB072107144E0FA1599EDEEA01B4DFDED4F8AA26BDD8F0ED7AF76DA862482B228A767BB472DF5584290DF6F7D7DAF122486D8523D562F026C4FAD75EC88C30A1019AFD3C9A212085C14E23A05151BE84EA1A00AD7737B5BB22232FB679AB407D1BA6DFDE4FE5DEE581599A8018D5790D0DA732DB63713976B9ADA811D0E3057975A9AB0B76409B0B8AE9529B0B767B342E822E4271A33DCE975AD45C4412CCF6585CA65C44E246C84C4365C7E5F9851AED716A197111A8B6029E1DD505979E1BB501FA3893F9967A383342C64A4E65BBE5A1C2ACA39977D59C81D3D4DB220E5E82754DBE1DF73735B6A6082EB67987DE786B97F23C0533ED6EA54B50AB3D1217E31681B811883333E1CCE0382B13CE0A8E43C4AFF57A7D84D7CB843383E3AC4C382B380E119BD6EBF513BC5E269C191C6765C259C17188B8B35EAF3FC1EB65C299C17156269C151C878829EBF5FA195E2F13CE0C8EB332E1AC8C388196122D5DECB496B4492A97685D8B4917406388A4E9284BB152874E731BB2DFF5A4943C96521CC400BA9FCA172B20D40A42A27AC40A12B582902A816105A83202C25C2E18AC3C3B6A05BCA8300560E94585190163982AFA4A4398DA00EDC3057AA506E256001253DC95809811805329E84A28950980C1F4702514660444585CDF568AB0B815F0B49860ADF4B89811D20F9900ADDC0F991580C4156525246E0595896ACA2A65A256C08BE98D320395065049B842AC52166E0724F86AD15729CD579BEDB16A195711AAB68E66CD6DD850755A79BB35634BCCAEF5D70EA671AD6C108A95D64D2B51DA562F5E5764AEECAA14B2320270B8B4AB04C4AD8031C1B55AA521C1ADF648547C5584A12668690E0DE539004B24AAA34A2FFC821D30E2B9E0A934E2B91582C458F76524668520D153BF321035427098C4A80CC4ACB01ECE3443D54ECEECA3991BD5E3208EFB6ACDDAA4255AF7CE5A3B4073DA48152495D347ED82A7AD0FD3EBE42768874A93446DEE81A5CF82CA4F204C53E1E0256B2A568F3231154E698380DAA0287A99443B2C4DA9158A1BC13886785CFC013089D55A96D22C569B7B60E9A5537E02F48C5A7352EA18B5B90796A1A3C93F01826DAE0D2985DADC0A473204EED22F80A59C29384AEB38338271F482493FD8E3D52A8B22586D8523E945937F19CDE26938FAE8B47E76683496805D4BA80546E33EA3499851DA72EC967F6CC3F7BB967EA1328ACA766F6983A2E83D4EB4C3D0D4FD4C6683A298CBC4EC8079BC922294E6EFCA04C430AC03B519B09B4DA502958E55DAA0287A9144BB3D9A20E62782096618965EAEDA6A8FC4F5F644206E04E2E84512CC8076E78A7852AB732B10C9F0006B3324255E89D6C919F1CA0645D18B24DA01FDC0F0820B7FBDE52A710A0C38595BA9BE49A9DACA04C430A47C6B33108BAAB26960D4DE07ADA178C26FB0B6AFBE9F561BBFB2C290CC8F113C9B538533691AA636288A614217ECA0B9987D8EAB4CC5CC3C9A884DFEAAC429586B163A2BB13A4F71B7DEDE384529EA66D234D5AA9CD686EA3730339DAA6D3E4ADB84F2DD80F21D8C52898449E7EF4A0BA0362BA5262BF00BBE7686B3B6DA235D28DB4817A05D2441584BC9C83033A0452AA92CA9512A1310C33057D766581B13292BB585890D8A62CEC4303B208BCFC4A6A4143E3302710C6BAE6807262576867484F63967374A436263D727ADA1E721A008E66C0638D5C8F494A40C213302661DA68F244D3CCC08C5597E36012D8D4791032DABEAF7954E0B6B9BAA5289D6B5B47601340E364D4A491A721D524D6DC89E0F35D5AA47D2FA5F9B015DBED631923A7D6D86621972EC821D80C6C48624286604E2180A75D3E3ED97C9014940D40645311449B08F66686B5F3ABB05CD6D3242255C67DCDC85D0386A74ED2069F474A913B561FB1DDFA2CE8FB4A40976289A618114EC905C1257E3917349DC0CC75A99B14081B6A898A38381DFB299088EF472CC8C601CED0327D10E4633BCB68B3F00F65B98F68CB4D5C28C601CAD96A21D8C66D804127F0084D0B5E48BB49CD766009628E222A1893F40F0EE0DE3BCB6029004A515094BB003D1A8788A8646EDA083C6951E8A7C7E911AC1380BB554A21D302F32C91269526446308E6182157F80F6D71FA6DE0ACAAF4B3221062C708E5D60C992164EC13E9AA8452553710A5ADA24464AB4AE98A50BA079C2577545E459BF5DB7A40DD96FC0224A80280393DBC1688613CFB51D8A46853A7438FA833D9E28BE21C289F6D10C039902C86910344B7C9458DD94016DB73737B6ACEB2137789B66481BAAE7689D097048733F33423A1615D4902B498D201CF287865319413895E08582531901EB0617B090560D6E8521958A142A506984E1684C27DC086921A61861EA97239A0614F22ED7EC5C932C450966919C6BBBBF2537276B5128A9B936A58B365CBF7341AD1A216DD5702B0C495F026B2B200E2C751DE4E63AC2DE06B848838A028E21F56CFF129AEE5F9AF3FDCB3E097FA68A20D58BDAA028861612EC90D6AE740BE4B6AE6C5014D353ABEDA3999F343640A719AA55EFA084EBFC2ABAEF094A83C88114728EE7F4241324905E28A80D9075339C8FF90A3E1DC3E402E46DFA1C9865F8D5F01DD0AFE0CF8044327F1DA9C7093ECECFAF1CBDE376085A4DB92FA3D576C08B91C0A26FE8A4E33AB7D340EEE9344F5890F697A05DB385254ECBD10C3353BF7250C34617A0CD8FF72F9938B7BE52506E1F4DEF69E06E75DBC9EAA6F2B7EA3D9638DD5939858EDD9CA26BE57F1FAEF7FC47E5129BA9799D3A901DC7BF551FB2876A7CBC2DC4FED2E3B6161318AE33D56CFC6A49837C6BABF12EAB9770EFD4C2FFE7BCCB94F35822632E6B4FA895CB5AE7947F592541AE2E999CE126FA116F0901F2CDEBFA5FB8B3E1DFDF957FCE7771999C6057DC4449FC8883ADFBF437947C9AFCFCEEBF2767B35D1CE515D93488DE994B32E4F956A2253628A1B492185B8AA074D2155BE89F18302AAAED98B452A76645AB7284B5DE4733A3B05D4BB4F30777B7827ABFB716D05DE91A1CA51B208A2010DBE7F69A91B8C2D8A5C95349090E153AD37888BDE1B113D31040805E770381AFAD5C770B5FAF8D5AB774FBE83B1B2501767BB40203B01B10270076EC6A02F9AF1B9248FCEB86C4797FDD6004D25F3720CEF9EB3AAA29E5AF1B4C4DF8EBF8BC28E1AF637F667CBFAEC382B1FD9E64A26B21CBB59BEA3A9871BB273B0DE03F60BA636CBB6E8F9693ED7A8099F98159F981214CBB3E2AE50766E50786D0ECFAA8941F98951F18C2B1EBA3527E60567E6008C1AE8F4AF981590161EC75AB5BB8692D65AB3B78682D54AB3584D14FDF25C3ADDB73ADF96D9D7128BBAD334E456EEB18CE716A5BC7089C31DB3A8E1ECA6CEBD8369CD7D61187D1DA3AC254BCB68E208CD6D631B6E4A4B68E0F8A71DABA763FC668EB88C3F96C2B9C8794C8710267899ACAD601A4A4B2756E144E63EB862470D8BA01D50CB62759D6BA295F2D757DAD885D2D347D1B7046BFD071D258871E5CF3C53A763ECE16EB8643E9627D14E6E0A138224DACE3A0E224B1AE388C43C715871E0D718561FCB08E3919811BF624B34E1BB3AAED1E433B8BAACD2E838A30FA39466066751CD83225AB33989F22792A0FA363F581E2A33C9C89D50B8C8F12090CAC9E80BCF4A39A77D51390973899D3ADFAC1F15126CEB3EA05C647896A82553F38F03259AF3D1D94A476CB8F05F768F70A640419FD22C4584D9D77C538A3A93B1274C7A609C5CBE45AD1997A00F1511AC665EA03C5477904125377201F05E20CA61E60BC3C304E5EEA01C747811873A90F142F3DC8CB1B17272D754CC655ACA51E40BC9586D295FA42F2F4C8E86718EE385EA6684A51EA03C5D324CDBE713849C8D3CCEE6979B4B195CBD3E258A372FFE8639C3EC7DD7494EF5E502A8A50C7E1BCF2F2F6E9E1A0D785738E5E6009756C948A26D40388AF2C01E108F581E22587CCE8413DC07859DC1835A80F145F2FE13E30BCA4BC182BA8E354C348417DC02C812715AD57B336424DBBF5AC8B3CB37B45D31146BFA609849C8E9DAD66E3F401E4A5FF33224E0F305ECA4359387DA09C3015D6CA5E69191A7611555A44873AC4E80793487EE9B80408C497AE2908CE7AE907C8396814E92E1DDFB518DBA517180FA7FA25924BC79C37E3B8F402E3A16E12B5A563F857F35A3A02899496AE50F75E46AE4866E901891259BA1E60A23C965E6016EE05E214965E60FC7549E7FCAAC45BE9981B15BE333FC93ADFC6F868B7CC77B13B76AFF23AC2E817799130D2793C71B2481F489427D20D4AE4883C49B76B6659B4FDB0B38D53D1E6CB4EF9FED17738CED3E8FA60294DA3330CF9C3034C45D2E83849728A46779C92A1D11D46F8ECBB7FE3307AC653A54A9AE80DAD33256D5C865689121960F483B0E64774CC74737644C740A3E44774C7F012A9F8487A2E7D653D1937A20F143F4FAAE245F48172C2AC4F2B9FA0E5A76CEE879F0C10A39F1A1825A16356C4CB5E38A32474DC4CF372EE5CA423743E46C3A9085D916A1A42C7905BA0203CC980B4A0ECB31B9696BC7CDD83B31168F4435464FC3B4DCEBC9B21CF32736E478367913F6F021AFDC33A79E2C38E8ACEF20B376BB2398BAFDC5AB046FFD46A2E3B7FCF8CD3D3B19556A592539E1867BCE3AF630A81DB59EDADA28E7BA75F52D1D37D9A6C1F485DAA82EB574DDB3D4B6469BA57F96793C74CBAA2C39B4895A53B937E35F98AC50B3A5CC96435BA33E57793BBBCBCE4995DD2E1506158D03DAA17985CEEAB6B6C7D1A3F7FD53D9B2F33F9DF8A57DA9642F91CCED48BE40BCCFD885C933EE6F49A0E9FFA6710BA5BC33526CF8FE565F43C0432487EEAC3553C906818AAD2CF2697077A859537E5C088EE4FBDC0E431E2D7D8D550D95A375452BDC258CFEAA20DBEE8505ED4E156C9F4EB5ED50B4C4E37E49AB8BEA6734E12D2BCA64949FCD93C2B5557C4068254D3C314525AC66729FEDEF028B3F212AB27A9BE2E1BE6259B41021D22E69702DD79C375A62208EE23E1D2AE9E6C0C780DFDD97C9DB157E34BD347D2A923F1D2AEB9BA299833CCD78D971AE76C7635E9808D25D29874F96FE7D30A951AF0BF1A63EEF97475C477EFABD0E71CBF96C64F35C439C64C708FC4CB720DCAAE21556011186E0CB144EC126D8FA888B6386E9A6545FC186D0AFCF3063FED9824E1BF45BB23BEE472FF403692EE8EC5E158907EB37FD849EBD4F9B4DDFFF9542BF3F9DD81FC97FBA8022E668CAB80EE928B63B9D545CB7D65A0B56D802021248D9D71A9D624C2424FAF1CE9B66414B201A2CDB740079490698A1CC8DE91CDFABB641D915ED254B6EE36945BEC7C11474F59B4CF29467D3FFE1777BFEDFEE56FFF062475A07C47310100, '5.0.0.net40') ALTER TABLE [dbo].[patientcareplan] ADD [ASTTestsDesc] [varchar](max) INSERT INTO [__MigrationHistory] ([MigrationId], [Model], [ProductVersion]) VALUES ('201811291952467_ASTTestsDesc', 0x1F8B0800000000000400E55DDD72E3B895BEDFAABC834BF76975F764B2C9943B2959B2A75D69DB2AC9DD7D4D4BB0CD8C442A24D563EFABEDC53ED2BE42001200F14712878008A67C271D82DF0140FC1C02E0F7FDFFFFFEDFF9DF5FF6BBB31F28CBE334F934F9F0EEFDE40C259B741B274F9F26C7E2F18F7F99FCFD6F7FF8AFF3CBEDFEE5EC1B4BF791A4C37726F9A7C973511C7E994EF3CD33DA47F9BB7DBCC9D23C7D2CDE6DD2FD34DAA6D38FEFDFFF65FAE1FD14618809C63A3B3B5F1D9322DEA3F20FFE3B4F930D3A14C76877936ED12EA7767C655DA29EDD467B941FA20DFA3459A26DBC9EDD5E2EB3B44837E96E7236DBC511CEC71AED1E81997AFF5792A90977871D5EE28C15AFF7AF07543A35F81352E3F4FF40AF92019B70CA03CA8AD7157A6CC0B85E4CCEA632CE5405E2302D18249B9F26D749F1D3C7C9D9ED71B78B1E76D8F018ED7234393BFCF997759166E85794A02C2AD076191505CAF0E3BBDEA2B298B4BA7E39FCD9AEC6FE3A7DFF91D4D8344A92B4880ADC16E4829C4FEBFA6BADD5157A8AF322AB207AD4A8787F9FDA54EF1F5D4DEA595EA49BE31E7BEBCE6E3BCEEC09B901DCA787E87FD6F113435917191E2D266757F10BDA7E41C953F1CC916EA21766C13F27675F93180F2EF8A6223B22D173F5DFCEF1F5FEE97BBC2D9E4366E0338A9F9E8B13E7C0BA3B5D278F69B6EFDD9B84DBFB7426E5F637D49770155EBC0EDE0C4BAFE4E7E09EAF93CD023FB3E13BDE1E4705050E134EDDE30C4DA540CB0CFDB87CD90FEEFAF225DA7F493783FBFD123DE4F7198A86AFEC9BE57A7639FF1C60607F5917E830B8DFAB7887B63F7F980DDFAAD7EBBBABABE147AE43719FFE9E04183149B0179FDAB1F57CBD4E3771B4FB8C43D0347BED33634B007DE66C0DE04DCDDAF961B6DD668337C3CFE91E7DB8FD10C6EF2C90DF5520BFB71F03D57320BFAB407E6F7F0A54CF81FCAE02F9BDFD53A07A0EE47715C8EFEDCF81EA3990DFD5A9FD5A474537681B6F9CC22219A14F5CA423BCA1C068395F0EDE06B1CFE5739A0CBFA6801D932070F8E8043BFEF22D0FF0728DB677C5331A3EECBDDEEF17281F7E1DE3F3F2DBB76878B74B5CD1D8F430BCE3CF697EB85C0CEF777DCC86DF0D585E27FF3C6601565FB1DF30CD793D0BE2F7062577498E020C58A5DB5BBE3A7691A63B1425E0690D17209F1FB3CC15E7CBCDF0D323CE3B761BE4B9CF763B943DC5281FDC33795878103DB563EBC074817EA05D7A20219653786AC2E913A436E1BCA1501557C1EC7070EED20B1C1185E95C45916CD79BE1F7B07FCDA2EDF0C17655DC438802639F4B94911DEAE1C7B1C54586A200A1FE7CF12D7A8A932880E3254AE20033C6628536C571F8474CC6A1ED969C8018CB64B5423F62F4FBDDE3FA352FD0BEDFE12A11A1DFF12A15E10D4D4DB8107191E22A187E6C679E834C69D87BA042872AF1E5ED7D8812576E8394986C9D862832F51BA4CCF328DBC641FA33F71CA63FE3C8250B338E31CF61D63B8EF9E618A2D8CC719052AF7F8B830CDFD46F9032DFA2639806CE1C0F506AEBB8F10A07533B548610D18E1C3DEC133A6A207DA24723C81B0A20BF440F37D13F431CFBC46E837444E2FAE4A7F39ADC86092A3EA7E9368CD720E5C57D7A1E0FBFF558B90D52E26F282FE287E36EF8C536E2394891BF66A878CE865F752AFD8669D6699E47B7D1F01144E938489197F3ABF4387C4FAEDC86E9C961D652B1DB30FBCCAF388809E3355C79D7CFD161F891BA761DAA612FE23CC09E0C711C26EC42D98FF82590DB5081177E29BA3BF9D7B2D6EF99CBE7D79C1CB1ECFB8A29DEDFEB437AE5FE37F46239C847CBBADBEF61DCDEA3FDF05FF47D5E85591B0FF155EEC5F0C7A170379C1D0E280AF0EDD6E5E5ED7D18AFC1767AE6DF02B90D7324E7619B86887C4BBF6142DF72C76117C86DB06D8E204EC36C50E318E7F4A19F61EAC5B10DCA2E02F95D9E9A40C03AD69D25E993DB868A8CD027DED511DE50C4BBCC50BE28EB7EF0AEB74CF3B82A6A10CF61C69B1B543C07D8D728FD8629F1E5BF8EF1F0AF1995DB316D1FE35122C61D761E6568B98B7AD1502910BD5EEE75883734DAADEFAF93C77B9417C31FC0AD5C07DA758A13741FA2D0CCF3F0EFFC95E7304BA8CFBBF97117E04C7BE537042116751DE68CD26CB6FE3D1AFE6352EA37447553D7611601B6DB35CA562880E7CA6F9852AFEFC34C1BCC719852DFC77B14A8DCC435A1521CDEF50DDA5EA5BB008B3E95DF458022AF93ED3C22A861FC061CC8863F9842FD86399A8243FEBB4712FC8FE5AD68FE1CEFB6389827FBBFE8F73E2F4532429F77221DE10DBD12E15107BF9890530E21063CE23A0C6503715D3EF8C17D978E1784AA7E2C9DF03AD9C4A4E5965F69F6E882E2FDFDF8B1E5FBDF50F75B679B01BE8D355579F13547211A7F417E84F0FB254A0290F0A0EC10A4C0C4F10A0D1FC512BF8282C2800FB81A43C632A6CE92947C71EFB4B15503F4DCD79201DED0B07A712C8A74F3DBF06F52C47198D799E418E02D1D3B0DF32213E498C232D83985D937940518542BB781DA73B45BC481DC8E69DFF0C6FDA3D31BF74F4E0D106F683A99C7D93C0077CED7301F1F9015DF008B90BF866146AADC86FA1C302A9E6F4208C97CCD88DB306B2FD55032A22F2E84816D96E728CFC998D167A03502F5196E1B81DED0A08B0B71F952967E2CEDA45E3E9FED48B5E2EAF8817A1DE43101F53ACED304F486DAC9F83635CA693BC2913359DA736C2A4D58BD68515BB0DE508321D5109C909068F54531AE4D9AA9C7832A60BB782069D08B3A1355F7AF51C157DCE4FBF070593BFE54CAFEBED34581A7EDA0A2FEAB0950D2A7ED0213F42F4D58A23867179428CB55322F6B68B27458179E24676106545437BA100DDCC3665C236972F773118923CD4F46A2B7EC02D4B8844C983AF55117ACF811A9B1418A1FB97681C927F44D70CA77049DB9934FC11A33A81CD7ED829437914D88CA567777A7A937C5CCBD46D8B4B3A8C17A2DB8A10285E5EACE5ED3DD64D4658B2E4863C46B023607EB9D4FDC1428199FBB31C6EBECF40D33ABB1DF374507C6D983CF13FCDAF9B4127DA786F369833AFCF94D7438E0894D508BA796B37525153FFFE31A2E08BFAF30A69BDCA00BCF73CB3DE1512D7A42CA55EC1AE7F42ACEF2621115D14379F668BEDD6BC97ACC8ACC73D3E4A8865CF5F3617792DFE6BBF5795441ABEBF80A179BB4CCB20610CF9D8EA9436090351E1AA34CDB5AD315EEE7E9EEB84F9AAF4FF50C4E951CAA1532D56A440933D5AAB67A107240E1F410A4D803FE00DA6F6FAA7CF12EB5E2D56B7AA537A18A21AD8828DAEDD1CA7D5711A634D8DF5F0BD78B20B5158E542BD19B10EBABBD90195B430334BB3C9A2E2085C14E3DA051CEBE84EAEA00AD7737D5BBA2612FD6B9722954EBA75AF372C72C4D408CEABC86865399EDB1B816BC5C57D40868F182B6BBD4D4053BA0CE05B976A9CE05BB3D1A576017A1B8D11EE74BADA82E2209667B2CAE912E22712364A4A19AE7F2F8428DF638B586B908545B01CF8E8A924BCF8DDA006D9C698C4B2D9C19217D25A79AE1725761D6D18CBBEA9A81D3D0DBA24C5E82750DBE1DF73755B626472ED67987D8796B93F23C0433E170A54950AB3D1257021781B811883333E1CCE0382B13CE0A8E4394B7F5727D8497CB843383E3AC4C382B380E51BAD6CBF513BC5C269C191C6765C259C17188B2B45EAE3FC1CB65C299C17156269C151C872839EBE5FA195E2E13CE0C8EB332E1AC8C3881A6126DB9D8692E69D3732ED1BA26932E80C6104913719662A50E91E83664BFF349A9B72C2D711003E87EAA9DAC80502B08898A212B48D40A42AAD48D15A0CA080873B95AB1F2ECA815F0A2C2E487A517156604F4612A272C75616A03D40F5707962A885B01484CEE57026246004E25DF2BA15426000613E395509811106171715D29C2E256C0D3626AB9D2E36246483B64EAB7723B6456001297B39590B81594272A68ABE4895A012FA637CA08541A4039E1F2B44A5EB81DB0C0572BCE4ACB7CB5D91EABD69015A16AEB68E6DC860D55A799B75BB0B6C4EC9A7FED601AE7CA06955A69DEB452C46DF5E27546E6B2B24A262B230087EBCA4A40DC0AE8135C2856EA12DC6A8F44955F45186A82E6E6D0909F033047A234ABF4C22FD8013D9EABAD4A3D9E5B21488CF25F46625608123DF52B0351230487E99BCA40CC0A6BE14CB0546DE4CC3E9AB1513D0EE2B8AFD62C8C5AA275EFACB503342F1BA96AA8F2F251BBDA6AEBC3F43AF809C2A5D220519B7B60E9A3A072098469CA1C3C674DD9EA912726012A6D10501B1445CF9368872D536A99E246308E211E172F0006B15A48531AC56A730F2C3D77CA2540CBA8052FA586519B7B60191A9A7C09106C73614A29D4E6563892217097AE00A672261F29CDE3CC08C6D133265DB0C7AB251E45B0DA0A47D2B3265F19CDE46938FAE8347F76084496805D53A80546E33EA3491552DA72ECD69E6CC3F73B977EA11A8ECA766F6983A2E82D4EB4C3D0D4FD4C6683A298F3C4EC8071BCD24194C6EFCA04C430CC03B519B09B4D750A958655DAA0287A9644BB3D9AA0242882096618969EAFDA6A8FC4C5FE44206E04E2E85912CC807AE7727C52AD732B10C9F0006B336449BC52CC9357C42B1B1445CF926807B403C30B2EFCF5964BD42930E0C5DA4A724E5AAAAD4C400CC3926F6D06625149380D8CDAFBA035644FB806ABFBEAFB69B5F22B2B0CC9FC18C1A33995579386616A83A2180674C10E1A8BD9E7B8CA50CCCCA389D8E4AF4A9C82B56695B512ABF31477EBED8D439422AD260D53ADB26D6DA87E0333D3A9DAE6A3B44D28DF0D28DFC12895429974FEAEB4004AB3524AB202BFE06B67386BAB3DD285B28D7401DA451254BD9415196606D448A5D325554A65026218C6EADA0CAB63A2A3A5D630B14151CC2B31CC0E58C5674A57D2123E3302710C73AE68072E4AEC0CCB11DAE79CDD280D0B1BBB3ECB1AFA3A0414C1BC9A015E6A64624ED20A213302461D26CE240D3CCC08C5597E36012D8D4791034DABEAF7954E136B9BA45389D635B576013476364DC749EA721D3A516DC89E0F35D5924BD2FC5F9B014DBE1651921A7D6D866219D6D8053B008D291D4950CC08C43164EAA6C7DB2FD3229280A80D8A62C892601F4DD7D6BE74760B9ADB348C4AB8CEB8B90BA1B1D7E8C24552EFE992466AC3F6DBBF459121694A13EC5034C30429D8216B495C0A485E4BE26638D6CA8C050AB445B91E1D0CFC96CD1478A497636604E3681F388976309AE1B55DBC00D86F61C237D2560B338271B4528A76309A611348BC0008A16BBD19693AAFCD002C51414642132F40F0EE0DFDBCB6C2914C5913AF001005ED16094FB003D1A81C8B8646EDA0A3CB95C28A7C22921AC1380B3557A21D30D232111469986546308E61C8162F407BC00F53FB07ADD84BC223062CF0AABDC0BB254DC5827D3471904ACFE21406B5899694685D51501740F314A22A95C8F348BB124A1BB2DF10481415513A26B783D10C67A86B3B148D4A7FE870F4823D9E28E721C289F6D174039954C8A913348B869458DD24046DB73757B6AC142257789B0A491BAAE7F89F497A48633F33421A1695E8900B498D201CF243C3A98C209C4A4243C1A98C8079834B6248B306B7C2904A8D0B15A834C27034EE146E84D410D3A030B5CB110D030A1D98EB7A5F93D0450966B1DCD7767FCB6A9FAC6EA12CF6B56967B4E1FA1D0B6A1D0A69F3875B6148FA14585B017160A9142157D711F636C0651F5414700CA9EF1F2CA11B084BF30EC2B2CF1602D35990CA456D5014430D0976486D574A08725D5736288AE9A9D5F6D18C4F1ABFA0D308D5AAA050C2757E67DDF74CA64136410A39C7731E93491C482F14D40658C7339CB8F90A3E6FC30408E48DFF1CB8CAF0ABE1CBA25FC11F1689F2003A528F33819CF15F39CCC7ED10B49AC45F46ABED8017238197DFD048C77512A8812ED4699CB090012841BB460B4B9CC616D7C4FDAF1CFDB0511A68F3E3FDDB28CED6AF6494DB47D37A1AD860DDF6C6BAC501AC5A8F254EF7AA9C42F06E5EA26B65941FAEF5FC47AD253693FD3A35203BD500AB36640FD5F8785BA402A4C76D2D4F305C63AAF9FDD59C06F97A576372569370EFD4C2FF732667CAA22CD13B97A52764CD65A973CAE8ACD22A57492667B88A7EC45B42A97CF3BAFE176E6CF8FABBF2E77C17978B132CC54D94C48F38D8BA4F7F43C9A7C9CFEFFE7B7236DBC5515ED1578308A3B9C8439E6F25A26383B64A2B2DB2A5AC4A2701B285A28A01A322EF8E492D75AA60B46A51582B88347314DBD5443B2371772DA8F77BAB01DD95AEEA51BA01A20892B37D6EAF398E2B8C5D9A3C9524E350E9348DD9D81B1E3B830D01042880375002DB0A80B73000DBE87F4BB78FBEB1515A61B7472B700ABB01714A61C7A626D009BB218954C26E489C49D80D46A0117603E22CC2AEBD9A9208BBC1D414C28ECF8B52083BB667C620ECDA2D187FF04906BA16FA5DBBA1AE836BB77BB0D300FE03863BC6DFEBF668397DAF0798991F98951F18C2DDEBA3507E60567E600871AF8F42F98159F98121ACBD3E0AE50766E5078650F6FA28941F981510C65E09BB85EDD65208BB83D9D642075B4318FDF05D72E6BA3DD79A31D71987F2E53AE35474B98EE11C27CB758CC01957AE63EFA15CB98E75C399721D711851AE234CC594EB08C288721D634B4E93EBF8A0184BAE6BF3631CB98E389C21B7C2794889C0277094A8C9711D404A725CE74AE1C4B86E48022BAE1B50CD897B9269AD9B44D65229D88A2AD64225B80167F4131DA7A17568C13503AD63E3E3FCB36E389480D647660E1EB22312CF3A762A4E3BEB8AC358795C71E8D1105718C638EBB82623B0CD9E64D469E36AB5DD6368E765B5D9655011463FC6085CAF8E1D5B26797506F393254FF96104AF3E507CE48773BB7A81F1912381D3D5139097765433B97A02F212277302573F383EF2C4995BBDC0F8C8514DD9EA07079E27EBB9A783E4D46EFAB16033ED9E818C20A39F84184FAAF3AE18E748754782EED834A178195C2B82540F203E72C3D8517DA0F8C88F408BEA0EE423439C13D5038C9707C6E9503DE0F8C810E342F581E2A5057979E3E234A88E8B71150FAA07106FB9A104A8BE903C3D32FA19863B8E97219A929EFA40F13448B36F1C4E12F234F3855A1E6D6C6507B538D6A8DC3FFA18A7CF71371DE5BB17948A74D4B13BAFBCBC7D7A38E875E1BC462FF08E3A564A453CEA01C4D72A01611DF581E2650D99118E7A80F132B931B2511F28BE5EC27D607859F2623CA38E430DA319F501B3049E54B49ECDDA283AEDE6B32E3ACEEE194D4718FD9C26507C3A36B69ADFD3079097F6CFA83D3DC078C90FE5F5F48172C2A5B0563E4CCBD0B08BFAD2223AD42146DF99443A4DC72940A0D2745D82E03C9A7E809C83469140D3F15D8BF1677A81F170AA5FA2CD745CF366AC995E603C944D22CB740CFF6AA64C47209124D315EADE4BCF95C9311DB104624C0F489414D3F53014E5C4F402B370CF10A7C3F402E3AF793BAFD54A1C988EEBACC237EB278919DAD823ED42862EA6C8EE884147187DC020924F3AF7274E3CE90389724EBA41897C93276976CD8C8DB61F89B6F133DA7C252ADF3FFA06C7391F5D1F2CA57C7486213F3CC054848F8E8324A77B74C729D91EDD61844FC8FB570EA37A3CD5B24B1355A2F5AA4B1B2FA2D5A28B0C30FA4E58732D3AAE9A73A645C740A3E45A74C7F012A9F858405DFA5A41653C8B3E50FC3CA98A63D107CA0957905AB9092D3F8B733F48658018FDD0C0E80D1D5758BCECAB337A43C78D392F67D8456A43E723399CD6D015A9A634740CB9053AC39374480BFA3FBB6E69C9F1D7DD391B8146DF4545F6C0D3ACBF77B3ED59AEC2DB51EA59ACC537018DFE619D7CE1C38ED6CEF26B396BE23A8B2FE65AB046FFD46A5E3C7FCF8C53DDB19956A5A5539E1867CFE3AF630A19DC59EDADA2A17BA727A9A8EE3E4DB60FA42C55C6F554D376CF12F19AEE55BE6CF29849293ABC89B45BBA33E9AAC9572C26E8702513DFE8CE94EB26777999E49925E970A8B035E81ED5042697FB2A8DAD4FE3A7B4BA67733293FFAD98D23617CAA775A656242730B72392267DCC699A0E9FFA2715BA5B431A93E7C732193D5B810C82A47A77150F371ABAAA74D9E4F240535879530E9FE8FED404268F114F635742659BDE50483585B19C55A20D4E74281375B85556FA75AF6A0293D30D4913D7693AC7246199D734288997CDA35295223690AD9A1EA6B0A4657C96E2F58647999549AC9EA4FABA6C18976C3A09B48B985F0A74E70DE94C5910DC4742D2AE966C0C780DEDD99CCED8AA71D2F49134EA484CDA355637057386F1BA31A971CC66A949036CCC91C6CACBAF9D4F2B546AC07F35F6DDF3E9EA88EFDE57A1CF397E2D8D9F6A88738C99E01689A7E51A94A52145601118AE0C31472C89B64754445B1C37CDB2227E8C3605BEBCC14F3B268BF0DFA2DD1127B9DC3F908DA4BB63713816A4DDEC1F76D23C753E6DF77F3ED5F27C7E7720FF721F45C0D98C7111D05D72712CB7BA68BEAF0C14B90D102484A4B133CED59A4458E8E99523DD96EC443640B4FA16E88012324C91C3DD3BB2597F97AC23D24A9AF2D65D87728D9D2FE2E8298BF639C5A8EFC77F71F3DBEE5FFEF66FE1E9878F62320100, '5.0.0.net40')