CREATE TABLE [dbo].[usd_cmp_grp]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[qtask] [binary] (16) NOT NULL,
[aux] [binary] (16) NOT NULL,
[aux2] [binary] (16) NOT NULL,
[type] [int] NOT NULL,
[attributes] [binary] (4) NOT NULL,
[name] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[credate] [int] NOT NULL,
[cretime] [int] NOT NULL,
[chdate] [int] NOT NULL,
[chtime] [int] NOT NULL,
[propflag] [int] NOT NULL,
[qcalendar] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[qevalrate] [int] NOT NULL,
[qnextevaldate] [int] NOT NULL,
[qnextevaltime] [int] NOT NULL,
[qevaldate] [int] NOT NULL,
[qevaltime] [int] NOT NULL,
[qtemplfold] [binary] (16) NOT NULL,
[qtype] [int] NOT NULL,
[state] [int] NOT NULL,
[seal] [int] NOT NULL,
[var] [int] NOT NULL,
[auxtext0] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext1] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext2] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext3] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[queryid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usd_cmp_grp] ADD CONSTRAINT [XPKusd_cmp_grp] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usd_cmp_grp_name_unique] ON [dbo].[usd_cmp_grp] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_cmp_grp] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_cmp_grp] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_cmp_grp] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_cmp_grp] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_cmp_grp] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_cmp_grp] TO [ca_itrm_group_ams]
GO