-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSqlQuery_4.sql
161 lines (148 loc) · 33.2 KB
/
SqlQuery_4.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
DECLARE @CurrentMigration [nvarchar](max)
IF object_id('[dbo].[__MigrationHistory]') IS NOT NULL
SELECT @CurrentMigration =
(SELECT TOP (1)
[Project1].[MigrationId] AS [MigrationId]
FROM ( SELECT
[Extent1].[MigrationId] AS [MigrationId]
FROM [dbo].[__MigrationHistory] AS [Extent1]
WHERE [Extent1].[ContextKey] = N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration'
) AS [Project1]
ORDER BY [Project1].[MigrationId] DESC)
IF @CurrentMigration IS NULL
SET @CurrentMigration = '0'
IF @CurrentMigration < '202009201440165_InitialModel'
BEGIN
CREATE TABLE [dbo].[Genres] (
[ID] [int] NOT NULL IDENTITY,
[Name] [nvarchar](max),
CONSTRAINT [PK_dbo.Genres] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[Videos] (
[ID] [int] NOT NULL IDENTITY,
[Name] [nvarchar](max),
[ReleaseDate] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.Videos] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[VideoGenres] (
[Video_ID] [int] NOT NULL,
[Genre_ID] [int] NOT NULL,
CONSTRAINT [PK_dbo.VideoGenres] PRIMARY KEY ([Video_ID], [Genre_ID])
)
CREATE INDEX [IX_Video_ID] ON [dbo].[VideoGenres]([Video_ID])
CREATE INDEX [IX_Genre_ID] ON [dbo].[VideoGenres]([Genre_ID])
ALTER TABLE [dbo].[VideoGenres] ADD CONSTRAINT [FK_dbo.VideoGenres_dbo.Videos_Video_ID] FOREIGN KEY ([Video_ID]) REFERENCES [dbo].[Videos] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[VideoGenres] ADD CONSTRAINT [FK_dbo.VideoGenres_dbo.Genres_Genre_ID] FOREIGN KEY ([Genre_ID]) REFERENCES [dbo].[Genres] ([ID]) ON DELETE CASCADE
CREATE TABLE [dbo].[__MigrationHistory] (
[MigrationId] [nvarchar](150) NOT NULL,
[ContextKey] [nvarchar](300) NOT NULL,
[Model] [varbinary](max) NOT NULL,
[ProductVersion] [nvarchar](32) NOT NULL,
CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY ([MigrationId], [ContextKey])
)
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201440165_InitialModel', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103AB5456225D94B1BD8BBC83A496174F38338BBE8CDA0A5B14394A254910A6C2CFA643DF491FA0A1DEA5FA464C9469A2DDA224060939CFF8F33C3F19FBFFF317EB70938798658B2504C9CD3D189434078A1CFC47AE2246A75FCBDF3EEEDD75F8DAFFC60433E15E7DEE8734829E4C479522A3A775DE93D4140E528605E1CCA70A5465E18B8D40FDDB393931FDCD35317908583BC08193F2442B100D22FF8751A0A0F2295507E13FAC065BE8E3BF3942BB9A501C8887A30716EC267068B07108AF2C562F19E7ABF80F04797CB74235B1FD53EA71C1D72C1194565E7C0570EA142848A2A34E5FCA384B98A43B19E47B840F9E336023CB7A25C426EE279757CA8B52767DA5AB7222C5879895461B027C3D337B9FB5C93FCA02038A57BD1C1571808B5D556A74E9E383F8288D17253D2F994C7FAD4810118A56C8F48BA4EB20D724C72E2A312590840FD7744A60957490C1301898A293F22F7C99233EF27D83E8648321109E77543D014DC6B2CE0D27D1C4610ABED03AC72F366970E719B74AE495892D56832DB6742BD3973C82D0AA74B0E254E6A7E9AAB3006B41662AAC0BFA74A418C619EF9907ADA926EC8D2FF0B69084CBC860EB9A19B0F20D6EA099D4F370EB9661BF08B955C838F82E1AD452215276009B9A5CF6C9DEA6788FBC47C08A58311E1E9B67C6251764B46E9D6228D1B1EB88EC3E021E40549BEBE78A4F11A142A1CB66CCEC324F60C65C66E85B89D384C39BD3C0E53B6FFE3F00BE1D01082A8032AE112352C64E9CF8F4CCBB68C1B8AE902B28762BA806D2BA60BC00FC1F48594A1C7521DEAA02EE437CDB9123ED9A54C1689D2088C062293458845943C71BEB3FCD3C1B0BCB115C33CE5EF6438766BD6D817172BB8A20CC1961B5ABB77F9DDD22760A35A6E3496E0FC52CB1C36A6215AC21C9411DFCAE94D3B2C3F34C98B946791E77E35C86B661B3C4A1CD58EB4E1CC4C063D912EF5AD547507B228625B6351E868E69AA6592D602E235A35636ED68D155D9BDBD1B68D6F681461C2A8B571F90A99673DDCF478BE7FE712643C5C4FB63430A5B6A5244C7F740DC62E8A464DAF592C15261ABAA43AAF4CFDC03AD68DDF0E7015721B10B5C35640AE38AE3FD76ECC616D9529A772F835FA20C0E3A93BC084854D9776DC94D3B8A5F24C439E04A2AB7AEDA2CE6A499D3E5BB1398C5D4371D383AEE54203D7664006852BBF677F7FB8B214B37FB83AE8BE74B8BA3834EA7A9D5163E3F5C3DF4C7A2D182853FA8B04BAE4D61ACED62BA8337B5B8B6E1409DB73837090B16A4383F65C29784F9DF2AA73A04E29933D7532CB971D6CAB8A99474AA895D5CCA85AE3BC82F44F24AC92921D7108EAFE8C8EC27232DF4A05C1481F18CD7FE553CE102BD5811B2AD80AA4CA9E140EBEF8CF8C89C53F677AE04AE9F3212384577F1431EDD2DE674FDFB362C73B483CD3D87BA2F13701DD7C5BE764BF75F67CE6FEA77D35E85DE8E367D5FF2EDCCFEF0703754722B50F7765B8FE7855626A51B3DE4F33E1C366E27C4E89CEC9ECE745417744EE624C2FE7E484FCB677342BB5F7135ED0ED21FCB007746B31349F46FD2FE753AB06DF894B04A00272E16559764AA5477DDB63BA40ED949EBF484D15863CB8F5941C5610EBBB4839D631A962AC64564B741F33E1B188F286D576311E9241B449253F73E712226C7C74776A193844DAAEDEA3646DB8B7CF019D43891EE0B4752CB5D0D9516B0DD8BF0C38C343F9BAC0D9D520BE3870DAA759F6D060C084AA7B4095F58758D3963A3D6559B1634ED33ABCEA9E5DB5716E1F22B573EE52BCBED929A3C384DE015A39F9DA3D47EB78FBD809DF7A37F7CECF1A669B2FB4E1A3B341C61633BA1E63DB1F557692B2663AAF65EC1E7342FB258537B4F60B306608C9D6150BFD7BB000AF7137CB3333B10A8B246168541C311A991B5014DB477A112BB6A29EC26D0FA44C7FD2F844798247AE8225F8337197A828516832044BDEF88944A79A5DF2D3616853E7F15D94FEFAF01226A09A4C77C077E27DC2B85FEA7DDDD24B75B0D0392CEFF5752C95EEF9D7DB92D36D280632CADD57A6DE4708228ECCE49D98D3673844B78F123EC09A7ADBE241DCCDA43F104DB78F2F195DC73490398F8A1EBF2286FD60F3F62FA6B7A5ED08210000 , N'6.4.4')
END
IF @CurrentMigration < '202009201449075_PopulateTableGenre'
BEGIN
INSERT INTO Genres (Name)
VALUES
('Comedy'),
('Action'),
('Horror'),
('Thriller'),
('Family'),
('Romance'),
('Drama')
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201449075_PopulateTableGenre', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103AB5456225D94B1BD8BBC83A496174F38338BBE8CDA0A5B14394A254910A6C2CFA643DF491FA0A1DEA5FA464C9469A2DDA224060939CFF8F33C3F19FBFFF317EB70938798658B2504C9CD3D189434078A1CFC47AE2246A75FCBDF3EEEDD75F8DAFFC60433E15E7DEE8734829E4C479522A3A775DE93D4140E528605E1CCA70A5465E18B8D40FDDB393931FDCD35317908583BC08193F2442B100D22FF8751A0A0F2295507E13FAC065BE8E3BF3942BB9A501C8887A30716EC267068B07108AF2C562F19E7ABF80F04797CB74235B1FD53EA71C1D72C1194565E7C0570EA142848A2A34E5FCA384B98A43B19E47B840F9E336023CB7A25C426EE279757CA8B52767DA5AB7222C5879895461B027C3D337B9FB5C93FCA02038A57BD1C1571808B5D556A74E9E383F8288D17253D2F994C7FAD4810118A56C8F48BA4EB20D724C72E2A312590840FD7744A60957490C1301898A293F22F7C99233EF27D83E8648321109E77543D014DC6B2CE0D27D1C4610ABED03AC72F366970E719B74AE495892D56832DB6742BD3973C82D0AA74B0E254E6A7E9AAB3006B41662AAC0BFA74A418C619EF9907ADA926EC8D2FF0B69084CBC860EB9A19B0F20D6EA099D4F370EB9661BF08B955C838F82E1AD452215276009B9A5CF6C9DEA6788FBC47C08A58311E1E9B67C6251764B46E9D6228D1B1EB88EC3E021E40549BEBE78A4F11A142A1CB66CCEC324F60C65C66E85B89D384C39BD3C0E53B6FFE3F00BE1D01082A8032AE112352C64E9CF8F4CCBB68C1B8AE902B28762BA806D2BA60BC00FC1F48594A1C7521DEAA02EE437CDB9123ED9A54C1689D2088C062293458845943C71BEB3FCD3C1B0BCB115C33CE5EF6438766BD6D817172BB8A20CC1961B5ABB77F9DDD22760A35A6E3496E0FC52CB1C36A6215AC21C9411DFCAE94D3B2C3F34C98B946791E77E35C86B661B3C4A1CD58EB4E1CC4C063D912EF5AD547507B228625B6351E868E69AA6592D602E235A35636ED68D155D9BDBD1B68D6F681461C2A8B571F90A99673DDCF478BE7FE712643C5C4FB63430A5B6A5244C7F740DC62E8A464DAF592C15261ABAA43AAF4CFDC03AD68DDF0E7015721B10B5C35640AE38AE3FD76ECC616D9529A772F835FA20C0E3A93BC084854D9776DC94D3B8A5F24C439E04A2AB7AEDA2CE6A499D3E5BB1398C5D4371D383AEE54203D7664006852BBF677F7FB8B214B37FB83AE8BE74B8BA3834EA7A9D5163E3F5C3DF4C7A2D182853FA8B04BAE4D61ACED62BA8337B5B8B6E1409DB73837090B16A4383F65C29784F9DF2AA73A04E29933D7532CB971D6CAB8A99474AA895D5CCA85AE3BC82F44F24AC92921D7108EAFE8C8EC27232DF4A05C1481F18CD7FE553CE102BD5811B2AD80AA4CA9E140EBEF8CF8C89C53F677AE04AE9F3212384577F1431EDD2DE674FDFB362C73B483CD3D87BA2F13701DD7C5BE764BF75F67CE6FEA77D35E85DE8E367D5FF2EDCCFEF0703754722B50F7765B8FE7855626A51B3DE4F33E1C366E27C4E89CEC9ECE745417744EE624C2FE7E484FCB677342BB5F7135ED0ED21FCB007746B31349F46FD2FE753AB06DF894B04A00272E16559764AA5477DDB63BA40ED949EBF484D15863CB8F5941C5610EBBB4839D631A962AC64564B741F33E1B188F286D576311E9241B449253F73E712226C7C74776A193844DAAEDEA3646DB8B7CF019D43891EE0B4752CB5D0D9516B0DD8BF0C38C343F9BAC0D9D520BE3870DAA759F6D060C084AA7B4095F58758D3963A3D6559B1634ED33ABCEA9E5DB5716E1F22B573EE52BCBED929A3C384DE015A39F9DA3D47EB78FBD809DF7A37F7CECF1A669B2FB4E1A3B341C61633BA1E63DB1F557692B2663AAF65EC1E7342FB258537B4F60B306608C9D6150BFD7BB000AF7137CB3333B10A8B246168541C311A991B5014DB477A112BB6A29EC26D0FA44C7FD2F844798247AE8225F8337197A828516832044BDEF88944A79A5DF2D3616853E7F15D94FEFAF01226A09A4C77C077E27DC2B85FEA7DDDD24B75B0D0392CEFF5752C95EEF9D7DB92D36D280632CADD57A6DE4708228ECCE49D98D3673844B78F123EC09A7ADBE241DCCDA43F104DB78F2F195DC73490398F8A1EBF2286FD60F3F62FA6B7A5ED08210000 , N'6.4.4')
END
IF @CurrentMigration < '202009201831524_ModifyRelationshipTablesVideoGenre'
BEGIN
IF object_id(N'[dbo].[FK_dbo.VideoGenres_dbo.Videos_Video_ID]', N'F') IS NOT NULL
ALTER TABLE [dbo].[VideoGenres] DROP CONSTRAINT [FK_dbo.VideoGenres_dbo.Videos_Video_ID]
IF object_id(N'[dbo].[FK_dbo.VideoGenres_dbo.Genres_Genre_ID]', N'F') IS NOT NULL
ALTER TABLE [dbo].[VideoGenres] DROP CONSTRAINT [FK_dbo.VideoGenres_dbo.Genres_Genre_ID]
IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_Video_ID' AND object_id = object_id(N'[dbo].[VideoGenres]', N'U'))
DROP INDEX [IX_Video_ID] ON [dbo].[VideoGenres]
IF EXISTS (SELECT name FROM sys.indexes WHERE name = N'IX_Genre_ID' AND object_id = object_id(N'[dbo].[VideoGenres]', N'U'))
DROP INDEX [IX_Genre_ID] ON [dbo].[VideoGenres]
ALTER TABLE [dbo].[Videos] ADD [GenreID] [int] NOT NULL DEFAULT 0
CREATE INDEX [IX_GenreID] ON [dbo].[Videos]([GenreID])
ALTER TABLE [dbo].[Videos] ADD CONSTRAINT [FK_dbo.Videos_dbo.Genres_GenreID] FOREIGN KEY ([GenreID]) REFERENCES [dbo].[Genres] ([ID]) ON DELETE CASCADE
DROP TABLE [dbo].[VideoGenres]
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201831524_ModifyRelationshipTablesVideoGenre', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103AB5456225D94B6BD8BBC83A4961741D075112F466D0D2D8214A512A4919368A3E590F7DA4BE4247BF9648C9768C64B7458B00814472FEBF19CEC87FFDF1E7E0C33AE4640552B1480C9DF3DE994340F851C0C472E8247A71FABDF3E1FDD75F0DAE83704D9ECA73EFD2734829D4D079D63AEEBBAEF29F21A4AA17325F462A5AE89E1F852E0D22F7E2ECEC07F7FCDC0564E1202F4206F789D02C84EC055F4791F021D609E5932800AE8A75DCF132AEE49686A062EAC3D099442B06B37B109AF2D96CF691FABF80087A57F36C235FEFD59E338E0EB9E48CA2B21EF08543A81091A61A4DE93F2AF0B48CC4D28B7181F2874D0C786E41B982C2C4FEF6F8A1D69E5DA4D6BA5BC292959F281D852F6478FEAE709F6B921F1504A7722F3AF81A03A137A9D5999387CE8F20245A6E4AEA8FB84C4F1D19805EC6F68464EB24DF20A7A4203EA99085004CFF4EC828E13A913014906849F909B94BE69CF93FC1E6214292A14838AF1B82A6E05E630197EE641483D49B7B5814E68DAF1CE236E95C93B022ABD1E4B68F857E77E1905B144EE71C2A9CD4FCE4E948025A0B926A08EEA8D62031CCE300324F5BD20D59E9FF521A0213D3D02113BAFE0462A99FD1F974ED901BB686A05C293478140CB31689B44CC012724B576C99E967887B620144CAC188F06C5B3DB338CF925EB6352BE07023A3F03EE22545BE3C7BA072091AD58DEC3D2F4AA46F683270B770DB09C28CD1EB833063FB3F08BF10080D210839A00AAE50C35256FAFCC052D99671BB796590DBEFA143B3A200FD71495102BF2D29CA843924292E958A7C962950CF8A4278D3926B11901D9AE481ACF4C76022B0598C5046B943E73BCB33EDFCAA74DFF22B3CD1E477EE9829301557186D0DE4D2CF6FBD11553E0DEC90A02F82E60A660DC814B694639BA0300F99D0768A31E1B318D3B9536B83E4C0BC4C55AA989B3B571063DD40DDBA7D7F88D40ABCB6E84A82E1A57D4E19B835F4D89516693452802C34A815CAA218A62760AD5B4A30364C451556459E9BD0492578A0EBD6E10DB30579133A16F29AE4E5056591174836C86B661B3CCAA4AD9D68C9693302BB13AB5276ABA715C3DDA954E3503ACACC88A6492D85A38AE6B66D76F3BEB9ECAFDD8E067B30A1718CD5BDD670172BC4CBBBEDD1A9F7F21E33CC79B8BE6A69352B6D2B497857D12518BB281A35BD615269BC15E89CA6F57B1484D6B16EEC7600AB94DB80A71DB5126EE5F1F4B9962DC735C02DF5A0E07F833E08D352925DDD262C6CBA6C36A29CCA96366114F12414DD25AD9B3ABFF8EBF4F98ACD61E01A8A5BB5CB72A155E99B0139285C459ABD7DB8F2F2F2F27075D07DE970757168346175468D8DC3F95577599D57E705F7C630B20AA479A4925E154AA3200E8AE2B4FFB38455ADF2230E4107AD101358A9BC8DD210F6D2033DEF573EE20CEDDD1E9850C116A0743E5A3838F65F189F2DFE399F105CA5027EC87784CF3E1CB1D4A57BC79F178E17F57948ACA8F49FA9FC26A4EB6FEB9CEC99E785E3EE7FDA5707CD87013EEB57980F33C3ADCE768C9DF67AE8FC96D1F4C9F8E759417642A61213B44FCEC8EF7B44BFEE3057B4AC9F75DE32FAD563A6C7A346B6AEFEE86DA6B47FC96066F7C0070C5BDDB3567E27611ECDD3B8E620EE183B5AE7B0EE31AC8D73FB48F486235AC3FA5AF3BC7728B327B9B719C3EC6E021153FB2904B1AAD872CB22FD614480DFC04A75662C1651895943A3F288510527A02996507A29355B505FE3B60F4A659FF79E284FF0C8753887602CA6898E138D264338E78DCF8529F477C9CF66CDA6CE83699C7D457B0D13504D96DE0253F131613CA8F4BE6929C51D2CD29C2AEEBB34963ABDF7969B8AD36D240E6454B8AF2A050F10C61C99A9A9F0E80A8ED1ED51C12758527F533685DD4CF607A2E9F6C115A34B494355F0D8D2E32B623808D7EFFF06961B8E1F111C0000 , N'6.4.4')
END
IF @CurrentMigration < '202009201846181_AddColumnClassificationToTableVideos'
BEGIN
ALTER TABLE [dbo].[Videos] ADD [Classification] [int] NOT NULL DEFAULT 0
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201846181_AddColumnClassificationToTableVideos', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103AB54562C5C9A50DEC5D649D6461749D045176D19B414B63872845A92215D828FA643DF491FA0A1D4A942C9196EDB8C96E8B1601029BE4FC7F339CA1FFFCFD8FC1DB65CCC91364922562E8F57B271E01112611138BA197ABF9F1F7DEDB375F7F35B88AE225F9549D3BD3E79052C8A1F7A8547AEEFB327C8498CA5ECCC22C91C95CF5C224F66994F8A727273FF8FDBE0FC8C2435E840CEE73A1580CC517FC3A4A4408A9CA299F24117069D6712728B8921B1A834C6908436F923C3198DE8350944FA7D37734FC1944D4BB9C151BE57AAFF1B9E0E8910BCE282A1B009F7B840A9128AAD094F38F120295256211A4B840F9C32A053C37A75C8231F17C7D7C5F6B4F4EB5B5FE9AB06215E65225F13319F6CF8CFB7C9BFCA02078B57BD1C1571808B5D256174E1E7AEF416468B92DE97CC4337DEAC000F40AB647A45827E506392686F8A846160250FF1D9151CE559EC15040AE32CA8FC85D3EE32CFC11560F09920C45CE79D3103405F75A0BB874972529646A750F7363DEF8D2237E9BCEB7096BB2064D69FB58A8B3538FDCA0703AE350E3A4E1A7402519A0B5905105D11D550A320CF33882C2D38E744B96FE5F494360621A7A6442971F402CD4233A9F2E3D72CD9610552B46838F8261D62291CA727084DCD027B628F4B3C47D621124D2C388F0625B3EB2B4CC925EB1353570B8CE92F83EE11545B93C7DA0D90214AA9BB87B419267A1A5C9C05FC36D2B080B462F0FC282EDFF20FC4220B48420E4804AB8440D2B59FAF303D3B21DE3B6F31A712A259BB3D05445A3BA86B1BDF54CCE059877FB7EDF7C33E97458BA5529B529DDAA54DC2FDDF2B8916CB687C6F29AD3C5FA127CE92C6CCB7BE97444104690F11582B619B2767C2610CF2033F6078C6303E4914F94E7F8B5EF44B375FA7DC2A3FAECE9F6B3773ACAE8ECFAFC991BA03214CDC50B29939015CE699643838DB6B82B11912D4059A781A9A81374214BD169088BA1F79DA3FE667E759D5FF333406DF3EB7B76EDBB159798E60AC84558B63B232A431AB919839E88DA2B582E21D3F58A72EC0F25469C09E5D65626429622703AB5B648F62CC85AA59AB9BD730929221475EBF6FD3E52EBDAE28AAE25585EDAE59481DF408F7BC5228D428A1AA08DDC3469A74FC0526DC87AEC944DE24B53E06DE8680901A8A675D85AAC6B501B3A0EF2DAE45567E2901B245BE40DB32D1E554D6D9CD85072ED086C4FAC5AD9B59E4E0CB7A7528343E5283B23DA266DA8EB7534D7F3925F0E4CD560E5774C5683094D53AC908D49CBAC90A01CB346C7C1F3878BB8E4E18772C38C516B5B4BC226852EC0DA45D1A8E935CBA4C27680CEA8BE824651EC1CEBC66E07B02AB92D78BA51ABE0561DD79F1BD972D8E4B3A11E18FED7E883589792A267B361E1D2154331E534DBD01F8E129EC7A2BBA47553971D5F93BE5C71390C7C4B71A776392E742A7D3B207B85CBA4D9EB87AB2C2FCF0F5707DD970E57178756F7DD64D4DAD89F9FDD443659DA7BFB73AD6FC826BBCE6BF395C1E9945DFB482DBD2EBF56991D9892B7FB95CBA981E5118FA0839E106958FF82955410F7F4815EF00B1F7186F6AE0F4CA8607390AA6C8DBDD393FEA9F50AF6CF7991F2A58CF83ECF529F7DD666DAA53BA7E967CE94CDF15A3CD12C7CA4D937315D7EDBE4E48ED0CF7C3DF94FFB6AAFE786083FAB977B6E28ECFF7BCF0B050BA7F31EE324B01C7ABF1634E764FCD3D4901D91DB0C53FD9C9C90DF7688EE02CF61C3A669A93FEB3C68F5D3874CB7078D945DFDDBEB4C91FF92C1D1EDD1F71806BB67C1F276C38C9CE9B89620EE188B36CE89DD63E226CE9B47B6571C215BD6379AFB9D43A33B69BECE98E8F6258898C66F748855C9166B16FA173B01610B2BF599B1982715662D8DAA2356159C80A2588CE945A6D89C860AB743C00AABDF9DCDCBD9553C83682C6E7395E60A4D8678C65BEFD81AFADBE417B3705BE7C16D5A3CC2BE8409A826D3F7C9AD7897B3C60BE1F58652DCC142E794B939752C95BE4117AB9AD34D22F66464DC5797820788538ECCE4AD08E8131CA2DB47091F6041C355D55E7633D91D88B6DB07978C2E321A4BC3634D8F5F11C351BC7CF3178E674219AA1E0000 , N'6.4.4')
END
IF @CurrentMigration < '202009201929348_EnhanceTablesVideosGenres'
BEGIN
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Genres')
AND col_name(parent_object_id, parent_column_id) = 'Name';
IF @var0 IS NOT NULL
EXECUTE('ALTER TABLE [dbo].[Genres] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[Genres] ALTER COLUMN [Name] [nvarchar](255) NOT NULL
DECLARE @var1 nvarchar(128)
SELECT @var1 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Videos')
AND col_name(parent_object_id, parent_column_id) = 'Name';
IF @var1 IS NOT NULL
EXECUTE('ALTER TABLE [dbo].[Videos] DROP CONSTRAINT [' + @var1 + ']')
ALTER TABLE [dbo].[Videos] ALTER COLUMN [Name] [nvarchar](255) NOT NULL
DECLARE @var2 nvarchar(128)
SELECT @var2 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Videos')
AND col_name(parent_object_id, parent_column_id) = 'Classification';
IF @var2 IS NOT NULL
EXECUTE('ALTER TABLE [dbo].[Videos] DROP CONSTRAINT [' + @var2 + ']')
ALTER TABLE [dbo].[Videos] ALTER COLUMN [Classification] [tinyint] NOT NULL
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201929348_EnhanceTablesVideosGenres', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103A16592B76B0401BD8BB489C6461749D045112F466D0D2D8214A512A4905368A3E590F7DA4BE424712254B94E4D86EB2DD028B00814D72FEBF19CED07FFFF9D7F0E32AE4E419A462911839FDDEB14340F851C0C472E4247AF1EE47E7E387EFBF1B5E06E18A3C16E74ED2734829D4C879D23A3E755DE53F4148552F64BE8C54B4D03D3F0A5D1A44EEE0F8F827B7DF77015938C88B90E15D22340B21FB825FC791F021D609E5D32800AECC3AEE781957724D435031F561E44CA36706B33B109AF2D96C764EFD5F4104BD8B79B691AFF72A9F338E0E39E38CA2B21EF08543A81091A61A4D397D50E0691989A517E302E5F7EB18F0DC827205C6C4D3CDF15DAD3D1EA4D6BA1BC282959F281D857B32EC9F18F7B936F94141704AF7A2832F31107A9D5A9D3979E47C0221D1725BD2E998CBF4D48101E8656C8F48B64EF20DF28E18E2A3125908C0F4EF888C13AE130923018996941F91DB64CE99FF33ACEF2324198984F3AA21680AEED51670E956463148BDBE8385316F72E110B74EE7DA8425598526B77D22F4C9C021D7289CCE399438A9F8C9D39104B41624D510DC52AD4162982701649E6E48B764A5FF0B69084C4C43874CE9EA3388A57E1A3983F7EF1D72C55610142B468307C1306B9148CB045A34B4A45ED367B6CC14B6E43FB20022E5608878B6AD9E589CA74D2FDB9A197C5CC928BC8B7841912FCFEEA95C8246FDA3E69E1725D2B73419BA1BFC6D4565C6E8F55199B1FD86CAAF05959654C420500517A872213CFD7CCFC2FD798D39558A2D986FEAA6B125C5B5BDB527E70CDD2F0763D70434F97558FE1539D6967F456EEE967F4958C93EDB431375C5E972734DBE765AD6E5BD767E222A03907C8D28CE953C5F23C0EAE19942380769CCF718C70EC9218F9427F8B5DF0866EDF4A78807E5D9C1F6B3B76990D1D7E5F993667CF2485417CF948A7C96F9A65A1E0D34EAE22E4540B6E0649305A6C24ED1832C469F212A46CE0F0DF5DBF995757FC3CFE0B4CEAFEFD8B5F0465C60966B20677EDE0F8DA9F269D04C18F444505FC1F20932AD5F946303A930E04CE866AD65C26731E2A6536B8B64C7029DAA5432B7772E204680A26EDDBEDF456A595A9AA24B0996975E72CAD0ADA0A779E5228D468A12A095D43459979E80956E497A6CA54DDE2B53F06DE8A4123CD055EBB0D5D894A03A741AC8AB93179D4A83DC20D922AF986DF1284A6AE5444BC5B523B03DB14A65377A3662B83D952A1C0A47D9195137A9A5AC97D1DC0C546E3E51159397DB317A0DA7348EB140564631B342BC7C0E1BBFF3F69F3EC29C87EBAB9621A4D4B694844D0B5D82B58BA251D32B2695C66E80CE697A038D83B071AC1BBB1DC02AE4D6E0D98C5A01B7E278FAB9922D878D462DF5C0F0BF421F846929C97A381B164DBA6C6AA69CCA967E711CF12414DD25AD9B3AEF00ABF4F94A93C3D0B5146FD4AE860B1B95BE1E909DC265D2ECEDC3959797FDC3D541F75F87AB8B43ADF9AE32AA6DECCECFEE21AB2CEDBDDDB9963764955DE7B5F9C6E06C945DFB4829BD2CBF56991D9A92F7F23358A306E6471C820E7A46A461FDF3D64A43D84B0FF4BCDFF89833B47773604A055B80D27967EC0C8EFB03EB99ECEB79B272950AF82EEF565F7CF666A94B5F9CAEF71C29ABE3B678A6D27FA2B239706F65BAE7CBCA37BF75326D798508F0B37EBD57081C01D7993FFEDDCB43C6A2D1954F704A588D9CDF339A5332F96566C88EC88DC432704A8EC91F0782E9B041D4B4DB5F7456B47AED4326DF83C6CDAEDEEE6D26CCFFC950D9ECDF771814BBE7C4FCE6C3AC9CA771CD41DC3132B5CE90DD23641BE7F671EE0DC7CB9AF595C6FFC581B23985BECD08D9EC591031951FF810AB8A2D372CD29FFB04F835AC94672662111598B5342A8E5855700A9A6241A66752B305F5356EFB8055367DA336AF6A97E11C8289B849749C683419C239AFBD79A7D0DF263F9B93EB3A0F6FE2EC7DF6354C4035597AA7DC88F384555E0FAF5A4A71078B34A7CC4D9AC652A737EA725D72BA8EC48E8C8CFBCA52700F61CC9199BA111E7D8643747B50F01996D45F17AD67379397035177FBF082D1A5A4A1323C36F4F815311C84AB0FFF00ABBDF12CE71E0000 , N'6.4.4')
END
IF @CurrentMigration < '202009201942055_dropConstraint'
BEGIN
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009201942055_dropConstraint', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED59CD6EE33610BE17E83B103A16592B76B0401BD8BB489C6461749D045112F466D0D2D8214A512A4905368A3E590F7DA4BE424712254B94E4D86EB2DD028B00814D72FEBF19CED07FFFF9D7F0E32AE4E419A462911839FDDEB14340F851C0C472E4247AF1EE47E7E387EFBF1B5E06E18A3C16E74ED2734829D4C879D23A3E755DE53F4148552F64BE8C54B4D03D3F0A5D1A44EEE0F8F827B7DF77015938C88B90E15D22340B21FB825FC791F021D609E5D32800AECC3AEE781957724D435031F561E44CA36706B33B109AF2D96C764EFD5F4104BD8B79B691AFF72A9F338E0E39E38CA2B21EF08543A81091A61A4D397D50E0691989A517E302E5F7EB18F0DC827205C6C4D3CDF15DAD3D1EA4D6BA1BC282959F281D857B32EC9F18F7B936F94141704AF7A2832F31107A9D5A9D3979E47C0221D1725BD2E998CBF4D48101E8656C8F48B64EF20DF28E18E2A3125908C0F4EF888C13AE130923018996941F91DB64CE99FF33ACEF2324198984F3AA21680AEED51670E956463148BDBE8385316F72E110B74EE7DA8425598526B77D22F4C9C021D7289CCE399438A9F8C9D39104B41624D510DC52AD4162982701649E6E48B764A5FF0B69084C4C43874CE9EA3388A57E1A3983F7EF1D72C55610142B468307C1306B9148CB045A34B4A45ED367B6CC14B6E43FB20022E5608878B6AD9E589CA74D2FDB9A197C5CC928BC8B7841912FCFEEA95C8246FDA3E69E1725D2B73419BA1BFC6D4565C6E8F55199B1FD86CAAF05959654C420500517A872213CFD7CCFC2FD798D39558A2D986FEAA6B125C5B5BDB527E70CDD2F0763D70434F97558FE1539D6967F456EEE967F4958C93EDB431375C5E972734DBE765AD6E5BD767E222A03907C8D28CE953C5F23C0EAE19942380769CCF718C70EC9218F9427F8B5DF0866EDF4A78807E5D9C1F6B3B76990D1D7E5F993667CF2485417CF948A7C96F9A65A1E0D34EAE22E4540B6E0649305A6C24ED1832C469F212A46CE0F0DF5DBF995757FC3CFE0B4CEAFEFD8B5F0465C60966B20677EDE0F8DA9F269D04C18F444505FC1F20932AD5F946303A930E04CE866AD65C26731E2A6536B8B64C7029DAA5432B7772E204680A26EDDBEDF456A595A9AA24B0996975E72CAD0ADA0A779E5228D468A12A095D43459979E80956E497A6CA54DDE2B53F06DE8A4123CD055EBB0D5D894A03A741AC8AB93179D4A83DC20D922AF986DF1284A6AE5444BC5B523B03DB14A65377A3662B83D952A1C0A47D9195137A9A5AC97D1DC0C546E3E51159397DB317A0DA7348EB140564631B342BC7C0E1BBFF3F69F3EC29C87EBAB9621A4D4B694844D0B5D82B58BA251D32B2695C66E80CE697A038D83B071AC1BBB1DC02AE4D6E0D98C5A01B7E278FAB9922D878D462DF5C0F0BF421F846929C97A381B164DBA6C6AA69CCA967E711CF12414DD25AD9B3AEF00ABF4F94A93C3D0B5146FD4AE860B1B95BE1E909DC265D2ECEDC3959797FDC3D541F75F87AB8B43ADF9AE32AA6DECCECFEE21AB2CEDBDDDB9963764955DE7B5F9C6E06C945DFB4829BD2CBF56991D9A92F7F23358A306E6471C820E7A46A461FDF3D64A43D84B0FF4BCDFF89833B47773604A055B80D27967EC0C8EFB03EB99ECEB79B272950AF82EEF565F7CF666A94B5F9CAEF71C29ABE3B678A6D27FA2B239706F65BAE7CBCA37BF75326D798508F0B37EBD57081C01D7993FFEDDCB43C6A2D1954F704A588D9CDF339A5332F96566C88EC88DC432704A8EC91F0782E9B041D4B4DB5F7456B47AED4326DF83C6CDAEDEEE6D26CCFFC950D9ECDF771814BBE7C4FCE6C3AC9CA771CD41DC3132B5CE90DD23641BE7F671EE0DC7CB9AF595C6FFC581B23985BECD08D9EC591031951FF810AB8A2D372CD29FFB04F835AC94672662111598B5342A8E5855700A9A6241A66752B305F5356EFB8055367DA336AF6A97E11C8289B849749C683419C239AFBD79A7D0DF263F9B93EB3A0F6FE2EC7DF6354C4035597AA7DC88F384555E0FAF5A4A71078B34A7CC4D9AC652A737EA725D72BA8EC48E8C8CFBCA52700F61CC9199BA111E7D8643747B50F01996D45F17AD67379397035177FBF082D1A5A4A1323C36F4F815311C84AB0FFF00ABBDF12CE71E0000 , N'6.4.4')
END
IF @CurrentMigration < '202009202001056_AddTableTagsRelateWithTableVideosSetNamesOfColumnsForTableVideoTag'
BEGIN
CREATE TABLE [dbo].[Tags] (
[ID] [int] NOT NULL IDENTITY,
[Name] [nvarchar](max),
CONSTRAINT [PK_dbo.Tags] PRIMARY KEY ([ID])
)
CREATE TABLE [dbo].[VideoTags] (
[VideoID] [int] NOT NULL,
[TagID] [int] NOT NULL,
CONSTRAINT [PK_dbo.VideoTags] PRIMARY KEY ([VideoID], [TagID])
)
CREATE INDEX [IX_VideoID] ON [dbo].[VideoTags]([VideoID])
CREATE INDEX [IX_TagID] ON [dbo].[VideoTags]([TagID])
ALTER TABLE [dbo].[VideoTags] ADD CONSTRAINT [FK_dbo.VideoTags_dbo.Videos_VideoID] FOREIGN KEY ([VideoID]) REFERENCES [dbo].[Videos] ([ID]) ON DELETE CASCADE
ALTER TABLE [dbo].[VideoTags] ADD CONSTRAINT [FK_dbo.VideoTags_dbo.Tags_TagID] FOREIGN KEY ([TagID]) REFERENCES [dbo].[Tags] ([ID]) ON DELETE CASCADE
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009202001056_AddTableTagsRelateWithTableVideosSetNamesOfColumnsForTableVideoTag', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED5ADD6EDB3614BE1FB0771074B50DA9152728B005768BD4490A637512C469B13B839668871845692215D818F664BBD823ED15764451B24452B6E438695714050A87E4F9FF78489EA37FFFFE67F0761552E711279C446CE8F67BC7AE83991F05842D876E2A16AF7E76DFBEF9FEBBC16510AE9C4FC5BAD36C1D50323E741F8488CF3C8FFB0F3844BC17123F8978B4103D3F0A3D1444DEC9F1F12F5EBFEF6160E1022FC719DCA54C9010CB3FE0CF51C47C1C8B14D1491460CAD538CC4C2557E71A8598C7C8C74377123D123CBBC34C203A9BCDDE21FF77CC82DEC55C4EE4E3BDCA6FC9D175CE2941A0EC14D385EB20C62281049872F691E3A94822B69CC63080E8FD3AC6B06E8128C7CAC4B3CDF2B6D61E9F64D67A1BC282959F7211851D19F64F95FB3C9D7CAF20B8A57BC1C1971008B1CEAC964E1EBAEF314BC0725DD2D98826D9AA3D03D0936C8F1C39EEE413CE2B47111F95C8020066FF8E9C514A459AE021C3A948103D726ED33925FEAF787D1F01C990A594560D015360AE360043B74914E344ACEFF0429937BE701DAF4EE7E98425598526B77DCCC4E989EB5C837034A7B8C449C54F53112518ACC5091238B84542E004C23C0EB0F4B4215D9395FD5F480360C236749D095A7DC06C291E86EEC9EBD7AE73455638284694061F19815D0B442249B145434DEA357A244BA9B026FF130970C45D081195D3FC81C4F9B6E9C9A999C2C755128577112D28F2E1D93D4A965880FE9139378DD2C4D73419781BFC6D45A5647478544AB6DF50F9A5A052930A18C488E30B50B9109EFDBE2761775E238A38270BE2ABBCA96CC970AD4F75E42CD1BD3B186D37A0DA5FFBEDBF628FD9F65FB137DB2A728F96DBF2403EADAB918D366821A76C4AB44E02C0E1F02900987E4B004F4D00F0B3550238D829B4057DF633A806CC76E84BC30AF6F42431E657145896861E1A967579874628C425C0095D431C7325DFAD21C7D68333C1E11C27CAFC29A1F048709D4F88A6F067DF08656DF5FB8806E5DA93ED6B6FB30883AFCBF5A7667CF2485407CF398F7C227D53858CCA8E7571972C70B6A4CACD41A02E1913F02089C167808AA1FB93A1BE9D5F09BB0D3F95AAEBFCFAAE9E0D6ED8051C74023BE77EFE241821EEA3C0DC2EE089A03E02090427D90E4614DE501C024E9830B30D613E8901378D5A6B242D5354A652C95C9FB9C0310014746BF67D1BA9E5E96A8A2E25685EDAE5948157414F1B50C964B31D03F573EFC990AA27B20D3B79026E65D6685C9EE5C02102DC51EEBE4ADE5129255B8157C292D1E0A9AC921A57F95C37229330C5A21A3AC8D29BFC5ADF17860FEAE4C51960902B9FEE20CF4F0883587A5023AD784C135FDCB62A2B2C97311D99DB134EA9E8C64403DBDB534C8543E1633D53D44D6A6D6EEEB4266BCD7DB06B27EC636B0DFB1506B96EAD0D2DCEF512F19BA2929757958AEA93D7507E1A4C501CC309592947A911679AD7A246AFA6DD2B3061CEC3F3B9A510536A5B4A827B1B5A626D164483A65724E1025E44688EB22BC828088D65CDFBBB61F714726B5BD80C59B1AB8AE5D9EF4A46D9AF3C64391014FF2BF041989D25F21AABE3DFA4939543445162B9328F229A86ACF94C6BA6CE2FC155FA7CC4E430F034C58DC3CB70A171D4D703D22A5C6A8F3D7FB8F214DC3D5C0D749F3B5C4D1C6A05882AA3DA447B7EFA23A2CA529F6BCFB5BC2255D935DE9B3E1B381B4E8F4343333BE0BB03D34AF5B961F9DC81AA9F9D9654A2EE0307C9168A97352358BC9F5D0B6C4581DAFDC2F458AB784946F63745456A27851ADF51AD140216DDD4D1EF3D66788DEB8FBEA40457790DD2AE3B0375F5D8DD9233EE22F912D701DD1FC147700F99AEB9C0612F5BD09BFE414794003E360B26889105E6222F51B827C7FD13AD65F7E5B4CF3CCE03DAA687F6E2654092B97467A1AF6379BB5AF9638F28F11F506216FFB732EDD8E5F9E6B746A6968E4800BFC5E13A2282B0B5F4C7D3BA209285514118B300AF86EE9F92E6CC19FF36536447CE4D0269E0CC3976FE3A14988C43E5AB82D20F215AFD58E56416D8BB6DBB3DDDD57C969A6BADC7DC6EEF9622BA414B91758096295A69DC4DB0243A00A2F7AB71AB8AD58B96A1B512CE3E15D0BD2AD94D5583E7295EFFAFEAD5D62B72F7403D274C64295657607785FB496D8F17038BFD19DA257FBE305E6C2F984AC4F46059E2F41561A56DF45E12298D8FC483E3C4DE2A322BCE0D659FFA872C4DDD9FFC8D08F7D7799686F2C3B1A19B61ED0C3537866C9CEDDD075BD3A8A96764E36A6D4958B5B533DE4C35EA6C15F17C0DAB5AD02A15F69D6D1BB3D773D0A654D951DAD69B6A280B7557B521FFD8CA560735B2E87A6D35D25E6AD253B556DB7C09033B74DCCCD212A4ABCA37E1902939596E58645F8833ECD71255B966CC1651912E358D8A25DAB57E82058277333A4F0459205FC0B48FE1319C7DD5A4BE42B90CE73818B39B54C4A900937138A7B5AFA4B2BCBB4DBE6C2BD6751EDCC4F263A64398006A92ECE97FC3DEA5A4F2B5CD95E57DD1C0224BE8EA959AC55264AFD5E5BAE4741DB1968C94FBCA73E81E87310566FC864DD123DE47B78F1C7FC04BE4AF8B0A613393DD81A8BB7D7041D0324121573C36F4F027603808576FFE0348EC837C1A310000 , N'6.4.4')
END
IF @CurrentMigration < '202009202008053_SetRequiredColumnNameTableTag'
BEGIN
DECLARE @var3 nvarchar(128)
SELECT @var3 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.Tags')
AND col_name(parent_object_id, parent_column_id) = 'Name';
IF @var3 IS NOT NULL
EXECUTE('ALTER TABLE [dbo].[Tags] DROP CONSTRAINT [' + @var3 + ']')
ALTER TABLE [dbo].[Tags] ALTER COLUMN [Name] [nvarchar](255) NOT NULL
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'202009202008053_SetRequiredColumnNameTableTag', N'Movie_Rental___Backend.DbMovieRental.MovieRentalMigrations.Configuration', 0x1F8B0800000000000400ED5ADD6EDB3614BE1FB077107439A4567E50600BEC16A99314C6EA2488D36277012DD10E318AD2442A8831ECC976B147DA2BEC50A264893FB6E43A69B715058A98E4F9FF78489EA3BFFFFC6BF8F629A6DE23CE3849D8C83F1A1CFA1E66611211B61CF9B958BCFAD17FFBE6FBEF861751FCE47DAAD69DC87540C9F8C87F10223D0D021E3EE018F1414CC22CE1C9420CC2240E509404C787873F0547470106163EF0F2BCE16DCE048971F1037E8E1316E254E4884E930853AEC661665670F5AE508C798A423CF2A7C923C1F7B7980944EFEFEFDFA1F057CCA2C1F9BC9828C7078DBF0B8EBE774609026567982E7C0F31960824C094D38F1CCF4496B0E52C850144EF562986750B443956269EAE9777B5F6F0585A1BAC092B5661CE4512F7647874A2DC17E8E43B05C1AFDD0B0EBE80408895B4BA70F2C87F8F590696EB924EC73493AB760CC0A0607BE015E35E39E1BDF214F1418D2C00A0FC77E08D732AF20C8F18CE4586E8817793CF29097FC6ABBB0448462CA7B46908980273AD0118BAC992146762758B17CABCC9B9EF056DBA4027ACC91A34A5ED13264E8E7DEF0A84A339C5354E1A7E9A8924C3602DCE90C0D10D12026710E649840B4F1BD23559F2FF4A1A0013B6A1EF4DD1D307CC96E261E41FBF7EED7B97E40947D588D2E02323B06B81486439B668A849BD428F645928ACC9FF44229C701F42448B69FE40D272DB0C8AA97B858FCB2C896F135A5194C3F777285B6201FA27E6DC2CC9B350D36418ACF1B7119505A3FDA3B260FB0D955F0B2A35A980418C383E07952BE1F2EF3B12F7E735A68873B220A1CA9BCA16896B7DAA27E702DDDB83D17503AAFDB5DBFEABF6986DFF557BB3AB227768B9290F94D3BA1A72D4A145316553A27312000EFB4F01C0F45B02F85A12C0EEC7D20638DA0FA51652BBC1318F1B60D4B3C6845F5260595BB66F9CB6E5ED1BB210A808677405812D957CB782A4DB0ECE14C7739C29F36784C2ABC1F73E219AC3CF232394ADD5EF131AD56B8F37AFBD9111065FD7EB4FCCF89491680E9E719E84A4F04D13322A5DB6C55DB0C8DB903BD72783BA754CC18324059F012A46FE0F86FA767E35ECD6FC54EE6EF33BF2F5F470CDCEE1E413D83B0BCB37C218F11045E676014F44ED11C82838935B1A51785471083861C24C3F84852405DC38B5D6483AE62CA952CD5C9F39C72900147473FBBE8BD4FAB83545D712342F6D73CA3068A0A70BA88A64B31903ED83F0B321D54E646B76C591B89199D3B832CB814304B8A3DE7D8DBCA3528A5C819F8425A3C1DB592535AE12BC6E849430C3A2193AC8D2EBFCDADE17860FDAE4D51960902B9F6E212F4F0883B8F0A046DAF09826BEBA7E3556586E673A3237279C5AD1B58906B637A7980687CAC77AA6689BD4D9DCD2692E6BCD7DB06D27EC626B0BFB0D06A56E9D0DADCEF51AF1EB2A53509699AA7254E0A8470DA7284DE1846CD4A7D488372B8B53E357B3FE2599B8E41184DC5299A9B5AD25C1450E2DB1360BA241D34B9271014F243447F20A328E6263997B7F3B764F25B7B585CD9055BBAA5A2EFF6E6494DDEA45960341F1BF041FC4F22C29EEB53AFE4DBAA2948828CA2C77E87142F398B9CF343775792B6ED29723268761A0296E1C5E860B8DA3BE1D904EE1527BECF9C355A6E0FEE172D07DE970B938B42A124D46AD89EEFCF4474493A53ED79D6B7D456AB273DE9BBE18381DA7C7BEA1290FF8FEC0B4527D69583E77A0DA67A72595A8FBC05EB285E265CD0816EFCB6B81AD28D0BA5F981EEB14AF8291FD4DD190DA4B21E73BAA9342C0A29F3AFABDC70CAF71FDD197D4E0AAAF41DA7567A8AE1EDB7B74C65DA45CE27BA0FB23F808EE21B31517381EC80583D96F744C09E063BD608A1859602ECA12857F7C7874ACF5F0BE9E7E5AC07944BB34D55EBC2E48A44BB756FE7AD6BB9BA540F688B2F0016566317023D39E6D9F6F7E7332B5B44822F85BECAF4522085B15FEF8BCB648C1C2A8204C58849F46FEEF05CDA937F9E55E911D78D719A48153EFD0FB635F60320E95FF3394FA6DC11D5DE73E57CDB5D6236FBBA76B11FD60A6C87AC0CC14AD34EE27B820DA03BA77AB77ABEAD58B96A4B572CE2ED5D09DAADAAE0AC2F314B2FF55B56BEB75B97FA09E132645595657607BB5FBB35A202F0616FB93B44FFE7C61BCD85E338D88E9C1B2C4E93F8495AED17B49A4381F8C7BC789BD6D64569F1D25A0F6572EAE4E50F95E84BBEC5CA6A1F270747436AC5D227793C8C6D9DE89B035905CFD231B576B7BC2AAAD9DF17ACAA9B355C4F335AF5A416B54DBB7B670CCBECF5E1B54757769539FCA5122EAAFAA23FFD84A587B35B2EA806D34D25E76D253B556E77C09037B74DFCC3213A4ABC607E390293959AE59C8CFC7190E5B89AA5E33618BA44A979A46D512ED5A3FC502C11B1A9D65822C5028603AC4F030969F3CA92F522EE2398E26EC3A17692EC0641CCF69EB132A997737C92F5A8C6D9D87D769F161D33E4C0035892C035CB37739697C797369795F3858C884AE5EAC329642BE5C97AB9AD355C23A3252EEABCFA13B1CA71498F16B36438F7817DD3E72FC012F51B8AAAA856E26DB03D176FBF09CA0658662AE78ACE9E12760388A9FDEFC035675D9AA37310000 , N'6.4.4')
END