CREATE TABLE [dbo].[usm_configuration]
(
[group_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[domain] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[data_type] [int] NOT NULL,
[is_visible] [int] NOT NULL,
[value] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[component_id] [int] NULL,
[aclinfo] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[product_code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[widget_type] [int] NULL,
[value_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_configuration] ADD CONSTRAINT [XPKusm_configuration] PRIMARY KEY CLUSTERED ([group_name], [name], [domain]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_configuration_idx_01] ON [dbo].[usm_configuration] ([domain], [group_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_configuration] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_configuration] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_configuration] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_configuration] TO [usmgroup]
GO