CREATE TABLE [dbo].[usm_queue_item]
(
[queue_item_id] [int] NOT NULL,
[created_time] [datetime] NOT NULL CONSTRAINT [DF__usm_queue__creat__78359834] DEFAULT ('today'),
[priority_no] [int] NOT NULL,
[status] [int] NOT NULL,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[queue_item_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[group_id] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[owner] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_time] [datetime] NULL,
[end_time] [datetime] NULL,
[delete_item] [int] NOT NULL,
[deleted_time] [datetime] NULL,
[item_comment] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data1] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data2] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data3] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_queue_item] ADD CONSTRAINT [XPKusm_queue_item] PRIMARY KEY CLUSTERED ([queue_item_id], [created_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_queue_item_idx_01] ON [dbo].[usm_queue_item] ([created_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_queue_item_idx_02] ON [dbo].[usm_queue_item] ([priority_no]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_queue_item_idx_03] ON [dbo].[usm_queue_item] ([type], [owner]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_queue_item] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_queue_item] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_queue_item] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_queue_item] TO [usmgroup]
GO