Distributed patch: version 8.0.0 R1 to v8.1

For the new version robot 8.1, after performed the installation in NMC, we can notice that there is no option to apply the patch. So, you should to run the following SQL query on your NMC server (on NewtestReference): 

DECLARE @vID SMALLINT, @vPackageId INT

IF NOT EXISTS (SELECT VRS_ID FROM NewtestReference.dbo.Version WHERE VRS_NUM = '8.0.0 R1')

 BEGIN

       INSERT INTO [dbo].[Version]([VRS_NUM], [VRS_DATE]) VALUES ('8.0.0 R1', GETDATE())

END

SET @vID = (SELECT VRS_ID FROM NewtestReference.dbo.Version WHERE VRS_NUM = '8.0.0 R1')

SET @vPackageId = (SELECT PCK_ID FROM NewtestReference.dbo.Package WHERE PCK_DESC = '8.1.0R0 - (Distribution Suite)')

INSERT INTO [dbo].[Package_Version] ([PCK_ID], [VRS_ID])

VALUES (@vPackageId, @vID)