CREATE TABLE [dbo].[usp_mailbox]
(
[id] [int] NOT NULL,
[del] [int] NOT NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[check_interval] [int] NULL,
[description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[email_type] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_port] [int] NULL,
[name] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[password] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[security_lvl] [int] NULL,
[userid] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[attmnt_repository] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[use_reply_to_address] [int] NULL,
[allow_anonymous] [int] NULL,
[save_unknown_emails] [int] NULL,
[attach_email] [int] NULL,
[split_out_attachment] [int] NULL,
[tenant] [binary] (16) NULL,
[email_address_per_hour] [int] NULL,
[exclusion_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[inclusion_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[log_policy_violation] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[usp_mailbox] ADD CONSTRAINT [PK__usp_mailbox__47919582] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usp_mailbox_X0] ON [dbo].[usp_mailbox] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usp_mailbox] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[usp_mailbox] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[usp_mailbox] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[usp_mailbox] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[usp_mailbox] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'usp_mailbox', NULL, NULL
GO