Use ManageSoft -- adust RMS DB name here

Set Identity_Insert SecurityPatchUIProductGroup ON

	Delete From SecurityPatchUIProductGroup
	Where Product = 'Java Runtime'

	IF NOT EXISTS (SELECT * FROM SecurityPatchUIProductGroup WHERE Product like 'Java Runtime 8')		
		INSERT INTO SecurityPatchUIProductGroup (GroupName, Product, SecurityPatchUIProductGroupID)
			VALUES ('Java', 'Java Runtime 8', 302)

	IF NOT EXISTS (SELECT * FROM SecurityPatchUIProductGroup WHERE Product like 'Java Runtime 9')		
		INSERT INTO SecurityPatchUIProductGroup (GroupName, Product, SecurityPatchUIProductGroupID)
			VALUES ('Java', 'Java Runtime 9', 331)

Set Identity_Insert SecurityPatchUIProductGroup OFF
	
	IF NOT EXISTS (SELECT * FROM SecurityPatchApplication WHERE Description like 'Java Runtime 8')	
		INSERT INTO SecurityPatchApplication (Description, ApplicationID, Selected, Visible)
			VALUES ('Java Runtime 8', 302, 1, 1)

	IF NOT EXISTS (SELECT * FROM SecurityPatchApplication WHERE Description like 'Java Runtime 9')	
		INSERT INTO SecurityPatchApplication (Description, ApplicationID, Selected, Visible)
			VALUES ('Java Runtime 9', 331, 1, 1)