· 9 years ago · Jan 16, 2017, 02:10 PM
1DECLARE @CurrentMigration [nvarchar](max)
2
3IF object_id('[dbo].[__MigrationHistory]') IS NOT NULL
4 SELECT @CurrentMigration =
5 (SELECT TOP (1)
6 [Project1].[MigrationId] AS [MigrationId]
7 FROM ( SELECT
8 [Extent1].[MigrationId] AS [MigrationId]
9 FROM [dbo].[__MigrationHistory] AS [Extent1]
10 WHERE [Extent1].[ContextKey] = N'Intra_News_Site.Data.Migrations.Configuration'
11 ) AS [Project1]
12 ORDER BY [Project1].[MigrationId] DESC)
13
14IF @CurrentMigration IS NULL
15 SET @CurrentMigration = '0'
16
17IF @CurrentMigration < '201604211446472_Initial migration'
18BEGIN
19 CREATE TABLE [dbo].[Advices] (
20 [Id] [int] NOT NULL IDENTITY,
21 [FromUserId] [nvarchar](128) NOT NULL,
22 [ToUserId] [nvarchar](128) NOT NULL,
23 [EpiserverContentId] [int] NOT NULL,
24 [Created] [datetime] NOT NULL,
25 [IsReadByReceiver] [bit] NOT NULL,
26 CONSTRAINT [PK_dbo.Advices] PRIMARY KEY ([Id])
27 )
28 CREATE INDEX [IX_FromUserId] ON [dbo].[Advices]([FromUserId])
29 CREATE INDEX [IX_ToUserId] ON [dbo].[Advices]([ToUserId])
30 CREATE TABLE [dbo].[AspNetUsers] (
31 [Id] [nvarchar](128) NOT NULL,
32 [Email] [nvarchar](256),
33 [EmailConfirmed] [bit] NOT NULL,
34 [PasswordHash] [nvarchar](max),
35 [SecurityStamp] [nvarchar](max),
36 [PhoneNumber] [nvarchar](max),
37 [PhoneNumberConfirmed] [bit] NOT NULL,
38 [TwoFactorEnabled] [bit] NOT NULL,
39 [LockoutEndDateUtc] [datetime],
40 [LockoutEnabled] [bit] NOT NULL,
41 [AccessFailedCount] [int] NOT NULL,
42 [UserName] [nvarchar](256) NOT NULL,
43 CONSTRAINT [PK_dbo.AspNetUsers] PRIMARY KEY ([Id])
44 )
45 CREATE UNIQUE INDEX [UserNameIndex] ON [dbo].[AspNetUsers]([UserName])
46 CREATE TABLE [dbo].[AspNetUserClaims] (
47 [Id] [int] NOT NULL IDENTITY,
48 [UserId] [nvarchar](128) NOT NULL,
49 [ClaimType] [nvarchar](max),
50 [ClaimValue] [nvarchar](max),
51 CONSTRAINT [PK_dbo.AspNetUserClaims] PRIMARY KEY ([Id])
52 )
53 CREATE INDEX [IX_UserId] ON [dbo].[AspNetUserClaims]([UserId])
54 CREATE TABLE [dbo].[AspNetUserLogins] (
55 [LoginProvider] [nvarchar](128) NOT NULL,
56 [ProviderKey] [nvarchar](128) NOT NULL,
57 [UserId] [nvarchar](128) NOT NULL,
58 CONSTRAINT [PK_dbo.AspNetUserLogins] PRIMARY KEY ([LoginProvider], [ProviderKey], [UserId])
59 )
60 CREATE INDEX [IX_UserId] ON [dbo].[AspNetUserLogins]([UserId])
61 CREATE TABLE [dbo].[AspNetUserRoles] (
62 [UserId] [nvarchar](128) NOT NULL,
63 [RoleId] [nvarchar](128) NOT NULL,
64 CONSTRAINT [PK_dbo.AspNetUserRoles] PRIMARY KEY ([UserId], [RoleId])
65 )
66 CREATE INDEX [IX_UserId] ON [dbo].[AspNetUserRoles]([UserId])
67 CREATE INDEX [IX_RoleId] ON [dbo].[AspNetUserRoles]([RoleId])
68 CREATE TABLE [dbo].[Subscriptions] (
69 [Id] [int] NOT NULL IDENTITY,
70 [UserId] [nvarchar](128) NOT NULL,
71 [TagId] [int] NOT NULL,
72 [IsMandatory] [bit] NOT NULL,
73 CONSTRAINT [PK_dbo.Subscriptions] PRIMARY KEY ([Id])
74 )
75 CREATE UNIQUE INDEX [SubscriptionUniqueIndex] ON [dbo].[Subscriptions]([TagId], [UserId])
76 CREATE TABLE [dbo].[Tags] (
77 [Id] [int] NOT NULL IDENTITY,
78 [SharepointId] [uniqueidentifier] NOT NULL,
79 [SharepointName] [nvarchar](256) NOT NULL,
80 [IsActingAlone] [bit] NOT NULL,
81 CONSTRAINT [PK_dbo.Tags] PRIMARY KEY ([Id])
82 )
83 CREATE UNIQUE INDEX [IX_SharepointId] ON [dbo].[Tags]([SharepointId])
84 CREATE TABLE [dbo].[AspNetRoles] (
85 [Id] [nvarchar](128) NOT NULL,
86 [Name] [nvarchar](256) NOT NULL,
87 [Discriminator] [nvarchar](128) NOT NULL,
88 CONSTRAINT [PK_dbo.AspNetRoles] PRIMARY KEY ([Id])
89 )
90 CREATE UNIQUE INDEX [RoleNameIndex] ON [dbo].[AspNetRoles]([Name])
91 CREATE TABLE [dbo].[RoleTag] (
92 [TagId] [int] NOT NULL,
93 [RoleId] [nvarchar](128) NOT NULL,
94 CONSTRAINT [PK_dbo.RoleTag] PRIMARY KEY ([TagId], [RoleId])
95 )
96 CREATE INDEX [IX_TagId] ON [dbo].[RoleTag]([TagId])
97 CREATE INDEX [IX_RoleId] ON [dbo].[RoleTag]([RoleId])
98 ALTER TABLE [dbo].[Advices] ADD CONSTRAINT [FK_dbo.Advices_dbo.AspNetUsers_FromUserId] FOREIGN KEY ([FromUserId]) REFERENCES [dbo].[AspNetUsers] ([Id])
99 ALTER TABLE [dbo].[Advices] ADD CONSTRAINT [FK_dbo.Advices_dbo.AspNetUsers_ToUserId] FOREIGN KEY ([ToUserId]) REFERENCES [dbo].[AspNetUsers] ([Id])
100 ALTER TABLE [dbo].[AspNetUserClaims] ADD CONSTRAINT [FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id]) ON DELETE CASCADE
101 ALTER TABLE [dbo].[AspNetUserLogins] ADD CONSTRAINT [FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id]) ON DELETE CASCADE
102 ALTER TABLE [dbo].[AspNetUserRoles] ADD CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id]) ON DELETE CASCADE
103 ALTER TABLE [dbo].[AspNetUserRoles] ADD CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[AspNetRoles] ([Id]) ON DELETE CASCADE
104 ALTER TABLE [dbo].[Subscriptions] ADD CONSTRAINT [FK_dbo.Subscriptions_dbo.Tags_TagId] FOREIGN KEY ([TagId]) REFERENCES [dbo].[Tags] ([Id])
105 ALTER TABLE [dbo].[Subscriptions] ADD CONSTRAINT [FK_dbo.Subscriptions_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id])
106 ALTER TABLE [dbo].[RoleTag] ADD CONSTRAINT [FK_dbo.RoleTag_dbo.Tags_TagId] FOREIGN KEY ([TagId]) REFERENCES [dbo].[Tags] ([Id]) ON DELETE CASCADE
107 ALTER TABLE [dbo].[RoleTag] ADD CONSTRAINT [FK_dbo.RoleTag_dbo.AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[AspNetRoles] ([Id]) ON DELETE CASCADE
108 CREATE TABLE [dbo].[__MigrationHistory] (
109 [MigrationId] [nvarchar](150) NOT NULL,
110 [ContextKey] [nvarchar](300) NOT NULL,
111 [Model] [varbinary](max) NOT NULL,
112 [ProductVersion] [nvarchar](32) NOT NULL,
113 CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY ([MigrationId], [ContextKey])
114 )
115 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
116 VALUES (N'201604211446472_Initial migration', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FE3B8157E2FD0FF20F869B7C8C6B97406D3C0D945C64976834E2E1867167D0B68897684D5C5AB4B2641D15FD687FEA4FE8592BAF22A91122DCBD3C5BC3822797878F8F1903C24BFF9EFBFFF33FBE9D5F7AC1718C56E189C4F8E0F8F26160CECD07183F5F9244D563F7C98FCF4E39FFF34BB72FC57EBD732DF29CE874A06F1F9E439493667D3696C3F431FC487BE6B47611CAE92433BF4A7C009A72747477F9B1E1F4F21123141B22C6BF6390D12D787D91FE8CF7918D87093A4C0BB0D1DE8C5C57794B2C8A45A77C087F106D8F07C7213241178BA835FE3A7859BC0C34B9080C387287C711DA4DDC4BAF05C80B45A406F35B1401084094890CE675F62B848A230582F36E803F01EDF3610E55B012F86455BCEEAECAACD3A3AC1CD9AD6054B51761A27A1AF29F0F8B4B0D3942DDEC9DA93CA8EC89257C8E2C91B6E7566CDF3C985F3E2DAA8E96C5567732FC2D904A646D9DCE0302F786089930F2A942030E17F07D63CF5923482E7014C5109EFC07A48979E6BFF1DBE3D86BFC1E03C483D8FD415698BD2A80FE813EAE30D8C92B7CF7055B4E0C6995853BADC942D581523CA54AD3B3D995877A872B0F4600505C2128B248CE0CF30801148A0F300920446019601336372B533755D47A18F6017D5752204A28135B16EC1EB2718AC936734E44E3E4CAC6BF7153AE597428F2F818BC6212A94442914E8D95CF763B8AB9AAF362EAA19B91434AA1364A8768B37CB9B47105BBF1482C63B7C44BE435BCE4DFC1902E723C28F0D5DA45E29F063187A1004EDF2EEC08BBBCE8021E9E789F5197A5986F8D9DDE43EA8182D4F751EFCEB73E85523B04A7A5A84698447E463284E7F04D11A26EA7AE51868D2AACCC1E99427C8342A5245FACCA6B5A369763F9B0DF201995EB90EFA7E8896B0F70E69C0218AECE235547BF2EEBD52B50AB52027B07223BF1EBFCAC38D91F600E2F86B1839BF80F8B94175F4D380EA0B68A711C2EB2201FE66EBB53D3C8701BC4BFD65ED9486A8CB58D73C7E0DAF818DE6CAAB0097EA2DEF5368FF16A6C955E06067FF25B179DFAF28C0883A17B60DE3F81A81193AF310AD5CFBCD67D857E15F06C65FE7192BF7E3F193A999AB9C09643357398FE8EAD77F069368C6CC6FAA7ACD3DE0FAB1581F7A367A2AB3128A0973F073AC389BEEE4FF295CBB819AAA6556B9AA798E56558B6CBAAA62616A9A1639E58A66195AF5CC73E9AAB94897B11DB99B4C47A1BA648E2716975C22874D3E87089FCA2BAC729B822565206A5A63DD561BC98B78730793C3B2F4612EF73A4232D1FCFBDB2127F6C0522E5CAFC54E54D762A7C7CBD5E98777EF8173FAFEAFF0F4DDB7B851DCD5562DEB3E5CE9D6971D594DBF022F355D55A7D190F929F3A321133BFED190A95946CCD88E1396283323F14AF94B3CEB8E3946B3A18703D5CCA12B1FC607741A2E7876323F5AB0D4F10F16319485597183BAA07E57DEBFD477248823573F1DA24164F1BD0F057DBB4B8E47B0EE1B10BE896F41E000D4FE37EDADBD3C560AD6ED4BFA2C9364458FD2B87D07974177CB21DDFD6AEE341A15EB1FCBCDECA23D6251A93F066AEB405D3C83086E42973C48F939751DED61530B1A28FAC40DDB0B3B41755D786100CD0D5C79F0000F382E60507DE4C6449DB2E5C0409B17690C0B906EA6EFB94BDBBAAEFDDC255FC3991DC3D64710C3029CD876E540C9B455F7E69D30C19A9E474BAFC5B4F985F47E2CA2F7E55C6CD761793C138B714BF6F75391AD06309FCA793741169D29FF228E43DBCDB4129FDF96F16EBAA5578163A905BFEBF1CE1D0CDF2284BAF81BD20B75FD84C5DB7D70093D98400BCF2FF8A6CD1CC4367078BBA3B6399AFA550E81F747445895D6F02F5CC56824C0089702F83C3446E30CCDC2FCB07103DBDD004FC9624C69C561878D50D5C3A65CC20D0C70E3944CA2A28074F33CADEA627AA8CD52B32981443D8016A71CAA00608F3CC60650E6AC4502D022D2390840698BED00A0B449F60EA0F9BA44B5FF9945ECD8E0C9ACA7C4E8CCD74383809332D70EB049D963F4D0AC97C9B2FE16ECA3EA3ECE76386DDD2A9225C00BB75F6994ABD1466E4F26534F1EE6A9B5A48397EA4D976FFE1AAD796C6690C86A1F607CC88CAA52751143DCC9C8E0036F4A5D4B47E10CE386BE4CA03113980711A9CAD028226D3C7A0FCB5EAE92CEABB23BC244371717F9D5D123BDBE353476248A0C313F8BEDAA523379AD7F97D829AEBEB574327B93DB006ED8AB753B420DADC67098A12DAA3461853BC58B207824EBE1A6489224243BCCFEA2217E35FCE6426EA5015028B7844AE5E24B0A5B01621E49C4AF80500918F1BBDECB65F644E83511C4C451C38AB0785C8455596460E10B98D0378627561DBF64DC1CE7D568014550952FCEBAB416395C785024541043D4105BDED76D145B447E34C416E7228D52F341D52294390FE304D28BDE1661F9510E2723DB14B5146D6B90B03104980974492E7713999BAF81B3A34D39305EB5A9422837729583D8842C114A596F4C5BA283954A9CB65B49149BD589CEF6B21213499558A96C8C712B15286D37922020A31121EC65223A3A23B150D190DE0622CE6879A34822532DB12942E3DC9F34B49D8F4611A54DB591BF10C037B53940A516A2225467BC728305A441A91633F6B5433EBFB61882DFF328465DFA9B82DAF5B48DA72E9E817D7025F0094D6103A5C001A177B5666AF2049250C1F69A5FBEE892365EB4EF55D8F9766B38B3D7DD42B34547FB7CDBDBF670AABBB8365FA6BAE932340794F70DAA5D4295369BE6DC1FC587D954421232BB059B8D1BAC09D290E28BB5C81943E63F2CF4E933FC5CC6D4A6ECCCEE69AA9A9230026BC8A4A2AA91A6D76E142798A56409F05D90B9E373D9847B22C9DAB6AC92DEF6F07D58AE79CBFCF87701B846069572BFC46F260B49D7A8A53EDE8E66171BB951C517B4308D0BF04024B8E1330FBDD40FE4FB627969320A474A698ACEC9A5D5111A52963C6E239724A2BF20658AD2D5A5576418A4C8EAA3BA1C9E0C83EA092E95973C9B3278E0020A1C06B9680F0D6925C0CB5C5F77B833FBFB0EB86F93B09D0150903850D8CA3F69CA2078003861449ABA549AAA819449A7A84B64F81848914C92869624EB02A52499D0499EC4A2E21C1A4E8AE359A09C1597AA2E59C0B8408A162477902DD0994D53972A206520050B92D565E3519C5F052545D65F47E30C05511C839E910F52EAFB460519DBF18EA2E95C7F32271E4853136EFD595356F1049A13567C1F25B2A4C13923C8CAE3D4FD90259121F748D43363DA2135BE8D96CBA4DE0E534EBFE9EDB45C9E1E7E4780125950CE0848F8B71FDA18118BD8AEFB280FDB4829B203B89D75221D0C33D881D4318F7EE735171FF3AC51DC4FA31667E22B6B0DED201FB9D27B3322613420CAC2C106B12308772B4046586A3B48A19F65521B122AA58B447EEDC9A6E9E0887A754923894A1A0D968CCF24EC15E2EE1389DE24A28C30B41B74DCECC24EB60E143CD224C55CBAD82FFA6E809DC036FAADCDDA31FE7DBFFA4E7102C72DF87E7C461796E687DEB6B67C6616477B8267FAC6C5A0606E7342F4D10437AB9527D13A33575946303DB5B8227CF6C22F26DA1EAF287596F4D23C51A58E36D23B674ADAC8AFA1C9D4610F91F8CEE4CE92D82C1594AA3325E6EC68569CE3B4B3D073073B799689550201CDD96F7102FD1C1E8BDFBDB9E7421C862A33A0559CBB827192BFB29E9C1C1D9F30E4F5E321929FC6B143916B48D9E4E92E1BE071B88B6DDA4AB1A1F90E9C276E0F5E4064A34598E0A6E24DE0C0D7F3C93FB3B267D6CD3F9EEAE207D67D84FAFACC3AB2FEC53F60EF49E9AEA55359D8A84672AAF7AC5BFA11BDA33D0E4C4C12BD2FDD369D3A93970F0EFBBAEFFB762149052E949AB11ED452BB337FB7DB9F972462FD2EB5FCCE07AFDFEBAA2664F6EE2551C0DE6D4A9E1113CAD8B9BBC89232738B06AB4A63C54CDD5D5493B274777145F5598FAEAB2D4B669F0FAC9BF84BE0FE9EA28447640DC6E53223CB145DA3E09C656F67E21E33DE16E63B8E2FB7D740E7397135C4F5E0BDED808C3DA38C35363B3EF08CB0C664EF12DADD69603B8047FAF64DF575922E85EAAEDD44D98A0EDAE44587E859F9F1CAFFDD64419A229FAE8BD9BBE885939679BCD3668EE441CDACD157CB639196FDA9550DEE9A78928D7D459A889433CD4CEF662257AEF07FB4AA7AB4774789C93C55F66FDDB93A0D22A181D3719F36CFDDB608B8D1E6B608BC564C48BD579B75C676636C5BAD5F65416A732B057DBF8B8367B8103D297F034B02D39C8E23602113BCABDE3D73E390A4004D7735C7C680D38B9F7164602B5EDBEF9E857168B0C9AE6F8E1C6C5A5C8B23C35A7E88BE734AC5A19126B9EA3032A0351FD7D3CFCCDB59FEB68225C1528D51448F73B12B9EC477FC8C63A8FDD685D652745810896E59481EE8EE9AA1692CB06AB91A35167C0D48C4D483FB54C94BB1DD26A64FE8C17B3966F7D272CB7D5C8E459DBDB4D712689C80D8C1FA451B1CBB5D24AB72926E071B25515B078ACA7DC183945B81AF695F5846FFC0C2F6B1B09FFCA1BB5E908E61CF3CF462B4D38679C0A5287343BBBC09C3D1E4B07D5ADCA1A72F1BCBB93EF3DBD8E7136719A25ECF23E312D2275E38EBB5F85AD81CC2EAB2FF894B4C12C55629084C73950AF234572BA1756CAABB885336D65DE469AE5B4296D854773E081BABCEB334D72C26A0622BA6579B5CA574B2A8C24606391187A98CC254245CC8AD27B35D8BDDDA6CA6662FD1E65DD41E2E93A8629C22A26FDD31F32ACD10D7CCFA2B9D67A8D12B61C0E0E6B01113AD1A310AE55624E40DE68D5220DB38AFAA11939043484C55D0DF203C0D6A039DAAE475191B0A2234160CE1D678205D9C4B36D8E492A7B0A9C9E2276CD2D5ACA0B7446AEFDC0886B96575FB5D34B7F2840E869B29A30CD5A18E3535CE87328059BA58438DA797E6242FA4B1061B2088DD83C66E9916B69B3BDBD614A64103CB3FD145DBD134C08F8FF2BF2E61ECAE6B11F8317A006D6A235AE5B9095661B91F66342AB33017B96E61021CB44BBD88127705EC0425E37747D97F155C3C76BFF297D0B909EED3649326A8C9D05F7AD42308BCAF6EAA3FE3BAA5759EDDE75B0D134D406ABAF8BDD67DF031753DA7D2FB5A70754C22026FD88BEBB4B82F137CAD76FD5649BAE3084564820AF355718647E86F3C242CBE0F16E00576D10DC1EF135C03FBAD7E152213D2DE11B4D967972E5847C08F0B197579F427C2B0E3BFFEF83F53BE300F559D0000 , N'6.1.0-30225')
117END
118
119IF @CurrentMigration < '201604211458355_Initial migration + 1'
120BEGIN
121 ALTER TABLE [dbo].[Tags] ADD [IsDisabled] [bit] NOT NULL DEFAULT 0
122 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
123 VALUES (N'201604211458355_Initial migration + 1', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FE3B8157E2FD0FF20F869B7C8C6B97406D3C0D945C64976834E2E1867167D0B68897684D5C5AB4B2641D15FD687FEA4FE8592BAF22A91122DCBD3C5BC3822797878F8F1903C24BFF9EFBFFF33FBE9D5F7AC1718C56E189C4F8E0F8F26160CECD07183F5F9244D563F7C98FCF4E39FFF34BB72FC57EBD732DF29CE874A06F1F9E439493667D3696C3F431FC487BE6B47611CAE92433BF4A7C009A72747477F9B1E1F4F21123141B22C6BF6390D12D787D91FE8CF7918D87093A4C0BB0D1DE8C5C57794B2C8A45A77C087F106D8F07C7213241178BA835FE3A7859BC0C34B9080C387287C711DA4DDC4BAF05C80B45A406F35B1401084094890CE675F62B848A230582F36E803F01EDF3610E55B012F86455BCEEAECAACD3A3AC1CD9AD6054B51761A27A1AF29F0F8B4B0D3942DDEC9DA93CA8EC89257C8E2C91B6E7566CDF3C985F3E2DAA8E96C5567732FC2D904A646D9DCE0302F786089930F2A942030E17F07D63CF5923482E7014C5109EFC07A48979E6BFF1DBE3D86BFC1E03C483D8FD415698BD2A80FE813EAE30D8C92B7CF7055B4E0C6995853BADC942D581523CA54AD3B3D995877A872B0F4600505C2128B248CE0CF30801148A0F300920446019601336372B533755D47A18F6017D5752204A28135B16EC1EB2718AC936734E44E3E4CAC6BF7153AE597428F2F818BC6212A94442914E8D95CF763B8AB9AAF362EAA19B91434AA1364A8768B37CB9B47105BBF1482C63B7C44BE435BCE4DFC1902E723C28F0D5DA45E29F063187A1004EDF2EEC08BBBCE8021E9E789F5197A5986F8D9DDE43EA8182D4F751EFCEB73E85523B04A7A5A84698447E463284E7F04D11A26EA7AE51868D2AACCC1E99427C8342A5245FACCA6B5A369763F9B0DF201995EB90EFA7E8896B0F70E69C0218AECE235547BF2EEBD52B50AB52027B07223BF1EBFCAC38D91F600E2F86B1839BF80F8B94175F4D380EA0B68A711C2EB2201FE66EBB53D3C8701BC4BFD65ED9486A8CB58D73C7E0DAF818DE6CAAB0097EA2DEF5368FF16A6C955E06067FF25B179DFAF28C0883A17B60DE3F81A81193AF310AD5CFBCD67D857E15F06C65FE7192BF7E3F193A999AB9C09643357398FE8EAD77F069368C6CC6FAA7ACD3DE0FAB1581F7A367A2AB3128A0973F073AC389BEEE4FF295CBB819AAA6556B9AA798E56558B6CBAAA62616A9A1639E58A66195AF5CC73E9AAB94897B11DB99B4C47A1BA648E2716975C22874D3E87089FCA2BAC729B822565206A5A63DD561BC98B78730793C3B2F4612EF73A4232D1FCFBDB2127F6C0522E5CAFC54E54D762A7C7CBD5E98777EF8173FAFEAFF0F4DDB7B851DCD5562DEB3E5CE9D6971D594DBF022F355D55A7D190F929F3A321133BFED190A95946CCD88E1396283323F14AF94B3CEB8E3946B3A18703D5CCA12B1FC607741A2E7876323F5AB0D4F10F16319485597183BAA07E57DEBFD477248823573F1DA24164F1BD0F057DBB4B8E47B0EE1B10BE896F41E000D4FE37EDADBD3C560AD6ED4BFA2C9364458FD2B87D07974177CB21DDFD6AEE341A15EB1FCBCDECA23D6251A93F066AEB405D3C83086E42973C48F939751DED61530B1A28FAC40DDB0B3B41755D786100FBC6E46EE24B37EE16DDEB1086C043970B3D541FB9D155A76C39C4D0E68F1A030CA4C3EA7B82D3B6426C3FC1C9578366BD81F511C4B08039B65D39E4326DD5E7854E98604DCFA3A5D7B2DCFC927C3F96E3FB72C2B6EB003F9ED3C5B825FBFBA9C85603984FE5BC9B208BCEE2E1228E43DBCDB4129F04979173BAA5578163A985D1EBF1CE1D31DF2284BAF81BD20B75FD84C5DB7D70093D98400BCF54F8CECE1CC4367078BBA3B6399AFA550E81F747448096D6F02F5CC56824C0089702F8643546E30CCDE7FCB07103DBDD004FC9624C69C561878D50D5C3A65CC20D0C70E3944CA2A280741B3EADEA627AA8CD52B32981443D8016E725AA00600F4FC60650E6D44602D022663A0840698BED00A0B449F60EA0F9BA44B5FF9945ECD8E0C9ACA7C4E8CCD74383809332D70EB049D963F4D0AC97C9B2FE16ECA3EA3ECE76386DDD2A9225C00BB75F6994ABD1466E4F26534F1E30AAB5A4C3A0EA4D976FFE1AAD796C6690C86A1F607CC88CAA5275118DDCC9C8E043784A5D4BC7F30CE386BE96A03113980711A9CAD028226D3C7A0FCB5ED392CEABB2DBC64437174F02D4D123BD08363476248A0C313F8BEDAA5233F9406097D8292ED1B574327B27DC006ED84B7A3B420DADC67098A12DAA3461853BC58B207824EBE1A6489224243BCCFEA2217E35FCE6426EA5015028B7844AE5E2EB0E5B01621E49C4EF89500918F1BBDECB65F6D8E83511C4C451C38AB0785C8455596460E10B98D0778F27561DBF64DC1CE7D568014550952FCEBAB416395C785024541043D4105BDEFC6D145B447E34C416E7228D52F341D52294390FE304D28BDE1661F9510E2723DB14B5146D6B90B0310498097449AE8913999B2F94B3A34D39305EB5A9422837729583D8842C114A596F4C5BA283954A9CB65B49149BD589CEF6B21213499558A96C8C712B15286D37922020A31121EC65223A3A23B150D190DE0622CE6879A34822532DB12942E3DC9F34B49D8F4611A54DB591BF10C037B53940A516A2225467BC728305A441A91633F6B5433EBFB61882DFF328465DFA9B82DAF5B48DA72E9E817DBA25F0094D6103A5C001A177B5666AF2049250C1F69A5FBE0D93365EB4EF55D8F9766B38B3D7DD42B34547FB7CDBDBF670AABBB8365FA6BAE932340794F70DAA5D4295369BE62C22C587D954423732BB059B8D1BAC09FA91E28BB5C8B947E63F2CF48938FC5CC6D4A6ECCCEE69AA9A9230026BC8A4A2AA91A6D76E142798EF6409F05D90B9E373D9847B22C9DAB6AC92DEF6F07D58AE79CBFCF87701B8462E9672BFC46F260B49D7A8A53EDE8E665724B951C517B430210CF04024B8E1330FBDD40FE4FB627969320A474A698ACEC9A5D5111A52963C6E23972422D220658AD2D5A557B41AA4C8EAA3BA1C9E5683EA092E95973C9B3278E0020A1C06B9680F0D6925C0CB5C5F77B833FBFB0EB86F93B09D0150D04150D8CA3F69CA2018053861449ABA549AF4819449A7A84B64981D48914C928696247F03A52499D0499EC4A2E21C1A4E8A636CA09C1597AA2E59C0DD408A162477902DD0994D53972AA07720050B92D565E3519C5F052545D65F47E30C05511C839E910F52EAFB460519DBF18EA2E95C7F32279E5A53136EFD595356F1989A13567C1F25B2A4C13923C8CAE3D4FD90259121F748D48365DA2135BEB296CBA45E21534EBFE915B65C9E1E7E4780125950CE0848F8B71FDA18118BD8AEFB280FDB4829B203B89D75221D0C33D881D4318F7EE735171FF3AC51DC4FA31667E22B6B0DED209FCBD27B3322613420CAC2C106B12308772B4046586A3B48A11F78521B122AA58B447EEDC9A6E9E0887ABF4923894AD291593FE3A405D6DF47834CE3F3127B21B9FBB4A4372529E315ED2D1D37BBFE93AD2A054F3E4931A8CB9097F5DD00BB946DF45B9BB563FCFB7EF59DE27200B7E0FBF1195D589A1FC8DBDA409A596AED099EE9FB1B8382B9CD09D1071DDC1C599E6BEBCC836519C164D7E28AF0490EBF34697B0AA3D459D22BF844953ADA486FB0296923BFD42653873D92E23B933B9962B35450AA4EA89893A859712AD4CE8ECF1D13E55926560904B402788B13E8E7F058FCEECD3D17E2A0569901AD09DD158C93FCCDF6E4E4E8F88421D51F0FC1FD348E1D8AF443CA724F77D9004FCD5D6CD356EA0FCD57E53CA17CF002221B2DE904F71E6F0207BE9E4FFE99953DB36EFEF154173FB0EE23D4D767D691F52FFE397C4FAA792D9DCAC246359253D067DDD28F801EED98606292807EE9B6E9D499547D70D8D77DDFB70B498A72A1D48C43A196DA9D91BCDDFEBC24111B79A9E5773E78FD5E573521E3782F8902567153F28C9850C61ADE459694315C3458551A2B6610EFA29A943DBC8B2BAA4F8E745D6D5932FB7C60DDC45F02F7F714253C226B302E971959A6682405A7367B3B13F798F1B630DF713CBEBD063ACFD5AB21AE071F6F0764EC1995ADB1D9F18167AA35267B97D0EE4E4FDB013CD29774AA6F9D74A95D77ED26CA5674D0262F3A44CFCA0F6BFEEF260BD214F9745DCCDE452F9CB4CCE39D3673243F6B668DBE5A1E8BB4EC4FF96A70D7C45376EC2BD24464A169667A3713B97285FFD356D5A3BD3B4A4C32AAB27FEBCE21DA6555CEF3871AC45303CFE43E6DC1BB6D3470A3CD6D3478AD98C07CAF36EB7888C608B95ABFCA42DDE6D61BFADE1B87E070217A6AFF061616A6792647C08C2678EBBD7B36C921890A9AEE8F6AACEFC7CF193932B0150C00BB67861C1A6CB22BA523079B16FFE3C8B0961FC5EF9CE67168A4492E4C8C0C68CD87FEF4D3F776E6C1AD6049B0546314D1E381EC8A27F1BD43E3186ABFBBA1B5141D1644A2BB1A9247C3BB668D1A0BAC5A2E588D055F039243F5E06355F2526CB789291D7A70718ED9BDB4DCBC1F9763516754EDB5041A272076B07ED106C76E17C9AA3CA9DBC146491ED78136735FF020E57BE06BDA17E6D33FB0B07D2CEC27A7E9AE17A463D8330FBD18EDB4611E7029CADCF32EEFD370D43D6C9F1637F1E92BCB72FED1FC4EF7F9C45986A8D7F3C8B884888A17CE7A2DBE163687B0BAEC7F07131357B1550A02D35CA5823CCDD54AA8269BEA2EE2948D7517799AEB96103836D59D0FC2C6AAF32CCD358B49B1D88AE9D52657299D2CAAB091D54EC4AB2AA355150917F2FDC96CD762B7369BA9D94BB47917B587CB24AA18A788286577CC064BB3D63533114BE7196AF44A5839B8396CC4E4AF468C42B91509A18479A314C836CEF56AC424E41012D327F437084FCDDA40F12A79A3C68682088D0543B8351E4817E7920D36B9E44E6C6AB2F8219C74352BE82D91DA3B378261BE5BDD7E17CDAD3CC984E166CA684C75E86C4D8DF3A10C6096C2D650E3E9A539C95569ACC106486BF7A0B15BA6AAEDE6CEB635856950D3F20F7DD176340DF013A6FCAF4B18BBEB5A047ED21E409BDA8856796E825558EE87198DCA2CCC45AE5B980007ED522FA2C45D013B41C9F8F552F6DF17174FE6AFFC25746E82FB34D9A4096A32F4971EF59402EFAB9BEACFF877699D67F7F956C34413909A2E7EF5751F7C4C5DCFA9F4BE165C1D9388C01BF6E2522EEECB045FCE5DBF5592EE38921399A0C27C559CE111FA1B0F098BEF830578815D7443F0FB04D7C07EABDF96C884B477046DF6D9A50BD611F0E342465D1EFD8930ECF8AF3FFE0FC4AB1C85339E0000 , N'6.1.0-30225')
124END
125
126IF @CurrentMigration < '201604271316239_Entity tag changed to handle episerver'
127BEGIN
128 IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_SharepointId' AND object_id = object_id(N'[dbo].[Tags]', N'U'))
129 DROP INDEX [IX_SharepointId] ON [dbo].[Tags]
130 ALTER TABLE [dbo].[Tags] ADD [EpiserverId] [int] NOT NULL DEFAULT 0
131 ALTER TABLE [dbo].[Tags] ADD [EpiserverName] [nvarchar](256) NOT NULL DEFAULT ''
132 CREATE UNIQUE INDEX [IX_EpiserverId] ON [dbo].[Tags]([EpiserverId])
133 DECLARE @var0 nvarchar(128)
134 SELECT @var0 = name
135 FROM sys.default_constraints
136 WHERE parent_object_id = object_id(N'dbo.Tags')
137 AND col_name(parent_object_id, parent_column_id) = 'SharepointId';
138 IF @var0 IS NOT NULL
139 EXECUTE('ALTER TABLE [dbo].[Tags] DROP CONSTRAINT [' + @var0 + ']')
140 ALTER TABLE [dbo].[Tags] DROP COLUMN [SharepointId]
141 DECLARE @var1 nvarchar(128)
142 SELECT @var1 = name
143 FROM sys.default_constraints
144 WHERE parent_object_id = object_id(N'dbo.Tags')
145 AND col_name(parent_object_id, parent_column_id) = 'SharepointName';
146 IF @var1 IS NOT NULL
147 EXECUTE('ALTER TABLE [dbo].[Tags] DROP CONSTRAINT [' + @var1 + ']')
148 ALTER TABLE [dbo].[Tags] DROP COLUMN [SharepointName]
149 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
150 VALUES (N'201604271316239_Entity tag changed to handle episerver', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FE3B8157E2FD0FF20F869B7C8C6B97406D3C0D945C649DAA0930BC69945DF025AA21D6174F1EA924950F497F5A13FA97FA1A4AEBC4AA444CBF274312F8E481E1E1E7E3C240FC96FFEFBEFFFCC7E79F53DEB0546B11B06E793E3C3A38905033B74DC607D3E4993D54F1F26BFFCFCC73FCCAE1CFFD5FAB5CC778AF3A192417C3E794E92CDD9741ADBCFD007F1A1EFDA511887ABE4D00EFD2970C2E9C9D1D15FA6C7C75388444C902CCB9A7D4E83C4F561F607FA731E0636DC2429F06E43077A71F11DA52C32A9D61DF061BC01363C9FDC0449049EEEE0B7F869E126F0F01224E0F0210A5F5C076937B12E3C1720AD16D05B4D2C1004610212A4F3D997182E92280CD68B0DFA00BCC7B70D44F956C08B61D196B33ABB6AB38E4E70B3A675C152949DC649E86B0A3C3E2DEC34658B77B2F6A4B223B2E415B278F2865B9D59F37C72E1BCB8366A3A5BD5D9DC8B703681A951363738CC0B1E58E2E4830A25084CF8DF81354FBD248DE079005354C23BB01ED2A5E7DA7F876F8FE157189C07A9E791BA226D511AF5017D427DBC8151F2F619AE8A16DC38136B4A979BB205AB624499AA75A72713EB0E550E961EACA0405862918411FC2B0C600412E83C802481518065C0CC985CED4C5DD751E823D845759D088168604DAC5BF0FA0906EBE4190DB9930F13EBDA7D854EF9A5D0E34BE0A271880A25510A057A36D7FD18EEAAE6AB8D8B6A462E058DEA0419AADDE2CDF2E611C4D62F85A0F10E1F91EFD09673137F86C0F988F0634317A9570AFC18861E0441BBBC3BF0E2AE336048FA79627D865E96217E7637B90F2A46CB539D07FFFA1C7AD508AC929E16611AE111F9188AD31F41B48689BA5E39069AB42A73703AE509328D8A54913EB369ED689ADDCF66837C40A657AE83BE1FA225ECBD431A708822BB780DD59EBC7BAF54AD422DC809ACDCC8AFC7AFF27063A43D8038FE1646CEDF40FCDCA03AFA6940F505B4D308E17591007FB3F5DA1E9EC300DEA5FEB2764A43D465AC6B1EBF85D7C04673E555804BF596F729B4BF8669721538D8D97F496CDEF72B0A30A2CE856DC338BE466086CE3C442BD77EF319F655F89781F1D779C6CAFD78FC646AE62A6702D9CC55CE23BAFAF59FC1249A31F39BAA5E730FB87E2CD6879E8D9ECAAC8462C21CFC1C2BCEA63BF97F0AD76EA0A66A9955AE6A9EA355D5229BAEAA58989AA6454EB9A25986563DF35CBA6A2ED2656C47EE26D351A82E99E389C52597C86193CF21C2A7F20AABDCA6604919889AD658B7D546F222DEDCC1E4B02C7D98CBBD8E904C34FF7E3DE4C41E58CA85EBB5D889EA5AECF478B93AFDF0EE3D704EDFFF199EBEFB1E378ABBDAAA65DD872BDDFAB223ABE957E0A5A6ABEA341A323F657E346462C73F1A3235CB8819DB71C2126566245E297F8967DD31C76836F470A09A3974E5C3F8804EC305CF4EE6470B963AFEC12286B2302B6E5017D4EFCAFB97FA8E0471E4EAA74334882CBEF7A1A0EF77C9F108D67D03C237F12D081C80DAFFA6BDB597C74AC1BA7D499F6592ACE8511AB7EFE032E86E39A4BB5FCD9D46A362FD63B9995DB4472C2AF5FB406D1DA8D5714ADF6153091A28F8C48DDA0B3B41755D786100FB86E46EE24B37EE16DCEB1085C023978B3C541FB9C155A76C39C2D0E68E1AE30BA4BFEA7B80D3B6406C3FC0C91783669D81F511C4B08039B65D39E2326DD5A7854E98604DCFA3A5D7AADCFC8A7C3F56E3FB72C0B6EBF83E9ED2C5B825FBFBA9C85603984FE5BC9B208BCEDAE1228E43DBCDB4121F04978173BAA5578163A945D1EBF1CE9D30DF2284BAF81BD20B75FD84C5DB7D70093D98400BCF54F8CACE1CC4367078BBA3B6399AFA550E81F747447C96D6F04F5CC56824C0089702F8603546E3CC0D127ED8B881ED6E80A76431A6B4E2B0C346A8EA61532EE10606B8714A26515140BA0B9F5675313DD466A9D99440A21E408BE3125500B06727630328736823016811321D04A0B4C5760050DA247B07D07C5DA2DAFFCC22766CF064D6536274E6EBA141C049996B07D8A4EC317A68D6CB64597F0BF651751F673B9CB66E15C912E085DBAF34CAD56823B72793A9278F17D55AD25150F5A6CB377F8DD63C36334864B50F303E644655A9BA0846EE6464F0113CA5AEA5C379867143DF4AD09809CC83885465681491361EBD87656F6949E755D96563A29B8B1701EAE891DE031B1A3B124586989FC57655A9997C1FB04BEC1477E85A3A99BD126E0037EC1DBD1DA186566338CCD016559AB0C29DE245103C92F57053244912921D667FD110BF1A7E7321B7D20028945B42A572F16D87AD00318F24E2E744A8048CF85DEFE5327B6BF49A0862E2A86145583C2EC2AA2C32B0F0054CE8ABC713AB8E5F326E8EF36AB48022A8CA17675D5A8B1C2E3C28122A88216A882D2FFE368A2D223F1A628B739146A9F9A06A11CA9C877102E9456F8BB0FC288793916D8A5A8AB63548D81802CC04BA24B7C489CCCDF7C9D9D1A61C18AFDA5421941BB9CA416C429608A5AC37A62DD1C14A254EDBAD248ACDEA44677B598989A44AAC5436C6B8950A94B61B491090D18810F632111D9D9158A868486F031167B4BC512491A996D814A171EE4F1ADACE47A388D2A6DAC85F08E09BDA1CA0520B5111AA335EB9C102D2A0548B19FBDA219F5F5B0CC1EF7914A32EFD4D41ED7ADAC65317CFC0BEDC12F884A6B08152E080D0BB5A3335790249A8607BCD2F9F86491B2FDAF72AEC7CBB359CD9EB6EA1D9A2A37DBEED6D7B38D55D5C9B2F53DD74199A03CAFB06D52EA14A9B4D731291E2C36C2A611B99DD82CDC60DD604FB48F1C55AE4D423F39F16FA3C1C7E2E636A537666F734554D49188135645251D548D36B378A134C77B204F82EC8DCF1B96CC23D91646D5B56496F7BF83E2CD7BC657EFCBB005C23154BB95FE2379385A46BD4521F6F47B31B92DCA8E20B5A980F06782012DCF099875EEA07F27DB1BC34198523A53445E7E4D2EA080D294B1EB7914B12F168903245E9EAD22B560D5264F5515D0ECFAA41F50497CA4B9E4D193C7001050E835CB48786B412E065AEAF3BDC99FD7D07DCB749D8CE0028D820286CE59F34651084029C30224D5D2ACDF940CAA453D42532C40EA4482649434B92BE8152924CE8244F6251710E0D27C5113650CE8A4B55972CA06E20450B923BC816E8CCA6A94B15B03B908205C9EAB2F128CEAF829222EBAFA3718682288E41CFC80729F57DA3828CED7847D174AE3F99132FADA909B7FEAC29AB784BCD092BBE8F1259D2E09C1164E571EA7EC892C8907B24EABD32ED901A1F59CB65528F9029A7DFF4085B2E4F0FBF2340892C28670424FCDB0F6D8C88456CD77D94876DA414D901DCCE3A910E8619EC40EA9847BFF39A8B8F79D628EEA7518B33F195B5867690AF65E9BD1991301A1065E16083D81184BB1520232CB5A5DD17F9BE53B8BFEF288F5F7832493A18A2DE6ED228A2927464D64F386981F5F7D1A0D2F89CC45E46EE3E25E94D47CA5845FB4AC7CDAEFE642B4AC1734F520CEA32E4617D37C0EE641BFDD666ED18FFBE5FFDA0B814C02DF8717C461796E6C7F1B6368F6696597B8267FAEEC6A0606E7342F42107373F9667DA3A7360594630D1B5B8227C8AC32F4BDA9EC1287596F4FA3D51A58E36D2DB6B4ADAC82FB4C9D4618FA3F8CEE44EA5D82C1594AAD329E6146A569C08B513E3734744799689550201AD84DFE204FA393C16BF7973CF8538A0556640EB417705E3247FAF3D39393A3E61F8F4C7C36D3F8D6387E2FB9012DCD35D36C0337317DBB495F543F34539CF251FBC80C87E0622E6EC9BC081AFE7937F6665CFAC9B7F3CD5C50FACFB08F5F5997564FD8B7F0ADF93655E4BA7B2B0518DE4ECF359B7F4E39E47BB259898E49E5FBA6D3A75E6531F1CF675DFF7ED42929D5C2835E34FA8A57627236FB73F2F4944445E6AF9830F5E7FD4554D4836DE4BA28050DC943C2326941186779125250B170D5695C68AC9C3BBA826250EEFE28AEA53235D575B96CC3E1F5837F197C0FD2D45098FC81A8CCB654696290649C189CDDECEC43D66BC2DCC771C856FAF81CED3F46A88EB41C5DB01197BC6626B6C767CE0496A8DC9DE25B4BB33D376008FF4159DEA3B275D56D75DBB89B2151DB4C98B0ED1B3F2839AFFBBC98234453E5D17B377D10B272DF378A7CD1C49CD9A59A3AF96C7222DFBB3BD1ADC35F1741DFB8A34014F684B1FF6EE1A21A3A8CA86AD3B61689765384F166A10400DA492FBB4E7EEB6B3C08D36B7B3E0B56222F1BDDAACE3121A43E26AFD2A8B6D9B5B60E8BB6B1C73C385E8B9FC3B58499826951C010D9AE061F7EEA92387642568BA2CAAB1A01F3F41E4C8C0563CF7DF3D0DE4D06093DD1F1D39D8B4C81E4786B5FCEC7DE79C8E43234D72436264406B3EE5A7DFB9B7D30C6E054B82A51AA3881EE963573C892F191AC750FB650DADA5E8B020125DCE90BC10DE3545D45860D572A36A2CF81A9009AA07F9AA929762BB4DCCDFD0837873CCEEA5E59AFDB81C8B3A7D6AAF25D03801B183F58B363876BB48562545DD0E364AA6B80E1C99FB820729B9035FD3BED09CFE8E85ED63613F094C77BD201DC39E79E8C568A70DF3804B51E66277798186E3E961FBB4B87A4FDF5196938DE697B8CF27CE3244BD9E47C625AC53BC70D66BF1B5B03984D565FF159898A58AAD521098E62A15E469AE56C22BD9547711A76CACBBC8D35CB784ADB1A9EE7C1036569D6769AE59CC80C5564CAF36B94AE96451858D14762212551987AA48B890DC4F66BB16BBB5D94CCD5EA2CDBBA83D5C2651C53845C41FBB63EA579AA2AE9976583ACF50A35742C1C1CD6123667A356214CAAD48D823CC1BA540B67162572326218790982BA1BF41781ED6063E57C9A3343614443F826B6CAEDC67C8DED0996C724994D8D464F1CB37E96A56D05B22B5776E04C3E4B6BAFD2E9A5B794609C3CD947196EA70D79A1AE74319C02C5FADA1C6D34B739298D258830D30D4EE4163B7CC4BDBCD9D6D6B0AD3E0A1E55FF6A2ED681AE0374BF95F973076D7B508FC863D8036B511ADF2DC04ABB0DC0F331A9559988B5CB730010EDAA55E4489BB02768292F173A5ECFF2A2EDEC85FF94BE8DC04F769B24913D464E82F3DEAED04DE5737D59F91EDD23ACFEEF3AD86892620355DFCCCEB3EF898BA9E53E97D2DB83A26118137ECC52D5CDC9709BE8DBB7EAB24DD71AC26324185F9AA38C323F4371E1216DF070BF002BBE886E0F709AE81FD563F26910969EF08DAECB34B17AC23E0C7858CBA3CFA1361D8F15F7FFE1F1599F5C01F9E0000 , N'6.1.0-30225')
151END
152
153IF @CurrentMigration < '201605031740316_changed name of prperty in tag entity'
154BEGIN
155 ALTER TABLE [dbo].[Tags] ADD [IsAvailable] [bit] NOT NULL DEFAULT 0
156 DECLARE @var2 nvarchar(128)
157 SELECT @var2 = name
158 FROM sys.default_constraints
159 WHERE parent_object_id = object_id(N'dbo.Tags')
160 AND col_name(parent_object_id, parent_column_id) = 'IsDisabled';
161 IF @var2 IS NOT NULL
162 EXECUTE('ALTER TABLE [dbo].[Tags] DROP CONSTRAINT [' + @var2 + ']')
163 ALTER TABLE [dbo].[Tags] DROP COLUMN [IsDisabled]
164 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
165 VALUES (N'201605031740316_changed name of prperty in tag entity', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5B6FE3B8157E2FD0FF20F869B7C8C6B97406D3C0D945C649DAA0930BC69945DF025AA21D6174F1EA924950F497F5A13FA97FA1A4AEBC4AA444CBF274312F8E481E1E1E7E3C240FC96FFEFBEFFFCC7E79F53DEB0546B11B06E793E3C3A38905033B74DC607D3E4993D54F1F26BFFCFCC73FCCAE1CFFD5FAB5CC778AF3A192417C3E794E92CDD9741ADBCFD007F1A1EFDA511887ABE4D00EFD2970C2E9C9D1D15FA6C7C75388444C902CCB9A7D4E83C4F561F607FA731E0636DC2429F06E43077A71F11DA52C32A9D61DF061BC01363C9FDC0449049EEEE0B7F869E126F0F01224E0F0210A5F5C076937B12E3C1720AD16D05B4D2C1004610212A4F3D997182E92280CD68B0DFA00BCC7B70D44F956C08B61D196B33ABB6AB38E4E70B3A675C152949DC649E86B0A3C3E2DEC34658B77B2F6A4B223B2E415B278F2865B9D59F37C72E1BCB8366A3A5BD5D9DC8B703681A951363738CC0B1E58E2E4830A25084CF8DF81354FBD248DE079005354C23BB01ED2A5E7DA7F876F8FE157189C07A9E791BA226D511AF5017D427DBC8151F2F619AE8A16DC38136B4A979BB205AB624499AA75A72713EB0E550E961EACA0405862918411FC2B0C600412E83C802481518065C0CC985CED4C5DD751E823D845759D088168604DAC5BF0FA0906EBE4190DB9930F13EBDA7D854EF9A5D0E34BE0A271880A25510A057A36D7FD18EEAAE6AB8D8B6A462E058DEA0419AADDE2CDF2E611C4D62F85A0F10E1F91EFD09673137F86C0F988F0634317A9570AFC18861E0441BBBC3BF0E2AE336048FA79627D865E96217E7637B90F2A46CB539D07FFFA1C7AD508AC929E16611AE111F9188AD31F41B48689BA5E39069AB42A73703AE509328D8A54913EB369ED689ADDCF66837C40A657AE83BE1FA225ECBD431A708822BB780DD59EBC7BAF54AD422DC809ACDCC8AFC7AFF27063A43D8038FE1646CEDF40FCDCA03AFA6940F505B4D308E17591007FB3F5DA1E9EC300DEA5FEB2764A43D465AC6B1EBF85D7C04673E555804BF596F729B4BF8669721538D8D97F496CDEF72B0A30A2CE856DC338BE466086CE3C442BD77EF319F655F89781F1D779C6CAFD78FC646AE62A6702D9CC55CE23BAFAF59FC1249A31F39BAA5E730FB87E2CD6879E8D9ECAAC8462C21CFC1C2BCEA63BF97F0AD76EA0A66A9955AE6A9EA355D5229BAEAA58989AA6454EB9A25986563DF35CBA6A2ED2656C47EE26D351A82E99E389C52597C86193CF21C2A7F20AABDCA6604919889AD658B7D546F222DEDCC1E4B02C7D98CBBD8E904C34FF7E3DE4C41E58CA85EBB5D889EA5AECF478B93AFDF0EE3D704EDFFF199EBEFB1E378ABBDAAA65DD872BDDFAB223ABE957E0A5A6ABEA341A323F657E346462C73F1A3235CB8819DB71C2126566245E297F8967DD31C76836F470A09A3974E5C3F8804EC305CF4EE6470B963AFEC12286B2302B6E5017D4EFCAFB97FA8E0471E4EAA74334882CBEF7A1A0EF77C9F108D67D03C237F12D081C80DAFFA6BDB597C74AC1BA7D499F6592ACE8511AB7EFE032E86E39A4BB5FCD9D46A362FD63B9995DB4472C2AF5FB406D1DA8D5714ADF6153091A28F8C48DDA0B3B41755D786100FB86E490B017E06625CCB9007918020F5D2EF4507DE446579DB2E510439B3F6A0C30900EABEF094EDB0AB1FD04275F0D9AF506D64710C302E7D876E590CBB4559F173A6182353D8F965ECB72F34BF2FD588EEFCB09DBAE03FC784E17E396ECEFA7225B0D603E95F36E822C3A8B878B380E6D37D34A7C125C46CEE9965E058EA51646AFC73B77C47C8B10EAE26F482FD4F513166FF7C125F460022D3C55E13B3B7310DBC0E1ED8EDAE668EA573904DE1F11015A5AC33F7115A39100235C0AE093D5188D333748F861E306B6BB019E92C598D28AC30E1BA1AA874DB9841B18E0C62999444501E9367C5AD5C5F4509BA5665302897A002DCE4B5401C01E9E8C0DA0CCA98D04A045CC741080D216DB01406993EC1D40F375896AFF338BD8B1C193594F89D199AF8706012765AE1D6093B2C7E8A1592F9365FD2DD847D57D9CED70DABA55244B80176EBFD22857A38DDC9E4CA69E3C60546B498741D59B2EDFFC355AF3D8CC2091D53EC0F8901955A5EA221AB99391C187F094BA968EE719C60D7D2D416326300F225295A15144DA78F41E96BDA6259D5765B78D896E2E9E04A8A3477A116C68EC481419627E16DB55A566F281C02EB1535CA26BE964F64EB801DCB097F476841A5A8DE130435B5469C20A778A1741F048D6C34D912449487698FD4543FC6AF8CD85DC4A03A0506E0995CAC5D71DB602C43C9288DF13A11230E277BD97CBECB1D16B228889A3861561F1B808ABB2C8C0C21730A1EF1E4FAC3A7EC9B839CEABD1028AA02A5F9C75692D72B8F0A048A82086A821B6BCF9DB28B688FC68882DCE451AA5E683AA4528731EC609A417BD2DC2F2A31C4E46B6296A29DAD6206163083013E8925C132732375F2867479B7260BC6A5385506EE42A07B109592294B2DE98B644072B95386DB7922836AB139DED652526922AB152D918E3562A50DA6E244140462342D8CB4474744662A1A221BD0D449CD1F2469144A65A625384C6B93F69683B1F8D224A9B6A237F21806F6A73804A2D4445A8CE78E5060B4883522D66EC6B877C7E6D3104BFE7518CBAF43705B5EB691B4F5D3C03FB744BE0139AC2064A810342EF6ACDD4E40924A182ED35BF7C1B266DBC68DFABB0F3EDD67066AFBB85668B8EF6F9B6B7EDE15477716DBE4C75D365680E28EF1B54BB842A6D36CD59448A0FB3A9846E64760B361B375813F423C5176B91738FCC7F5AE81371F8B98CA94DD999DDD35435256104D690494555234DAFDD284E30DFC912E0BB2073C7E7B209F74492B56D5925BDEDE1FBB05CF396F9F1EF02708D5C2CE57E89DF4C1692AE514B7DBC1DCDAE4872A38A2F68614218E0814870C3671E7AA91FC8F7C5F2D264148E94D2149D934BAB2334A42C79DC462E4944A441CA14A5AB4BAF68354891D54775393CAD06D5135C2A2F793665F0C00514380C72D11E1AD24A8097B9BEEE7067F6F71D70DF26613B03A0A083A0B0957FD29441300A70C2883475A934E90329934E5197C8303B902299240D2D49FE064A4932A1933C8945C539349C14C7D840392B2E555DB280BB81142D48EE205BA0339BA62E5540EF400A1624ABCBC6A338BF0A4A8AACBF8EC6190AA238063D231FA4D4F78D0A32B6E31D45D3B9FE644E3CB5A626DCFAB3A6ACE2313527ACF83E4A64498373469095C7A9FB214B2243EE91A807CBB4436A7C652D9749BD42A69C7ED32B6CB93C3DFC8E0025B2A09C1190F06F3FB4312216B15DF7511EB691526407703BEB443A1866B003A9631EFDCE6B2E3EE659A3B89F462DCEC457D61ADA413E97A5F76644C268409485830D624710EE56808CB0D496765FE4034FE1FEBEA33C7EE1C924E960887ABC49A3884AD29259BFE16424D609A3C1A5F15989BD8EDC7D52D29B9094D18A76968E9B5DFEC9D69482079FA4984B17FB58DF0DB043D946BFB5593BC6BFEF573F282E06700B7E1C9FD185A5F991BCADEDA39985D69EE099BEBD312898DB9C107DCCC1CD90E5A9B6CE2C5896114C752DAE089FE3F00B93B687304A9D25BD804F54A9A38DF4FE9A9236F22B6D3275D80329BE33B97329364B05A5EA7C8A39879A156742EDDCF8DC21519E65629540406BE1B738817E0E8FC56FDEDC73210E699519D08AD05DC138C95F6C4F4E8E8E4F184AFDF1D0DB4FE3D8A1283FA41CF774970DF0D0DCC5366D25FED07C53CED3C9072F20B29F81883CFB2670E0EBF9E49F59D933EBE61F4F75F103EB3E427D7D661D59FFE21FC3F7249AD7D2A92C6C542339017DD62DFDE8E7D17E092626E9E7976E9B4E9D29D507877DDDF77DBB902428174ACD18146AA9DDF9C8DBEDCF4B127191975AFEE083D71F755513F28DF79228E0143725CF8809659CE15D6449F9C2458355A5B162FEF02EAA49B9C3BBB8A2FADC48D7D59625B3CF07D64DFC25707F4B51C223B206E3729991658A44527066B3B733718F196F0BF31DC7E2DB6BA0F34CBD1AE27AB0F17640C69E11D91A9B1D1F789E5A63B27709EDEEE4B41DC0237D47A7FAD24997D875D76EA26C45076DF2A243F4ACFCA8E6FF6EB2204D914FD7C5EC5DF4C249CB3CDE693347B2B366D6E8ABE5B148CBFE84AF06774D3C61C7BE224D4015DAD287BDBB46482AAAB261EBCE19DA65192EE00B3588A0065EC97DDA7477DB5AE0469BDB5AF05A31A1F85E6DD6F1098D3171B57E9505B7CDAD30F4FD350EBAE142F464FE1D2C254CF34A8E80094DF0B67BF7EC9143121334DD17D558D18F9F237264602B5EFCEF9E097268B0C9AE908E1C6C5A7C8F23C35A7EF8BE735AC7A19126B9223132A0351FF3D34FDDDB9906B78225C1528D51448FF7B12B9EC4F70C8D63A8FDB686D652745810896E67481E09EF9A256A2CB06AB95235167C0D4806D5837F55C94BB1DD26A670E8C1BD3966F7D272D37E5C8E459D41B5D712689C80D8C1FA451B1CBB5D24ABF2A26E071B25595C079ACC7DC18394DF81AF695F984E7FC7C2F6B1B09F1CA6BB5E908E61CF3CF462B4D38679C0A52873B3BBBC41C351F5B07D5ADCBDA72F29CBF946F35BDCE7136719A25ECF23E312E2295E38EBB5F85AD81CC2EAB2FF0D4C4C54C55629084C73950AF234572BA1966CAABB885336D65DE469AE5B42D8D854773E081BABCEB334D72C26C1622BA6579B5CA574B2A8C246163B118FAA8C4655245CC8EF27B35D8BDDDA6CA6662FD1E65DD41E2E93A8629C22A290DD31FB2BCD52D7CC3C2C9D67A8D12B61E1E0E6B01193BD1A310AE556240412E68D5220DB38B7AB11939043484C97D0DF203C156B03A5ABE4551A1B0AA25FC1353657EE33648FE84C36B9E44A6C6AB2F8E99B74352BE82D91DA3B3782617E5BDD7E17CDAD3CA984E166CA684B75E86B4D8DF3A10C6096B2D650E3E9A539C94D69ACC106486AF7A0B15BA6A6EDE6CEB635856950D1F24F7BD176340DF0A3A5FCAF4B18BBEB5A047EC41E409BDA8856796E825558EE87198DCA2CCC45AE5B980007ED522FA2C45D013B41C9F8BD52F6DF15178FE4AFFC25746E82FB34D9A4096A32F4971EF57802EFAB9BEACFF876699D67F7F956C34413909A2E7EE7751F7C4C5DCFA9F4BE165C1D9388C01BF6E21A2EEECB045FC75DBF5592EE38621399A0C27C559CE111FA1B0F098BEF830578815D7443F0FB04D7C07EAB5F93C884B477046DF6D9A50BD611F0E342465D1EFD8930ECF8AF3FFF0F4D83A333239E0000 , N'6.1.0-30225')
166END
167
168IF @CurrentMigration < '201605160846514_updated subscription to usersubscription'
169BEGIN
170 EXECUTE sp_rename @objname = N'dbo.Subscriptions', @newname = N'UserSubscriptions', @objtype = N'OBJECT'
171 IF object_id('[PK_dbo.Subscriptions]') IS NOT NULL BEGIN
172 EXECUTE sp_rename @objname = N'[PK_dbo.Subscriptions]', @newname = N'PK_dbo.UserSubscriptions', @objtype = N'OBJECT'
173 END
174 EXECUTE sp_rename @objname = N'dbo.UserSubscriptions.SubscriptionUniqueIndex', @newname = N'UserSubscriptionUniqueIndex', @objtype = N'INDEX'
175 DECLARE @var3 nvarchar(128)
176 SELECT @var3 = name
177 FROM sys.default_constraints
178 WHERE parent_object_id = object_id(N'dbo.UserSubscriptions')
179 AND col_name(parent_object_id, parent_column_id) = 'IsMandatory';
180 IF @var3 IS NOT NULL
181 EXECUTE('ALTER TABLE [dbo].[UserSubscriptions] DROP CONSTRAINT [' + @var3 + ']')
182 ALTER TABLE [dbo].[UserSubscriptions] DROP COLUMN [IsMandatory]
183 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
184 VALUES (N'201605160846514_updated subscription to usersubscription', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5DDB6EE4B8117D0F907F10FA6937F0BA7DC90C2686BD0B8F2F8991F105D39E45DE0C5AA2DBC2E8D22BA93D36827C591EF249F98590BA932C4AA4C496D493C5BCB445B2582C56155945F2CC7FFFFD9FE35F5E7DCF7AC151EC86C1C96C7F776F66E1C00E1D37589ECCD6C9D34F1F66BFFCFCC73F1C5F38FEABF56B51EF90D6232D83F864F69C24ABA3F93CB69FB18FE25DDFB5A3300E9F925D3BF4E7C809E7077B7B7F99EFEFCF31213123B42CEBF8F33A485C1FA77F903FCFC2C0C6AB648DBCEBD0C15E9C7F27258B94AA75837C1CAF908D4F66574112A1871BFC2D7E58B809DE3D4709DABD8BC217D721DCCDAC53CF4584AB05F69E66160A82304109E1F9E84B8C17491406CBC58A7C40DEFDDB0A937A4FC88B713E96A3AABAEAB0F60EE8B0E655C38294BD8E93D0D724B87F98CB69CE37EF24ED59294722C90B22F1E48D8E3A95E6C9ECD479716D3274BEABA3332FA2D50051936A6EB09B35DCB1E0E29D524B8832D17F3BD6D9DA4BD6113E09F09AB4F076ACBBF5A3E7DA7FC76FF7E1571C9C046BCFABF34AB82565CC07F289CCF10A47C9DB67FC948FE0CA995973B6DD9C6F5836ABB52947777830B36E48E7E8D1C3A52AD424B148C208FF150738420976EE5092E028A034702A4CA177AEAFCB28F489DA45559F44038961CDAC6BF4FA0907CBE49998DCC1879975E9BE62A7F892F3F12570891D924649B4C6009FCD7DDF8763F57CB17249CFC4A510AB4E88A0DA25DE4CEF2CC254FA051162EFF89EF80E6D3A57F1678C9C8F447F6CEC12F60A821FC3D0C32868A777835EDC65AA1892799E599FB19756889FDD55E683726B79A8EAD05F9F43AFB4C0B2E86111AE236A91F7215C7E8FA2254ED4F9CA74A089ABA286C0535620E3282F85F8399E578EA6D9FDAC56C407A47C653CE8FB2196C2D63BA4014D94C8C56BE8F6E0DD7BA56E157A214EE0C98DFCCA7E95CD8DA37687E2F85B18397F43F17303EBE4A701D617D85E47445F1709F2571BEFEDEE390CF0CDDA7FAC9CD2107D199B9AFB6FE125B2C95A7911D056BDE97D0AEDAFE13AB9081CEAECBF24B6E8FB15091861E7D4B6711C5F1265C6CE594876AEFDD633EAABE82F03F6D779C5CAFC78FC606AE52A5602D9CA55AC23BAFCF55FC1249C71EB9B2A5F671E72FD18E6875D8D1E8AAA35C6C01AE21A0B57D35DFC3F854B375063B5A82A6735ABD1CA6A5E4D97554A4C8DD3BCA69CD1B4422B9F592D5D3617EBC7D88EDC55CA23C82E255EAFF5C0EB265841D051B816A4ABCABBAD2264A19452856ADA6F5D9741E569BCBAC1C96ED17A37A37B19119A642DFEBA2B90DDB1941B57FBB203D57DD9E1FEE3D3E18777EF9173F8FECFF8F0DDF718348E15B6A5D3473BDDF81624EDE957E4AD4D77D5C91A529F65DE1A52B2D3B78694CD227BC64F1CD8A2A84CC82BD52FF459D7E638CE863607669843773E8C0FE8642E7485326F2D94EAF48D055665B02A1D5017AD1FCBFB17FC4E44E3F81D5087EC104F62EBD343DFEFD6E31E2DB593C4F2A4275AAAEDCDD38A0D5B73522E04126025DD38421AD2760C1F5A99EC9FAC4D65A56D82A4D5EF56D76A75E57949DF839292D040D925E17CE5D44E485FA75E18E0BE393742EC05B9690B73E734F23C03356321B7507E142CAC2A192087A0E2A75A33087567D6F7B8A66D0BD87E5C936DF7CC7A06EB238A71AEF3548E85F9A5DCAAAF1D9DF48317BFA839BDF6DDE6F7DCDBB1DFDE96E3B4B1B3F9D4DA61BDADCFF7435EAD5260B154F07440159D8DC4691C87B69B72051FFB16697276A4178163A9E5CC2B7B17CE93AF8986BAF41BE18B4CFD8CD7B7DBE01C7B38C1165DB6E8059D3314DBC811E54EC6E668F2573A04D11FD532B02C877F123A26968023DA0AD163D498D8991B24A2D9B881EDAE90A72431AEB5A2D9512194FDF025E77885033A382591A830208DB3E7655FDC0CB549EA785ED3443D05CD0F475415803F29999A827247341205CD93A28328282BB111149415C9D62968B62F519D7F6E433B35F5E4F653B07666FBA141949311D708BAC9C863F2AA596D9365F30DC454D51CA7914EDBB442B4007D11E29546BA1A6304E333198BCD49A58A5B31DFA92E86E680B051BAFB668CA68983016CA649C82ADDE7E9C7512C064EF9294F359BFFDB903EB1771434568CCD28579D9D31B4AB2EF3C97B64FE0E97741D965D45AE4D77FE5E405D93A4B7C486D621092343ACE7B05C557AAEBF1E185377F21B762D93CC5F1837A037FC0DBE91B4866563389D6125AAB49085A3EA0B906C92CD7053E64992C21D261E69C8770D1F8CC8A5348016CA25A1D2397CFF61238A98651EE96323D2024762947CFE98BE447A4D801C3A19589E468FF3342CAF1994F80227ECC5E49955E53B393727783596409E84159BF32EAD858E904E84880239470DB2C5B5E046B279A648836C7E8ED2483533AA16A2DC599A4050DC04B710CC8E7F043A69E0D4D2B46D50E0806A0A5DD330C93DF25AE5E61BE7BCC52927D3CB31955A2A58AF72E2BB460BD254DE23B392E820A54257DBA504E5737532BABDA4C4655F25522A06635C4AB996B60B0948E26864157B8988CDE84824940FA4B7806AE7BAA25024D9AC967C568DE3CC9F348C5DCC60D55A9B1A237CA1401C6E7B624B3DB5551B06E7A51BA4D198C86A11AB09B964EBAE8260C47848234B6346344C64D4666F5D3C07FFF60BF0194DA905A5E4428DEF725FD5E42924E984CD0DBF785C261D3C141B2B44C7DD06CEC5C31B1836745D401C7B5B9CA71AE9B5F93AD5C0CCD01A51DC61282389B2EC789EC190E41F8EE712BC92E36BB45AB9C1B2865F927FB1161978C9D94F0B7D240F3FA331B71939F3714FD95312466889B952D235E1F4D28DE28402A63C227ABFE4CCF1856A60DC24D9FB165DB2A1913887C59EB8A84F7FE70AD708E652C45462C09953BA2423F569C89A5EC114AC4A6C68514419E4A108B83574167A6B3F90C7CEF2D6F54C5D9D4A53064F4EADCAE2D469C9733B724A1012479D2654AE4EBDC4E5A8932C3FAAD31171399899104A45CAC7734E1F84A483A0834246885569258597B9BEEEEACEE5003AE87D1B85CD18408E27C1E856F64993460D924020562B53A7CAA246D469B225EA143968883A49AE4883CB3A0004C364BDA0133D8944E11A1A4E4A807C609C9550AA4E19007FA893068A3BD00678E6CBD4A902F81075C240B13A6D6AC5D9F5D23AC9EAEB649C2190E531E819C544A6BE6F54A0B119EF082DE7FA8B79ED7D36B3E0569F3569E52FB00562F9F7496A9634796744B3B25C763FCD92D0907B24E69533EB901A9F66CB69324F9719A7DFF4745B4E4F4F7F27A025B2A49D112511DF9368EB084C62B3EEA33890AB53911DD28D36896C42CCE0040A4741FA13D84E62CAAB477EC78DD9A4C1D7DE469BFC34AD6B70CE81F4B5C23483AD361435D51F7E827179477AE286912BD209CE99479D6C64CE1469D1ACDE767214AB82C9E8A5F1D584BF9ADC7D31D15B4894B59544848E9B5EEC49F782C0E3CF3A997397FA44DF0D10E17213F3D626ED98FEBE7DFA417111A723F8717A42075B8B96BCA9B0CFCC06694BF499BD9531A832B73921F6784258218BD36A9D55B068032C752DAE889EBF881B89B647314A9325BD745FEB52871BE9DD34256EE4D7D564ECF00749E2640AE7497C955295CA7325EEFCE8383FCB6907C5170E77B22A33AB5004B2B77E8B13EC67EAB1F8CD3BF35C4C535145856B14B84F384EB2D7DBB383BDFD030E4B7F3AB8F6F3387618281029B83D3B65033C3A77A94C5B014134DF978B38F2C10B8AEC6704A1665F050E7E3D99FD336D7B645DFDE3A16ABE63DD4664AE8FAC3DEB5FE2C3F89E08F35A3C158D8D7224479E4FA7A51FEEBC43FE484CE2CE3FBA6D3C75C6521F5CEDABB9EF3B85756472906A8AA65051ED0E44DE2E7F911204425E70F9838F5E7FD4650D041AEF451100133745CF88086560E15D684981C2216355192C0C1CDE85352968781757549DF7E8BADAA265FA79C7BA8ABF04EE6F6B52704FA4C1B95CCEB24C214602672D5BBB12F758F136B0DE0990BDBD0C5D84E5D520D7037AB783666C196AADB1D5F14E04A535467B4CD5EE8E44DB4179A46FE4545F31E9A2B88EED268A5174E0266B3AC4CC361FAFFCDF2D18BC38B2653B5FC5F3D9386859CF3B05757528D654222638DD873835A33722FAC6B6AA0A8003DA32019A326DE812DE5C6AED0DA1C0170004EDB29706C0400D06CF0D4091DB1439778B0FE8A0CDC50722575C3EBDD798757C4263625B6D5E65196A73DB047D674B3367B411BB227F07FB01D34091138036031E5F8F0F0739247240D365CDA9C1E4F4027D9C98B2E54FF2C787761C5AD964F73727AE6C5A008E13D3B5EC047D749CC6A1354D72CF61628AD67C56CFBE436F870ADC882E015B358E113D20C7AEFA045F1634AE43ED572EB4B6A2C32A1174C542F242776C18A7A9A855CBBDA8A9E8D780684D3D0155953C153F75721C859EA0995376350A57DEA7E5681460364C6D8BA6AD2023EC6D3A29CBB89B685560D3CDE84981F6D601E7725B74420ABE20F6B42D50A5BFEBC2E675613B4148C7DEB04E21A61E7AB3DA29A01E70ABCA5DDF2EAEC908383AFC9CE617ECD99BC872C0D0ECAAF6C9CC790CC9AC679973092A94489CF75A622F7C0DB0BBF4BFFF8251A4F82E81C4B5D02950A7B95B092E6453DF791EB3B1EFBC4E73DF12B4C5A6BE33236CEC3AABD2DC338C50C5772CEE3A858EC52A50C77CADF6AED3E84AE82DFD0A750002F3C9E4D822C336F9A9C90E0AF4A1F10895A08E690984053B328C2B0B27D70C232C5D73184B96C06508EBD984515B8D0885713112A407F342C935DB3848AB1191D44D08C635E82F101153B5019B55F20C8D4F19B1CFDE1A872BF719B2577326875C801A360D197EEB26DDD902B305B13DBA10C044607FA05ADDF997ADB7300AC406869D19647F1C5A53F63FB440CC62CF1A1202BB8DAF834C1A1BB001B4D92D18EC863166BBB9BB4D2D711A98B2E25B5F12BAAE03FA8A29FBEB1CC7EEB222415FB507D86682D6B2CE55F01416B133C7515185BB14768D13E49088F6344ADC276427A4983E604AFF2FE3FCD5FC85FF889DABE0769DACD6091932F61F3DE635058DC19BFA4F8173599E8F6FB350C4C410089B2E7DF8751B7C5CBB9E53F27D095C439390A0C17D7EA597CE6542AFF62EDF4A4A3702D2898C502EBE3227718FFD954788C5B7C102BDE02EBC11F5FB8497C87EAB9E97C888B44F042BF6E373172D23E4C7398DAA3DF993E8B0E3BFFEFC3F6A497BFB2D9E0000 , N'6.1.0-30225')
185END
186
187IF @CurrentMigration < '201605160910456_added role subscription entity'
188BEGIN
189 CREATE TABLE [dbo].[RoleSubscriptions] (
190 [Id] [int] NOT NULL IDENTITY,
191 [RoleId] [nvarchar](128) NOT NULL,
192 [TagId] [int] NOT NULL,
193 CONSTRAINT [PK_dbo.RoleSubscriptions] PRIMARY KEY ([Id])
194 )
195 CREATE UNIQUE INDEX [RoleSubscriptionUniqueIndex] ON [dbo].[RoleSubscriptions]([TagId], [RoleId])
196 ALTER TABLE [dbo].[RoleSubscriptions] ADD CONSTRAINT [FK_dbo.RoleSubscriptions_dbo.AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[AspNetRoles] ([Id])
197 ALTER TABLE [dbo].[RoleSubscriptions] ADD CONSTRAINT [FK_dbo.RoleSubscriptions_dbo.Tags_TagId] FOREIGN KEY ([TagId]) REFERENCES [dbo].[Tags] ([Id])
198 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
199 VALUES (N'201605160910456_added role subscription entity', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5F6FE4B6117F2FD0EF20EC531238DEB3DD04E9C14EE0F39FD4E8D93EDCFA82BE19B444AF85D34A1B49EBD828FAC9FAD08FD4AF5052FF490E2952A2B4DAEBC12F6B911C0E873F0EC91972F8DF7FFFE7F8979755E03CE338F1A3F06476B0FF66E6E0D08D3C3F5C9ECC36E9E3F73FCD7EF9F9CF7F3ABEF0562FCE6F65BE239A8F940C9393D9539AAEDFCEE789FB845728D95FF96E1C25D163BAEF46AB39F2A2F9E19B377F9D1F1CCC31213123B41CE7F8E3264CFD15CEFE21FF9E45A18BD7E90605D7918783A4F84E52161955E706AD70B2462E3E995D85698CEE6FF01FC9FDC24FF1FE394AD1FE87387AF63DC2DDCC390D7C44B85AE0E071E6A0308C5294129EDF7E4AF0228DA370B958930F28B87B5D6392EF1105092EDAF2B6CEAEDBAC3787B459F3BA6049CADD2469B43224787054C869CE17EF24ED59254722C90B22F1F495B63A93E6C9ECD47BF65DD274BEAAB767414CB301A226D9FC703F2FB8E7C0C97B154A0898E8DF9E73B609D24D8C4F42BC2125823DE7C3E621F0DDBFE3D7BBE8330E4FC24D10347925DC9234E603F944FA788DE3F4F5237E2C5A70E5CD9C395B6ECE17AC8A35CA54AD3B3A9C3937A472F410E00A0A0D492CD228C6BFE210C728C5DE0794A6380E290D9C0953A89DABEB328E560476715D274120195833E71ABDBCC7E1327D2243EEF0A79973E9BF60AFFC52F0F129F4C9382485D27883013ED575DF45DBAAF962ED939A894A21A33A25826A97B89ADE598CA9F44B2264BCE33BA23B8CE95C251F31F2DE11FCB8D827EC9504DF45518051D84EEF063DFBCB0C18927E9E391F719065489EFC75AE838AD1725FE7A1BF3E46413502ABA4FB45B489E988BC8BE0F43B142F71AACF578E011557650E81A73C41C651910AF1733CAF158D5AFDACD74407647CE53C98EB2196C2CE2BA4118728914BA0A8F6F0871FB5AAD5A8852881473F5ED5E3577BB871D43EA024F9238ABDBFA1E449C13AF96981F505763731C1EB2245ABF5E0B57D788A427CB3593DD44A698CBAAC75CDDD1FD12572C95C7911D252BDE9BD8FDCCFD126BD083DAAEC3FA5AEA8FB35095861E7D47571925C123063EF2C222BD77EF319D555F49785F1D779C6CAF578726F6BE62A6702D9CC55CE23A6FCF59FC1249C71F39B2E5F6701F25709CC0F3B1BDD97591B8C8139C43916CE663AF9BF8F967EA8C76A9955CE6A9EA395D5229B29AB94981EA7454E39A35986563EF35CA66C2E360F891BFBEB8C47905D4ABC99EB9EC7269841C0289C0BC2AAF66AABDCB2504A19A054EBADEB6A53799AAC6F70BA5F96DECFE95EC68426998B3FEF0B64F71CEDC2F5BAEC50775D7674F0F078F4D30F3F22EFE8C7BFE0A31FBEC44DE3B6B66D59F7D14A075F826435FD86828DEDAA3A8D864C67D91F0D19D9E98F868CCDD27AC6771C58A2CC4CC86BE52FF16C3AE638CEC61E0E4C33C7AE7C1C1DD069B8D019CAFE68A154A73F58602883596983BAA07E5BDABFE4772288E357401DAC433C899D370F7DB94B8F3BB4343612CB8D9E68A9B736CF322A96E6245DD84880994CF711D22D6DC7ED432B93FD8DB599AC8C872029F575D4B58EBACA5FD2D75152111AC9BA24F8574EDD94D4751A4421EE6B7323C49E919F95B0E7A791DB19E830166C0BD5476184D5295D4C1DED76043E17AFABA074C18A0066323578F1BA44D3EEA1A35B5BAD1E327EBBB898DA96ADED2EA67C896A579B39EF50828B714AE558AA8C8C5B6B56290108B9301470A21FDAF194E5320514E9D44E4390E7461C9C9D20C237AA034678125FA7BCD6296F9CDDC6C00BCD7C14D91B6FFC24A31E957D97C39DA698561665CB616353837D33C36E981876E504C1B61D9874B100CF23CDFEBE2FB2D5B01653055003594C207D9A2491EB675CC1275D4ACF20DBD28BD073F4DC84F572413842734D10EAD36F842FD2F5331E6FB7E1390E708A1DBA52A76712CF50E2224F943B699B67C85F35418BCB9986D389E5F03BA1623212704C4B217A722421E3CC0F5371D8F8A1EBAF51A02531AEB4E6B0A342A8EAE153CEF11A87B4715A22D161406A5A9C5775713DD426A9E379038966002DFCC1BA00E09DC3530328E7959600B4F0038D025056625B00282B929D0368BE4FD0ED7F6E0F3F357872FB1B189DF97A68147032E2DA023619794C1E9AF0625FD6F72D2BFFBAEFC57D695BDFB75502004CB08FF0F8B7822F253B23E04B29739DFA615FDEB6F045F769DA3DCF6CDA06421763CBABEBC8F693E300AAC1C136F0D410B24EF58511622B68AA8D6CB2EE058CDECA3E554105B0DE692B9FEFF8DD96761B4163B48C45B5D7AFE6567448EB8B416DFD1E63C4A8381861C4A8843CF51103FB64B5BB9A75D00E8427F610A9C1FA76187035D9D906BA9A329FFCFA913F642FDD35C8EE8A35BABBB8D0A98F24E931FEB1312461648CDD072C579D9A9BD73BB7899DE20A444B27F337FA2CE086BF62B125D4B06C8C871956A25A1359B455BC00A671590FABECE4127FF538D61385757E7CD3895C4A23A0502E89896D6A733F09BD0D4E4AE058B4E99D3F6457C55F52C0E3471A5638FD92C269C42383125FE094BD3936736AEF0CA7E604ADC612285C4662715EA5B5D0119C1F1051C0436240B6BCB7A5245BD8B50DC816A7309454F341D542943B9A22101417C12D04F3C323029D6CE3D45294DFB5437444B388065195A4402935464903B692DB838DCCEA7B86FC30D6F627566DAAA02FA8046DDF5F8316047F5ECDB392E820A57200B44B097269295BC639B57A4989734049A45436C6BA940A94B60B09B00C1938567A8988351349245434A4B78024077444016918F70DCCFB8D5601DA48212CB5419F233B8880320DAB211FC1D4A66F9EB6279DA679AD41359F3C7ACBA6714E511488C4BEDA62616D61B2C5A63A40FFC3E779C5E6B69B5AF58DAD8D66E8F7BDD2B46ABFEF251734340423EED00DEC867644C3ECD5DB94759769870F17014C382A639796B9ABC177B5D2574D331203D770CD2FE351481B0F596B34EC35DD1ACE596806683674DC4E6C7B9BE541D7F6D0A6EB744D05961618E519C06A6F5BA51DCFF3C885C587E3B924C4E1F1355AAFFD70D90879587C711679BCC3B3EF17E6C1FF56398DB9CBC899DF895735A5518C96984B2555134E2FFD3849698CC50744CF679E792B211BB893976C9CCA2AD9CDBAD887E586AACC4F7F178053C67F2C77F9A209A4A074495ABAA24694EC08BB30AAC4820E0D4289021403A76ECFA260B30AE5D61C79E9A6EDB8494565539653ABED8A4D5A726BA39C1214BCAF49134AD7A75E85F26B92AC3EEAD31143F9313D21A48A948FE71C1E0433988041C146C9425A0BF032D5D71DEE9C55AA03EEDB280C33008A10740CB6F24F86341A51CC04628D347DAA6CA0B9264D36459F22174DAE49924B32E0B219338E61B299D0899E44A2700E032525448963949590AA4F198817D7240D2477A00DF0CCA7E9530542CA350903C9FAB4E928CEAF673449D65F27A30C0113A145CD289AD6CD75A3068D61B423349D9B4FE68D904ECC845B7F36A455046D128815DF27892CA9E5D70AB272EF4A3F644968C835121318895548CA684E729A4CB42346E9ABA23DC9E999E17702289119EDAC8004B21A1B62042631ACFA285DC44D2A32B7F1D63A91358859EC40C13969DE81ED24A63C7B14A72E99451A7C10736B9D9F99752DF63960BED6E866B0D440BBA666AC18705FDE919EB860E4924C36E74C1C187667CE2419D1ACC3C17014EB84C9E0D2FA6CC21F96EF3E99984D24DA68253B42CFCF8E9A656B4120F64A93CCB94F75E2CA0F11E172887E6B9376427FDF3E7EA33989D3167C3B3DA183A5C5913CD4B6CFCE026947F0CC1EE91915CC3D94D060AB23E1A894790FB693186680982D6B776175C4FAA7842552795CC16419549601D63A2D731175C089B26ABB55ACD5CFD27B408D2A4DB8911E97D5E2467E8256C60EEF49143B537028F2592A28558E45CE81785C38F3DA1F5213BC7B7996995302816CAE5E9314AF72782C7E0FCE021F535B6499E11A85FE234ED23CFCCDECF0CDC121F7FEDA74DE429B2789C7C4D2923E88C676D908517B7C2AD3D6885A86017AC4B7C7C26714BB4F087A69E92AF4F0CBC9EC9F59D9B7CED53FEEEBE27BCE6D4CFAFAADF3C6F9971859A8E7AB64463C9585AD72247FAD2CEB967E6F9579E49FD4E65B650F7E1B4F9DDFDF1A1DF675DFF7EDC2E66B5620D52C1C554DB5FBE355EDF21729410F57955C7EB3422FDF9AB2063E4ED58B22F000952D7A5644287B60AA0B2DE9E352D060D5692CFCD85417D6A40F4D755145B5C3CF54D59625B3CF7BCE55F229F47FDF90843B220D4EE57223CBD62B0380B36D6767E21E33DE00F39DF0CC4BAF812E3EE56240AEC7732D1D90B1632F9D589B1D3F880F9958A3BD4D68777FBDA40378A4D776752F569ABEFCB16D3551B6A2033779D1317A56ED5FFBBF9B307871E4D376318B17BD71D8329F77DAD435A32A6712B1C1E901C4A91DDC88018176152AC0DB112D1D6028534595F0E2D2686D086D7C814724BAACA58107242C6E9E1581FA7769E7DC6D7F401B6D6F7F2072C539547AB5B9FB43005F8682E83A8FF3E298EE5CA2C3E9B07389D221A2871C9967C3DEF2D25CB0D4E24A0BB12BB92F601D693B42FB04620A037144D45146C688243C66101CD5296F83EDDCF4A3AD4F0C6C45741975EC992F116CB283DF13071B70326D67B0961FBD193FCAD796912639203531A069844A915CCD368828C777A73C0848CF70D7BDA3C16D2310F5D4E2BEF50C669EC51C310D8F3C2D44C0E7C9A70184498421070F84996260908907D8D7718C9805309F3884DACFF54D1844D039BEFE93CD170DABB1E7AA8EF8DAEA6CD51EDDCADE6C2586C254C6C9DC6555A371B16E5A8A46239897AD3DD4B401B2858D5027B06C77C7AD1BD07F189C94518E9BD434E3BBEF0A26A4219EC49A762544FF572C0C8F85DD0CBEBFED05EB140C70632F563B59DF465CAA727784CAB39842B43EBE4F8B5B5CEC751779A0FCFC3ED0C9CC7B8848AFE76E3649EC499138AFB5C45AF81C6075D923DD70AC4ABE4AC0CB25540AE451572B095DAEAABB707A28EB2EF2A8EB96040457D59D0F4265D5791675CD701C4CBE6271D529542C66812AE673B5579DEDAE84DAB2AF500560F85F991C5B64D8263F3DD9890648A142310B54A978CB574376828D0112A59049563DF4FCC2961F3960E3E5AA5FEE904E778C1291C40313A6D209BF696045288C769384B2B22F946250597FC2C08A489A43080EDCD45F20B07BCDC2930590D613032CA844215365F025FF014461E77182C6945245F59952B3C5670314CF0F482EDAF768AE7CD690C505B0D9E4326EB7AAC9F06D7EAB50DF8610402B74FFB7184CFB5FB6D883039D0DD0EC5C25F77F6AC1D60C30B640EC3EAF604908EC1EB21947DD5A832D3CA8B0038D1DF819856EEA6EA8458EC1B309623493E3F9C74D48EF69E7FF9DE3C45FD62468E0A610BB8CC5A4CA73153E46A5E186E3A8CCC21D5FBEC629F2508A4EE3D47F446E4A92E9156D3F24CAB2080C75B17AC0DE5578BB49D79B943419AF1E02E6BE283500A9EACFDE8660793EBECDF772369A40D8F4E9D5F6DBF0DDC60FBC8AEF4BE0C0B48404B52C157712685FA6F46EC2F2B5A2742304F393112AC45719C4EEF06A1D1062C96DB840CFB80B6F047EEFF112B9AFF5055A1991F68E60C57E7CEEA3658C564941A32E4FFE2518F6562F3FFF0FF3E0FBB243B50000 , N'6.1.0-30225')
200END
201
202IF @CurrentMigration < '201606201400477_Added MyReadNews Entity'
203BEGIN
204 CREATE TABLE [dbo].[MyReadNews] (
205 [Id] [int] NOT NULL IDENTITY,
206 [NewsPageId] [int] NOT NULL,
207 [ReadDate] [datetime] NOT NULL,
208 [UserId] [nvarchar](max) NOT NULL,
209 CONSTRAINT [PK_dbo.MyReadNews] PRIMARY KEY ([Id])
210 )
211 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
212 VALUES (N'201606201400477_Added MyReadNews Entity', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5DDB6EE4B8117D0F907F10FA6937F0BAC77676B119D8BBF0F89218195F30ED59E4CDA0BBE9B6B06AA957527B6D04F9B23CE493F20B2175E5A5489112A5564F067E718B64B1583C2C9245B2EABFFFFECFF1CFAFABC07BC171E247E1C9E460FFDDC4C3E13C5AF8E1F264B2499FBEFB71F2F34F7FFCC3F1C562F5EAFD52E63BA2F948C93039993CA7E9FAFD749ACC9FF10A25FB2B7F1E4749F494EECFA3D5142DA2E9E1BB777F991E1C4C31213121B43CEFF8D3264CFD15CE7E909F675138C7EB748382EB688183A4F84E52661955EF06AD70B246737C32B90AD3183DDCE0DF9387999FE2FD7394A2FDBB387AF11784BB89771AF8887035C3C1D3C4436118A528253CBFFF9CE0591A47E172B6261F5070FFB6C624DF130A125CB4E57D9DDDB459EF0E69B3A675C192D47C93A4D1CA92E0C15121A7A958BC95B427951C89242F88C4D337DAEA4C9A2793D3C58B3F274D17AB7A7F16C4341B206A92CD0FF7F3827B1E9CBC57A1848089FEED79679B20DDC4F824C41B5222D8F3EE368F813FFF3B7EBB8F7EC5E149B809029657C22D49E33E904FA48FD7384EDF3EE1A7A205578B8937E5CB4DC5825531A64CD5BAA3C38977432A478F01AEA0C04862964631FE2B0E718C52BCB843698AE390D2C09930A5DA85BA2EE368456017D7751204928135F1AED1EB471C2ED36732E40E7F9C7897FE2B5E945F0A3E3E873E1987A4501A6F30C0A7BEEEFB685B355FAC7D523351296454A74450CD12D7D33B8B31957E49848C777C4F7487359DABE413468B0F043F73EC13F64A821FA228C0286CA677835EFC65060C453F4FBC4F38C83224CFFE3AD741C56879A8F3D0FF3E45413502ABA48759B489E988BC8FE0F47B142F716ACE578E011D57650E89A73C41C551910AF1733CAD158D5EFDACD74407647CE53CD8EB219EC2CE2BA4018728914BA0A9F6F0FB1F8CAA35A8852881273F5ED5E3D778B809D4EE5092FC1EC58BBFA1E459C33AF9D701EB333CDFC404AFB314ADD6BDD776F71C85F866B37AAC95D2107539EB9AFBDFA34B342773E545484B75A6F7319AFF1A6DD28B704195FDE7742EEB7E43024ED8399DCF71925C1230E3C5594456AEDDE633AAABE87F0EC65FEB192BD7E3C983AB99AB9C09543357398FD8F2D77D06537026CC6FA67C9D05C85F25303FFC6CF4506665180373C8732C9CCD76F2FF182DFDD08CD532AB9AD53C4723AB45365B562931334E8B9C6A46B30C8D7CE6B96CD99C6D1E9379ECAF331E4176297136D783884D3083845138178455E3D556B965A1943240E9D65BD7D5A6F23459DFE074BF2CBD9FD3BD8C094D3217FFBA2F91DDF38C0BD7EBB243D375D9D1C1E3D3D18FDFFF8016473FFC191F7DFF256E1AB7B56DCBBA8F56DAFB1224ABE917146C5C57D56A34643ACBFD68C8C88E7F34646C96D633B1E3C012656642DE287F8967DB31277036F470E09A3974E5C3E88056C385CE50EE470BA53AFEC1024319CC4A1BD406F5DBD2FE25BF23419CB8026A611D1249ECBC79E8CB5D7ADCA3A5B591586DF4444BB3B5799651B33427E9D24602CC64BB8F506E695B6E1F1A99EC6EACCD64653D0449A9AFA3AE71D455E7255D0F4A2A42035997A4F395D3794AEA3A0DA21077B5B911622FC8CF4AB83BA751DB19E830966C0BD5476984D5296D4C1DCD76043197A8ABA074C98A0066B2357889BAC4D0EE61A25B1BAD1E2A7EDB1C31352D5B9B8F98F225AA5B6DE67D40092EC6299563A932326E9D59A52420E4C2D0C0897E68C65396CB1650A4535B0D41911B7970B68288D8A8161811497C9DF21AA7BC61761B3D2F34F351E46EBC89938C7E54765D0EB79A621A59542D878DC7E3F51BBDA441874E8B915817FE3A061BC72015CD1D5AE2AEAB4E2A727A2EDBF97E4EE3EED3D424ECD6E8E5DEE0B51BC6AE5DB9CBB2EDA3740A5B7845C3F6F74391AD56B072AAA45E812C36CAF53449A2B99F7105DFB92ACFA8F9965E840BCFECC0BA5EB84A97B9AE09427DFA8DF045BA7E22E2ED363CC7014EB147F78CF476EC194AE66821CB9DB46D61C95FB5549417D6CCF127CFE19FA48AC948C0312D85E81DA6848C333F4CE561E387737F8D02238909A50D871D1542558F98728ED738A48D33128909034A23F7B4AA4BE8A126491D4F1924DA01B4B899600A00F19AC2D8002ADC8F5000B438911C04A0BCC4B600505E243B07D07CC76ADAFF8235696CF01476DA303AF3F5D020E0E4C4B5056C72F2183D34E16DA7AAEF1BF6A075DFCB1692A6BE6FAA04009864A913F1EF045F5A7606C09756E626F5C3A7CADBC217B51818F73C673EE8095D9C55B9AE23B36C0C032886836DE08911B249F585396C2B68AACDBDAAEE058E5FB47DAA830A604736563E7F12775BC66D048F45542CEACF9F6B6EE5AB11E662D09FC30C3162741C0C306274421EFB88816F071877357F55A0273CF1D7992DD6B7FD808B65671BE862653EFAF5A3F8DC43B96B50BD5A64BABB785A6C8E24E58392A131A4606488DD072C57939AD987C6DBC44EF118A7A193C5B7A50E70233EF6D9126A783686C30C2F51A3892CDA2A5E00D3B8AA87757672C5CD8961AC271AEBFCF0A613B5940640A15A1223DBD4E6E724D42F01298163D9A677FE98392D784D81133FD2B0E2D02F290E8D446450E2339CF26F18275E7D3A23A83949ABF1048A2323B9B8A8D21AE848871F1051E084C4826CF982504BB6B06B5B902DEE0369A9E683AA81A870494A22282F821B08E6D798243AD9C6A9A1A8B86B87E8C8669106A2ECBD09891A9B68C09C4EE2A0B499D1C6C05FF11E96C9AC7F392BAA03E373C9AA4DD51092548BF11922430B1A46E274C14BA28594CA81D42C25E8684CDB32E170AC939484832C8594CAC638975281D266210116268B039A4E22E2CD4D0A09150DE92C20C59533594006870416C7044CAB00ADA61196FE604020DB8B80324D6D201FC964676EE676271DD64CC750CD27A1CEB2616EDECA0251D8691B2CB50D4C36D8667BE87FF886BADCDC6693ADB9D196698679DF6B4DB4EEFB5EF1E4C84030F24EDFC2FEE84634DC9EBF4959B79976440728C084A3339A1999CD18BEAB1D836E9A5118CAFA6B7EE96145D978C8EA6360F769D770C1D2D343B3A16B7B72DB9B2C18A6368C265D676A7270B4C028EF12567BE42AED789AFBE22C3E1C4F154E3B8FAFD17AED874BC68967F1C59BE51E3CCFBE9BD9BBB35CE534A6734ECEE28EBEAA298D62B4C4422AA99A707AE9C7494ABD863E227ACFF36CB192B2811601C5C6A9AC92DFF4CB7D586EA8CAFCF4FF02705A8FA6A5B54036A514942E494B57D418935D089746955CD0A36E55518062E0F6EE59146C56A1DA2AA42ECDDAA0592A3ADBB49A5A6D9F6469A9AD966A4A903B4A9626946E4EBD724EC992AC3E9AD3919D53723D21A5CA948FA7021E24739A8441C9D6C943DA08F02AD5D71EEE8275AB05EE9B28F433000AA78A1CB6F24F963418BF7C123126CD9C2AEF3A91A5C9A7985314FC23B22485240B2E592F881C936C422B7A0A89C2392C9494E4F790535652AA3965C003224B1A486E411BE0594C33A70A3849640903C9E6B4E928CE9F79B024EBAFA351868089D0A166944DF4F6BAD180463FDA119ACEED2773C6491937E1D69F2D69156EC82462C5F751224B69F97582ACFC94A61BB21434D41A8973F5C52B24AD7F32354DCE7F17A7F475FECBD4F4ECF03B0294A88C764E4002598D2D310293E8577D9447CD2C15D5F1F3D63A91378839EC40E990D3BE039B498C79F6286E6F728B34F842E7D63A3F33EB3AEC73C07C6DD0CD60A99E764DACF723705FDE929EBC6014926C36E79C67237E67CE2559D1AC1D1C0914EB84D1E0D2F96C225EBA6F3F99D84D24C668253BC2859F5D59CBD68280372196CCB94F75E2CA0F11E1B28F7E6B927642FFBF7DFAC67012A72DF8767C42074BCB23B9AF6D9F9B05D28EE099BFD23328983B28A1DE5647D2952BFB1E6C26D1CF00B15BD6EEF0EA88B9C8E6B0E7D5540DFA5C57B82775C838EEE19422F3DD023B95FB1E0E3DD5D75DDD21F3279CD222BBBCF062B3902ECB00ABE586D50C3DC295475BD3FB7623EC285FA43155DA70A3BCB86DC48DFA2EB78A1DF12C5AEE4CE9485ACC5241A9F852FDAE8EA48BE3E0E6E092D2F9709E65E2954020DBF3B724C5AB1C1EB3DF82B3C0C7D49A5D66B846A1FF84933477C434397C777028C4A41C4F7CC869922C38DF66CA20917C970DE03FCAA7326DF47066E92A4A8EC718BEA078FE8CA0E87357E102BF9E4CFE99957DEF5DFDE3A12EBEE7DDC6A4AFDF7BEFBC7FC93EAE3A466AB4E2A92CEC94237504C7AC5BBAC56F5C901FA9CBF88D8F7E134FAD63120E0EFBBAEFBB76211BE10FA49A3946ABA9B60FE8D72C7F991214CCAFE4F29B157AFDD6963530605F278A40503E57F49C88501574AF0D2D65C03D68B09A34160EC0D7863565F0BD36AAA83E32B655B565C9ECF39E77957C0EFDDF3624E19E484350B9C2C87215790538AEDDD999B8C38CD7C37C2785BEEA34D0E5F05616E43A84B06A818C1D8BFEE46C76BC93833B39A3BD4D68B78FE8D4023CCA07E4A64F7C6DA3216D5B4D94AD68C14D5E74889ED59FD0FEDF4D18A238F269BB98C58BDE386C98CF5B6DEA584FF399445C707A0071EA0637B26BAA5D850A104FA7A1032C65AAA9125E5C5AAD0DA18D2F1058A7CD5A1A08AAE370F3AC095EB24B3BE776FB03DA6877FB03992BE148AE539BDB0747F9321444DB795C14C778E712134E7B9C4B5467623B8B183956461BEB831829A3B525145E0C49BBCB8ECB01ED99965957AA0EA7DCED10ECC706359AD342FC62FC0BD80AB80EF7300207E5805322BDCBA221DC920FE9514BF7D4C362473EFED00D23035BE1AA4AEFC8EA4B049BEAF5C7C8C1065C4FDD19ACE5F7EF867719B865A4296E498E0C6806FE9214FE192CDC538ADDA9F604D4D1777E67D792DBF06A3F3627921D2323648E87449781BB8508F851C93880308A9806E09D3E5B0CF432F100FB3A8111BB6808238750F3D5CC118308BA8AD97DB2F9A26135F45CD5125F5B9DAD9A5DDCB99BAD64BFBA0C2D397197558DC1EBDA71291A038F7EAEF650E306C8163642ADC0B2DD1DB76974907E7052BA4C67A919068BD8154C28FDBCC935ED4ABC8FAF58E81F0BBB19C963DB0BD63118E0865EACB6B2BE0DB854159E7995D76925979D629F160FF1F8174BEAA81BF993AE93C9E23122BD9E1FB3291CD0CAC445AD25D722E600AB4BD63738851DD68A5502A75C52A5401E7DB58AF805BABA8B430F6DDD451E7DDD8AA800BABAF341A8AD3ACFA2AF1976862B562CAF3AA58AE52C50C562AEE6AAB3DD95545BF615AA00F401AE9263830C9BE467263BD90029552867812A959FFA37556D1C0105AACE22420A64CB80BA4CCAA46A26143366CB115578E7DCFA7043CA699553560AE783D2943DE2002A4E84C2695185DF3CF7422906AFF378294E44C20E21D84B5C7781C0C7780EE2A340DA55F6E6A213854A65C21E457A10859B4828CCD455B9101B53B3E518259A58270A9F0C1D9AAB9E35542E245C36B90C12A06B32ECF8C129D4B72104D0DADD3DF08B6DFFAB1695B057C51E9A9DABE4EE715D5CCD00430BC46D2C174742E0F7AA6CD006670D7610BD65071ADB73CC9676EAAEAF458E458C16D9F1CDF1F4D326A4B7CEF35FE738F1973509EA252EC473CE3253E5B90A9FA2D2402470546611AE495FE3142D508A4EE3D47F42F39424D3D7FC7E489465E185EE62F5881757E1ED265D6F52D264BC7A0CB8A7C5D4D0A4AB3F0B44C3F37C7C9BEF195D3481B0E9D38BFAB7E1878D1F2C2ABE2F818BD90A12D482553C46A07D99D24709CBB78AD28DE4395445A8105F6578BBC7AB75408825B7E10CBDE036BC11F87DC44B347FABDF5AAB883477042FF6E3731F2D63B44A0A1A7579F2936078B17AFDE97FD887DAF182BC0000 , N'6.1.0-30225')
213END
214
215IF @CurrentMigration < '201606231413384_Created index for readnewsarticle'
216BEGIN
217 CREATE TABLE [dbo].[ReadNewsArticles] (
218 [Id] [int] NOT NULL IDENTITY,
219 [NewsArticleId] [int] NOT NULL,
220 [ReadDate] [datetime] NOT NULL,
221 [UserId] [nvarchar](256) NOT NULL,
222 CONSTRAINT [PK_dbo.ReadNewsArticles] PRIMARY KEY ([Id])
223 )
224 CREATE UNIQUE INDEX [ReadNewsArticleUniqueIndex] ON [dbo].[ReadNewsArticles]([NewsArticleId], [UserId])
225 DROP TABLE [dbo].[MyReadNews]
226 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
227 VALUES (N'201606231413384_Created index for readnewsarticle', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D5F6FE4B6117F2FD0EF20EC531238DEB3DD04E9C14EE0F39FD4E8D93EDCFA82BE19B444AF8568A58DA4F5D928FAC9FAD08FD4AF5052FF490E4552A2B4DAEBC12F5E911C0E873F0EC92139F3DF7FFFE7F8979755E03CE338F1A3F06476B0FF66E6E0D08D3C3F5C9ECC36E9E3F73FCD7EF9F9CF7F3ABEF0562FCE6F65BE239A8F940C9393D9539AAEDFCEE789FB845728D95FF96E1C25D163BAEF46AB39F2A2F9E19B377F9D1F1CCC31213123B41CE7F8E3264CFD15CE7E909F6751E8E275BA41C175E4E12029BE93944546D5B9412B9CAC918B4F6657611AA3FB1BFC39B95FF829DE3F4729DAFF1047CFBE47B89B39A7818F08570B1C3CCE1C1486518A52C2F3DB4F095EA471142E176BF2010577AF6B4CF23DA220C1455BDED6D9759BF5E690366B5E172C49B99B248D5686040F8E0A39CDF9E29DA43DABE448247941249EBED25667D23C999D7ACFBE4B9ACE57F5F62C88693640D4249B1FEEE705F71C3879AF42090113FDDB73CE3641BA89F1498837A444B0E77CD83C04BEFB77FC7A17FD8EC3937013044D5E09B7248DF9403E913E5EE3387DFD881F8B165C793367CE969BF305AB628D3255EB8E0E67CE0DA91C3D04B8824243128B348AF1AF38C4314AB1F701A5298E434A0367C2146AE7EABA8CA315815D5CD749104806D6CCB9462FEF71B84C9FC8903BFC69E65CFA2FD82BBF147C7C0A7D320E49A134DE6080CFF6BAEFA26DD57CB1F649CD44A590519D1241A925DE4EEF2CC654FA251132DEF11DD11DC674AE928F1879EF087E5CEC13F64A82EFA228C02854D3BB41CFFE320386A49F67CE471C641992277F9DEBA062B4DCD779E87F1FA3A01A8155D2FD22DAC47444DE4570FA1D8A9738D5E72BC7401B57650E81A73C41C651910AF1733CAF154DBBFA59AF890EC8F8CA7930D7432C859D5748230E512297A0A5DAC31F7ED4AA56A316A2041EFD78558F5FEDE1C651FB8092E473147B7F43C9530BEBE45F0BAC2FB0BB89095E17295AAD07AFEDC35314E29BCDEAA1564A63D465AD6BEE3E4797C82573E545484BF5A6F73E727F8F36E945E85165FF297545DDAF49C00A3BA7AE8B93E49280197B671159B9F69BCFA8AEA2FF59187F9D67AC5C8F27F7B666AE722690CD5CE53C62CA5FFF194CC21937BFE9F27516207F95C0FCB0B3D17D99B5C11898439C63E16CA693FFFB68E9877AAC9659E5ACE63994AC16D94C59A5C4F4382D72CA19CD3228F9CC7399B2B9D83C246EECAF331E417629F166AE7B1E9B600601A3702E08ABDAABAD72CB422965806A5B6F5D579BCAD3647D83D3FDB2F47E4EF7322634C95CFCFBBE4076CFD12E5CAFCB0E75D76547070F8F473FFDF023F28E7EFC0B3EFAE14BDC346E6BDB96751FAD74F0254856D36F28D8D8AEAAD368C87496FDD190919DFE68C8D82CAD677CC78125CACC84BC56FE12CFA6638EE36CECE1C03473ECCAC7D1019D860B9DA1EC8F164A75FA83058632989536A80BEAB7A5FD4B7E2782387E05D4C13AC493D879F3D097BBF4B8434B6323B1DCE889967A6BF32C63CBD29CA40B1B093093E93E42BAA5EDB87D5032D9DF589BC9CA780892525F479D72D455E7257D0F4A2A4223599784F395533725759D065188FBDADC08B167E46725EC9DD3C8ED0C74180BB685EAA330C2EA942EA60EB51D81CFC5EB2A285DB02280994C0D5EBC2ED1B47BE8E856A5D543C66F972326D5B2557DC4942F51ED6A33E71D4A70314EA91C4B9591716BCD2A25002117460B9CE807359EB25CA680229DDA6908F2DC8883B31344F84675C0084FE2EB94A79CF2C6D96D0CBCD0CC4791BDF1C64F32EDA3B2EF72B8D314A36451B61CD61F8F187974E09CC6A9EF7652D91C85AFA351391A1BD2EABB04A5C2A787B4BD2FEB28B7A25616B1C61630FBD6AFDDB07CEDCAC5966D9FAB53D8C2CB9B667FDF17D96A6D2BA60ABA16C862A2694F932472FD8C2BF802567960CDB6F422F41CBDD3EB7A152BDCECBA2608F5E937C217E9FA198FB7DBF01C0738C50EDD40D2ABB26728719127CA9DB4CD33E4AF5A378AABECC65928CBE17742C56424E0989642F4425342C6991FA6E2B0F143D75FA3404B625C69CD61478550D5C3A79CE3350E69E3B444A2C380D4E23DAFEAE27A4825A9E379038966002DAE29E80280BFB330358072972524002D8E274701282BB12D009415C9CE0134DFBEEAF63F675A9A1A3CB96D378CCE7C3D340A3819716D019B8C3C260F4D780F2AEB7BC586B4EE7BD15CA2EA7B552500C004B31D8F7F2BF86A6567047CB5CA5CA77EF888795BF8A2E603ED9E676C0903A18B3131D77564668E7100D5E0601B786A0859A7FAC236B61534D5B65F59F7026731AD7DDA0615C0A8ACAD7CBEE3775BDA6D04CF48642CB61F46D7DC8AF724F4C5D07E2833C68869E3608411D326E4A98F18F8AA807657B3F70606C2137BB7D9607D3B0CB89AEC6C035D4D994F7EFDC8BFFD90EE1A644F181BDD5DBC33D64792F475C9D818923032C6EE0396AB4ECDCD57C7DBC44EF13247D1C9FC43530BB8E15FFE6C09352C1BE3618695A8D644166D152F80695CD6C36D7672C9358A71AC272DD6F9F14D2772298D8042B92426B6A9CDCF49A893025202C7A24DEFFC21F360F09202277EA461C5A15F521C1AF1C8A0C41738651F34CE9CFA748653738256630914474662715EA529E808871F1051E084C4806CF99CB0956C61D736205B5C0E6AA59A0F2A0551EEC69440505C042B08E6779A043AD9C6495194DFB5437444B38882E8F56B790902A2C6DFB0D0E0B04DECA0C81B43AE3106242F641B99DBDFD2F23A41FB70B26A53358E04FDA27D90D8A0058D257ECE6025D1414AE568524B093A1F6B6D197742D64B4ADC6996444A6563AC4BA940A95A488099C9E094A69788589B93444245437A0B4872094D1490C64981C15941A355806A6B1156FBE9004776100165EA5A433E82DD4EDFD66D4F3A4D5B5D836A3E13F5964DE32EAE281089B15661AE5530A930D00ED0FFF09D75B1B96ABBADBEE5B6D10CFDBE6FB5D3DAEF7BC923240DC188DB7D0323A41DD1301B7F95B2EE32EDF02E518009A7CD72A6653B6BF05D6D1BDAA61989B56CB8E6973E57A48D874C3F1AC69F6E0DE7CC3D03341BBABB27B65D65C6D03564A8749DAEDDC1D202A3BC50586D94ABB4E379EE9DB3F8703C97B8F13CBE46EBB51F2E1B6E3D8B2FCE22F7E979F6FDC2DCC1E52AA731771939F3DBFAAAA6348AD11273A9A46AC2E9A51F2729F523FA80E865CF336F256403CD02928D535925BBF317FBB0DC5095F9E9FF05E05A7D9C962603D19E5250BA242D5D518B4C76315C18556241873A5A45018A812BBC6751B0598572D390BC74D310DDA4D266A09653AB8D944D5A72D3A59C12E4A0B249134AD7A75EB9AB6C92AC3EEAD311DD55323D21A48A948FE71C1E049B9A8041C1E0C9425A0BF032D5D71DEE9C89AB03EE5514861900859B45065BF927431A0D4F7D02B1469A3E55D6996293269BA24F91F398D824C9251970D9F48BC830D94CE8444F225138878192123C2132CA4A48D5A70CF8446C9206923BD00678E6D3F4A9026E139B8481647DDA7414E76F3D9A24EBAF9351868089D0A26614EDF4E6BA5183C630DA119ACECD27F386DB3266C2AD3F1BD22A1C9309C48AEF934496D4F26B0559F9514D3F644968C83512E3FC8B5548AD1ECBE434198F5E8CD26FF36826A76786DF09A04466B4B30212C86A6C881198C4B0EAA33C6F6E52919D416FAD13598398C50E144E3ACD3B504D62CAB34771859359A4C1B73AB7D6F99959D7629F03E66B8D6E064B0DB46B6AFA4302F7E51DE9890B462EC96473CEF83A6277E64C9211CDDAE51147B14E980C2EADCF26FCCDFBEE9389D944A28D56B223F4FCECDE5AB61604FC0B35C99CFB5427AEFC10112E87E83795B413FAFFEDE3379A93386DC1B7D3133A585A1CC9436DFBEC2C907604CFEC959E51C1DC43090DB63A12EE5D99F7A09AC43003C46C59BBC3ABA3C655379B3DCFDD91EBD0F12A0A032946D6950FA321D924032C553E7D1834555F7775C7CC9E780A8BEEF2028CC9C2BA2C03AC9E15AB1B7AA42B8E3ED5A3772D04499FA935AA34E1467A9B5B8B1BF9056F193BFCD9B4D899C211359FA58252F1A5FA5D1D5117C7C3EAF093C279719E65E6944020DBF5D724C5AB1C1E8B3F82B3C0C7D4BA5D66B846A1FF889334F7CE343B7C7370C845AD9C4E04C97992788CCF33691849B6CB46702AE553992A3D9F19FA8F12233686CF28769F10149FEE2AF4F0CBC9EC9F59D9B7CED53FEEEBE27BCE6D4CFAFAADF3C6F997E8F8AA672C47239ECAC2563992C778CCBAA55F84478FFC486D46787CF0553C758E5A383AECEBBEEFDB85CD188020D5CC5B5A4DB57BC83FB5FC454A50B8BF92CB6F56E8E55B53D6C0907EBD280261FB6CD1B322425958BE2EB4A421F9A0C1AAD35838445F17D6A4E1F9BAA8A2FA08D954D59625B3CF7BCE55F229F4FFD890843B220D4EE57223CB566C16E0F8766767E21E33DE00F39D101CABD7401703601990EB11E4AA0332762C3E94B5D9F18318FEC91AED6D42BB7BCCA70EE091BE2AD77DF76B1A2F69DB6AA26C45076EF2A263F46CFB89EDFFDD84C18B239FB68B59BCE88D43C57CDE6953D7F4459F49C406A70710A7767023FAABDA55A8001177141D6028D3962AE1C5A5D1DA10DAF802A177BAACA581B03B1637CF2DE14D7669E7DC6D7F401B6D6F7F2072C51DD1F56A73F7F0295F8682E83A8FF3E298EE5CA2C3E9807349EBF1D8CEC2060CA4A1D71DAC3CECF406806B2E3C47674B6BD7C596463B55E3C3A2ED44752CA70744D9F99ABD4D8EF9F0A6767F5A88DD4F7C01BB19DB612C26E0781D70B6D4EE8A690C77EB637A0A6B7BBD626054987E488A8981AD70C1D5EEA0EB4B049BEC41CBC4C106DCB8DD19ACE5570AC77785B865A4492E7E4E0C681A2EA0242E270CDC6EF2DD29776ED43326406F9799DBF0D63F35E7983D233E64BE94785788BB8508F89DCC34803089580DE0B544530C0C32F100FB3A8E11B3280F138790FA76E9844104DD26ED3FD97CD1B01A7BAEEA88AFADCE566AAF7DF6662BD15F70839698B8CBAA46E3C1F0B4148D8693425B7BA86903640B1BA14E60D9EE8E5B37EAC93038295DC137A96906C1D8154C485DD78935ED4A1C93AF58181E0BBB19A164DB0BD62918E0C65EAC76B2BE8DB854E55EAA953782052FA47C9F166F09D94757F26822F9ABB49399F710915ECF8FD9243E7545E2BCD6126BE17380D525EB1B9CC23E78F92A81532EA152204F7BB592900C6D7517871EAD751779DAEB96043A68AB3B1F84AD55E759DA6B86FDFBF2158BAB4EA162310B54319F4B5D75B6BB126ACBBE4215806ECD657254C850253F3DD9890648A142310B54A9E8BD4059351FBC45AC99CF0156CC66D2EA33C1B60175A19049D66C2836CE9683C6B0FEC7DBC32A49A759467949FC2B0A53F88463C458110AA35525AE01ED0BA518CCD643C25811497308C18EF0FA0B043ED6B3100206D2B6A2C39A3651C85428EC34650051D809F6D298CA2A2F69536AB61886A5259C8BC4CD448FE6CA670D99570C9B4D2EE320B43519F6656115EADB100268FDEE1FDBC6B4FF658B4CD871E400CDCE5572FFD035B66680B10562375C8D2521B07BD7665C0A6B0DB610A066071A3B70589A6EEA6EA8458E41181AD197CFF1FCE326A417DDF35FE738F1973509EA082FC42E63A9A9F25C858F516930E2382AB370D7A6AF718A3C9422BAB97A446E4A92A983023F24CAB270B477B17AC0DE5578BB49D79B943419AF1E02E6B534353CB5D59FC5DA61793EBECDF790369A40D8F4E9DB80DBF0DDC60FBC8AEF4BE0A2B68404B568154F2B685FA6F489C5F2B5A27423384795112AC45719E2EEF06A1D1062C96DB840CFB80B6F047EEFF112B9AFF5F37119117547B0623F3EF7D13246ABA4A05197273F0986BDD5CBCFFF03969F953077BD0000 , N'6.1.0-30225')
228END
229
230IF @CurrentMigration < '201606270640337_added foregin key on ReadNewsArticle'
231BEGIN
232 IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'ReadNewsArticleUniqueIndex' AND object_id = object_id(N'[dbo].[ReadNewsArticles]', N'U'))
233 DROP INDEX [ReadNewsArticleUniqueIndex] ON [dbo].[ReadNewsArticles]
234 ALTER TABLE [dbo].[ReadNewsArticles] ALTER COLUMN [UserId] [nvarchar](128) NOT NULL
235 CREATE UNIQUE INDEX [ReadNewsArticleUniqueIndex] ON [dbo].[ReadNewsArticles]([NewsArticleId], [UserId])
236 ALTER TABLE [dbo].[ReadNewsArticles] ADD CONSTRAINT [FK_dbo.ReadNewsArticles_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id])
237 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
238 VALUES (N'201606270640337_added foregin key on ReadNewsArticle', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1D5D6FE4B6F1BD40FF83B04F49E078CF7613A4073B81CF1FADD1B37DB8F5057D3368895E0BD14A1B49EBD828FACBFAD09FD4BF5052DF22875F12A5D51A07BF784572381C0E67C81972E67FFFF9EFF12F2FABC079C671E247E1C9EC60FFDDCCC1A11B797EB83C996DD2C7EF7F9AFDF2F39FFF747CE1AD5E9C5FCB7A47B41E69192627B3A7345DBF9FCF13F709AF50B2BFF2DD384AA2C774DF8D5673E445F3C377EFFE3A3F3898630262466039CEF1E74D98FA2B9CFD203FCFA2D0C5EB748382EBC8C341527C27258B0CAA738356385923179FCCAEC23446F737F88FE47EE1A778FF1CA568FF531C3DFB1EC16EE69C063E22582D70F03873501846294A09CEEFBF247891C651B85CACC90714DCBDAE31A9F78882041763795F57D71DD6BB433AAC79DDB004E56E92345A19023C382AE834679B77A2F6ACA223A1E405A178FA4A479D51F36476EA3DFB2E193ADBD5FBB320A6D50052936A7EB89F37DC73E0E2BD8A4B0833D1BF3DE76C13A49B189F8478435A047BCEA7CD43E0BBFFC0AF77D16F383C093741D0C495604BCA5A1FC82732C76B1CA7AF9FF16331822B6FE6CCDBEDE66CC3AA59A34D35BAA3C39973433A470F01AE58A14189451AC5F86F38C4314AB1F709A5298E430A0367C4E47A67FABA8CA31561BBB8EE937020595833E71ABD7CC4E1327D224BEEF0A79973E9BF60AFFC52E0F125F4C93A248DD27883013CE57DDF45DBEAF962ED939E894821AB3A258452535C0EEF2CC694FA2510B2DEF11D911DC670AE92CF18791F08FFB8D827E895003F44518051A88677839EFD65C61882799E399F719055489EFC752E838AD5725FD7A1FF7D8E826A055645F78B6813D3157917C1E577285EE2541FAF9C0764589535389CF2021146452984CFF1BC163472F1B35E131990E195E3602E87DA10765E208DB844095D0249B7873FFCA8D5AD462F44083CFAF1AA5EBFDACB8D81F60925C91F51ECFD1D254F12D4C9BF16505F607713137E5DA468B51EBCB74F4F51886F36AB875A288DD197B5A9B9FB23BA442ED19517216DD51BDEC7C8FD2DDAA417A14785FD97D4E565BF26002BE89CBA2E4E924BC2CCD83B8BC8CEB59F3EA3B28AFE6761FD75D658B91C4FEE6D69AE5213883457A9474CF1EBAFC1049831FA4D17AFB300F9AB04C6A7AD8DEECBAA0DC4C01ABC8E85AB992AFF8FD1D20FF5502DAB8A51CD6B28512DAA99A24AF765546B9FC6A9EF0618469AA974CF4E3B54CECD3E58C9940928283DC21635C574CD2A28C99AD732A5EA62F390B8B1BFCE7004D1A5C09BB5389A821538A2C2B520AA6A6F0ECB13168594F1BF6C7B785D9D814F93F50D4EF7CBD6FB39DCCB98C0245B87DFF639B07B8E76E37A1B79A8BB8D3C3A78783CFAE9871F9177F4E35FF0D10F6FF18CBBAD5366367DB4D3C1774C594FBFA26063BBAB4EAB2113B1F657430676FAAB2143B334F6B11307B6282B13F05AF54B7E365D730C66632F87D630C7EE7C1C19A0BD5C1825DFC1B2C040D879CBC2F06AA041ADBEF63E4A7C7AD0EB6DF01B4D3509B760C2C34BA7CD2CBB4D94EE787B2B1ADA877D3D43A14E5FCDC04A00AC4A07D465716E6BDF54E23B1159CD9E1D3A086B16C457693DD94DFB1D5A1A6B07B177032DF54EB55945C9A1969473B215AC647A02178AFF8E076F2592FD3540462BE325485A7D5D75CA55573946FBEE902A402399913947EAA99B92BE4E8328C47D8DEB04D833F2B316F61CB2620B1D5DC69C55AEFAC8ADB0BAC4D8A6495AA92D706C2D565641E5BC5113AA646AD4646589A6C55047B62AED85227CBBF89255DB56B52F39DFA2DA9566CE0794E0629D523A962223C3D69A3D9763849C181276A21FD4FC94D532652832A99D96208B0DBF38BB1905984175B10A3020BEAA3CA5CA1BE7B431F046335F45F6D61B778E97AECABEDBE14E2A4689A2683B6C6C6AB06F66D80D13C3AE5C15DAF64D05BA5980F54873BEEF8B6A355BF3A51C5303554C58FA344922D7CFB082AFB4955700DA23BD083D47EF3E40BD5DE0EECA5D130EF5E937821799FA19CB6FB7E1390E708A1DBA53A7978FCF50E2228FA73B199B67885FA5A0F9ED4CC35DDBC6F03BAE63B212704C5B217A452C21EBCC0F537ED9F8A1EBAF51A04531A6B5E6B2A344A8FA614BCEF11A8774705A24D14140685A9C577D3133A4A2D4F1BCC189660C5A5CFCD06500F616C8D41894B97E2260D0C2833A0A83B629B605066D9364F20C0AFA4544D32F7792D493CFF9035553AFE802E02F25FF5BE12E193623F0968CDE93E72CF86A96AE6461AC4353137CCCC919967BF94E7B14B1D722D716A45E8B1E93674DF818291449F2336543EC71160F03B927371481FC0FF1972DC12743670CC927A3B94EFFB097785BFC452D00DA33DF32070CC45D2D2B71DD4766A91887A11A186C839F1A44D6E9BE306F6D859B6AF3AD687A01778A744E65AC02D885B585CF77EC395E7B8CA09B4384A2DC9F5C63CB5F75D02783DCAF32C68A916130C28A911179EA2B06F6F66B4FB5E85863959FB67BB091A2B30DEEDAADA30DF34E4B786A103D376E4C771113409F93842FC1C6E6210122639C3E60BAEAF4DC8C10B04DDE295ED12926997D146E816FD8577A5BE29A361AE3F14C9BA25A8A2CDA2ABF004E17D10CCB3C30829B10E3584F247E9FF14D27622A8DC085624A4CEC509B7BE0684011D202C7BC4DEFFC218B36F29202BE6432B0C29D9C14EE48963328F0054EDB8F8F674EEDF763C41C27D5DA000A6724DF9C15690A389C5B0D020AF8DE0CC0964F7FA5600B8F8902ECF56B692006C0713678031C8BCB425214F315AA00CADCA0E200F23B6A05C0FC8E1307273B85299AB2260090689C8D4503A88C5220951A4BAEB10604AFD91B95E5EFDE5999A0EDF6AEC654AD234EBE68BBA81BB0A0B5C4EA8C36253A50A95C4D6A2A419E57E9C818DF6B2F2A317E520195CAC1F4A612FCD889A791DAF9D7B622CADC7F8D3135E592844852579F8ADC1678A758BB6AD6018C6F06BEAB5E8CD3B6C409F8A618487FB6816FD7017CA3F69F1878501AA30264B48C81A43E1306EC2004CAF48E067D386BA6BE07C01E759A16CC06D45CA5F6A64DE392314F1081095B61C45620A9305B0F30FFF0657C7EB86A6BB6BE3DBB310CFDB9975AAFEDCFBDE075950661141A476E9AB5439AC1D50E1BD4095038327BA29645B18177759892A919810D71B8E19751A38483870C621A26B16E03678C60030C1BBA2BCB8F5D65DCD135EFA8649DAE35C6D206A3BCC05B990FAAB2E3791E5FB8F8703C1704223EBE46EBB51F2E1B81898B2FCE228F4A7CF6FDC23C44EF2A8731775B74668D1D554F6914A325664A49D704D34B3F4E521A09F901D1CBD567DE8AAB061A4B04C7C9B2CBB63D849FC3F29859D6A7FF170C278DD25C1A52782B5301E9928C7445ED54D9FB136E55F10D1D1A2A1A052806AECC9F45C166158A0D66E2D64DF37C138ACC6C2F86569B6E9BB0C4065D312428C46E132654AE0FBD0AB8DB04597DD487C307DC6DCD0457CA433E9E33FCC0591A391EE4CCC06D96D6627891E8EBCEEE8CE1AF03DFAB200CB3008A40B12DDECA3F19C268C41AE58035CAF4A1B6C3C13661B64BF42132315F9B209922032C9B915D5B48360B3AC1135014AE6120A4B858AE2D61C595EA4306A2BA364103C51D600338B365FA5081C0AF4DC040B13E6CBA8AF3B7554D90F5D7C90843C0706A5132F2DE0B73D9A8016318E908A9737365DE8864D852B8F567435845AC420E58F17D929C25B4875BE1ACDC81D58FB30430C412A9150FB02D90A4410CC5305B41FE5A425F16E4500CCF8C7FB7C4250DF3BD45EE60FD91E6BCA184308CCC6102ED35013145FA30EB887B4D70F5D737C651BC2D6120B103F9210CA50E0C62588554DEEB683183E0AEC7D626B16D62B53881DC2500F309548398F27EA4B82ADDDAF6C3B7A7B736F999A3C0E29C030E118D69065B0D740E6F860E032D3D1DE1F14710A6C8C4DCD30A0BD6B6F5B48A8C60D6D1C1188875C164F8D2BA36615FB8745726668A449B5BCFA2D0F3B3FBA1D9E90208C5D50473EE5399B8F24344B01C62DE54D44EE8FFB78FDF682A713A826FA747747863C8ADE4A10C097636483BC2CFEDAB73A332730F2134D8EE88BB92D8E1E0A40431CC0231DBD6EEC2EEA8EDF1E4B648E50518936D50D906D8EB28741175E9F2B4528502D09A67E1E3BD469726D808EFB86B6123BEF62E4287F54DF393C9B9A8D92A152B155FAADF958BBA700FAB13E872FEE2BCCACC2919811CAE5E9314AF72F658FC1E9C053EA6D6EDB2C2350AFD479CA47934B4D9E1BB834326EFEE7472E0CE93C46B85561426C26D4FD90841DC7C4A53658045C3786D7CCED9F019C5EE1382326C5E851E7E3999FD2B6BFBDEB9FAE77DDD7CCFB98DC95CBF77DE39FFE603CDF5CC466B8453D9D82A46E22CB5D9B4F4CB51EB911FA9CD1CB50FBE0AA7CE79574767FB7AEEFB4E61338B2908358B4E5843ED9EB4544D7F1E1294B0B4C4F29B157AF9D614353029692F8840E2515BF0AC90509458B40B2C61525168B1EA0C164E32DA05356182D12EA2A876219B8ADAB265F679CFB94ABE84FEEF1B527047A8C1885C6665F511480AF7EDCE6AE21E1A6F007DC7E5CBEBB5D0F99C7806E07AE4BDEBC0193B9632CE9A76FCC46784B3067B9BACDD390DDCDB902A60A2B5AC2715F1197AE4C2BD90F5C56C1C4052BF67FAB6CE7BE1AE4CA631CE438576B3C8857267EE44D3916D5B5995A3E8804DDE740CF922F7F2EEAC80E9CA092C39865977C019A199EA414B10EA606A2E098D526CBD0D5601125A2926A0B77601535FE99CFDBB67B6EA72A203B25A5934E148B207ED92FDA6DB29950EDADE2995C78A71EBF51A73F7EC446F434074D5E32C39A6AB4B74301D569748DD727A9C23F2AFD9DB5E9A1396DAFD69A3F64EEE0DEC236DA78D9940387A2004953C40D51841E8C78C9F267BBD62709C9B7E0A9889315B11984C1EB6EC2D329BE841CBC498CD289D4B2F5663275518D7A95F66985DE115F5F39689714AAFF42C13934AF9554169A0C2B7C2671AAF5D26C6681AC1C204C1490CC2D64AA41117D2511AEF71F090B3DBC87631B5E0B23D33A66451B7D8E89FBBC511F0FB976930C224729D8017584D796010C50358001844CCB2A44C9C85D4F79027CC44D0BDE3FECAE64DB3D5D8BAAA237F6D555BA9E33BDAD3569CD3B35F469A298B1A8D87C0D312341AE12C873F6E4F8141B67010EAC42CDB3D71EB660D1A864FCA540A4D689A496476852784410EF99E76250FD0575E189E177633C3CFB637AC5330C08DBD59ED647D1B71ABCABC692CEF8E73F16AD9392D5E9DB64493241B4FFE7EF164E63D4464D67387AC20FA320F9C955A7C2F6C0DB0BB647D8353385A33DB25E00FE53A05EAC8BB15A43491F55DB8C7A47D1775E47D0B1285B07D73CE16AE67AE06D42F53C96CCCF9E2970E39AF221F71F1485AD131BFDBE53AE6AB401DB3B5D45D67A73AAEB7EC2BD40118785F4447050D55F4D3A31D6FF8E4B985AB02B20B170D4183769C6D0322255749D43D940E6ACB4997DA91EAE569C9846AB625BC04913839153EE11C4B5688D292AA822092FD8932504A255B0411887A306EA27D0E29248CF54C4A56F8A3294FE0687F16B803F4715AC89C04A9003E2A8F943304721D8E0C330029ECE4486AE8D72A14DC9486CD672F926441124467E9315CB10A150593B139E4327D886CC8700818ABACBE0D2280AE80FE29A14CE75FB4F385A3630E306C913ED430910FA201C62688DD2C4F9688D03EC837D3B9581BB085BC4E3B30D881B339751377436D720CB237F121B08EE79F37217D7D9CFF3AC789BFAC41D0687F21765B66ABAACE55F81895D63306A3B20AF3DAE01AA7C84329A23BDB47E4A6A498C6F5F043222C8B688217AB07EC5D85B79B74BD49C990F1EA21680519A0563859FF598AAA36CEC7B7F9C1D6C610089A3E7DB07D1B7ED8F88157E17D09BC6F1080A0E6BDE209119DCB943E255ABE56906EB808B0224005F92AABE41D5EAD03022CB90D17E81977C18DB0DF47BC44EE6B1D754104443D116DB21F9FFB6819A35552C0A8DB939F8487BDD5CBCFFF079E5FC9A770C50000 , N'6.1.0-30225')
239END
240
241IF @CurrentMigration < '201606280641088_changed advice to notification'
242BEGIN
243 EXECUTE sp_rename @objname = N'dbo.Advices', @newname = N'Notifications', @objtype = N'OBJECT'
244 IF object_id('[PK_dbo.Advices]') IS NOT NULL BEGIN
245 EXECUTE sp_rename @objname = N'[PK_dbo.Advices]', @newname = N'PK_dbo.Notifications', @objtype = N'OBJECT'
246 END
247 IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_FromUserId' AND object_id = object_id(N'[dbo].[Notifications]', N'U'))
248 DROP INDEX [IX_FromUserId] ON [dbo].[Notifications]
249 ALTER TABLE [dbo].[Notifications] ADD [NotificationType] [tinyint] NOT NULL DEFAULT 0
250 ALTER TABLE [dbo].[Notifications] ALTER COLUMN [FromUserId] [nvarchar](128) NULL
251 CREATE INDEX [IX_FromUserId] ON [dbo].[Notifications]([FromUserId])
252 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
253 VALUES (N'201606280641088_changed advice to notification', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1D5D6FE4B6F1BD40FF83B04F49E178FD9104E9C14EE0B3CFADD1B37DB8F5057D3364895E0BD14A1B49EBD828FACBFAD09FD4BF5052DF24875F12A5D51A07BFAC4572381C0E67C81972E67FFFF9EFC92F2FABD07946491AC4D1E9EC70FF60E6A0C88BFD205A9ECE36D9E3773FCD7EF9F9CF7F3AF9E0AF5E9C5FAB7AC7A41E6E19A5A7B3A72C5BBF9BCF53EF09ADDC747F1578499CC68FD9BE17AFE6AE1FCF8F0E0EFE3A3F3C9C230C62866139CEC9E74D94052B94FF83FF3D8F230FADB38D1B5EC73E0AD3F23B2E59E4509D1B7785D2B5EBA1D3D9559425EEFD0DFA23BD5F0419DABF703377FF53123F073EC66EE69C85818BB15AA0F071E6B85114676E86717EF725458B2C89A3E5628D3FB8E1DDEB1AE17A8F6E98A2722CEF9AEABAC33A3822C39A370D2B50DE26CDE29521C0C3E3924E73B679276ACF6A3A624A7EC014CF5EC9A8736A9ECE6EE22C780CBC123CDBE1BBF33021950182E36A41B4DF6EBEE7C095F66A8EC18C45FEF69CF34D986D12741AA10D6E11EE399F360F61E0FD03BDDEC5BFA1E834DA84611B6F8C392EA33EE04F78BED728C95E3FA3C7723457FECC99D3EDE66CC3BA59AB4D3DC6E3A39973833B771F4254B3458B1E8B2C4ED0DF5084123743FE2737CB5012111828272CD73BD3D7798248BBAA43CCB5E80EAF00A04F399C0FEB2045095EB078CD64B86BF518E4F0DAD348E054D0C8FAD9E70B0DA15FA59F91EBBFC7F3E4A100235D417F1FC721722363789749BCC20B3969468DD734165533E7DA7DF988A265F68485D8D14F33E73278417EF5A584FD250AB064C38DB264A3ECEA2EB6D6916A9037EE73B0CC892C18EECCF98CC2BC42FA14AC81C9B96F6A925F9FE39099DABAC2FD22DE241E99E65856EBCE4D9628D3C7B4A0961ACFAA9E00CBA2588E635907C2F064DE4839A9EC3B5BAFC3125E818FB1F86320ECBC041C90BD590986E9124ABA3DFAE1470BCB37EF05CBC8C720593562B7ABDCF9E4A6E91F71E2FFDD4D9F24A8E39F16505F206F93607E5D64EE6A3D786F9F9EE208DD6C560F8D741EA32F6B5373F7477CE97A58397F8848ABDEF03EC6DE6FF126FB10F944477FC93C5E656B02B082CE99E7A134BDC4CC8CFCF3186F9BFBA97B22ABC82F0BEBAFB3563BF39F033CA8FB21B45BA515E4DAADD22FA618DBD572525C194DA88BE979E806AB14C490D158F755D50649B806A78D05D54CB70C1FE36510E9A15A5515A35AD450A25A563345956C6289663F4BB2C00B118C3453E99E6501A89CE301B092291310507A842D6B8AE99A575092B5A8654AD5C5E621F592609DE308A24B80B76B7134052B7044856B4154D5DE4056C73E0229E77FD916F2BA3EA49FA5EB1B94ED57ADF70BB897098689B717BFED7360F71CEDC6CD56F34877AB797CF8F078FCD30F3FBAFEF18FDFA3E31FDEE2C17BB4531C2489A913F550BBAABCA75FDD7063BBAB4EAB2117B1F657430E76FAAB2147B3B246B21307B6A82A63F05AF52B7E365D730C66632F076A9863773E8E0CD05E2E8C92EF607D6020ECBCF5617835D0A2565F9329213E390CF6B6E56EDFC0283CCE74DACCB2DB44E98EB7B7A2217DD8D73304EAF4D50CAC04C0AA64405D16E7B6F64D15BE1391D5ECD9A183B066417C95D693DDB4DFB94B63ED20F689B84BBD536D5E5172A8C5E59C6C052B999EC085E2BFE3C15B89647F0D90D3CA7809E2565F579D72D5D5BEE5BE3BA41AD048A666CEEB7CE665B8AFB3308E505F033C06F6EC06790B63501D2C7464197356B9FA23B7C29A12639B266EA5B6C0B1B558590595F3464DA892A9519395259A16431DD9AAB4178AF0EDE26F566D5BD5FEE6628B6A579A39EFDD14B56E7E542223C7D69A3D97638482181276221FD4FC94D73265283CA99D96208B0DBF38BB1905984175B10A3020BEAA3CA5CA1BE7B431F046B35845F6D61B778E97AECABEDBE14E2A4689A2683B6C6C6AB06F66D80D13C3AE5C27DAF66D06B25980F5487BBEEFCB6A0D5BF3A51C530355CC587AB312DCF72DFC5257E9658895603D64638553DCD6E6AE895ADF9C7C897C9484AF786ECB0DF86BC6EE4AAE11B955D4187BCBEBB19771928B93DC3D8679F0809B58AAE197B54FD408659C2F9B1E299A9EC7AB15EEF036821A1F2B1A17174CEAEADF1FF0335CCC65FBE3599AC65E90531DBED6585DF1A03BFE10F98EDE7D8F663BC8DD97BCC6F316906F98EF305967AC3CB98D2E508832E4909318B9FD7EEEA69EEBF3EB0A8FCC37C4AFDE80F1DBD5963B9EC6F02F5CC758D2A184B472C935C114735F1065BC580C222F58BBA116C598D69A629510A1EE872DB9406B1491C16991440701A1E9785EF7C5CC908A5227F316279A316879B1479701D85B3E536350E67A9180414B0FF9280C4A536C0B0C4A9364F20C0AFABD44D32F77823593CFF97B5553AFE802E02F25FF5BE12E193623F0968CDE93E72CF8EA9DAE6461AC7F53137C8C6504967BC5496A14B147916B0B528FA2C7E459133613084592DC66D0127B9C45CB40EEC90D8120FF43FC654BF0C9D01943F2C968AED33F7C0B605BFC458E64DA334F997B06E22ECA0BD0F4911F1DC761A81606DBE0A7169175BA2FCD975BE1A6C63C2F9A5EC05D269D5319AB00767F6DE1F317F614AF3D46D08D2542517E5FA0C196BFCAA24F06B9DF6C8C1523C36084152323F2D4570C7C9B437BAA45C71AABFCB4DD838D149D6D70D74E1D6DE0B77AA2A9573C4B87A30F98F096E265A0366F1DECEF5B622F294623B09794E43AFDB7E32E6C9FC5CAE7955AF3CF4614B0CC5EEC53CEB105970499B1F98AA6B4964E8CB7CA53807F4E34E732679DE0D2CC388618898B707C2B8C984A23F0A29812133B1F17CE5AE29FC42D1A0F60232E2E1E72E7E54B067864F1C04AA76C5A7AAE59CE20C01728A35FAECF9CC6450C8A3F4EDAD1604AEF35078413720A389C9F0E020A38F30CC0566FC5A5604B178C02ECF56B657106C071467D031CCBDB6552148B75AA00CA5CB9E300F25B7405C0E2521C07273FD6299AB2360590689CD14603A88C5220955A0BAFB51204E10F5A95E5811258C9A0ED47AFC754AF234ECA68FBBC5BB0A0B5C46A0E9A121DA854AD2635952057AE74648C33B7179518C7AB804AD5607A53097E1DC7D348ED4DA4CD92327F626B4C6DB9242192D477A822B705DE29D7AE9A75006B9E8133AC17E3D0A63D01DF9403E9CF36F0754C806FD40E1903974C6B54808C963190D409C3801D8440B9DED1A00F671ED57729D8A34EDB24DA825AA8D4DEB469DD4AE70922B0892BACE20A241576F001E61F7EBDC10F576D1ED73790B786A13FF75273B8FDB9173CC7D3208C42E3C86DBD764833B4DA11440AE389A361A6343054B646521FB22464911B2587264B15904C4114C8B0A66D5AEB4310C68C360039A0CBD83C355426215DA3904A36EADA702C6D48AA1BE2B5D1A12E3B991711B6CB0F27734128EE936B77BD0EA2652B3477F9C5591471B9CFBF5B9807A95E1530E61E4567D64452F794C589BB444C29B97AEDA3CB204933120BFCC12557D9CFFD15570D34B1088E9F5597B415859FC3EA585AD527BF4B8693C629A7CD2FBC85AA847789C74B6E95E743472D6E90377748E074377413E07DC6791C6E5691D8E4266E5D87B06E83A83FEAC3814258B74142E5FAD0F9670E6DD87CA93E643E9835454BAE541F72DBBDD2862973BB88A13566F5362CB1B19D2C7B86DF382B28C7E99C899A5E385ACB4A24603B2F2AD61C69BEAE941086595A654C646A15149F0C61B4C2EA72C05A65FA50E9C8C76D9874893E4426BC711B24536480653B88318564BBA0133C0145E11A068B940B5B4C2D56AE541F3210C0B80D1A28EE001BC0992DD3870AC4386E03068AF56193555C3C116C836CBE4E461802E65C8B9291F7A998CB460D18C34847489D99ABC556404E6A03D37C36845586DCE48095DF27C959422BBD15CE2ADC6AFD384B00432C91A8B096B44092C6E214C3A4625552425F16AB530CCF8C7FB7C4252DA78245EE60BDA4E6BCA184308CCC61E245526708BA481F661338B20DAEF9FAC6388AB7580C247620EF88A1D481410CAB90AA3B27143308EEA16C6D1269C3AFC509E4AE26984FA01AC494F723E58D706ADB0F5F12DFDAE4E7EE0B8B730EB86934A6196C35D039BC1D010FB4497584C71F41982213331415DD8EB641514546309B20770CC4A660327C695D9BB00F79BA2B133345A2CDADE771E407F9DDD5324408F7F4A80DE62220327115442EC672887953513B25BF6F1FBFD154E26404DF4E8FE8F0C6905BC9431912EC6C9076849FE90B7DA332730F2134D8EE88BB28D9E1E0A40431CC0231DBD6EEC2EE88F6AB725BA4EA5A8EC936A86A03EC7514BA88388E795AA9221E68CDB3F08D62AB4B136C84F7EFB5B0115FC917A1C37AC0F9C9E41CE16C959A95CA2FF5FFB523BC7442AB1355735EE9A2CACCA918011FAE5ED30CAD0AF658FC1E9E870122D6EDAAC2B51B058F28CD8A5068B3A383C32326BFF574724DCFD3D4A722842A124ED313374244C2805056192DD434C9139DD599048FCBEC6675CED1B694D3191F0D5EBBC01365717E08CC61F1199CA36737F19E5C2809EF55E4A397D3D9BFF2B6EF9CAB7FDE37CDF79CDB04AF9177CE81F36F3ECE648355975CCF4628558D7511EA938D42EA9E1E63153594311A20C0F1ED2CC020D43C72A7D93CC2497FBBB02994F0B7C2F29B95FBF2AD296A6052DF5E1081C4BDB6E05921A128316F1758C2A4BC90C4D5192C9CA4B70B6AC204BD5D246DE39736154455CBFCF39E73957E8982DF37B8E00E53831148CCCAEA2390143EE19D55EC3DF4416F6D006C33D85C92BD163A9F2FD2005C8F9C901D3863C7D2295AD38E9FF86C89D6606F93B53BA7487C1B52054C4298F7A4223E438F42B897B2BE9C8D4348EAF74C6DD8F940D395C934C679A4D06E16B950EE219E68AABE6D2BAB6A141DB0299A8E215FE4AEE39D15305D398125C730EB0E3823B4D3A06809421D4CCD25A151FAB9B7C12A40B237C504F4D62E605A389DB37FF7AC6F5D4E7440C63735986E796576D77ED3ED944A066DEF94CA63C5F80A7B8DB97BE6AEB72120BAEA71961CD3D5253A980EAB4BA4BE3E3DCE1139EDEC6D2FCD094BACE2A411BD937B03FB48DB29772610CA1F88B6258FC5354600FF3103C6C99EC4181CE7A69F3E6762CC56C6609347687B8BCC267A25333166334A85D38BD5D8491586B0EA975567577845FD6666629CD22BB5CDC4A45271FF501A93F1ADF099C6139A89319A465C34415C158338BD1269C445AF9486B61C3CC6EE3632854C2D9A6ECF6C3379803136D0E96E7104FCA8661A8C30893C31E0AD58531E1844F10016000611B30C33136721F5E5E60933117499B9BFB279D36C35B6AEEAC85F5BD556EA5096F6B415E7F4EC97CD67CAA246E375F1B4048D46E4CEE18FDB5360902D1C843A31CB560F426619977A700B9803090EE2D923B9CEAE308A226823DFDF4EE54D1A48A87CE511797FBB990569DB7BDC29D8ECC6DEDF7632D88DB8BB65DE5656D7CDB9E8BCEC9C96AF5F0191A5CC5B54BCA93C9DF90F31E680C29FDBAEC1474966BBE3241BD7235703EAF42C5DDFA00C8E56CD76093855B94E813AF26E052960647D973E3669DF651D79DF82C42A6CDF9CC786EB99AB01F5CB54321B73210EA4432EAAC8475C3EDF5674CC6F99B98EF92A50C76C2D75D7F9D190EB2DFF0A7500262A10D151414315FDF468C75B4F796EE1AA80ECC2C569D0A01D67208148C95512750FA5CFDA72922A3A5EBF3C8D9B50F152C24B10239453EA13CE4965852894541584B7EC4F94815250D9228840D483111DED73482961AC679EB2C21F6D7902C721B4C01DA0A3D442A6294805F0F182A49C2190EB70CC9A01486127A7544BBFD641EAA6346C3EDB93246B94206E4C8FE18A55A828CC8DCD2157E95364438683D35865F56D1001F427F44FA1653AFFA29D2F1CB77380618BF4A1869D7D100D30364106CB8A658B20D0319F4F6D639910B6F260ED1A1106CE7ED54D3C0EB52932C876C507F33A997FDE44E4C973F1DF054A83650382C42D8C904719BEEA3A57D1635CD9DF188CAA2ACC13876B94B9BE9BB96427FCE87A192E26C14482080BD7322EE287D503F2AFA2DB4DB6DE6478C868F51052910D881D4FD67F9ED28BC6F9E4B63808DB1802463320AFC46FA3F79B20F46BBC2F8147150210C44058BE5B22739991F74BCBD71AD20D17CB5604A8245F6DD7BC43AB758881A5B7D1C27D465D70C3ECF7112D5DEFB509F52002A29E089AEC271781BB4CDC555AC268DAE37F310FFBAB979FFF0FD8BEB74AA2C90000 , N'6.1.0-30225')
254END
255
256IF @CurrentMigration < '201608161441174_RoleSubscriptionViewModel HasActiveNotification'
257BEGIN
258 ALTER TABLE [dbo].[UserSubscriptions] ADD [HasActiveNotification] [bit] NOT NULL DEFAULT 0
259 ALTER TABLE [dbo].[RoleSubscriptions] ADD [HasActiveNotification] [bit] NOT NULL DEFAULT 0
260 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
261 VALUES (N'201608161441174_RoleSubscriptionViewModel HasActiveNotification', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5DCD6EE43612BE2FB0EF20F42909266E8F9D04D9819DC0F18C37C68EEDC1B427D89B21B7E81E216AA923A91D1B8B7DB23DEC23ED2B2CA95FFE14FF244AAD360673F1B4C862B1F8B148569155FFFBCF7F4F7E7E5A47DE234AB330894F67AF0F0E671E8A974910C6ABD3D9367FF8F6C7D9CF3FFDF52F27EF82F593F75B5DEE9894C335E3EC74F639CF376FE6F36CF919ADFDEC601D2ED3244B1EF28365B29EFB41323F3A3CFCDBFCF5EB39C224669896E79D7CDCC679B846C57FF07FCF93788936F9D68FAE92004559F53BFEB228A87AD7FE1A651B7F894E6797719EFA77D7E8CFEC6E11E6E8E0AD9FFB071FD2E4310C307733EF2C0A7DCCD502450F33CF8FE324F773CCF39B4F195AE46912AF161BFC831FDD3E6F102EF7E04719AAFAF2A62D6EDAADC323D2AD795BB126B5DC6679B2B624F8FAB892D39CAFDE49DAB3468E5892EFB0C4F367D2EB429AA7B3EB240F1FC265459E6FF0CD799492C280C071B1303EA0ABBFF2E042AF1AC46060917FAFBCF36D946F53741AA32DAE11BDF23E6CEFA370F90FF47C9BFC8EE2D3781B4534DF9873FC8DF901FF84C77B83D2FCF9237AA87A7319CCBC395B6FCE576CAA51759A3E1E1FCDBC6BDCB87F1FA10616943C167992A2BFA318A57E8E820F7E9EA3342634502158A175AEADF314917A758318B5E816CF00A04D359D779B3043299EB078CEE4B8697D1FD4F4E86124746A6A64FE1C881F2DA95F661F911FFC82C7698942CC744DFD972489901F5BD3BB4893359EC869DB6B3CA7B1AA9A7957FED37B14AFF2CF58891DFD38F32EC22714D4BF54B43FC521D66CB8529E6EB54DDD26CE1AD275F2DA7F0C57859025DD9D791F515414C83E871B6070EEDA92E4AF8F49C40D6D53E06E916CD32519E64455EAD64F572837E7B494969ECFBA9C84CBF2B39AC7AA0CC4E1C9BCD5724ADD77B6D94415BD921F6BF5C751D87B0D3820BC790D86E512299A3DFAFE0707D3B76805EBC887305DB76AB7ABDEF9E067D99F491AFCEA679F15ACE33F1DB0BE40CB6D8AF1BAC8FDF566F0D63E7C4E6274BD5DDFB7DA798CB69C0DCDED9FC985BFC48BF3BB98D4EA4DEF7DB2FC3DD9E6EFE280ACD19FF2A5B8641B1270C2CED97289B2EC02831905E709DE36F75BEE89AE227F39987F9D57B5B3E031C49DBA1B6275AB5705F5EA56AF2FB61CBB5DE594BC722BA129A7E7911FAE3390436EC5BAAB8BB64CC22584D55852CC76CBF03E5985B119AB755139AB65092DAB55315B56C92696ACEC67691E2E230433CD15BAE321007D17300016B20501216526D8AAA45CAE4501AD58CB52B6525D6CEFB3651A6E0A1E41760971BA942053B0802054B8142455E30D647DEC23940AFCABB69057CD21FD2CDB5CA3FCA0AE7D50D2BD48314DBCBDF8FD4020FBCA33AEDC6E358F4CB79AC7AFEF1F8E7FFCFE073F38FEE13B74FCFD4B3C788F768A83343173A21E6A5755B4F49B1F6D5D37D56936142AD6FD6C28C84E7F36146CD6D6487EE0C01A75614CDEA87C8D67DB39C77136F67460BA3976E3E3E800E3E9C22DF21DAC0F1C85BDB73E0CBF0C50D2EA6B3225C22787C1DEB6DCDD1B18A5C7994E9B597E9BA8DCF1F65E68481BEED7194275FACB0CBC0880454987BA4CCE5DED9B6A7E27A2ABF9B3430765CD93F8A2ADB5DAFA573F3B5BE6E123629D94FD4C69BB42F4ADBFB25E72E48E167F6576542E0A2A4ECAF8BBA0B0C142B6C77AE99AD2F134AF65B2FFB252C8CA7A5EE35A5FA6B2762A370EEBBEDBAE86D048F66BC1954D3452BC3A8B9218F5554598D8A31F1635AC497530FB91692C98FA9A1F8519D67EB13694E25A7AB31E5F8AD755D077D1520A15B2B594F2BAC4D00C69A25BB5464819BF5D9CD8BABDB0DE895DEE7BDD6A33EF173F43D475925A6514DC3A33120B402885A18013F9418FA7A2942DA0F0A0769A823C37E2E4EC6669E03AD5C5D4C091F8B2E4ED66F73ACEB968E0DD6B3935DD4D62C1E2A09CEA7DF7D89DD62D2D8BB23DB6B551C4BD41643F8C21FB72F169D7F72EC80E045E9CE8F1BEAB8AB5B016BF0AA0068AD8417ABB96DC4C2E3D6897D9458457D6A6CBD6AB5879AF5CB8D0EA7CC7F3290E501A3DE3B1ADB4FD73CE6F75AE10B9FFD49AA5AB8BBC17495AA893C291873178280C2C53F1D326206B13E346A8AA1E69AA9E27EB356EF026862A1F6B2A9757619AE2DF1D8A235C8E25FDE3599625CBB0903A7C01B3BE8CC236FC2E0E3CB39B29ED1E53B8D97985C72D24BF61DC61B1CE787D7213BF4511CA9147966C724FFFDCCF967E20CE2BDCB3C092BF665727EE81A98B032C87DF080D634D875252CB27171A338CBE30CE45B518C6CB70E3474612E36A1BAA552284A61DFECB5BB44131E99C91484C18901AB9E74D5BDC08E9247532A7906807D0EA0A922900F8FB4853032877114A02D0CA973F0A405989ED00A0AC48260F50D043271B7EB5BBAE1D7CC133AD1B7A4D1300BEB4F877822E153723604B25EFC9230BBE2468AA593893E2D4141F676E81F55E79921A45ED31E2DA81D663E4317968C26602A94A52DB0C28B52798C92CF49EDABA08E21FC2972BC5A762670CCDA792B949FBF07D855DE18B1CC98C479E31F70C842EC6B5D0B6511C1DC70114C5C12EF04409D9A4F9CA7CB91334B5367FD9F0023E38E598AAA00238138C95CF37FC29DEB88FA06F4CC6A2FA1242CBAD78E9C65C0C6A67DC183346C5C108334625E4A9CF18F88A88F150CB8E354EF1B4DB838D929D5DA06BAF8E36F0AB42D9D06B1ED0C371126CB0A579C3688CADC3830347F052723402BC942237699F8E10B17B88550F418DC69F8F7DE0185EFCA3D3B115978299B171C54ADA684D4C768A29C03F271B7395B34E7213671C438CC24538BE15462EA511B02897C4C4CEC7A5B396F827718DD603D8AA8BB7F785F3F229073CB2B863955336AB3CD73C3208F105CAD937F633AF751183EA4FD0762C99CA7B2D1011949C868EE0A7838802CE3C0BB2F5AB7625D9CA05A3217BF55C5B9C01728251DF82C7EACA9A92C5729E6A8872F7F80482E2165D43B0BC6927D0298E759AAABC4D01149A60B43120AA921428256AE251334112A8812AAC0EE9C06B06633F7AD3A7661E095AC6D8E74DD182E612BF72B092E820A57A36E9A504B972953DE39CB9BDA4C4395E2552AA3BD35B4AF03B3E51467A6F226B9654F913A93ED17A492124A5EF50276E07D8A9E6AE1E3A8035CFC219D60B38AC694F829BAA23FD61035FC70470A377C858B864A85E013A5A0520A51386233B88808A75C7403E8279D4DCA5E04E3AB44994A25A2EA9BD65435D75170522B1896BACE21A263576F001C61F7E122276576F1E37379053DD301F7BA539DCFDD84BDEF8190846B3E2A86DBD6E4433F4B2238969260AC7C04C6961A8A47AD21CB21462511B2587164B1D3A4D2314C8B0666C5AEB2310CE8C368038A0CBD8A23474262153A3904E379ADA701C6D48EA1BE28DD1A1F976322F6381573F9CCC2541C34FAEFCCD268C575410F1EA176F5146103FFF76611F4E7B5DD2982F1939F32692A6A53C49FD15E2BE92ABD701BA08D32C2751CBEF7D7295FD3C580BC540138BE4F85937C95A51C431AC8FA57579F2770538654475D6FC225AA82A7A17B8BFE45679D17544A1415DDD2321DEFDC84F81F719E749B45DC772939BBC76136C9B26D1FC684E070AB64D9384BE9B53179F39D0B4C5AFE694C5B0DB8C2C85AFE69469F70A4D53E57691536BCDEA342DB9B19D4C7B0E6F82155440BA60A266278ED1B49229D8CE938A3747DACF2B2D8561A65615BD999905E54F9634A800C00231EA9B39553646334D93FD624E910BC44C93E43E597049875B6698A43F74A22791285CC262920A019699C92A7C35A70C845AA649039F3BD00678E6BF995305A231D38481CFE6B4C92C2E9F08D224DB5F27A30C0173AE43CD28FA54EC75A3018D61B423B49CD92F8B54E8506603D3FE6C49AB0A0E2A10AB7E9F24B2A4567A27C82ADD6AFD9025A121D7484C004E562129A386CA6932513519A5AF8A2A2AA76787DF1DA184722A384407EF25B5C78696C2303A878B6CC99C21D84FE634DB109734B9F6D7178628D1623190DA81BC23965A072631EC8254DF3961C020B987B2B341640DBF0E0750B89A603F807A12C3E80649241A9AA0A4C8D87B9EEAD63973B4802FA2EF0C60858BC421AE0057900194C05A039DF5E9D07DA0DDAB233DF198C37DB231753161F9583B17F3C98A661B9D8FA3D87E980C2E9DAF58FC63A1EE0B96DD62658CD6F3240EC2E27E6C15864478DE4493791B12BDBB0E631F7339C4B8E9A49D91BF6F1EBE32DC28901E7C3D3DA1C39B4F61260F65AC70B309DB133CB397064705730F2534D80E4CB88CD9E170A625B1BF3B30BBEDF93EECC058FFB0B00DABAF17D96CB5EA3AC07E4AB3DE1107B8282B5DE406232C49DF5A524DDA70237D4760C48DFC69818C1DDE932F0EA6E0D0E78B3450AA7E69FEDF38F42B67BA3E35B8E05D2F8BCCBC1A08F890F89CE5685DC263F147741E858858E9EB02577E1C3EA02C2F43BACD8E0E5F1F7119C5A793DD7B9E6501133E5593E29B1DB811222B8644B2DA50AAB669B5D83CDA24085EEE368F76C1B6A32CDAF8F8F1DC859E2C6FF67D684F4BCC991D3FFAE9F2B30FA53DBE8C03F4743AFB5751F78D77F9CFBBB6FA2BEF26C573E48D77E8FD5B8C97D972D525BBB6154B75655386FAE4FF50BAD9C79845AD64AC3A08209ECEBB0C522D2290DA8D239C66B90B4CA114CB35975FADFDA7AF6D5903D328F7A208A44A7645CF890865A990BBD092A6418634AE4967E1B4C85D5893A644EEA2695BFFBAAD22AA6B163FBFF22EB34F71F8C7167FB8C5D2E0141237B3FA28248D6F7B6F17F61EEB41EFD500D866F0D93B7B4D743143A705B91E59383B2063CF12583A5B1D3F88F9299DD1DE25B43B27A57C195A054CFB58B4A4133E278F52B957BABE1A8DD790D6EF994CB2F381A62BC80CFA79A459DD1CA250EDE99E6872C45D2F56752F3A7053561D43BFA85DE07BAB6094B95EBAEC6EBB428B97EF3013193874D0F9618C34AB09A7F6AAD52AD9DFCBC01E905A4F3300BD972B30099F8931A17B8EBD2E9308C8AFA727D32DE1CEFE1A84BA1D7B49A7DD1D7B45AE380767AF3E77CF93F6321484F3C5A9EB4E8397EF741727134E875D9C94DE483328CADC8AEE36C0F68225767B5289DD6BBE809DAEEBE44613489A00C43553473D1B2355C298A1F9548F8F2C0E9CD34F543431B055D1EED4B1F05E22D864EF91260636ABA443BDA0C60FAA345858BFFC45FB8215FDEBA48921A55712A18969A5F216A632FAE54BC199C163A58901CD20029D24828D454464853612E2842A83880E1ECD78173959A616B7B8675E9F22941B358A469942A68508F869D1348030898C3CE0BD5D5B0C0CB2F00016008E11BB5C3E138790FEFAF58441045DB7EEBFD8BC68588DBD5675C4D74E572B7DD05077AB95E096ED973769CAAAC6E01DF7B4148D418CD4E18FDB5300C80E0E429DC0B2D383905D6EAB1E6801B34DC1E1527BA431DA17A068C2638AEDED5586AA8194CA178CA8DBDBCF7C53BBDEE34EC16637F6FEB693C16EC4DD2DF7FAB3BE102FC441E6C7B47A9F0BA82C6D86A8F2D5E7E92CB84F30024A7F2E5D428C47CD37276836A145A104D4E859B6B946391C179C6F1270AA0A8D0265D4CD4A92EDA8DAAE7C6CCAB6AB32EAB625296CF8B6058F8DD0B250026A972B64D7E7521D28BB5C1651F7B87A60AE6958DC320B0D8B45A086F952FAA68BA3A1D05AF12BD40098124226478D0C75F233939D683D15D1221401E12244AB30909D60208144291492350F252ADB713A303633823A619E74E1659497241AABB0A84F38FB9713A1305A551248B4BF50064AF6E54A2012550FC6CE748F904AC338CFF1E5041FB43E81233E3A4007E8287590D30B5A02C4A8494A6448F43A1CB9670051B8C9DE45ADAF4DA8BE29755BCCABA5C8CF25896CD3A3BBF225541688C76597EB4435AA2EC3E1739C427D174200FD09FD9395D98EBF6CE70B47481DA0DBB2F5D0C0CE3EC80A30B64006CB3FE64A20D0315F4C22E45810AE328EED9B1006CE33D64D3D0EB529B2C82B26861B3B997FDCC6E45176F9BFB7280B572D0912BD31464BC6F0D594B98C1F92DAFEC6715417E19E385CA1DC0FFCDC273BE1077F99E3CF24DC491863E55A45877CB7BE47C1657CB3CD37DB1C7719ADEF2326F602B1E3A9DA2F92A7B13C9FDC940761175DC06C86E41DFB4DFCCB368C8286EF0BE0518584043110560FA1C858E6E441D4EAB9A1742D44F49511AAC4D7D8356FD17A136162D94DBCF01F5117DE30FCDEA395BF7C6E8351C888E8078215FBC9DBD05FA5FE3AAB68B4F5F17F318683F5D34FFF0708BBADDDB6CB0000 , N'6.1.0-30225')
262END
263
264IF @CurrentMigration < '201608300539365_newsarticlenotoficationsubscription'
265BEGIN
266 CREATE TABLE [dbo].[NewsArticleNotificationSubscriptions] (
267 [Id] [int] NOT NULL IDENTITY,
268 [NewsArticleId] [int] NOT NULL,
269 [UserId] [nvarchar](128) NOT NULL,
270 CONSTRAINT [PK_dbo.NewsArticleNotificationSubscriptions] PRIMARY KEY ([Id])
271 )
272 CREATE UNIQUE INDEX [NewsArticleSubscriptionUniqueIndex] ON [dbo].[NewsArticleNotificationSubscriptions]([NewsArticleId], [UserId])
273 ALTER TABLE [dbo].[NewsArticleNotificationSubscriptions] ADD CONSTRAINT [FK_dbo.NewsArticleNotificationSubscriptions_dbo.AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[AspNetUsers] ([Id])
274 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
275 VALUES (N'201608300539365_newsarticlenotoficationsubscription', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1DD96EE4B8F13D40FE41E8A7DDC0DBED63773219D8BBF0F8480619DB8369CF226F862CD16D6175F44A6A8F8D205F96877C527E21A44EDE8744A9D5CE6080815B248BC56255B1582CB2FEFBEFFF1CFFF21C85CE1348B320894F6607F3FD9903622FF183787532DBE40F3FBC9DFDF2F31FFF707CE147CFCEAF75BD23540FB68CB393D9639EAFDF2D1699F70822379B4781972659F290CFBD245AB87EB238DCDFFFCBE2E0600120881984E538C79F37711E44A0F8017F9E25B107D6F9C60DAF121F8459F51D962C0BA8CEB51B816CED7AE064F621CE53F7EE1A7CCDEE96410EE6E76EEECE3FA5C953E043EC66CE6918B810AB25081F668E1BC749EEE610E7775F32B0CCD3245E2DD7F0831BDEBEAC01ACF7E08619A8C6F2AEADAE3BACFD4334AC45DBB006E56DB23C890C011E1C55745AD0CD3B517BD6D01152F202523C7F41A32EA80909E983E2D3E7248404A03B7C7716A6A8F2C9ECAAE9E2345B5F837C5E379C97202F5308EE6B92FE36C721EE39DAEDF61ABE3A9CEFA37F7BCED926CC37293889C106CE76B8E77CDADC8781F777F0729BFC06E293A383FB87A3B73FBD71FDA3373F82A39FF091C2B1C27AC407F80972C81AA41037F0D08C7FE62CC8760BBA61D30C6B535205F21214919973E53E7F04F12A7F84C273F876E65C06CFC0AFBF54CCF5250EA044C14679BA813FAF3761E8DE87A0295F48FB44FF4B7A3DFCE98D955EAFDDA760554C3DD53F141C24579F415894668FC1BA142F62BEEFAA6A976912A1DF247F95A577CB64937A683089B0CAAD9BAE404E6277BC6899578BA51128FB6C5D439D3E6B234C59F6E6564503EA22097517634B438DEFB0FD6A73DCE97A0D27AF602D15C3310B17AC16C4730AC29EC3AFD772D2FEFCEDFCCDFEDB37F383A31FFF7CA866A8180E74E6BC773350D18C16DD99A622586EEE332F0DD68516E02A04040DAF7557D2A4D509DC0A8DCCD76A815FAB561EBA7AEBD65DF1B184050544425B351F196CDA121E06DA9C420FAA03ABD02006E295D1D752388AA3438E4462A459E6490AFE0A6290BA39F03FB9790ED2B855F82AADF137373BF5F2E0095C2779F050895BDDFDFB04D2D58D27AA8AD87E2143AA69A72B25A584DA93657A89974BBC812CEB21595494E08884598922AAD4CB0E29B030166FD8EA9B44EB4AF4C53A8016C8136E84688A8208D04876364DB34231C5ABD33089415F8D04813DB941D1C218945443745A48693963975813143A581F3ACA40697BE01AC364CBA4C697AE45E3CB2B67F0E556EA65A8D0103B68321AC437B5B65543655B7B35AB868AC804E82445B46A928A9A89D4EBA158D694E0883EA8912C6AF53254B0CD6789539FED2B82F05A247D3C21B980E4092DD81D1ABD9C25F1439046C0EFAB503EB959F635497DA8AD1E25A8C33F2DA0BE04DE26856CBBCCDD683D786F9F1EA11D76BD89EE91348CD797B5A9B9FD9A5CBA1E5C842E62D4AA37BC8F89F75BB2C92F62FF1C2E685F72AF06887EDE06913E002BE89C7A1EC8B24BC8CCC03F4B3671DECFF8472A6BDBFEF553FF298083BA43CB817009C1CD01AC66BB84702B30D622BF96A9795B637C9BE8E15BD713605B16CB71ADEA98627A16BA41C4B7BEA985EBAEAEDA22C9AFC12CCB826AA6D6C3C7641508360A740F755531AA650D25AA55355354D1E27E9AE681A7B32BC32AE3332AB58774DBB03CA3DBD094913E03D7C7800B36A064256658BC727603CAAB648CAE70CF4EB300B37FE756507252B77D7D873DB29EE9ACDC250BA9AA6D3A931B3463BB196FFE5A8CE6E1B7C7672940ED581BA4ABD30FDA5D39ECBAAF13119F4D04A7B127E8B5B02C3476EB21A5F01ECE930782A7D630ED6A44D50BBF95ED8EC21C4D46733E08B5CC108615AD0FE5E697B68FC3AA4125C59132BA7A875B14568FFD788B02ECF4032EA6AE37B7E5012CA68F508843EDA58B9E7E75C38DEDAE3A49436158DB978602ECF4A5A140B30EC9D48A42AA2B43F05AF5F9014E6A99A3301B5B1C88618EDDF9383A40DF7E566FD5BA98D56AA8DFAC6DDD550323665F0379FB56A0D8B21AD241C1D860A69E8D6EB166A40FA14BA81909E19BCC6C4166D01CA01D6EEFDDEE8485AF93CB8C09E092F9D5F4046813095C3BA5F1FA21BB0CDD557B5DC4589ECA7B2D8C2B60A868DF2F31B432C21738CF95A7E025A7C37CAF003A776AB9B6F2845C266971805E98D29033F69949261A7E59FB484C086553353D54343D4BA208767813F31A1F291A9747104DF51FF7D9892EA714FF789A65891714C4E7DC81A96E30909D5EC4BEA3BECE2088AB76AEE06405C8510ABF405ACE68F576139F8310E4C041311FE88ED0999B79AECF0A161C8E6F8058E3FE64116BAF4690C8FD89E913EA5C90A2462E3A38CE20B70571CE2AE820F682B51B2AA944B5D454EE68EC4D1F74C93958831875A8A4844EE7FC9B100881A61F6A5254143A5E601C2767447EB4AD68CA15A1B7EDACB341E7AA595775C2612DE60E04CDF656384B8ACE08CC25A5F9E4F9AB0DD5144D37276EB39DE26249D0671DCE650A6D76F913ADC9B5C7C88D0413A1280F0B6BB165A321F5C9200FE09452D792D0C8301841666444D6E9BE0A20DC8AC4F00F064453AD3825E01F0699F09222BE832B5EA5314DF6B13F9F5BE22D294623309794E43AFDE3C760DB67B1EA4C476BFEE9031ECBEC4507E46833D7109C452233365F9194D6D259C956794A10D6249A77558C93C1D40FB2B9510457093638D561E4203B1C39C546E04F3949741098148356C16CBA0C4047B64D8D41A9903A018356E783A3302849B12D30284992C933A8F67980702D353E1CC0D66F9D53318365DD389072F4B5DE10C3310C00C3F99B3C47739DEC42B78FD4E38EB996E8332603CF92340E766C0E946133865F4942EFC973163F9A5877AD14BA9BA6B1940B3D5823F9D2A5E4DAC23A4ED063F2ACC98F1CD776D589D49E557FE076159F149D6D7807774AF5715F1B10AE78B25705863AAF19DDDB2CC3608C955442E469799BCB280474E20E5BB467DAADD49FDF17C7F1CF3927D400727D156D90557119344720E04B90937781DAC807EE5135C35624107AC993016C974505507AC27840598950002D9FFD62E0145CAF684A2B241E1C56FF6B00E5016274BC020EBE15E1C1233DBF06D3595F7C94CE67E55133005B5F529482ADFC20AAA1AB37645C8AE8ECA5552CCADCFB633994DE085120311DC0520A0B3C71B08AE2073669E5A415A0D28CAAD1068C92D38A27C1E07014026D6A9303D7200A3F088243178D6809F9D248C44B50D4A1D84A42297984848AE81D08843DB8C4124570C44F60CC1EF26358969A53325EF6587F8031724FF139C3559FF6CB6D6FDC02C386C159032414919EF02B48DB813682CB6A2C71340EAF493FA1F4F81A1B08B50A4948233FB0A6286E9D38F50D3905697887AEE25150C7AEFDC9421DB40E4014D12B072C5D740E0E4D8E0E55833139E613AC3BF560AC53A9B65DD454E29D5E999C5FF5A21275D624A0523D98FE02A67D518223759D0E55FA1DABE0F2A96541CAC4D6F420650059E6C7CA73AC23A5BB5FDFE18F2FF08C292C338D642EFE11F49CD04AD2F0581BF8AC7B89AFD0941AC2B6E6BB4375EC2A05FBC83DA7F62CABC1A58BE7CFD3D97BC8ED4EA9E7CFDECEC38EDD59DF8F693C534DD9F1A2CCC4527D385E0852B61C5FB9EB7510AFB0142ED5176759E66F39FB61699ECC242A612C3C4254693F5AD3539EA4EE0A50A5E8C6890F2E8334CB51CE987B175DE439F323A61AD70F277013D45DE2AE3676DA6A8F415D1BFD5D3FED81FEBE79F84E9ED686F0047CCFF16656902FE1B8D1A59A820480A352781BE502C0D2734337E55C9C3B4BC24D148B1DB4E2D6E5C36A78FBF20B0BE17841E1CFB860191A1A11594E5B3A207D72D4853CE807C5D14375DD8909A1C7C19C07482D4441EC422CA7476D39AD26476AD24B3E2A9DEBF256CD682921D67A1860F61A1F7FF719148310CD627DDE87CF82E80C500C05F54943A9BF4D66125973C0E22432672AE693A80631CC9A22781F1B0728A832148388A054A7893810C101E3D698ACB00E2DF215C712D660256EAB61B887481A8183210A3AC0634D1DAA481F26951082182C596404B3CD0B41416C0B26C397EC4ED122933207B8E61CAB06B1BBCACFCE1ABB03CA4F749C6A631BC1739968F09512C2405AB17C819ED05EE5274318D823E60C30AC4C1F2AF9CE3C0E932CD187483D268F83A48A0CB0C49F8C2790C40B3AC11350945FC3403C9947E20949654AF521739E8BC741738A3BC0E6E04C97E943E5BC288F03E6149B2953D63468BF4E461992E797169522B10C996B4479F361D461F3C6300EA2F9D8C138C4DE18E65A8858B981738D79A38870B431A526C622FDDA306931D2A5FA90F10BD7384CD9456C31B4F6A22DA1BC84D76F27E190119EAA5BF1C894517AFD5C320218C3C89A1D6B137B659690D9F6B321ACEA1D590658F57D929C258C44B0C25965A0663FCE12C0102FF7C45BADE46A2F7D60560C93788095B0A8640FD08AE199F1EFB616779DE0079B6BBE46DC6D0753A00BD4810EB6C8371E8985972C7A659CC48480D8744A5361D41D7CD22A08BBC30DEDD39F8413BAF9BAAB7C45461E30DEE83A6CC7C4E35CB7E1B8951507BB289E82F55BA9AE596A7190F02A11D6A50936C24B545AD8880E2FC4E8D03122EC6432A12274958695AA2FCDEF2654A40AD320E2478A21A16890622859153242C76D9455664ECD0827B3E54B9683A8648FE5EFE1591800B455AF2B5CB971F000B2BC7C237576B87F7038734EC3C0CDCAA89E2A22E51D7DD94A2B44E5E00885A8003F5AD0CDCD035D10942CF389A791C5A90658AE1EE311E5F8C94DBD4737659F1036CD9AE3B699F75AA0CC85B70FB10F9E4F66FF2C5ABD2B22A0D05FC5E73DE743F6250E7EDFC082DB74039C7FB1C9FB0CB1A2CEF57B8DB953F288AEB32ABC0EABFB16A59A09EA2E4CE7ECC33FEECAA67BCE4D0AE5F19DB34FCD5417FEA947D1019BB2690F6CF4DF62979E948F21AF01D284CA67CD0D692F4D547D1FE4A34D264DDF521B54CAA19ADE43859AE8C27C4472EB82C436303DE0616A8711D9FBE9BBCA7BC469BDD60418D254D2257FCDEAB9E45007FBDD858838CFD705A3CD41F273EF9D6527EBAAACEB2A49D377BAAA4C07D3015599F4A07CA74C6022FBBB8E3EE99EECBD0B27F312BDD7587E17B9CFDF9BA2C64DE6DE0B222761BB2D785648284AC8DE059630193B4AC29153A9617406CB4FCEDE05356162F6429FF44CCB6EA642ED6D0EBB25037E1DAB22956A97C7613D53ED76E10C51A25D683DBD7481274AADDB4504D8B4BA465BD2B6B9EEB6B44B025E2394EAC663EC931567D03B2B47D372993009597BAD956CD25503703D12AB76E08C1DCB496ACDC0FCC4A61CB5067B9BAC6D35CFE8EBD034DCD4835ADB39ACA5FD5D9D3DBE3140B3FF36B973B2CDFF7766A2E8311413D1D9313B1BA85DB951639C2372A1EAB85B8F1145E7D6F64E90CC7D4DC80E458DC8C5E2151C15594B4739950C94EDC39F82E71E077C2C5B71AD5C47E73A268FCD6A5C84D6151A674B0F167394446FFEA2E752FC6449CF778F778249342E5A4F8C49E40150E45B90EA57A507D1369C958E4284291E8499F8B79DADF3903A8ECD68251F978978716B135DC4A6C25663EBA88EFCB5552DA57EFBD5545389D72DF6C16F0C165BB8CBAA46E36AFCB4148D598E56E6C5756C22151937B85953F98FBAF648C769234BCCD819325F5FA6D51E6CF28D47BAF3C84EE74D9D40F62A4EB606C12E7CC4ECA863EFC44517600D82A5A79F037562CC56E5F01030DB88994EC76636D19DD889315BEF7CA6432D883AE959F075D2466AD45DE1B36E776827C67946794707E232263B0FEE75344D61BA2BDCA3BE4B3B314ED178957D67D6C36D9D806C7935D4F61C6D95D1345EB71F5E274DC1A5B4056EE9E45EDAEE02C679667F283FE314CEC746F233763A16DB76764E3679003D93D5D3039CB37C65F6CDF242FBC9CCBF4FE0BC979104A7D9FA1AE4D5EB060CDBF03B6B971861876D1571A7EDD3E1AA8E59C6643A66ABF03A661FBC56755DC817D35BF195D7013715060D9355BE4C076C155E6FCA64274CD7CC7AC2F4CCD4904FA0BA4BD2F3C8F44716F33A93A63D53271DD5CB392A1FA5200798ACEFCA2521EDBBAA23EF5B90598B21B3CEC695A5BE4E2BEEA474C875A5CA7BAA93F6942BD58A9C513CA1668E597932CE5412E9145EDEDF6D6464E526782A0B98254DB6AFE040690BE91DCB7432B0F6278568A5E1A723E84F0A3655AA24E5AAE0B920DA3AC430E6F0255D5F2008A2D78D6C0EB94E25251B32FF4D22AB73BE0D2270630BFAE79F359D7F9125C27F80BEFFB0074B2D2BB06BB80F9ECB08C23356D837822D13C2561AD95D2382E0347480B4B19D4921B426052FDADA27CA705962AD10853073058FB15A1097ED2685B52658FA36BAF66BA416CCB16132BEDA229A6093C07D8CD3BEF8550E0AEB295EAD08DF18C63ADF976D21A5AB2D828C6DC370DDB5FD53B89A9A6E43ED540CB2B3B24F6B1E2F3E6F62743FAEFC750EB260D58240790F63E0119ED0A6CE87F821A9FDB114467515EAB6D515C85DDFCD5D24FC0FAE97C362F43A481043C25579152FA27BE07F886F36F97A93C32183E83E24EE5923C7AEACFF22052D89F3F14DE9DDB03104886680AE14DEC4EF3741E837785F72EE770940208F71752313CD658E6E66AE5E1A48D74C122F11A08A7C8DA3FB1644EB1002CB6EE2A5FB04BAE006A5EF2358B9DE4B7BF15C04443D1124D98FCF037795BA5156C168DBC39F9087FDE8F9E7FF013991C3B27ADE0000 , N'6.1.0-30225')
276END
277
278IF @CurrentMigration < '201611090908521_TagSortOrder'
279BEGIN
280 ALTER TABLE [dbo].[Tags] ADD [SortOrder] [int] NOT NULL DEFAULT 0
281 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
282 VALUES (N'201611090908521_TagSortOrder', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1DD96EE4B8F13D40FEA1D14FBB0B6FB78F3D26037B171E1FC920637B30ED59E4CD905B745B581DBD92DA6323C897E5219F945F08A993F7254AAD7606030CDC22592C16AB8AC56291F5DF7FFFE7F8D7E7289C3C81340B92F8647A30DB9F4E40BC4CFC205E9D4C37F9C3F76FA6BFFEF2E73F1D5FF8D1F3E4B7BADE11AA075BC6D9C9F431CFD76FE7F36CF908222F9B45C1324DB2E4219F2D9368EEF9C9FC707FFF2FF38383398020A610D66472FC6913E741048A1FF0E759122FC13ADF78E155E28330ABBEC39245017572ED45205B7B4B70327D1FE7A977770DBE64778B2007B3732FF7661FD3E429F02176D3C969187810AB05081FA6132F8E93DCCB21CE6F3F676091A749BC5AACE1072FBC7D590358EFC10B33508DE56D5B5D7758FB876858F3B6610D6AB9C9F2243204787054D1694E37B7A2F6B4A123A4E405A478FE82465D501312D207C5A74F4908094077F8F62C4C51E593E955D3C569B6BE06F9AC6E382B415EA610DC9724FD7D8643DC9B68B7DB6BF8EA70B68FFEED4DCE3661BE49C1490C3670B6C3BDC9C7CD7D182CFF0E5E6E93DF417C727470FF70F4E6C79F3CFFE8A71FC0D18FF848E158613DE203FC0439640D52881B7868C63F9DCCC97673BA61D30C6B535205F2121491E9E4CA7BFE00E255FE0885E7F0CD7472193C03BFFE5231D7E7388012051BE5E906FEBCDE84A1771F82A67C2EED13FD2FE9F5F0C79F9CF47AED3D05AB62EAA9FEA1E020B9FA04C2A2347B0CD6A57811F37D5755BB4C9308FD26F9AB2CBD5B249B7489069308ABDC7AE90AE42476C7F39679B5581A8172CFD635D4F1B336C294656F6E5534201B49A8BB185A1A6A7CFBED579BE34ED76B3879056BA9188E59B860B5209E5110F626FC7A2D27EDCF0EF66747B3839FDFFC7CA066A7180E733A79E765A0A2182DB8534D35B0D8DC67CB3458173A80AB0E1034BCD65D49915623702B34125F2B057EAD5A75E86AAD5B6FC5C712161410095DD57C64B0694B781868F3093D280B46A141F4C22983AFA3700C47871C69C408B3C89314FC15C420F572E07FF4F21CA471ABEC551AE36F5E76BACC8327709DE4C143256A75F7EF1248552F1EA91A62FB85ECA8A69DAE8C94F2E94E92E9E55D2EEF0692AC8764515182231265258AA852271BA4C0C258B861ABAFF2AC27CF17EB00DA1E4FB8F9A1290822400359D834CD0AB514AF4EC324065DF51104F6E405458BAEA016499ADFA47033ED52CD58ADC5B4B0B2ABB4090A16068C8E46519A2FB8DA31D973A9F1A56BD1F8F2CA197CB9953AD93A34440B754883F8AA1BB768EB6C6BABE7D4D61159115632442B26A9A099C8BC1E8A654D098EE8831AC9A256275B07DBBB963875D9FD2208AF43CE8713910B489CD081E9A2D1CB59123F046904FCAEEAE4A397655F92D487BAEA51823AFCD301EA0BB0DCA4906917B917AD7BEFEDE32334E5AE37D17D6B3C0DD197B3A9B9FD925C7A4BB8045DC4A85567781F92E5EFC926BF88FD73B89C7DCE973540F4F33688F4013841E774B9045976099919F867C926CEBBED1F90C2DAB673FED47F0AE0A0EED062205C40706300ABD92E20DC0A8CA5C8AF656ADAD618DF267AF8D6F504D896C5725CAB3AA6989E855E10F12D6F6AD9BAABABB648F26B308BB2A09AA9EDF0215905824D02DD435D558C6A5943896A55CD1455B4B49FA679B0D4D9916195F119955A43BA6D589ED16D68CA489F80E763C0059B4FB212332C5E39BBF9E455324657B85FA75980D9BB732B2839C96E4F6FB13FD6339C953B642155B50D67727B666C35E3CD5F87C9DCFFD6F82C05A81D6B81D87A0DA1D595C3AEBB7A21F1B944701A6B825E09CB4263BF205209EFE03C2D41F0D49AA5B62654BDEC3BD9EC288CD16430C78350C7F46156D1DA506E7C69FB379C9A53521C2993AB73A44661F3B80FD528C08E3F5663EC7A735BDEBF62FA0885D8D74EBAE8E9372FDCB8EECA4A1A0AB3DABD341460C72F0D059A7534A75600535D1982D7AACF8F8D52CB1C85D9D0E2400C73E8CE87D101FAD6B37AA3666354ABA17EB5B5F5D60C8C945DCDE3EDDB8062BBAA4FE7046381997A35ECC2D448FF814D941A09E1ABC40C2E316806D0EEB6F34E77C4A267E52C6362BF641E353DF1D94402A74E69B8BECF2E436FD5DE323196A6F23A0CE306E82748F8730CED8BF005CE72E52378C9E9E8E02B80CE9B5A9EAD7C2097495A1C9B174634E48B7D668A89869FD73E121242D1544D0F154DCF9228821DDEC4BCC6478AC6E5D14353FD877D769ACB09C53F9E6659B20C0AD2732ECE54D71EC84E2F627FA2BE032108C79E5CC1C90A9083147E81B49CD2CAED263E0721C8C104457AA08B45675EB6F47C56ACE0707C03C41AB7278B587B9F8244EE3BA64FA871418A1A79E8C03883DC16C439AB9E837819ACBD504925AAA5A66A47636FFAA04BCEC11AC4A8432525743AE75F9F400834FD5093A2A2D0F11CE3383923F2C3744553AE88D96D679D8D5557CDBAAA130E6B31172768B677C259527406602E29CD47CF5F6D78A668BA39B19AED14174B823EEB70EE6068B3CB77B426D71E2337FE4B84A23C18ACC5968D80D427833C68534A5D474223C3600099911159A7FB2A6C702B12C33F12104DB5E27C807F0C64C24B8AB80EAE7895A634D9C7FE6CE688B7A4180DC05C5292EBF48F1F806D9FC5AAD31CADF9A78F761CB3171D88A3CD5C7D701689CCD07C45525A4B67255BE52941389368DE55B14D0653DFCBE646115425D8E054C790BDEC70E4141B803FE524D14160540C5A05B1E932001DD1363606A542E9040C5A9D0C0EC2A024C5B6C0A0244946CFA0DA6701C2B5D4F860005BBF75CEC30C9675E300CAC1D77A430C8730000CE76FF41CCD75B10BDD3E527F3BE65AA2CF970C3C4BD2F8D7A1395086CD107E2509BD47CF59FC2862DDB552E86E1AC7522EF4600DE44B97926B0BEB38418FD1B3263F625CDB5527527B4EFD81DB557C5274B6E11DDC29D5C77D6140B8E2C95E12E8EBBC66706FB30C832156520991C7E56D2E6310D0893B6CD19E69B7527F7E5F1CC73FE79C4003C8F555AC41564565D01C81802F404EDE016AE31EB847D50C5B9140E8254F06B05D161540E909E30165254201B47C2D8C815370BDA229AD90787058FDAF01940788D1F10A38F85684078FF4FC1A4C677DE1513A9F9547CD006C7D39510AB6F283A886AEDE907129A2B39756B12873DF8FE5507A234481C474004B292CF064825514BFCA492B27AD009566548D3660949C563C090687A31068539B1CB80651F841101CBA68444BC89746225E82A20EC556124AC923245444B72010F6C8124B14C1113F81317BC88F61596A4EC978D963FD1EC6C83DC5E70C577DDA2FB7BD710B0C1B06670D9050447AC2AF20AD056D04D7D458E2681C5E937E42E9F13536106A159290467E604D51DC3971EABB710AD2F00E5DC5A3A08E5DBB93853A68ED8128A2D70D58BAE81C1C9A1C1DAA066372CC275877EAC138A7526DBBA8A9C43BBD3239BFEA4425EAAC4940A57A30DD054CFB920447EAAC0E55BA1DABE0F2A96541CAC4D6F420A50759E647CA73AC23A5BB5FDFE18F2FF08C292C338D642EFE01F49CD04AD2F0581BF8AC3B89AFD094EAC3B6E6BB4375EC2A05FBC83DA7EE2CABDEA58BE7CFD3D97BC8ED4EA9E7CFDDCEC38DDD59DF8E693C534DD9F1BC4CDF527D389E0BF2BC1C5F79EB7510AFB0BC2FD597C9A24CFA72F6FDC23C034A54C2982F0951A5FD684D4F79927A2B4095A21B273EB80CD22C478966EE3D748DE7CC8F986A5C3F9CC04D507789BBDAD869AB3D06756DF477FDA807FAFBE6E11B792E1CC213F02DC79B5941BE84E346976A0A12008E4AE16D940B008BA5177A29E7DADC59126EA258ECA015B72E1F54C3DB975F5808C7730A7FC605CBD0D088C872DAD201E9A3A32EE4413F288E1EAAEB4E4C083D0EE63C406A210A620F62393E6ACB69353A52935EF241E95C97B76A464B09B1D6430FB3D7F8F8ED67500C42348BF5791F3E0BA233403114D4270DA5FE369A4964CD018793C89CA9984FA21A443F6B8AE0556C1CA0A04A5F0C2282529D26E24004078C5B63B2C23A74C8571C4B588395B8ADFAE11E22DF040E8628B080C79A3A54913E4C2A97043158B2C808669B528282D816E8C3C3F24AE0D0B0CFA3E17176D7E990E199C36073EE5783D85D45EA66BDDE01452A3A9A75B125E1B95F34F84A09A1270D5BBE624F68C2F293210CEC2174061856A60F957CAB1E874996186841F2417A421392450658E2CFCE1348E20556F00414E5D730104FE6A179425299527DC89C27E771D09C620BD81C9CE9327DA89C57E971C09C623365CA9A19EDD7D12843F22CD4A152249621738D286FDE8F3A6C5E2AC641341F2D0C4DECA562AEB589951B38EA98D78E08A71D536A6278D26F1693D6275DAA0F19BFBC8DC3945DEA16436B2FED12CA4B78957714CE1DE109BD13EF4E19F1D7CDBD2380D18FACB9B136B1B76A09996D3F1BC2AA5EA3658055DF47C959C2A806279C55067D76E32C010CF1724FBCF84AAEF6D2676AC53089675C098B4AF68CAD189E19FF6E6B71D709A470B9E66BC4F05A980236507B3A24235F8B24165EB2E8957112134EE2D2C14D85645BF8B7551076871BDA4744098776F37557F98A8C62603CDB75089089F7BA6EC371512B0E89516C06EBB7525DD9D4E220E1B524AC4B136C8417B2B4B0111D8488D1A1E34DD8C964C24EE82A0D2B555F9ADF4DD84915F241C4A21443429125C550B22AFC848E0129AB4C2735239C4C172F590EA2923D167F84676100D056BDAE70E5C5C103C8F2F2BDD5E9E1FEC1E174721A065E56460855D12D6FE98B5B5AE12E074728DC05F8D19C6E6E1E3483A064994F3CB22C4E58C072F510CF31C74F5EBA7CF452F63162D3DC3B5E9BBDAF05CA5C9E7B1FFBE0F964FACFA2D5DB229A0AFD557CDE9BBCCF3EC7C11F1B58709B6EC0E45F6C024043ACA818814E63B64A41613BABC2ABB5BAEF5AAA99A0EEC274CEDEFFE3AE6CBA37290E9BDE4EF6A999B2E19F7A1416D8944D3B60A3FFA6BBF4D47D08790D9026543E906E487B69AAEBFB201F6C3269FA96DAA0520ED5F41E2AD4840DF311E9B10B12BBC0F48087A91B4664EFBAEF2AEF1127FF5A136048534997FC35ABE392430509D80B11111B600F060B0AC0C8EB860DE587E73BCB93CEF5A1ED524BD377BCFA5007D31EF5A1F4B47DA7EC68220DBD8E52B2CF3A6FC3C9BC8CF33596DF44DEF3B7A6A871B3CA7782C8C91CEF0A9E13128A32C3DBC0126685475941722A538DCE60F959E26D5013668857AF3F7C056AB7C3AC5BBAD961DA65257E1DAB2295F597C7611DB3FEDA708628E72F34C15E6CE089B2FCDA88009BE1D7685FDB36D7DDDBDAE4023642A96E3CC4665B7190BDB372342EBF0B931BB6D35AC9E67F3500D721C7AB0567EC587A546706E64736FBA933D8DB646DA7294F5F87A6E16642D4DACE612DDDEFEADCF18D019ADDB7C9D6993FFFDF9989A2475F4C4427EBB436506DB951639C0372A1EACC5C8F114587DFEE8EA1CC7D4DC80E458DC8C5E2159C3739CB8F39969498ED4BA41C7CDAC2DE33610E99FC5272335B5768265B7A4199A3243AF3173D97E237543A3EC4BC134CA271F37B644C228FA2221FA7543F73DD8BB6E1AC7414224C712FCCC4BF7EED9C87D4C170462BF9B04CC40B7E1BE9223616B61A5A4759F2D756B594FA315A534D255EB7D817C831586CE12EAB1A8DFBF5E352346649639927E0B18954A400E1A671E5BF32DB213FA88BB43543A7EC7C7DA95F3BB0C9571EB1E7919D4EE43A82745A9CF411825DF880E95A87DE898B6ED11A445C8F3F29EBC898AD4A2A2260B60153AF0ECD6CA28BB52363B6CE0956FB5A1075F2C5E0EBA48B5CADBBC26776177147C6794689507BE232265D10EE7534CDA9BA2BDCA3BE903B324ED178267E67D6C36D9D806C7935D4F61C6D95D1349EDBEF5F278DC1A5B4056EB1722F6D7701E3BCFBDF979F710CE76303F919AD8EC5B69D2E94CD6640CF64F57E01E72C5F990EB4BC157F32F5EF1338EF6524C169B6BE0679F54402C336FCCEDA2546D8615B45DC69FB96B9AA639631998ED92ABC8ED917B8555D17F2C5F4567CE575C0CDCD41C364952FD3015B85D79B32FB0AD335B39E303D3335E413A8EE92F43C32FD91C5BCCEA479D8D45950F592A0CA4729484A26EBBB724948FBAEEAC8FB16A4FA62C8ACB37165A9AFD38A3B2916C9B754895875F2B072A55A91C48A27D4CC312B4FC6994A229DC24B44BC8D14B1DC8C536501B3A4C9F6151C286D21BD63194F4AD8EEA410AD34FCFC08DD49C1E66E95E48015BC39445B8718C61CBEA4EB0B0441F44492CB21D7B9AD6443E63F6CE474CEB741046E6C41F784B8A6F32FB244F8AFD8771F766FB96E05760DF7D574194178C60AFBD0B06342B8CA6BBB6B44109C86F690C7D69A14426B52F02CAE7BA2F497B6D60951083357F0A2AB0371D96E965A6782A56FA36B3F69EAC01CEB2705AD2BA2093609DC173DDD8B5FE5A0709E73D689F00D61ACF37DD90E72CCBA22C8D0360CD75DDB3DA7ACA9E9D6D74EC5205D2CFB3EE7F1FCD32646F7E3CA5FE7200B562D08948831064BC213DAD4791F3F24B53F96C2A8AE42DDB6BA02B9E77BB98784FFC15BE6B018BD0E12C4907055A2C78BE81EF8EFE39B4DBEDEE470C820BA0F897BD6C8B12BEBBFC8894BE27C7C537A375C0C01A219A02B8537F1BB4D10FA0DDE979CFB5D0210C8635CDDC8447399A39B99AB9706D23593554C04A8225FE3E8BE05D13A84C0B29B78E13D011BDCA0F47D002B6FF9D25E3C1701514F0449F6E3F3C05BA55E945530DAF6F027E4613F7AFEE57F8D5C2C6840DF0000 , N'6.1.0-30225')
283END
284
285IF @CurrentMigration < '201611162040206_VisibleInGui'
286BEGIN
287 ALTER TABLE [dbo].[AspNetRoles] ADD [VisibleInGUI] [bit]
288 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
289 VALUES (N'201611162040206_VisibleInGui', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1DD96E24B7F13D40FE61304FB621CFE8F02ED6826443ABC311B292163B929137A1354D8D1AEE63DCDDA39510E4CBF2904FCA2F84EC93F7D1CD3E46592CB0D034C962B158552C168BACFFFEFB3F47BFBE04FEE419C4891785C7D3BDD9EE7402C265E47AE1EA78BA491F7FFC30FDF597BFFEE5E8DC0D5E26BF97F50E503DD8324C8EA74F69BA3E9CCF93E513089C641678CB384AA2C774B68C82B9E346F3FDDDDD9FE77B7B7300414C21ACC9E4E8CB264CBD00643FE0CFD3285C8275BA71FCABC8057E527C87258B0CEAE4DA0940B27696E0787A19A6B1737F0DBE26F70B2F05B3332775669FE3E8D9732176D3C989EF3910AB05F01FA713270CA3D44921CE87770958A47114AE166BF8C1F16F5FD700D67B74FC04146339ACABEB0E6B771F0D6B5E372C412D37491A058600F70E0A3ACDE9E68DA83DADE80829790E299EBEA25167D484847441F6E94BE44302D01D1E9EFA31AA7C3CBDAABA3849D6D7209D950D6739C88B1882FB1AC57FCC70883B13ED763B155FEDCF76D1BF9DC9E9C64F3731380EC106CEB6BF33F9BC79F0BDE5DFC1EB6DF407088F0FF61E1E0F3EBC7BEFB807EF7F0207EFF091C2B1C27AC407F80972C81AC41037F0588D7F3A9993EDE674C3AA19D626A70AE4252822D3C995F3F20984ABF4090ACFFE87E9E4C27B016EF9A560AEBBD08312051BA5F106FEBCDEF8BEF3E083AA7C2EED13FD2FE975FFDD7B2BBD5E3BCFDE2A9B7AAA7F283848AEBE003F2B4D9EBC752E5EC47CDF17D52EE22840BF49FECA4BEF17D1265EA2C144C22AB74EBC022989DDD1BC665E2D9646A0ECB3750975FCAC8D3065D99B5B150DA88924945DF42D0D25BEDDF6ABCD7127EB359CBC8CB5540CC72C5CB09A17CE28083B137EBD9A9376677BBBB377B3830F3FFFBCA766A7100E733AF9E824A0A0182DB85329B97FF7120F12E932FCEDEEB224FAC7083673C2162A65B1794896B1B7CEF40957B520CCF05AF739756BEDC2AD50698F52C1F06B956A4817DD5B67C5C71216641009BD577D64B0A94B781868F31C3DA8064C4783E884EB7A5F93E1180EF6396C891166914631F80D84207652E07E76D214C461BD70A8B4CFDF9CE464997ACFE03A4ABDC7426C8DE5621095C6F60BD9514D3B5D19C9E5D39E24D3A6825CDE0D24590FC9ACA2044724CA4A1451A556F64C8685B170C356DFE4594F9ECFD71EB4639E715346531044807AB2D6699A656A295C9DF85108DAEA2308ECD9F1B2166D412DA238BD89E1C6DCA69A69B416D3C2CAAED2262834306074348AD27CC1D58EC9FE4D8D2F5D8BC69757CEE0CBADD4CAD6A12136508734886FBA71405B67A86DA3555B4764453492215A314905CD44E6F550CC6B4A70441FD44866B55AD93AD83E38C7A9CD4E1A41781B72DE9F889C43E2F8164C178D5E4EA3F0D18B03E0B655279F9D24F91AC52ED4554F12D4E19F16505F80E526864CBB489D60DD796F9F9FA02977BD091E6AE3A98FBEAC4DCDEDD7E8C259C225E83C44AD5AC3FB142DFF8836E979E89EC1E5EC2E5D9600D1CF5B2FD00760059D93E51224C9056466E09E469B306DB77F400A6B6847FF89FBECC141DDA3C540B880E0C60056B35E40B815184B915FCBD4B42D31BE8DF4F02DEB09B0CD8BE5B816754C313DF51D2FE05BDED4B2755F56AD91E4D7601665413553DBE153B4F2049B04BA87B2AA18D5BC8612D5A29A29AA68693F89536FA9B323C32AE3332AB58674DBB03CA3DBD09491BE00C7C5800B369F64256658BC7276F3C9AB648CAE70BF4EB300B377E756507252B33D7D83FDB19EE1ACDC210BA9AA6D3893DB3363AB196FFE364CE6EEB7C6A73140ED580BA4A9D7105A5D29ECBAAD17129F4B04A7B226E895302F34F60B2295F011CED31278CFB559DAD4842A977D2B9B1D85311AF5E67810EA982ECC2A5A1BCA8D2F6DFF8655734A8A236572B58EFAC86C1EFB611F19D8F1C77D8C5D6F0EE5FDCBA68F50885DEDA4B39E7E77FC8DEDAE1A49436656DB97860CECF8A52143B38C0CD50A862A2B43F05AF5F971566A99A330EB5B1C8861F6DD793F3A40DF7A566FD49A18D56AA8DF6C6DBD350323655BF378781B506C5775E99C602C3053AF46B33035D27FD0244A8D84F04D627A971834036877DB7AA73B62D16BE42C6362BF641E353DF1D90402A74E6EB85E2617BEB3AA6FAC184B537EB58671037413707C1742FBC27F85B35CF8085E533AD2F80AA0F3A69A670B1FC8451467C7E699110DF962979962A2E1DDDA454242289AA2E9BEA2E9691404B0C39B90D7F840D1383F7AA8AAFFB4CB4E733EA1F8C7932489965E467ACE259CE20A05D9E979E84ED4F72904A1DD932B38591E7290C22F9096535AB9DD8467C0072998A0480F7449E9D449968ECB8A151C8E6B8058E5F66411ABEF6690C8FDC0F409352E885123071D182790DBBC3065D5B3172EBDB5E32BA944B5D454ED68EC551F74C91958831075A8A4844EE7FCAB180881AA1F6A5254143A9A631C2767447E98AE68CA1531BBF5ACB3B1EAAA595775C2612DE61206CDF656384B8A4E0FCC25A5F9E8F9AB0ECF144D372756B39EE26C49D0671DCE1D0C6D76F981D6E4DA63E4C67F8950940783D5D8B21190FA6490076D4AA96B49686418F420333222EB745F840D0E2231FC2301D1542BCE07F8C74026BCA488EBE08A576E4A937DECCE6696784B8A510FCC2525B94EFFF801D8F02C569CE668CD3F7DB46399BDE8401C6DE6EA82B34864FAE62B92D25A3A2B1A94A704E14CA27957C536194C7D279B1B4550956083531C4376B2C39153AC07FE949344078151316811C4A6CB007444DBD818940AA51330687132D80B8392141B804149928C9E41B5CF02846BA9F1C100B67EEB9C87192CEBC60194BDAFF58618F6610018CEDFE8399AEB6217BA7DA4FE76CCB5449F2F197896A4F1AF7D73A00C9B3EFC4A127A8F9EB3F851C4BA6BA5D0DD348EA55CE8C1EAC9972E25D700EB38418FD1B3263F625CDB5527527B56FD81C32A3E293A437807B74AF5715F1810AE78B29704BA3AAFE9DDDB2CC3A08F955442E471799BF3180474E20E5BD467DAB5D49F3D64C7F12F2927D000727D116B90145119344720E00B90927780EAB807EE5135C35624107AC99301AC974505507AC2784059895000CD5F0B63E0645CAF684A2B241E1C56FF6B00E5016274BC020EBE15E1C1233DBF06D3595E7894CE67E15133005B5E4E94822DFC20AAA1AB37645C8AE8ECA5552CCADCF7633994DE085120311DC0520A0B3C996015C52F7CD2CA492B40A51A55A50D1825A7154F82C1E12804DAD42607AE41147E1004872E1AD112F2A5918897A0A843B1958452F2080915D11B10087B6489258AE0889FC0983DE4C7B0CC35A764BCECB17E0763E49EE27386AB3EED97DBDEB805860D83B3064828223DE15790B6016D04D7D458E2681C5E937E42E9F13536106A159290467E604D51DC3A71CABB710AD2F00E5DC5A3A08E5DDB93853A68ED8028A2D70D58BAE81C1C9A1C1DAA066372CC275877CAC158A75269BBA8A9C43BBD3239BF6A4525EAAC4940A57230ED054CFB920447EA1A1DAAB43B56C1E553CB829489ADE9414A07B2CC8F94E758474A77BFBEC31F5FE0195358661AC95CFC3DE839A195A4E1B136F059B7125FA129D5856DCD7787EAD8550AF6917B4EED59569D4B17CF9FA7B3F790DB9D52CF9FBD9D871DBBB3BC1D5379A6AAB2A3799E0AA6F8703417E48C39BA72D66B2F5C6139648A2F93459E40E6F4C7857936952087315F12A24AFBD1AA9ED2287656802A45374E5C70E1C5498A92D63C38E81ACFA91B30D5B87E38819BA0EC1277B5B1D3567A0CCADAE8EFF2510FF4F7CDE377F2BC3A8427E07B8E37B3807C01C78D2ED56424001C95C2DB286700164BC77762CEB5B9D3C8DF04A1D8412B6E9D3FA886B7CFBFB0108EE614FE8C0B96A1A11191E5B4A503D2B783BA646A081C0E59C28508B9DAF5B2C38CE2021513948F033CF390A209BCD081E31EDFFCC9A93FF4E431A426FDEEBDD2B92CAF1597965A63ED910E66AF3A35683E836210A2592C4F10F159109D2A8AA1A03E6928E5B7D14C226B60589C44E694C67C12D520BAD1A38277B67180822A5D3188084A713E8903111C590EC66499BD6991AF38B6B5062B715B75C33D44060B1C0C51D0001E6B3C5145FA30A9EC14C460C922239875920A0A625DA00F0FCB548143C33E8F86C7D97DAC4586678E97CDB95F0D627B15A99DF57A0B14A9E8B0D7C62687E7D0D1E02B25848E346CFE2E3EA109F34F8630B0A7D5196058993E54F2F57B1C265962A005C927EE094D48161960893F644F208917348227A028BF868178324FD71392CA94EA43E63C628F83E6143780CDC1992ED387CA79E71E07CC293653A6AC99517F1D8D32244F572D2A45621932D788F2E6DDA8C3EAED631C44F5B181A189BD7DCCB536B17203D71FF37E12E106644A4D0C4FFA1564D2FAA44BF521E3D7C17198B26BE26268F535604279092F078FC2B9233CF3B7E2DDC96308DBB9770430BA91353BD626F6FA2D21B3F5674358C5FBB60CB0E2FB28394B18276185B3F230D2769C2580215EEE893764C9D55EFAF0AD1826F1302C6151C91EC615C333E3DFA116779DD00C9B6BBE4654700353A009D48E8EDDC8F7278985972C7A639CC404A8D874705341DE0DFCDB2A08DBC30DF5B3A48443BBFABAAD7C45C645309EED32A8C8C47B5DB6E1B8A815C7CE28DA83F55BA92E816A7190F0A213D6A50936C22B5E5AD8880E42C4E8D0112CEC6432812C74958A958A2FD5EF2A90A5082221A25BB221A158956C284911D0424795E455A69392118EA78BD7240541CE1E8B3FFD53DF0368AB5E56B87242EF112469FE82EB747F776F7F3A39F13D27C9638E8A789943FA2A985600CDDE010AA0016E30A79B9B87E1202849E212CF368B5320B05CDDC703CFE1B3132F9F9C987DDED8349B8F53E703AC8132D7F12E4317BC1C4FFF99B53ACCE2B3D05FD9E79DC96572177A7F6E60C16DBC01937FB129050DB122833B72EC1EBC1487A39328830A356845BA46B9319A3287F0CEAFEE839B6A5E2ABB309DFACB7FDCE74D7726D999D5E164979AF0266C588EA2013679D316D8E83F362F3DBCEF43EC3DA450952FB71BD25E9A839B92BA4E2793A66FAE540A1D534CEFBE42DB34613E226F7746621B98EEF130B5C388EC25FC6DE53D2280406B020C692AE992BFF4B55CB9A85883E642448418340783C51660E4B5C386F233F8ADE549EBFAB0E9524BD377BCFA5007D30EF5A1F4D07EABCCF1E2D05F5F29E998C1F4E17F734E268FFC492CBF0B9C97EF4D51E3A6BB6F059193D2DE163C2B2414A5AC6F024B98AE1EA52B49A9143A3A83E5A7AF6F829A3075BD7AFDE12BD0661BD5B2A59D8D6AB374C96F6355A4D211F338AC653AE2269C214A460C4DB0D726F044E9879B88009B7AD8685F5B37D7DDDB3649526C8452D9B88FCDB6E23C7C6BE5685C7E1726696DABB5924D4C6B00AE45F2D9069CB165795BAD19989FD9B4ACD6600FC9DA5673B1BE0D4DC34DD1A8B59DC35ADADFD5D9E31B0334DB6F931BA724FD7F67268A1E5D31119D45B4B181DA941B35C6D92317AA8EDEF5185174866EEF18CADCD784EC50D4885C2CDEC07993B5C49D63C9D5593F91CAC1A72EEC3C45679F59392517BC75856632D0D3CE1C25D19ABFE8B9143FEED2F285E8AD60128D0BE4236312793016F96AA6FAFDED4EB40D67A5A310618A3B6126FE2D6EEB3CA48EA9335AC9FB65225E0CDD4817B1B1B055DF3AAA217F0DAAA5D4AFE49A6A2AF1BAC53E8D8EC1620BB759D5685CD31F97A231CB66CBBC4D8F4DA422370937BF2CFFF9DB16894B6DE4D3E93B97E8DBCB49DB824DBEF148731ED9EA0CB323C8F3C5C96B21D885F79847B6EF9DB8E832AE41C4F5F8B3C58E8CD98A6C270266EB31276CDFCC26BA9F3B32666B9DF9B5AB055127910DBE4EDA4822BB2D7CD6EC3EEFC838CF28436B475CC6E431C2BD8EA6C95EB7857BD4F77A47C6291AEFD76FCD7A38D409C8C0ABA1B6E7685046D3C803D0BD4E1A834B69006E69E45E1A7601E32424E8CACF3886F3B19EFC8C8D8EC586CE63CAA659A067B27806817396AFCC539A5FAE3F9EBA0F119CF73C92E024595F83B4786981611B7E67F51223ECB0AE22EEB47E125DD531CB984CC76C155EC7EC43DEAAAE33F9627ACBBEF23AE0260DA161B2CA97E980ADC2EB4D991686E99A594F989E991AF2095477497A1E99FEC8625E67D20471EAF4AC7AD959E5A314644B93F55DB824A47D1775E47D0B72903164D6D9B8B2D4D769C59D940659C15419627512C472A55A915D8B27D4CC312B4FC6994A229DC2CB903C44EE5A6E2AACBC8059D264FB0A0E94BA90DEB18C27576D7B5288561A7E9A85F6A46093CA4A92D30A9E2EA2AD430C630E5FD2F50582207A69C9E690CBA45BB221F3DF47B23AE74310811B5BD03E53AFE9FC8B2C11FE63F8ED87DD59125E815DC37D7C5D46109EB1C2BE576C9910B612EE6E1B1104A7A11D24D86D4C0AA13529785DD73E51BACBA76B852884992B7818D682B80C9B3ED79A60E9DBE8DA2FA35A30C7BAC98D6B8B68824D02F76150FBE2573828AC27C3B5227C7D18EB7C5FB685E4B7B608D2B70DC375D7B64F766B6ABA75B55331C863CB3EF37934FFB209D1FDB8FCD71948BC550D02E5730CC192F08456752EC3C7A8F4C752189555A8DB565720755C277590F03F3ACB1416A3D741BC1012AEC817791E3C00F732BCD9A4EB4D0A870C82079FB8678D1CBBB2FEB364BD24CE4737B977C3C610209A1EBA5278137EDC78BE5BE17DC1B9DF2500813CC6C58D4C349729BA99B97AAD205D33C9C944800AF2558EEE5B10AC7D082CB90917CE3368821B94BE4F60E52C5FEB8BE72220EA8920C97E74E639ABD809920246DD1EFE843CEC062FBFFC0FCDE1707E25E00000 , N'6.1.0-30225')
290END
291
292IF @CurrentMigration < '201611170709078_IdpRoleMatch'
293BEGIN
294 CREATE TABLE [dbo].[IDPRoleMatches] (
295 [Id] [int] NOT NULL IDENTITY,
296 [ApplicationRoleName] [nvarchar](max) NOT NULL,
297 [IDPRoleName] [nvarchar](max) NOT NULL,
298 CONSTRAINT [PK_dbo.IDPRoleMatches] PRIMARY KEY ([Id])
299 )
300 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
301 VALUES (N'201611170709078_IdpRoleMatch', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1DD96EE4B8F13D40FEA1D14FBB8BD96E1F3B93CDC0DE85D7C7C6C8D81E4C7B16793364896E0BAB967A25B5C746902FCB433E29BF105227EF4B945AED0C0618B845B2582C56158BC522EBBFFFFECFD1CFCFAB68F204D22C4CE2E3E9FE6C6F3A01B19F0461BC3C9E6EF287EF7F9CFEFCD39FFF74741EAC9E27BFD5F50E513DD832CE8EA78F79BE7E3F9F67FE235879D96C15FA6992250FF9CC4F56732F48E6077B7B7F9DEFEFCF01043185B02693A34F9B380F57A0F8017F9E26B10FD6F9C68BAE92004459F51D962C0AA8936B6F05B2B5E783E3E9659CA7DEDD35F892DD2DC21CCCCEBCDC9B7D4C93A73080D84D272751E841AC16207A984EBC384E722F8738BFFF9C81459E26F172B1861FBCE8F6650D60BD072FCA403596F76D75DD61ED1DA061CDDB8635287F93E5C9CA10E0FE6145A739DDDC8ADAD3868E9092E790E2F90B1A75414D48C800149F3E25112400DDE1FBD32845958FA7574D1727D9FA1AE4B3BAE1AC04799142705F92F4F7190EF1CD44BBDD9B86AF0E667BE8DF9BC9E926CA3729388EC106CE76F466F271731F85FEDFC1CB6DF23B888F0FF7EF1F0E7F7CFBCE0B0EDFFD000EDFE223856385F5880FF013E4903548216EE0A119FF743227DBCDE9864D33AC4D4915C84B5044A6932BEFF9038897F923149E831FA7938BF01904F5978AB93EC7219428D8284F37F0E7F5268ABCFB0834E573699FE87F49AF076FDF39E9F5DA7B0A97C5D453FD43C14172F509444569F618AE4BF122E6FBAEAA7691262BF49BE4AFB2F46E916C521F0D261156B9F5D225C849EC8EE62DF36AB13402E59EAD6BA8E3676D8429CBDEDCAA68403692507731B434D4F8F6DBAF36C79DACD770F20AD652311CB370C16A613CA320BC99F0EBB59CB437DBDF9BBD9DEDFFF0EE2F1AEC14C3614E27BF7819A828460BEE544AEEDFC22C8444BA8C7FFD7C5913FD970436F3E20E2A65B1B9CFFC345C17FA84AB5A106678ADBB92BAAD76E15668B447AD60F8B56A35A48BEEADB7E463090B0A8884DE6B3E32D8B4253C0CB4798E1E9405D3D1207AE1BAC1D7643886C3030E5B628459E4490A7E053148BD1C041FBD3C0769DC2E1C2AEDF3372F3BF1F3F0095C2779F85089ADB15C6C45A5B1FD427654D34E57464AF97427C9B4A92097770349D643B2A828C11189B2124554A9933D5360612CDCB0D55779D693E7F37508ED9827DC94D1140411A081AC759A66855A8A9727511283AEFA08027BF2C2A24557508B24CD6F52B83177A966ACD6625A58D955DA04050B034647A328CD175CED98ECDFD4F8D2B5687C79E50CBEDC4A9D6C1D1AA2853AA4417CD58D5BB475B6B56D746AEB88AC082B19A2159354D04C645E0FC5B2A60447F4418D6451AB93AD83ED834B9CBAECA41184D721E7C389C839244EE4C074D1E8E534891FC2740582AEEAE4A397655F923480BAEA51823AFCD301EA0BE06F52C8B48BDC5BAD7BEFEDE32334E5AE37ABFBD6781AA22F675373FB25B9F07CB8049DC7A85567781F12FFF764939FC7C1195CCE3EE77E0D10FDBC0D57FA009CA073E2FB20CB2E203383E034D9C479B7FD035258DB76F49F044F211CD41D5A0C840B086E0C6035DB05845B81B114F9B54C4DDB1AE3DB440FDFBA9E00DBB2588E6B55C714D3D3C80B577CCB9B5AB6EEEAAA2D92FC1ACCA22CA8666A3B7C4896A1609340F7505715A35AD650A25A553345152DED27691EFA3A3B32AC323EA3526B48B70DCB33BA0D4D19E913F0020CB860F349566286C52B67379FBC4AC6E80AF7EB340B307B776E052527D9EDE92DF6C77A86B372872CA4AAB6E14C6ECF8CAD66BCF9EB3099FBDF1A9FA600B5632D105BAF21B4BA72D875572F243E97084E634DD02B615968EC17442AE117384F3E089F5AB3D4D684AA977D279B1D85319A0CE67810EA983ECC2A5A1BCA8D2F6DFF8653734A8A236572758EFA286C1EF7611F05D8F1C77D8C5D6F6ECBFB574C1FA110FBDA49173DFDE6451BD75D5949436156BB978602ECF8A5A140B38E0CD50A86AA2B43F05AF5F971566A99A3301B5A1C88610EDDF9303A40DF7A566FD46C8C6A35D4AFB6B6DE9A8191B2AB79BC7D1B506C57F5E99C602C3053AF865D981AE93FB0895223217C9598C12506CD00DADD76DEE98E58F4AC9C654CEC97CCA36667C79D7D44A0AFBCDC7FB4901DBCF957C1D1131C2A145B711EA36BC59B7A59CA891BA273312F6E56020763B989BACC2E226FD9DE9E32E6CEF29A17E392EA27F8FD730C6DDDE80592B0F257BDE474D4FB1540679FADFEACFC7117495A8470141B3AA8A3F698C9231A7E5E0788EF8845AF6A7AA0687A9AAC56B0C39B98D7F850D1B83C066BAAFFB0C74E7339A1F8C7932C4BFCB0203DE74258759D87ECF43C0E26EABB3D826B06932B3859211230F805D2724AEB8B9BF80C442007131475842ECC9D7A99EF05ACC0C0E1040688352E7816B1F69E1089DC774C9F5089811435F250F04206B92D8C7356E385B11FAEBD484925AAA5A6B644636FFAA04BCEC01AC4A8432525743AE75F0B420834FD5093A2A2D0D11CE3383923F243C64553AE881F6F679DBD37A19A7555271CD6622E04D16CEF84B3A4E80CC05C529A8F9EBFDA5061D17473E286DB292E96047DD6E1DC07D26697EF684DAE3D466E2CA208457960628B2D1B8DAB4F067900B194BA8E844686C100322323B24EF75508EB5624867F3C259A6AC55915FF48D284971431465CF12AB775641F7BB39923DE92623400734949AED33F7E18BB7D16AB4E16B5E69F3E6674CC5E7450983673F5C159243243F31549692D9D956C95A704A175A27957C5D9194C7D2F9B1B45809F6083531D89F7B2C391536C00FE94934407815131681550A9CB007474E5D818940AEB143068754A3D08839214DB02839224193D836A9F4B09D752E3432A6CFDD6399B3558D68D8379075FEB0D311CC200309CBFD17334F7B847E8F6919EFD60AE25FAACD3C0B3248DC51E9A0365D80CE15792D07BF49CC58F68D75D2B85EEA6712CE5420FD640BE7429B9B6B08E13F4183D6BF26F2F68BBEA446ACFA93F70BB8A4F8ACE36BC833BA5FAB8AF5D08573CD9AB167D9DD70CEE6D966130C44A2A21F2B8BCCD650C023A71872DDA33ED56EACFEE8BE3F8E79C136800B9BE8A35C8AA90079A2310F005C8C9FB686DDC03F7A89A612B1208BDE4C900B6CBA202283D613CA0AC442880962FD731700AAE5734A515120F0EABFF3580F200313A5E0107DF8AF0E0919E5F83E9AC2FDF4AE7B3F2A81980AD2FCA4AC1567E10D5D0D51B322E4574F6D22A1665EE9EB21C4A6F845444C2C2D4F8724484C151D0308DC2D21D0B63996015C56FD7D2AA4E2BDCA51950A35B1895A9159D82C1E1A817DA702707AE41147E4805872E1AB117F2859688BEA0A84331A98452F2780B15D12D08843D1FC6124510304060CC860C6058967A58325E3648A0873172630238C355C70EC82D79DC9EC386C15951241491C60B28486B411BC1054C96381A47E1A4D7517A188E0D845AD324A4911F7F5314774E9CFAD6A78234BC235CF128A843DCEE64A18E6D7B208AE8DD0E962E3AC790260791AAC1981C1A0AD69D7A30CEA9545B426A2AF1CEC24C4EC33A51893AB91250A91E4C7701D3BEFEC3913AAB239A6E8734B87C6AD9A332B1353D96E94196F9774038D691F2F040FFF8005FE019C35A661AC90E0C06D073422B49C3FF6DE001EF24BE4253AA0FDB9AEF5CD5B1AB14EC23F7C3BAB3AC7A972E9E775067EF21B73BA57E44773B0F3776677DD7A6F173356547F332C951F5E1682EC8867474E5ADD761BCC4B223555F268B3235D2E9F70BF33C41AB12C6DC274495F6CA353DE549EA2D01558AEEAF04E0224CB31CA563BAF7D0A5A0D360C554E37AF5041E82BA4BDC71C74E5BED2EA86BA3BFEBE76AD0DF370FDFC83346119E806F39BED10AF2051C37BAA253900070540A6FA35C0058F85EE4A59C7B6DA749B459C56277AFB875793B0C6F5F7E61211CCD29FC19872E43432322CB694B87B7EF0675C9A427381CB2840B11727510164723D5752C26C41F0778162245B30A630F8E7B7CF327A7FEB6278F2135E9C51F94CE7579ABB8B4D41A6B8FF4307BCD1984FD0C8A418866B13E8FC467417446298682FAA4A1D4DF463389AC81E1701299331FF3495483E8478F0A5E90C7010AAAF4C5202228D569270E447000BA35262BEC4D877CC5B1AD355889DBAA1FEE2172B3E06088020B78ACF14415E9C3A4F2AE1083258B8C60B6E95728886D813E3C2C070B0E0DFB3C1A1E67F7B10E199E39AC36E77E3588DD55A46ED6EB1D50A4A2C35E179B1C9E434783AF94107AD2B065C6074213969F0C61604903186058993E5432AF030E932C31D08264F206421392450658E2291A0824F1022B78028AF26B1888279394819054A6541F32273D030E9A536C019B83335DA60F9593C10107CC293653A6AC99D17E1D8D32244F571D2A45621932D788F2E6FDA8C3E6556F1C44F3D1C2D0C45EF5E65A9B58B981EB8F798D89700332A5268627FDBE37697DD2A5FA90F1CBE5384CD9A57331B4F65231A1BC84578D47E1DC119EF93BF1EE941189DDDC3B0218FDC89A1B6B137BD79990D9F6B321ACEAE5660658F57D949C258C9370C25965506A37CE12C0102FF7C4EBC8E46A2F7DD2590C9378F298B0A8644F3E8BE199F1EFB616779DD00C976BBE468CB185296003B5A76337F2655562E1258B5E192731012A2E1DDC54C8B8857F5B056177B8A17D70977068375F5F195F51E1FF2ED730FCDE80C5F2256DDE0F3F719F9F25B6A4BC0A06F63DFEB22C81265E303C6F903133CCA9471D706672B251B7E11C5F284212502410EBD3545D37D6E206E1953AAC4B136C849709B5B0111D9289D1A1A39BD8C964829CE82A0D2B555F9ADF4D9053156044443E154342714CC550B22AD8898E382AAB4C2735231C4F172F590E56257B2CFE884EA31020374E5DE1CA8BC30790E5E55BC1D383BDFD83E9E4240ABDAC8C47AB62A9DED3970EB582ABF60F517015085673BAB979881682926501F1E6B638F10BCBD543BCCE1D3F79A9FFE8A5ECA3EEA639CCBCF6E1EB162873F1F3320EC0F3F1F49F45ABF7935A7F159FDF4C2EB3CF71F8C70616DCA61B30F9179B48D5102B32F0A7C4EE3ECC71383AE981A830944EA4B3CA0864CB1CC2DBE5BA4FBBAA79A9EEC274EA2FFF7157367D3329CE33DF4FF6A809B761C37A1416D8944D3B60A39F62431AD83184D88748A12A9FDD37A4BDE02C932B75BD4E264DDF52A9543AA69ADE0385B6B161BECA52C048EC02D37D1EA66E18917DEE6157798F082ED19A00439A4ABAE42F7D1D572E2A0EC55E8888F0137B3058DC09465E376C288FCFD8599E74AE0F6D975A9ABEE3D5873A98F6A80FA5011D3B658E570121FA4A49C70CA60343EC39990C0721B1FC66E53D7F6B8A1A150CE20022110CE2169E1312B2511FF6B038611E2530941827A71287E90C960EEFB0478D13CFA1BBFEF015A8DD46B56EE966A36A9724FE75AC8A5412761E87754CC26EC319A214ECD0047BB181274ABA6E23026CC275A37D6DDB5C776F6B939ADD08A5BAF1109B6D45ACC4CECAD1B8FC2E4CAAEE4E6B259B8EDB005C8794DB169CB163D9AA9D19981FD964D4CE606F93B59D66A07E1D9A869B98566B3B87B574BFAB73C737066876DF265B2762FE7F67268A1E7D31119D3BD9DA40B5E5468D710EC885E2888A9D65416E3C86C2CCB0CD016C02D0C46D2F0D87D09B19515C83BBA34173FF1FDA1BA046E402FE0ACE009DA5ED1D4BA6DEF681640E3E6D61EF097A87CCC92B7990415768265B7AD89DA3243AF3173D97E2C7983ABE0FBF134CA2F1E0C3C898441E2047BE72AB7E7DBF176DC359E9284498E25E9889FFEA82731E52C7391AADE4C332112FAE71A48BD858D86A681D65C95F5BD552EA57AD4D359578DD62132360B0D8C25D56351ACF6A8C4BD198E5B26632536013A9C84CC4CD2ECD7FAEBA43DA6217D9B486CE24FCFA3252776093AF3C62CF233B9D5F7A0459FE38596D04BBF001B3480FBD13175D9E3788821F7FAEE891315B95EB48C06C0366841E9AD944F7E947C66C9DF33EF7B520EAA4B1C2D7491729A47785CFECEEDF8F8CF38CF233F7C4654C1633DCEB689AEA7957B8477D0F7F649CC24DFAB0A3EBE1B64E40B6BC1A6A7B8EB6CA681A793BFAD7496370296D815BACDC4BDB5DC0E823B31EFD8C63381F1BC8CF68752CB6ED2CC66C5A147A26ABA7293867F9CA2CC5E58307C7D3E03E81F35E46129C64EB6B9057AF5F306CC3EFAC5D62841DB655C49DB6290C541DB38CC974CC56E1754CD752775DC817D35BF195D70137C90F0D9355BE4C076C155E6FCA344E4CD7CC7AC2F4CCD4904FA0BA4BD2F3C8F44716F33A932674542767D6CBCD2C1FA520BBA1ACEFCA2521EDBBAA23EF5B90339021B3CEC695A5BE4E2BEEA45864F153E587D6490FCD956A45363C691269650A695E8F74166AB512618E75793A85A924D261BC7CECDBC86DCD4D955716304BA86C1FC381D216D23BA4F1E4B2EE4E0AD1CAC64FC3D29D146CD26949F26AC1F355B4358A61CCE14BBABE401044AF6DB91C729D944F3664FE1B594EE77C1B44E0C63274CFE46D3AFF22CB879F2CA3FBB07B4BD22DB0A3B8C9196404E11947EC7BE68E09E12A21F7AE114170FADA43026E6B5208AD57C1EBDBEE89D25FBE6D274421CC6AC1C3D10EC465BBE9B59D0996FE9E40FBE56407E6583FB9B35D114DB029E13E1CEC5EFC2A8788F364D94E846F08639DEF3B77901CDB154186B661B8EEE1EEC9B04D4DB7BE762A0679AED9A75E8FE69F3631BA2359FE3A0359B86C41A07CAF31F009CF6B53E7327E486AFF2F85515D85BADD7505722FF0720F09FF83E7E7B018BD1013C69070553ED9F3D53D082EE39B4DBEDEE470C860751F1177ED912359D67F91CC9BC4F9E8A6F4A6B81802443344D74A6FE25F36611434785F70EE930940200F75752512CD658EAE462E5F1A48D74CF24211A08A7C8D63FD16ACD6110496DDC40BEF09D8E006A5EF03587AFE4BFBF88008887A2248B21F9D85DE32F5565905A36D0F7F421E0E56CF3FFD0F573FAD9E1FE70000 , N'6.1.0-30225')
302END
303
304IF @CurrentMigration < '201611290712234_TagColor'
305BEGIN
306 ALTER TABLE [dbo].[Tags] ADD [Color] [nvarchar](max)
307 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
308 VALUES (N'201611290712234_TagColor', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED1DD96EE4B8F13D40FEA1D14FBB8BD96E1FBB9BC9C0DE85C7C7C6C8D81E4C7B16793364896E0BAB967A25B5C746902FCB433E29BF1052478BF725EA686730C0C02D92C562B1AA582C1659FFFDF77F8E7E795E459327906661121F4FF7677BD30988FD2408E3E5F174933F7CFF76FACBCF7FFED3D179B07A9EFC56D73B44F560CB383B9E3EE6F9FADD7C9EF98F60E565B355E8A749963CE4333F59CDBD20991FECEDFD75BEBF3F0710C414C29A4C8E3E6DE23C5C81E207FC799AC43E58E71B2FBA4A021065D57758B228A04EAEBD15C8D69E0F8EA797719E7A77D7E04B76B70873303BF3726FF6314D9EC20062379D9C44A107B15A80E8613AF1E238C9BD1CE2FCEE730616799AC4CBC51A7EF0A2DB973580F51EBC2803D558DE35D57587B5778086356F1AD6A0FC4D96272B4380FB87159DE674732B6A4FB77484943C8714CF5FD0A80B6A424206A0F8F429892001E80EDF9D4629AA7C3CBDDA767192ADAF413EAB1BCE4A90172904F725497F9FE110DF4CB4DBBDD9F2D5C16C0FFD7B3339DD44F92605C731D8C0D98EDE4C3E6EEEA3D0FF3B78B94D7E07F1F1E1FEFDC3E1DB1F7FF282C39F7E00873FE223856385F5880FF013E4903548216EE0613BFEE9644EB69BD30DB7CDB0362555202F4111994EAEBCE70F205EE68F50780EDE4E2717E13308EA2F15737D8E432851B0519E6EE0CFEB4D1479F711D896CFA57DA2FF25BD1EFCF893935EAFBDA770594C3DD53F141C24579F405494668FE1BA142F62BEEFAA6A1769B242BF49FE2A4BEF16C926F5D1601261955B2F5D829CC4EE68DE30AF164B2350EED9BA863A7ED64698B2ECCDAD8A0664230975177D4B438D6FB7FD6A73DCC97A0D27AF602D15C3310B17AC16C6330AC29B09BF5EC349FBB3FDFDD9C16CFF87BFECBD55B3530C87399DBCF73250518C16DCA994DCBF855908897419FFFAF9B226FAFB0436F3E2162A65B1B9CFFC345C17FA84AB5A106678ADBB92BA8D76E156D86A8F5AC1F06BD56A4817DD5B6FC9C71216141009BDB7FDC860D394F030D0E6397A50164C4783E884EB7A5F93E1180E0F386C891166912729F815C420F572107CF4F21CA471B370A8B4CFDFBCECC4CFC327709DE4E14325B6C67231884A63FB85ECA8A69DAE8C94F2E94E926953412EEF0692AC8764515182231265258AA8522B7BA6C0C258B861ABAFF2AC27CFE7EB10DA314FB829A3290822403D59EB34CD0AB5142F4FA224066DF51104F6E485458BB6A016499ADFA47063DE8EBAA74994A412AAC23FB5A86AA2CCAC567C5A25B0B680090A1666928EDE521A49B87233D925AAF1A56BD1F8F2CA197CB9955A595434440BA54B83F8AA8107B4A886DA9C3AB5A844B68A950CD18A492A682632AF876259538223FAA046B2A8D5CAA2C276DB254E6DF6EB08C2EB90F3FE44E41C122772602069F4729AC40F61BA02415B75F2D1CBB22F491A405DF5E8DE0AA14D26E06F52C8B48BDC5BAD3BEFEDE3233418AF37AB7BD0817D25EECBD9D4DC7E492E3C1F2E41E7316AD51ADE87C4FF3DD9E4E771700697B3CFB95F03443F6FC3953E0027E89CF83EC8B20BC8CC20384D3671DECE8E460A6BE8E38493E0298483BA438B817001C18D01AC66B380702B309622BF96A9695B637C9BE8E15BD713605B16CB71ADEA98627A1A79E18A6F7953CBD65D5DB541925F83599405D54C6D870FC932146C12E81EEAAA6254CB1A4A54AB6AA6A8A2A5FD24CD435F67478655C667546A0DE9B6617946B7A129237D025E8001176C3EC94ACCB078E5ECE69357C9185DE17E9D660166EFCEADA0E424BB3DBDC5FE58CF7056EE908554D5369CC9ED99B1D58C377F1D2673F75BE3D314A076AC0562EB9B8456570EBB6EEBEBC4E712C1D95A13F44A58161A7B1F914A780FE7C907E1536396DA9A50F5B2EF64B3A3304693DE1C0F421DD38559456B43B9F1A5EDDF706A4E4971A44CAED6B12585CDE33EB8A4003BFEE892B1EBCDA1BC7FC5F4110AB1AB9D74D1D36F5EB471DD9595341466B57B6928C08E5F1A0A34EBF853AD90ABBA3204AF559F1FCDA596390AB3BEC5811866DF9DF7A303F4AD67F546CDC6A85643FD6A6BEBAD191829DB9AC7C3DB8062BBAA4BE7046381997A35EC82E148FF814D2C1C09E1ABC4F42E316806D0EEB6F54E77C4A267E52C6322CC641E353B3BEEEC23027DE5E5FEA385ECE0CDBF0A8E9EE05001DF8AF3185D2BDED4CB524E5C1F9D8B7971B3123818CB4DD465761179CBE68E9631779697C91897543721F69F6368EB462F908495BFEA25A763EBAF003AFB6CF467E58FBB48D22284A3D8D0411DB5C74C1ED1F0F33A407C472C7A55D30345D3D364B5821DDEC4BCC6878AC6E531D8B6FA0F7BEC3497138A7F3CC9B2C40F0BD273AE9D559786C84ECFE360A2BE4124B8CC30B98293152201835F202DA7B4BEB889CF40047230415147E85ADEA997F95EC00A0C1C4E6080D8D605CF22D6DC462291FB8EE9132A3190A2461E0A5EC820B78571CE6ABC30F6C3B51729A944B5D4D49668ECDB3EE89233B00631EA5049099DCEF9978F1002DB7EA8495151E8688E719C9C11F981E9A2295744A937B3CEDECE50CDBAAA130E6B31D78E68B677C25952747A602E29CD47CF5F4DA8B068BA3971C3CD14174B823EEB706E1D69B3CB77B426D71E2337165184A23C30B1C1968DC6D527833C80584A5D474223C3A00799911159A7FB2A84751089E11F4F89A65A7156C53F9234E125458C1157BCCA6D1DD9C7DE6CE688B7A418F5C05C5292EBF48F1FC60ECF62D5C9A2D6FCD3C78C8ED98B0E0AD366AE2E388B44A66FBE2229ADA5B39241794A105A279A77559C9DC1D477B2B95104F8093638D59178273B1C39C57AE04F39497410181583560195BA0C4047578E8D41A9B04E018356A7D4BD302849B101189424C9E81954FB5C4AB8961A1F5261EBB7CED9ACC1B26E1CCCDBFB5A6F88611F0680E1FC8D9EA3B9C73D42B78FF4EC07732DD1679D069E25692C76DF1C28C3A60FBF9284DEA3E72C7E44BBEE5A2974378D6329177AB07AF2A54BC935C03A4ED063F4ACC9BFBDA0EDAA13A93DA7FEC061159F149D21BC833BA5FAB8AF5D08573CD9AB165D9DD7F4EE6D9661D0C74A2A21F2B8BCCD650C023A71872D9A33ED46EACFEE8BE3F8E79C136800B9BE8A35C8AA90079A2310F005C8C9FB684DDC03F7A89A612B1208BDE4C90036CBA202283D613CA0AC44288096EFE331700AAE5734A515120F0EABFF3580F200313A5E0107DF8AF0E0919E5F83E9AC2FDF4AE7B3F2A81980AD2FCA4AC1567E10D5D0D51B322E4574F6D22A1665EE9EB21C4A6F845444C2C2D4F8724484C151D0308DC2D21D0B63996015C52FE4D2AA4E2BDC653BA0AD6E6154A656740A0687A35E68C39D1CB80651F821151CBA68C45EC8175A22FA82A20EC5A4124AC9E32D5444B72010F67C184B1441C00081311B32806159EA61C978D920810EC6C88D09E00C571D3B20B7E4717B0E1B0667459150441A2FA020AD056D04173059E2681C85935E47E9613836106A4D9390467EFC4D51DC3971EA5B9F0AD2F08E70C5A3A00E71DB93853AB6ED8028A2773B58BAE81C439A1C44AA06637268285877EAC138A7526D09A9A9C43B0B33390D6B4525EAE44A40A57A30ED054CFBFA0F47EAAC8E68DA1DD2E0F2A9658FCAC4D6F458A60359E6DF01E15847CAC303FDE3037C81670C6B9969243B30E841CF09AD240DFFB78107BC95F80A4DA92E6C6BBE7355C7AE52B08FDC0FEBCEB2EA5CBA78DE419DBD87DCEE94FA11DDED3CDCD89DF55D9BAD9F6B5B76342F5329551F8EE6829C4B4757DE7A1DC64B2C0753F565B22813309D7EBF30CF46B42A61CC7D425469AFDCB6A73C49BD25A04AD1FD95005C846996A3A44FF71EBA14741AAC986A5CAF9EC0435077893BEED869ABDD05756DF477FD5C0DFAFBE6E11B795E2AC213F02DC7375A41BE80E34657740A12008E4AE16D940B000BDF8BBC9473AFED348936AB58ECEE15B72E6F87E1EDCB2F2C84A339853FE3D06568684464396DE9F0F6DDA02E995A05874396702142AE0EC2E268A4BA8EC584F8E300CF42A4685661ECE509E78D8AA1E74F4EFDA1278F2135E9C5EF95CE7579A3B8B4D41A6B8F74307BDB3308FB19148310CD627D1E89CF82E88C520C05F54943A9BF8D66125903C3E12432673EE693A806D18D1E15BC208F031454E98A414450AAD34E1C88E0007430262BEC4D877CC5B1AD355889DBAA1BEE2132C0E06088020B78ACF14415E9C3A4B2BB1083258B8C6036495E28884D813E3C2CD30B0E0DFBAC0FAB4AF782C3A93E8D464ED8BDB043A1610EBCCD25480D627795B19B357F0794B1E8C0D8C54689E714D2E02B25848EB474993582D0A6E527431858E201061856A60F95CC0D81C3244B0C3429990082D0A664910196789A070249BCC00A9E80A2FC1A06E2C9247620249529D587CC49F18083E6145BC0E6E04C97E943E56481C001738ACD94296BAA345F47A30CC9135A874A915886CC35A2BC7937EA70FB32386122D51F2D8C55EC6570AEC58A951BB80F99179D085722536A62BCD26F8493162C5DAA0F19BFA08EC3945D5C17436B2E2613CA4B785D79140E2261DC80130F5119D5D8CE452480D18DACB9B136B1B7A109996D3E1BC2AA5E7F668055DF47C959C2580B279C5506B6B6E32C010CF1724FBCB04CAEF6D267A1C530896793098B4AF66CB4189E19FF0EB5B8EB8477B85CF335E2942D4C011BA81D1DDD91AFB3120B2F59F4CA3889097271E924A7C2CE2D7CE42A08BBC30DCDA3BD84537CFBF595F1157585C0E51A86DF3DB058BEA4CDBBE127EE13B6C4969457C1C0BEC75FA725D0C40BFAE70D32EE863939A983D64C4E47EA369C23104558038A26627D9AAA2BCB5ADC20BC96877569828DF042A21636A28336313A7484143B994CA0145D65CB4AD597EDEF6DA05415A444444F154342B150C550B22A608A8E5A2AAB4C2735231C4F172F590E56257B2CFE884EA31020374E5DE1CA8BC30790E5E57BC3D383BDFD83E9E4240ABDAC8C69ABE2B1DED11717B502B4F60F518016085673BAB979981782926501F16EB738790CCBD57DBCF01D3F79A9FFE8A5ECC3F0A679D0BCE6F1EC06287379F4320EC0F3F1F49F45AB77935A7F159FDF4C2EB3CF71F8C70616DCA61B30F9179B8CD5102B3278A8C4EE3ECC71383A2986A8509656A4B3CA2A64CB1CC21BEABACFC3AA79A9EEC274EA2FFF7157367D3329CE44DF4DF6A809B761C37A1416D8944D5B60A39FA6431A1CD287D88748A12A9FEE37A4BDE02C932B759D4E264DDF52A9543AA69ADE0385B6B161BECA52C048EC02D37D1EA66E18917D326257798F0850D19A00439A4ABAE42F7D2D572E2A96C55E888810167B3058EC0A465ED3A48065E00A49AA6F56DEF3B7F215599BA1E5911E3BCBDDCE35ABEDA24DD377BC9A5507D30E35AB343464A70CFB2AB4445FBDE918D47488893D27938125C69A85A3E8C8B012071089B012B7F09C90908D1FB187C509182981A1343D3995C64C67B074A0883D6A9CC810FB95AC8909B151A1EEB6BC7629EB5FC7AA48A584E77158CB94F0369C214A080F8DB9171B78A214F03622C0A67F37DA2137CD7577C93689E28D50AA1BF7B16D57445DECAC1C8DCB83C3240E6FB556B2C9C1BBD87628A2265E65EE6C6706E6473635B633D843B2B6D37CD8AF43D370D3E46A6DE7B096EE7775EEF8C600CDF6DB64EBB4D0FFEFCC44D1A32B26A233395B1BA8B6DCA831CE1EB9501C9BB1B32CC88DEC509819B619894D009A1C0048032BF466461421E1EE90D1DCFF87F606A811B980BF82D344674984C79237B879AE99834F53D879BAE03E33044B9E87D0159AC940CFCC7394446BFEA2E752FC3454CBD7EA778249349E9F181993C843EDC83777D5B9003AD1369C958E428429EE8499F86F4038E72175C4A4D14ADE2F13F1222447BA888D85ADFAD65196FC35A89652BFB16DAAA9C4EB169BA60183C516EEB2AAD178A0635C8AC62CB3369327039B48459E246EAE6BFEE3D92D9228BBC8EDD5775EE3D7971FBB059B7CE5117B1ED9E96CD723C839C8C9B123D885F798D3BAEF9DB8E81ABE413CFDF833578F8CD9AACC4B0266EB313F75DFCC26BA993F32666B9D85BAAB055127A916BE4EBA4868BD2B7C6677937F649C67942DBA232E6372AAE15E47D3C4D3BBC23DEA1BFD23E3146E0A8A1D5D0F873A01197835D4F61C0DCA681A5944BAD7496370290DC02D56EEA5611730FAC8AC433FE318CEC77AF2335A1D8B0D9D53994DD242CF64F5C805E72C5F9933B97C3AE1781ADC2770DECB4882936C7D0DF2EA1D0D866DF89D354B8CB0C3A68AB8D326A182AA639631998ED92ABC8EE95AEAAE0BF9627A2BBEF23AE0A61CA261B2CA97E980ADC2EB4D99548AE99A594F989E991AF2095477497A1E99FEC8625E67D2F492EA54D17A99A2E5A314E45A94F55DB924A47D5775E47D0B32183264D6D9B8B2D4D769C59D148B9C82AA6CD53AC9AAB952ADC8CD274D69AD4C68CDEB91CE89AD5622CCB12E4FA73095443A8C971D7E884CDBDCC47D6501B384CAF6311C284D21BD431A4F66EDF6A410AD6CFCA430ED49C1A6C096A4D2163C84455BA318C61CBEA4EB0B0441F46E97CB21D729026543E6BFB6E574CE8720023796A17D5E71D3F917593EFCB41BED87DD59CA70811DC54DF3202308CF38625F46774C0857E9C1778D0882D3D70ED2815B934268BD0ADEF1764F94EEB27F3B210A61560B9EA076202EC326FB762658FA7B02ED37981D9863DD64F2764534C1A684FB04B17BF1AB1C22CE53773B11BE3E8C75BEEFDC41AA6E5704E9DB86E1BA87DBA7E63635DDBADAA91864DD661F8D3D9A7FDAC4E88E64F9EB0C64E1B20181B2CFC6C0273CAFDB3A97F14352FB7F298CEA2AD4EDAE2B907B81977B48F81F3C3F87C5E88598308684ABB2DB9EAFEE417019DF6CF2F526874306ABFB88B86B8F1CC9B2FE8BD4E224CE4737A537C5C510209A21BA567A13BFDF8451B0C5FB82739F4C000279A8AB2B91682E73743572F9B28574CDA4521401AAC8B775ACDF82D53A82C0B29B78E13D011BDCA0F47D004BCF7F691E1F1001514F0449F6A3B3D05BA6DE2AAB6034EDE14FC8C3C1EAF9E7FF0187F6F83F13E80000 , N'6.1.0-30225')
309END
310
311IF @CurrentMigration < '201612072031585_RoleTagRights'
312BEGIN
313 CREATE TABLE [dbo].[RoleTagCreateRights] (
314 [Id] [int] NOT NULL IDENTITY,
315 [RoleId] [nvarchar](128) NOT NULL,
316 [TagId] [int] NOT NULL,
317 CONSTRAINT [PK_dbo.RoleTagCreateRights] PRIMARY KEY ([Id])
318 )
319 CREATE INDEX [IX_RoleId] ON [dbo].[RoleTagCreateRights]([RoleId])
320 CREATE INDEX [IX_TagId] ON [dbo].[RoleTagCreateRights]([TagId])
321 CREATE TABLE [dbo].[RoleTagSubscribeRights] (
322 [Id] [int] NOT NULL IDENTITY,
323 [RoleId] [nvarchar](128),
324 [TagId] [int] NOT NULL,
325 CONSTRAINT [PK_dbo.RoleTagSubscribeRights] PRIMARY KEY ([Id])
326 )
327 CREATE INDEX [IX_RoleId] ON [dbo].[RoleTagSubscribeRights]([RoleId])
328 CREATE INDEX [IX_TagId] ON [dbo].[RoleTagSubscribeRights]([TagId])
329 ALTER TABLE [dbo].[RoleTagCreateRights] ADD CONSTRAINT [FK_dbo.RoleTagCreateRights_dbo.AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[AspNetRoles] ([Id]) ON DELETE CASCADE
330 ALTER TABLE [dbo].[RoleTagCreateRights] ADD CONSTRAINT [FK_dbo.RoleTagCreateRights_dbo.Tags_TagId] FOREIGN KEY ([TagId]) REFERENCES [dbo].[Tags] ([Id]) ON DELETE CASCADE
331 ALTER TABLE [dbo].[RoleTagSubscribeRights] ADD CONSTRAINT [FK_dbo.RoleTagSubscribeRights_dbo.AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[AspNetRoles] ([Id])
332 ALTER TABLE [dbo].[RoleTagSubscribeRights] ADD CONSTRAINT [FK_dbo.RoleTagSubscribeRights_dbo.Tags_TagId] FOREIGN KEY ([TagId]) REFERENCES [dbo].[Tags] ([Id]) ON DELETE CASCADE
333 INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
334 VALUES (N'201612072031585_RoleTagRights', N'Intra_News_Site.Data.Migrations.Configuration', 0x1F8B0800000000000400ED5D6D6FE33612FE7EC0FD07C39FDA626BE7A5EDB58BA48734D9F4826BB28B75B6B86F0BC5661CA1B2E44A729AE070BFEC3EDC4FBABF70D49BC5972139942859CE05058A8D490E87C399E1907CC4F9EFBFFF73F2D7A755307A2471E247E1E9F87072301E91701E2DFC70793ADEA4F75F7F3FFEEB8F7FFED3C9BBC5EA69F46B55EF38AB475B86C9E9F8214DD76FA7D364FE40565E3259F9F3384AA2FB74328F56536F114D8F0E0E7E981E1E4E092531A6B446A3938F9B30F55724FF83FE791E8573B24E375E701D2D489094BFD392594E7574E3AD48B2F6E6E4747C15A6B1F7F986FC917C9EF929995C78A937F910478FFE8272371E9D05BE47B99A91E07E3CF2C2304ABD94F2FCF6534266691C85CBD99AFEE005B7CF6B42EBDD7B4142CAB1BCADAB63877570940D6B5A37AC48CD37491AAD2C091E1E97729A8ACD1B497BBC952395E43B2AF1F4391B752E4D2AC805C97FFA1805540062876FCF8338AB7C3ABEDE767196AC6F483AA91A4E0A92973125F74714FF366129BE19A1DBBDD9EAD5D1E420FBEFCDE87C13A49B989C866443673B7833FAB0B90BFCF9DFC9F36DF41B094F8F0FEFEE8FBFFFF63B6F71FCDD37E4F85B76A474ACB41EF703FD896AC89AC4943772BF1DFF7834E5DB4DC586DB664C9B422A5497A8898C47D7DED32F245CA60FD4788EBE1F8F2EFD27B2A87E2995EB53E8538BA28DD27843FFBCD904817717906DF954DB67F67F4DAF47DF7EE7A4D71BEFD15FE6532FF44F0D27B3AB8F24C84B93077F5D981737DF9FCB6A9771B4CAFEE6F5AB28FD3C8B36F13C1B4CA4AC72EBC54B92F2DC9D4C6BE545A97446CABD5A575487AFDA19A7B27A8355B30135B184AA8BBEADA1E2B7DB7ED11A77B65ED3C9CB55CBA470D2C245ABF9E144A0F06604D7AB35E970727838399A1C7FFF97A363B33A857498E3D14F5E424A8989863BD68AFB573FF1A990AEC29F3F5D5542FF29A2CDBCB0854B996DEE9279ECAF737F02BA968C33B6D6E742BAB577012B6CBD47E560E05A951BC2B27BEB2D612E69414E91F37BDB1F256EEA128803B4CE89836AA07422894EB4AEF735998EE1F808504B4630B3348AC9CF2424B19792C5072F4D491CD60B87C9FBFCCD4BCEE6A9FF486EA2D4BF2FCDD6DA2E76E2D2E47EA93A9A6587B591C23EDD59B2182AE8EDDDC292714CE615353C66A66C6431ABD42A9EC9B9B0366EDAEAD59E71F6FC6EEDD338E6910D659086A022D453B42ECA2C774BE1F22C8842D2D61F51628F9E9FB7684B6A16C5E9FB986ECCDB49F73C0AA2582355FA4F94546D9C59A3155F7409722C60C342833009E3B78C4112EBDC6C7689667EC55A22BF50B9C42F58A9554425526CE0744512AF1E788711D5AE36A74E232A55ACD2C88644C7A435341B9BC7B158D4D4F098FD606632AFD52AA26276DB054F6DF6EB19859761E7FD99C83B2A9CC0418084E8E53C0AEFFD7845166DDDC9072F49FE88E205F5550FEEA310316422F34D4C9576967AAB75E7BD7D78A001E3CD6675473A88AFD47D399B9ADB3FA24B6F4E97A07761D6AA35BD5FA2F96FD1267D172E2EE872F6299D5704B33F6FFD159E801376CEE6739224975499C9E23CDA8469BB383A7358BBBE4E385B3CFA74509FB3C540B980B0C10053B35E40C00A52A408D7B20D6D2B8E6F231CBF553D05B745B19ED7B28E2DA7E781E7AFE0C85B58B63E57556B26E11AD2A2ACA8661B3BFC122D7DC52641ECA1AAAA66B5A86164B5AC66CB6AB6B49FC5A93FC7ECC898CAEC8C6AA3216C1B5967B00D6D15E923F1160C71C5E693AF240D0B2A97379F50256B7695FB755105A4BD3B58C1A849CDF6F40DF6C7B8C0D9B843564A151D38F3DB33EBA8996DFE3242E6EEB7C6E731C9DAC91148D3B3491A75A5B4EBB6679DEC5C6674B6D184B8121685D6A78F994BF889CED39CF88F7558DA3484AA967D279B1D43301AF576F0A0F4315D8455A237D4075FE8F30DA7E194964721E46A8D2DC9631EF7E0929CECF0D12543F79BBB3AFDCBA78F73885DEDA4F39E7EF5828DEBAE1A59431E56BBB7869CECF0AD2167B3C29FA2205755654A1E551F4673996D4EE0AC6F73E086D977E7FDF8007CF46CDEA83509AACD545F636DDC9AC188B26D78BCFB18501D57757938214560B6A71ACDC070FCF941132C1C4FE1D5627AB7986C06B2DD6DEB9DEE804DAFD161998430D39DA8358BE32E3E64A4AFBD74FED0C076D8E6AF8683331C01F06DB88FC146F1B6A72CC5C4F5D1B915AEF9D65B16C75E1FFDE5439A3484360B545E3513A7992F1F882C2806884586EA80585FB0A24B44B2D80100EE03AAA0786D0D4D2E8996D1DC5D6B7B1508BD9A6CCF263B200B15544165A4503595EE83751D9BAAD8076CAD402D2CD3F636BB59296EF08A53CAABE432F096F547D0D6B65B7CAD2DDDF974F30DDBA77041E2E0992A787921F49C8A1FAF5D930C5C546F50CA0BAFCB28CE27233F31A5267120CD39D7F0D37A91D922B7AB2C9B1E199A9E47AB15EDF07D08353E36342E7026DBEADF1CC8D35C4C28FBE3599244733F173DF05D77F9552EDFE9BB7031327FA2ABF85A70744D27CBCF2258FA0B95E558F4A1EFC30B1290948C32586FF6DDFBB997CCBD85EC1FE87016168C6DEFB865C6EACF7D79E6BE92FAA48E9DC459232F43072654DBFC309557013F9CFB6B2F304A4968895C41B2B16FFB104B2EC89A8459874649603AAF960799816D3FC2A49824743265344EAF88F0975FAA29377C0656CFBAFCF9A369D64D9D00AA257DD72BAABD13CDD2B2D3837269653E78FDAABFC5514D37F0614E3DC5F99280571DE0B35EB4BA7C257A72F41841B0BF8A453DF2BFE656FEDC052F06FD173A5AE93A321A1D073DD88C4EC898EECB507A271603E33F54536D0083C0981F1B5D32807841F32ACE4DF93E0E261347BAA5E5A807E5D28A1CD33F8B76DABD8A95D01DD4FC8B381EC7EA25A2AED1CAD58566F1CCF4AD57BCA4513E2BDAA94E29B0EBAA793701D92DA6BE93CD8D0141AFD8E09498B34E76387A89F5A09F7A916018189482965F2C601540FC7C61680A2A7C37A150D01206D68B82F212DB8182F22219BC82A2811FCAB5D41A05C2ACDF18F093C5B26EFDB54CEF6BBD25877D040096F337788D06F114CA631F2DB882395A12C14416274BDA8F9DFAD6401D377D9C2B69E43D78CD823F19C3AE95CAE3A6612CE5CA13AC9ECED2B5E2DAC13ACEC963F0AA097F1E883EAA53B93DA7E781BB757C5A7676713AB857AE4FBA0FD09D3643953BBFAFE9FDB459C7411F2BA946C8433F6D5602AE74B3AD475FF15A258105ED144B8BDFB2B90B74B87237D651DD607AD253DDD46158D8F9653584B7B351208D0374ACAA366E7088DAD9BF13D5CCD59EF851101667501A3D464E525109CD69ADA55AA01DDEA7BABBD143F0D59F06EAA6635F3C240473B4540ABD9F74AF847BE82D3543D89DBA0ED66716F8D70CED495BD478CADAC75CDCE550D0A71400B9D21D5789734D4A30B4A85E19F11949F9C7866ACC2D089394749427221EB7E808D6473206A2E26601222AEFC60C448BE407129DDC780C4DC5CD3044473E7B4010850849E70B063AEC3138448F471D584C67F5B29A763ECBDB5C0BB2D52B685AB2E51D9C69E8E6CB005022987B1C938A4A0F8BC91A2A1EC29B84C47C8308DB11F78D23C286A4601DB422A9168EB2B4BCA9884B1505FA8C2F9435268F2C4A53612AAA1337894E1A0512DF0E71EB1525678FC274337400C7282EB4FCC01142910E510A6F2ACB05AEA81E12585F251DC1BC349282C902C2722520E6557B59280A982DC7B10CB465B82C5610CD7865686D07630491B4C070CD885BFDF9371BDC32C300D6428D44B4285B83681BC846F12E982C1C0480941B871E42CA0C44588D35A2D1834605893B174EF51899413410F0513D0A01FAD85E2C02D8B103A1A89E9395E58201EF69AF2C05F89E6930185A8675A71A8C732955319C594A10824C3B320143D64A4A02DE4B21A56A30ED0D0CFD2A0D60758D804DBCE5D8429B58FB4445D23AB3B505337560CBF0D32440746484DCF0518C0E74C32EF0D29640171AE960363DF839659484408D686D4E193DD99BAF3294EA22B686210998B8CAA03E7AF482BBC8AA73EB82EED4317B0F7DDCA9BD7D77B7F3E836EE54DE102BE463BE4DB6BB4F16E464D8D1DB5D2077B08551DD5122A5655628DD85A66359F5A258F04B124A69996FD8ACEFD864A9198E75AC2FD5BAD333F0410BB4F050DAA6BB19EA44746ED4AE7A71637BE3B02D3B99CEE60F64E5953F9C4C69953959A71B2F281ECBA80AAEBDF5DA0F9749DDB2FC65345B7B733A80F3AF67E3D1D32A0893D3F1439AAEDF4EA7494E3A99ACB64FE2CEA3D5D45B44D3A383831FA68787D35541633AE7420FF17E64DB531AC5DE9208A5D92B160B72E9C7497AE1A5DE9D973D0D72BE5849D5C0FB15C51968D5257B85224F5E75105AD5CEFE5D9E6B26D9BFDFDF7F21BD2C42599C544FCD26DCC9E697C02D5549F9928E3B7BA8231701014224C8F47302B3B9177831F0E2CF79146C56A1FAFA4DDDBA78848D6D5FFC225338990AFC4B576B920CAD84AC97AD7867BF1FD2E53398B374F8129022D5EA859FDF81978FB248B80596E0859FF99A951F7A69043C05BDEBF9D34B7FD79327899ABF4FED55CE5579EDB8506E4DDE5F75307BDBDBE0E633A826A19AC50A95CCCE820AA9ACA692F52952A97E1BCC24CA1B26879328DDBEDB4FA29944377E5491A89525A8A8D29582A8A894B8139688028AB23325CBE34D877A0504DB0855025B75A33D5CA275960C57D0809E1C3C0945789A4212756EB07C9115CD3A97BA40B12EC0D36312AAB3D4989FF1B4CAACEA2C9DF2A7C1D8897CB6E7D06824E891BD059949ECAF3376B3E6EF81335601605C6C94A0436E845E192974E4A58BE4CC9C372D7EB2A4C1E4F79588316578AA7C0A6696265F62E149F93CCB9C37E58B2CB864B329734CB2058DE829240AD7B0304F297F3267A952299E32904999250D1437A00DF02C96E1A902C99659C240B19D33954395FAD7C138431E71E2D02972CB90BD47D437EFC61D6E1370722152F56383609549C00946AC4CB9C5F1A1F4AE3377942895DA04AF622A4E3E82154BF194D967EA589ABAE7EBD4D4EAE7C938E7A57CB46C1007444A1C949313A2025FDEEE884841A31B5B73136D322918399BAD7FB6A4552659948895BF0F52B394D831279A557C62D04EB31434D4CB3D97C8905FEDB5D917D534B9EC845C44A5CBCEA8A667A7BFBB5ADC317035976B3EE28B9106A14013AA1D5DDDF149D0B885972F7A619A2481F65C1E920B1F003538233751D81F6DA873E37187E2DB5F5F985E091F73B95CC3D8AFC01A2C5FDAE6DDE81398298EDB9242152CE27B36091CC7265B3018DD8060678EEFE60CE491D773462ADDA8CBFFCDED99020EE65E170C3DE0D5C148E85523701AC143F2A44BD50A9F6F73715AB5016E470D88A70C6E28CBCAF4A6216A9E956F27305DDA70A37C3B02C58D4A67D4EC88E0497932250CA55865AB4AE52FDBBFB718CA12BFC8012BF3216530C97C284989A514018D4595F1A85284D3F1EC3949C9AA508FD9EFC179E093EC84B7AA70ED85FE3D49D22221D9F8E8E0F0683C3A0B7C2F2950B02554F3ADF8BA040ABB79789C6137C96235159BDB2340332A49B2E0921D02697F9558AE3ED222868F5E3C7FF0623951A165E2D0224011894A2F7C5C850BF2743AFE67DEEAEDA80A6DF29FDF8CAE924FA1FFFB8616DCC61B32FA17C7D5D1B7DF5973C5E30A0BEEEEFC94A583C9B928A0DC5A890E9F0F5A0B11C32987F2094BEC8346665DAABAB09DFAAB7F7C2E9ABE19E57089B7A30361C29BA861358A06DC144D5B706395B0557D44D287D9FB994335E63BB594BD02E6005A5DA79329CAB7702AA58F29A7F7C8E06D9A28DF2D9B9A3517B10B4E0F214EDD28A2FC60D8BEEA1E875D434D80A54C355DC24B5FCB954B80B93537220EDDD69C0C036B63C46B49A4C4B4F1A2FA62E53D7DA95F91D10AAD0781EDAD763BF7AC4D176D51BEC3F5AC184E3BF4AC5AD4D85E05F625EA0CEFDE3001B5883E6BAEC93CE6CCDAB3008E8E479C39A0C821CEDCD2732242195AD69C1680252B886579BC533F5B28ED062B62C89AB30680C69AAF64355CAC890B75B7E5453B2435686B6F57C52DFC4BAD6176811C83F96AAE1932CAABA04583B9E726F4646C57731360315D0D76C87573EC2E1963E13538AC014B55E33EB6ED0640D6DEDAD1B04E7018809883B592458875B7ED3000AA709A61C04F012DB4F828F469A059FF04CE1C0798DC281CD3DEA56AE397665B10D5DE7A1A017A63B19D635ABADFD5B9D31B0B36DB6F93F1E7CD3A0CD6FFA13209F2E84A896A6458CB00B5A93622C6D9A316AA615B7BAB8220E8CB1066E0827E16F5654FD0EA264A0B91DADBA9D9E545A08BF3CB6C6F9335E2D9703AEB5A24D4EBC43BD9DB0E6ADE4D302ADC9CABF050EE2005BD486D582E43358772EE2753C208459A0730C37051D04BF66339830EC04F5DD849C663C3AB5B18F736B2C9DD8478270A6B34A3FE128B19B26EB4D72F712ED56FDEB64C5EBB174A8278876A604AA207D6F2C9447ACDF2C6F52C3D0FC83362C87AE84899E0C7A09CEB90191F6DB592F7AB44101E7AA08BD850D4AA6F1FD550BF76EAA5CCC9836C3D957ADD9233E731B4E4C27D76358897BA86E568107992D4091C5489728B3244A25C382B1047962FE84437CCAF6039D713C31B33727FBAF746FA5714286B941B3579D591E63AA27E47A6170D11B3BB40EFC6B85292CE37E165DA53C52EBC2C7D299A86798FC7E2EB995D281BF494CCDE285B990C57A16C65E94B5436D5133D0353B666B9DB7A581031798ED9751253FFA5E859B3277D06A679E64C76DD6B9994E69A3D7514CB5E8AF6989FF61998A6880B62F156C07EAE87BBBA01D9F16A883E39DAA9A221D22376EF938670A4B4036D6974BCB4DB054CBC32EBF09C7108F7633D9D3336BA16DBE5392300A5EAE4F6B493B509C28189BA2595BF88AB0D23024ED1EDCEAFE98D29450771113B1CC5EAD16F35D1A701B82E73CED5B6DECB7045A2C02502FA22557949BEC8FCD4DD30DD9131EDEC903CD26094AC5FBFD444B7FA734DEFF867E8AA6FF8A41CB8E2DC960F050208C92AB5B0D24115CFCF9D8E177711D581029F7996AC6F485A9C2FC8DE0AEEACDEB82B3BACABA83BADF3559A3A96C37DA963B90AD4B158CBDC756EAC526FF9AF500760466791A6BCA5953A90AB40BDC979CA4C5D4BBB74A967A9867E02CD5DF2F7B9527F7C31D4199F1BC64649CB9B3DAD969675F4A32C6F3F6DFA2E2F7AB47D9775F47D979761463163AE0364E9635A81938279D3DF68D7E281B36CD6620DD0AAC557E18DF3C47E9E054C11570CF528BC178EF15F52E40FBA30A996CA8B4915712C48EBBC8A0BA9A28611A9AED9A74AD841C8C54A95343C489DF20FC1AA3F28183115815513FAEC40B339D80E552C90220ADD613940A52E14E33F7EA0082148A778055D590E70C52E45A15AE8E114C4ED4521C1BB012998DE5616237D8663402FC5FA0A43503D05ED72C82518593B64F80167A773BE0B21808059401066606DABF95705827092D7F6C386F1A1C0B8114052FDC510330EA94C2310285694F3F0391644897F3489018249EEB51014103F400E18306027A25006F38AAC71EE855245DF66A128F39F7529146E97A14878E6C05CB09029C8861AC1ADBA312CFC16099DF1CB413806A182A068CC881EEA44688A3D1A98F0CABDF995E74366EB2B2AF66B7C7D04EB30400313AAF4A41F7DC730200601B379711BBAF5BD53515EB92B866EBE9EEF60EBA638E35066A8EA462C1A85305E24B7D6899D8900BCD1548BC17C01DA8D7E280EA07459AB3A13915E518C577C2E74A5537148B98EB66527D3E228ADFC81FE29E5343A997EDC84D9135EC55F1724F1973589134A3324F9D5644DB4AA7315DE47D5D59AC0515545788EE49AA4DEC24BBD2C90B8F7E6292DCE1E30F6432AC4FC45CBEC19ED3BB2B80ADF6FD2F526A54326ABBB807B0A32BBA3D3F57F3295783E795F1C54BB180265D3CF5E3D7B1FFEB4F183C596EF4BE001140589ECF2AF7C1D289BCB347B2568F9BCA574936747C0102AC5B7BDB3BC25AB75408925EFC399F7489AF04657F25FC8D29B3FD76F63AA8898278217FBC985EF2D636F959434EAF6F44FAAC38BD5D38FFF0316620DD034160100 , N'6.1.0-30225')
335END