CREATE TABLE [dbo].[ap_wmv_usr_config]
(
[usr_nm] [varchar] (49) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[session_nm] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ap_host] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[session_commands] [varchar] (4256) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[frame_height] [smallint] NOT NULL,
[frame_width] [smallint] NOT NULL,
[dt_format] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tm_format] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[action_back_color] [int] NOT NULL,
[action_selected_fore_color] [int] NOT NULL,
[action_selected_back_color] [int] NOT NULL,
[normal_back_color] [int] NOT NULL,
[normal_selected_fore_color] [int] NOT NULL,
[normal_selected_back_color] [int] NOT NULL,
[color_map] [varchar] (160) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[action_font_nm] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[action_font_style] [smallint] NOT NULL,
[action_font_size] [smallint] NOT NULL,
[normal_font_nm] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[normal_font_style] [smallint] NOT NULL,
[normal_font_size] [smallint] NOT NULL,
[column_names] [varchar] (660) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[column_widths] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[divider_location] [int] NOT NULL,
[messages_per_bundle] [smallint] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_wmv_usr_config] ON [dbo].[ap_wmv_usr_config] ([usr_nm], [session_nm], [ap_host]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ap_wmv_usr_config] TO [apwmv_admin]
GRANT INSERT ON  [dbo].[ap_wmv_usr_config] TO [apwmv_admin]
GRANT DELETE ON  [dbo].[ap_wmv_usr_config] TO [apwmv_admin]
GRANT UPDATE ON  [dbo].[ap_wmv_usr_config] TO [apwmv_admin]
GRANT SELECT ON  [dbo].[ap_wmv_usr_config] TO [apwmv_user]
GO