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

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

/*
========================
	SERVICE URL
========================
*/

IF (select count(1) from System_Default where Default_Name = 'AuthService') = 0
BEGIN
insert into System_Default (Default_Name, Default_Value) values ('AuthService', 'https://storeauthservice.cashpos.co.za:5030/AuthService.svc')
END

/*
========================
	VERSION UPDATE
========================
*/

UPDATE System_Default
SET Default_Value = '2.0.3.1'
WHERE Default_Name = 'CurrentVersionNumber'

/*
========================
	TABLE CREATION
========================
*/

IF OBJECT_ID('dbo.ServiceProdA') IS NULL
BEGIN
CREATE TABLE [dbo].[ServiceProdA](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ProdA] [varchar](max) NOT NULL,
 CONSTRAINT [PK_ServiceA] 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

/*
========================
	POPULATE TOKEN
========================
*/

IF (select count(1) from ServiceProdA) = 0
BEGIN
insert into ServiceProdA (ProdA) values ('khPmPYBieKOZYT06r2WaQB/+XcqyeHB6xGqMEN89sMc57Mk4lwQv5/xJfeN9Uq5MJo6vlRPVh9SoTyar34RtvRT85fiaNGkhKjLo43mPK1s=')
END
GO

/*
========================
	PROC CREATION
========================
*/
IF (OBJECT_ID('spGetServiceA', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spGetServiceA
END
GO
CREATE PROCEDURE spGetServiceA 
	-- Add the parameters for the stored procedure here	
AS
BEGIN
	select ProdA from ServiceProdA
END
GO

/*
========================
	PROC CREATION
========================
*/
IF (OBJECT_ID('spSetServiceA', 'P')) IS NOT NULL
BEGIN
DROP PROCEDURE spSetServiceA
END
GO
CREATE PROCEDURE spSetServiceA 
	-- Add the parameters for the stored procedure here
	@ProdA varchar(max)
AS
BEGIN
	declare @count bigint;
	set @count = (select count(1) from ServiceProdA)

	--no record exists, add it
	if @count = 0
	BEGIN
		insert into ServiceProdA (ProdA) values (@ProdA)
	END

	--record exists, update it
	if @count > 0
	BEGIN
		update ServiceProdA set ProdA = @ProdA
	END
END
GO

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

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