CREATE TABLE [dbo].[usm_mr_iref]
(
[type] [int] NULL,
[file_id] [int] NULL,
[ebulk_id] [int] NULL,
[rbulk_id] [int] NULL,
[event_table] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[import_id] [int] NULL,
[metric_id] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iref_idx_01] ON [dbo].[usm_mr_iref] ([file_id], [type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iref_idx_03] ON [dbo].[usm_mr_iref] ([type], [ebulk_id], [file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_mr_iref_idx_02] ON [dbo].[usm_mr_iref] ([type], [rbulk_id], [file_id]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[usm_mr_iref] TO [usmgroup]
GRANT INSERT ON [dbo].[usm_mr_iref] TO [usmgroup]
GRANT DELETE ON [dbo].[usm_mr_iref] TO [usmgroup]
GRANT UPDATE ON [dbo].[usm_mr_iref] TO [usmgroup]
GO
[dbo].[usm_mr_iref]
