Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='WarrantyUpdateWM31Oct2023';

if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO

UPDATE Product
SET [2nd_Warranty_Period_ID] = 7
WHERE Product_Category_ID IN 
	(SELECT Product_Category_ID 
	FROM product_category 
	WHERE Master_Category_ID IN (973, 1943, 972, 1942, 791, 1768, 573, 1562) AND IsSecondHand = 1) 
AND [2nd_Warranty_Period_ID] <> 7;

UPDATE product_category 
SET Default_Warrant_Period_ID = 7 -- 6 months
WHERE Master_Category_ID IN (973, 1943, 972, 1942, 791, 1768, 573, 1562) AND IsSecondHand = 1 AND Default_Warrant_Period_ID <> 7;

Print 'Insert into script history if everything else is cool';

	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'WarrantyUpdateWM31Oct2023');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO