CREATE TABLE [dbo].[ap_wmv_messages]
(
[webmv_key] [int] NOT NULL,
[session_nm_id] [int] NOT NULL,
[vte_handle] [int] NOT NULL,
[job_id] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[job_nm] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[processor_id] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[action] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[reply_id] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[message_txt] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[alarm] [int] NOT NULL,
[session_state] [smallint] NOT NULL,
[action_fl] [smallint] NOT NULL,
[xc_color] [smallint] NOT NULL,
[assigned_id] [int] NOT NULL,
[sequence_id] [int] NOT NULL,
[mon_num] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mon_name] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mon_type] [varchar] (42) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mon_prty] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ems_dt] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jes3_nm] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[pc_tm] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[host_tm] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[vfp_day] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ap_dt] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ap_julian_dt] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[session_action_id] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ap_wmv_messages_x1] ON [dbo].[ap_wmv_messages] ([assigned_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ap_wmv_messages_x2] ON [dbo].[ap_wmv_messages] ([session_action_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_wmv_messages] ON [dbo].[ap_wmv_messages] ([webmv_key], [session_nm_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ap_wmv_messages] TO [apwmv_admin]
GRANT INSERT ON  [dbo].[ap_wmv_messages] TO [apwmv_admin]
GRANT DELETE ON  [dbo].[ap_wmv_messages] TO [apwmv_admin]
GRANT UPDATE ON  [dbo].[ap_wmv_messages] TO [apwmv_admin]
GRANT SELECT ON  [dbo].[ap_wmv_messages] TO [apwmv_user]
GO