CREATE TABLE [dbo].[MoversConnectSetup]
(
[MoversConnectSetupID] [int] NOT NULL,
[CloudServiceLogin] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceAppName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CloudServiceAppVersion] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Token] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TokenObtained] [datetime] NULL,
[TokenExpires] [datetime] NULL,
[WorkTimeStart] [numeric] (5, 2) NULL,
[WorkTimeEnd] [numeric] (5, 2) NULL,
[UserName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateModified] [datetime] NOT NULL,
[ModifiedBySysUserFID] [int] NOT NULL,
[ActivateEmail] [bit] NOT NULL,
[EmailProfile] [sys].[sysname] NULL,
[ConnectionsLastVerifiedDate] [datetime] NULL,
[ExternalAccountIdentifier] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MoversConnectBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_MoversConnectSetup_MoversConnectBaseUrl] DEFAULT (' '),
[ApiServiceUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_MoversConnectSetupID] CHECK (([MoversConnectSetupID]=(1)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_WorkTimeEnd] CHECK (([WorkTimeStart]<[WorkTimeEnd] AND [WorkTimeEnd]<=(24)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [CK_WorkTimeStart] CHECK (([WorkTimeStart]>=(0) AND [WorkTimeStart]<(24)))
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [PK_MoversConnectSetup] PRIMARY KEY NONCLUSTERED  ([MoversConnectSetupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectSetup] ADD CONSTRAINT [FK_MoversConnectSetup_Sysuser] FOREIGN KEY ([ModifiedBySysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[MoversConnectSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoversConnectSetup] TO [MssExec]
GO