CREATE TABLE [dbo].[Act2SignLog](
	[ID] [uniqueidentifier] NOT NULL,
	[RequestID] [uniqueidentifier] NOT NULL,
	[RequestHID] [int] NOT NULL,
	[RequestDescription] [nvarchar](255) NOT NULL,
	[StiplyID] [int] NOT NULL,
	[DocumentSignCount] [int] NOT NULL,
	[DocumentAttachmentCount] [int] NOT NULL,
	[HasGeneralConditions] [tinyint] NOT NULL,
	[SMSCount] [int] NOT NULL,
	[iDinCount] [int] NOT NULL,
	[IsCompleted] [tinyint] NOT NULL,
	[IsRejected] [tinyint] NOT NULL,
	[Syscreated] [datetime] NOT NULL,
	[Sysmodified] [datetime] NULL,
 CONSTRAINT [PK_Act2SignLog] 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]
GO

ALTER TABLE [dbo].[Act2SignLog] ADD  DEFAULT (newsequentialid()) FOR [ID]
GO

ALTER TABLE [dbo].[Act2SignLog] ADD  DEFAULT (getdate()) FOR [Syscreated]
GO

ALTER TABLE [dbo].[Act2SignLog] ADD  DEFAULT (0) FOR [IsCompleted]
GO
ALTER TABLE [dbo].[Act2SignLog] ADD  DEFAULT (0) FOR [IsRejected]
GO



delete from BacoSettings where SettingType = 0 and SettingGroup = 'general' and SettingName = 'CSGKToolsSuiteLic'
delete from BacoSettings where SettingType = 0 and SettingGroup = 'general' and SettingName = 'CSGKToolsSuiteProd'

update BacoSettings set SettingName = REPLACE(SettingName, 'CSGKToolsAct2Sign', 'CSEasyAct2Sign') where SettingType = 0 and SettingGroup = 'general' and SettingName like 'CSGKToolsAct2Sign%'
go
