9300-LINKSOFT Upgrade to 9400.sql

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_LBS_KIT_ITEM_LBS_INVENTORY". The conflict occurred in database "CLIENT-EXTRA-CASE9273", table "dbo.LBS_INVENTORY".

IF OBJECT_ID(N'[dbo].[LBS_KIT_ITEM]') IS NOT NULL
	AND OBJECT_ID(N'[dbo].[LBS_INVENTORY]') IS NOT NULL
	AND NOT EXISTS (SELECT * FROM sys.objects WHERE [object_id]=OBJECT_ID(N'[dbo].[FK_LBS_KIT_ITEM_LBS_INVENTORY]') AND [parent_object_id]=OBJECT_ID(N'[dbo].[LBS_KIT_ITEM]'))
BEGIN
		ALTER TABLE [dbo].[LBS_KIT_ITEM]
			WITH CHECK
			ADD CONSTRAINT [FK_LBS_KIT_ITEM_LBS_INVENTORY]
			FOREIGN KEY ([COMPANY_ID], [PART_NO]) REFERENCES [dbo].[LBS_INVENTORY] ([COMPANY_ID], [part_no])
		ALTER TABLE [dbo].[LBS_KIT_ITEM]
			CHECK CONSTRAINT [FK_LBS_KIT_ITEM_LBS_INVENTORY]

END