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

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

if((select count(0) from SystemSetting where SettingKey = 'ParAvailThreshold')=0)
begin
insert into SystemSetting(SettingKey,SettingCategoryId,SettingValueString,SettingValueDecimal,TypeFlag)
values ('ParAvailThreshold',1,'2057,2067',2650.00,4);
end;

IF (SELECT count(*)
    FROM SystemSetting
    WHERE SettingKey = 'AccessManagement') = 0
    BEGIN
        INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueString, TypeFlag)
        VALUES ('AccessManagement', 1, '1,2,150,235,264', 4)
    END
GO

update systemsetting set settingvaluedecimal = 100.00 where settingkey in ('KeylineAvailability','PromoAvailability');

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

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