CREATE TABLE [dbo].[HARGLOBALAUDITPOLICY]
(
[AUDITPOLICYOBJID] [int] NOT NULL,
[ACTIONOBJID] [int] NOT NULL,
[ENABLED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARGLOBAL__ENABL__5812160E] DEFAULT ('N'),
[ONSUCCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARGLOBAL__ONSUC__59063A47] DEFAULT ('Y'),
[ONFAILURE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARGLOBAL__ONFAI__59FA5E80] DEFAULT ('N'),
[CREATORID] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARGLOBAL__CREAT__5AEE82B9] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARGLOBAL__MODIF__5BE2A6F2] DEFAULT (getutcdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARGLOBALAUDITPOLICY] ADD CONSTRAINT [HARGLOBALAUDITPOLICY_PK] PRIMARY KEY CLUSTERED ([AUDITPOLICYOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARGLOBALAUDITPOLICY_ACTID_IND] ON [dbo].[HARGLOBALAUDITPOLICY] ([ACTIONOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARGLOBALAUDITPOLICY] ADD CONSTRAINT [HARGLOBALAUDITPOLICY_ACTID_FK] FOREIGN KEY ([ACTIONOBJID]) REFERENCES [dbo].[HARACTION] ([ACTIONOBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HARGLOBALAUDITPOLICY table identifies which valid audit events are allowed to be logged at run-time, if auditing is enabled for the CA SCM server.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID identifying the audit action associated with the global audit policy record. This column identifies a record in the HARACTION table.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'ACTIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Sequence Object Identifier identifying an global audit policy record.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'AUDITPOLICYOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Date/time when this global audit policy record was created.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of user who created this global audit policy record.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Flag indicating whether this global audit policy record will be processed at run-time. Valid values for this column are Y=audit action will be audited at run-time, N=audit action will not be audited at run-time. By default, this column has value Y.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'ENABLED'
GO
EXEC sp_addextendedproperty N'Caption', N'Date/time when this global audit policy record was last modified.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object identifier of the user who last modified this global audit policy record.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'Flag indicating whether the audit event is logged when the auditable action failed. Valid values for this column are Y=log failed audit events, N=do not log failed audit events.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'ONFAILURE'
GO
EXEC sp_addextendedproperty N'Caption', N'Flag indicating whether the audit event is logged when the auditable action was successful. Valid values for this column are Y=log successful audit events, N=do not log successful audit events.', 'SCHEMA', N'dbo', 'TABLE', N'HARGLOBALAUDITPOLICY', 'COLUMN', N'ONSUCCESS'
GO