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

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 ReturnQuestion set Description = 'Does the customer have their CashPOS till slip with the correct item and serial number (if applicable) and dated within 12 months from today?'
where Description = 'Does the customer have their CashPOS till slip with the correct item and serial number (if applicable) and dated within 6 months from today?';

update ReturnQuestion set Description = 'Are there any obvious signs of infestation, abuse, impact or alterations like a cut plug that you can see with a naked eye?'
where Description = 'Are there any obvious signs of abuse, impact or alterations like a cut plug that you can see with a naked eye?';

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'GpMinimum')
BEGIN
CREATE TABLE [dbo].[GpMinimum](
    [GpMinimumId] [bigint] IDENTITY(1,1) NOT NULL,
    [GpValueFrom] [decimal](10, 2) NOT NULL,
    [GpValueTo] [decimal](10, 2) NOT NULL,
    [LowestGpPercAllowed] [decimal](10, 2) NOT NULL,
 CONSTRAINT [PK_GpMinimum] PRIMARY KEY CLUSTERED 
(
    [GpMinimumId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO

IF (select count(1) from GpMinimum) = 0
BEGIN
INSERT INTO GpMinimum 
(GpValueFrom, GpValueTo, LowestGpPercAllowed) 
VALUES 
(0, 1000, 38),
(1001, 3000, 36),
(3001, 5000, 35),
(5001, 7500, 32.5),
(7501, 99999, 30)
END
GO

IF (OBJECT_ID('spGetGpMinimums', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spGetGpMinimums
END
GO
CREATE PROCEDURE spGetGpMinimums
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT * FROM GpMinimum
END
GO

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LowPricingAuth')
BEGIN
CREATE TABLE [dbo].[LowPricingAuth](
    [LowPricingAuthId] [bigint] IDENTITY(1,1) NOT NULL,
    [Stock_Item_ID] [bigint] NOT NULL,
    [AuthDate] [datetime] NOT NULL,
    [Rrp] [decimal](10, 2) NOT NULL,
    [System_User_ID] [bigint] NOT NULL,
    [Reason] [varchar](max) NOT NULL,
 CONSTRAINT [PK_LowPricingAuth] PRIMARY KEY CLUSTERED 
(
    [LowPricingAuthId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO

IF (OBJECT_ID('spLogGpMinimumsOverride', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spLogGpMinimumsOverride
END
GO
CREATE PROCEDURE spLogGpMinimumsOverride
    @StockItemId bigint,
    @Rrp decimal(10, 2),
    @SystemUserId bigint,
    @Reason varchar(max)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    INSERT INTO LowPricingAuth 
    (Stock_Item_ID, AuthDate, Rrp, System_User_ID, Reason) 
    VALUES 
    (@StockItemId, GETDATE(), @Rrp, @SystemUserId, @Reason)
END
GO

/*Turn on for JV only*/
IF (select count(1) from SystemSetting where SettingKey = 'GpMinimums') = 0
BEGIN
    INSERT INTO SystemSetting 
    (SettingKey, SettingCategoryId, SettingValueBit, TypeFlag) 
    VALUES
    ('GpMinimums', 1, (select count(1) from System_Default where Default_Name = 'ISJV' and Default_Value = '1'), 4)
END

IF (select count(1) from System_Function where Function_Key_Word = 'GpMinimum') = 0
BEGIN
    SET IDENTITY_INSERT System_Function ON
    INSERT INTO System_Function 
    (System_Function_ID, Description, Tool_Tip_Text, Allow_Check_List, Requires_Authentification, Function_Key_Word, RightSet, IsMenuBased) 
    VALUES 
    (144, 'RRP update on Quaranteen Release, below minumum percentage', 'None', 0, 1, 'GpMinimum', 1, 0)
    END
    SET IDENTITY_INSERT System_Function OFF
GO

UPDATE [System_User] SET Global_User_ID = NULL WHERE Global_User_ID = 169 AND First_Name = 'Taneil' AND Surname = 'Ramroop'

IF (select count(1) from Profile where Profile_ID = 20) = 0
BEGIN
    SET IDENTITY_INSERT Profile ON
    INSERT INTO Profile
    (Profile_ID, Description) 
    VALUES 
    (20, 'Global User')
    SET IDENTITY_INSERT Profile OFF
END

IF (select count(1) from System_Function_Profile where Profile_ID = 20 AND System_Function_ID = 144) = 0
BEGIN
    INSERT INTO System_Function_Profile 
    (Profile_ID, System_Function_ID, Right_Type_ID) 
    VALUES 
    (20, 144, 5)
END

IF (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = 2) = 0
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES 
    (2, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

DECLARE @systemUserId bigint;

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 32)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 40)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 16)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 38)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 19)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 13)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 36)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 62)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 88)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 96)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 110)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 133)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 138)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 141)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 158)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 163)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 168)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 169)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 184)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 195)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 198)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 202)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 204)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 210)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 211)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 212)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 214)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 220)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 221)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 222)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 224)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 228)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 230)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 231)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 239)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END

SET @systemUserId = (SELECT System_User_ID FROM [System_User] WHERE Global_User_ID = 240)
IF (@systemUserId IS NOT NULL AND (select count(1) from System_User_Function where System_Function_ID = 144 AND System_User_ID = @systemUserId) = 0)
BEGIN
    INSERT INTO System_User_Function 
    (System_User_ID, System_Function_ID, Right_Type_ID, Store_ID) 
    VALUES
    (@systemUserId, 144, 5, (SELECT Default_Value FROM System_Default where Default_Name = 'Main_Store_ID'))
END


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

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