CREATE TABLE [dbo].[not_log]
(
[id] [int] NOT NULL,
[del] [int] NOT NULL,
[last_mod] [int] NULL,
[nlh_hdr] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nlh_msg] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nlh_msg_html] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nlh_c_alias] [binary] (16) NULL,
[nlh_c_addressee] [binary] (16) NULL,
[nlh_email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nlh_cm_method] [int] NULL,
[nlh_transition] [int] NULL,
[nlh_pri] [int] NULL,
[nlh_type] [int] NULL,
[nlh_ack_time] [int] NULL,
[nlh_status] [int] NULL,
[nlh_user_ack] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nlh_start] [int] NOT NULL,
[nlh_ack_by] [int] NULL,
[nlh_end] [int] NULL,
[cntxt_obj] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cmth_used] [int] NULL,
[tenant] [binary] (16) NULL,
[context_instance] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[not_log] ADD CONSTRAINT [XPKnot_log] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [not_log_x2] ON [dbo].[not_log] ([cntxt_obj]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [not_log_x4] ON [dbo].[not_log] ([context_instance]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [not_log_x0] ON [dbo].[not_log] ([nlh_c_addressee], [nlh_start]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [not_log_x1] ON [dbo].[not_log] ([nlh_status], [nlh_c_addressee], [cmth_used]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [not_log_x3] ON [dbo].[not_log] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[not_log] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[not_log] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[not_log] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[not_log] TO [service_desk_admin_group]
GO