CREATE TABLE [dbo].[SMTP]
(
[SMTPPriKey] [int] NOT NULL IDENTITY(1, 1),
[Host] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Port] [int] NULL CONSTRAINT [DF_SMTP_Port] DEFAULT (25),
[NeedLogin] [int] NULL CONSTRAINT [DF_SMTP_NeedLogin] DEFAULT (0),
[UserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HasFirewallProxy] [int] NULL CONSTRAINT [DF_SMTP_HasFirewallProxy] DEFAULT (0),
[FirewallProxyHost] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirewallProxyPort] [int] NULL,
[FirewallProxySocksVersion] [int] NULL CONSTRAINT [DF_SMTP_FirewallProxySocksVersion] DEFAULT (0),
[FirewallProxyNeedsLogin] [int] NULL CONSTRAINT [DF_SMTP_FirewallProxyNeedsLogin] DEFAULT (0),
[FirewallProxyUserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirewallProxyPassword] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EnableSsl] [bit] NOT NULL CONSTRAINT [DF_Smtp_EnableSsl] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SMTP] ADD CONSTRAINT [PK_SMTP] PRIMARY KEY CLUSTERED  ([SMTPPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[SMTP] TO [MssExec]
GRANT INSERT ON  [dbo].[SMTP] TO [MssExec]
GRANT DELETE ON  [dbo].[SMTP] TO [MssExec]
GRANT UPDATE ON  [dbo].[SMTP] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Proxy Name or IP address', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxyHost'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0-No 1-Yes', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxyNeedsLogin'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Proxy login password', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxyPassword'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Proxy Port Number', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxyPort'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Socks version 0-NoSocks 1-Socks4 2-Socks4A 3-Socks5', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxySocksVersion'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Proxy login id', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'FirewallProxyUserID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0- No 1-Yes', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'HasFirewallProxy'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Host name or IP address - mail.moverssuite.com', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'Host'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0- No 1-Yes', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'NeedLogin'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Login password', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'Password'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Port Number-25-SMTP', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'Port'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Login id', 'SCHEMA', N'dbo', 'TABLE', N'SMTP', 'COLUMN', N'UserID'
GO