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

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(1) from SystemSetting where SettingKey = 'AllowSecondHandDepositSales') = 0
BEGIN
INSERT INTO SystemSetting 
(SettingKey, SettingCategoryId, SettingValueBit, TypeFlag) 
VALUES
('AllowSecondHandDepositSales', 1, 1, 4)
END
IF (SELECT COUNT(1) FROM System_Default WHERE default_name = 'ISJV' AND Default_Value = '1') > 0
BEGIN
UPDATE SystemSetting SET SettingValueBit = 0 WHERE SettingKey = 'AllowSecondHandDepositSales'
END

ALTER TABLE lay_bye
ADD LaybyStockStatusId INT DEFAULT(0);
GO

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='LaybyStockStatus' AND xtype='U')
BEGIN
    CREATE TABLE LaybyStockStatus (
        LaybyStockStatusId INT PRIMARY KEY IDENTITY(1,1),
        Description NVARCHAR(255)
    );
END;
INSERT INTO LaybyStockStatus (Description)
VALUES 
('To Be Ordered'),
('Order Sent'),
('Ready for Final Payment'),
('Collected'),
('Back to Floor');
GO

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

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