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

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 OBJECT_ID('dbo.Status_Log_A') IS NULL
BEGIN
CREATE TABLE [dbo].[Status_Log_A](
    [Id] [bigint] IDENTITY(1,1) NOT NULL,
    [Value1] [text] NOT NULL,
 CONSTRAINT [PK_Status_Log] PRIMARY KEY CLUSTERED 
(
    [Id] 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('dbo.Status_Log_B') IS NULL
BEGIN
CREATE TABLE [dbo].[Status_Log_B](
    [Id] [bigint] IDENTITY(1,1) NOT NULL,
    [Value1] [text] NOT NULL,
 CONSTRAINT [PK_Status_Log_B] PRIMARY KEY CLUSTERED 
(
    [Id] 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 (select count(1) from Status_Log_A) = 0
BEGIN
INSERT INTO Status_Log_A (Value1) VALUES ('JVBGre6By94ESTONIZqa9NajQqHqYgk3te2J/o8DDb9GlWFhy0i0plYPGwWYJE4nOL0vteKMpR9NliU1gnLXxw==')
END
GO

IF (select count(1) from Status_Log_B) = 0
BEGIN
INSERT INTO Status_Log_B (Value1) VALUES ('oeYJjw5HKeyMOjrqdWq0H1cGYSGfoihC/X7kOF6n78w=')
END
GO

IF (OBJECT_ID('spStatusLogUpdate', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spStatusLogUpdate
END
GO
CREATE PROCEDURE spStatusLogUpdate 
    -- Add the parameters for the stored procedure here
    @Param1 int,
    @Param2 text
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    IF (@Param1 = 1)
    BEGIN
        UPDATE Status_Log_A SET Value1 = @Param2;
    END
    ELSE IF (@Param1 = 2)
    BEGIN
        UPDATE Status_Log_B SET Value1 = @Param2;
    END;
END
GO

IF (OBJECT_ID('spGetStatusLog', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spGetStatusLog
END
GO
CREATE PROCEDURE spGetStatusLog 
    -- Add the parameters for the stored procedure here
    @Param1 int
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    IF (@Param1 = 1)
    BEGIN
        SELECT Value1 FROM Status_Log_A;
    END
    ELSE IF (@Param1 = 2)
    BEGIN
        SELECT Value1 FROM Status_Log_B;
    END;
END
GO

update System_Default set Default_Value ='2.0.3.2' where Default_Name = 'CurrentVersionNumber';

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

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