CREATE TABLE [dbo].[usd_applic]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[target] [binary] (16) NOT NULL,
[actproc] [binary] (16) NOT NULL,
[activity] [binary] (16) NULL,
[installation] [binary] (16) NULL,
[status] [int] NOT NULL,
[errorcause] [int] NOT NULL,
[errorparam] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creationtime] [int] NOT NULL,
[activationtime] [int] NOT NULL,
[completiontime] [int] NOT NULL,
[administrator] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[applicationid] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[task] [binary] (4) NOT NULL,
[percentsent] [int] NOT NULL,
[retentiontime] [int] NOT NULL,
[renewstatus] [int] NOT NULL,
[firstrenew] [binary] (16) NULL,
[nextrenew] [binary] (16) NULL,
[applicationgroup] [binary] (16) NULL,
[userparams] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uuid] [nvarchar] (37) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[racassoc] [binary] (16) NULL,
[uninstallstate] [int] NOT NULL,
[permmask] [int] NOT NULL,
[starttime] [int] NOT NULL,
[uuid2] [nvarchar] (37) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usd_applic] ADD CONSTRAINT [XPKusd_applic] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usd_applic1] ON [dbo].[usd_applic] ([activity]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usd_applic4] ON [dbo].[usd_applic] ([actproc], [status], [task], [uninstallstate], [target]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usd_applic3] ON [dbo].[usd_applic] ([applicationgroup]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usd_applic2] ON [dbo].[usd_applic] ([installation]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usd_applic0] ON [dbo].[usd_applic] ([target]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_applic] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_applic] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_applic] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_applic] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_applic] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_applic] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_applic] TO [upmuser_group]
GO