[dbo].[scap_checklists]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	5
Created	12:40:39 PM Sunday, December 05, 2010
Last Modified	12:40:56 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
	FileName	nvarchar(255)	510
	DirName	nvarchar(255)	510
	Timestamp	timestamp	8
	Version	nvarchar(255)	510
	XCCDFFileName	nvarchar(255)	510
	CPEDictFile	nvarchar(255)	510
	Title	nvarchar(255)	510
	SetValLng	int	4
	SetValUUID	binary(16)	16
	SetValText	nvarchar(255)	510
	uuid	binary(16)	16
$Foreign Keys scapcl_inviddomid: [dbo].[invsetup].invid\domainid$	domainid	int	4
$Foreign Keys scapcl_inviddomid: [dbo].[invsetup].invid\domainid$	invid	int	4

	Name	Columns	Unique
	XPKscap_checklists	uuid

Name	Columns
scapcl_inviddomid	invid->[dbo].[invsetup].[invid] domainid->[dbo].[invsetup].[domainid]

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Select	ams_group
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[scap_checklists]
(
[FileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DirName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Timestamp] [timestamp] NOT NULL,
[Version] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[XCCDFFileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CPEDictFile] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Title] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SetValLng] [int] NULL,
[SetValUUID] [binary] (16) NULL,
[SetValText] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[uuid] [binary] (16) NOT NULL,
[domainid] [int] NULL,
[invid] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[scap_checklists] ADD CONSTRAINT [XPKscap_checklists] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[scap_checklists] ADD CONSTRAINT [scapcl_inviddomid] FOREIGN KEY ([invid], [domainid]) REFERENCES [dbo].[invsetup] ([invid], [domainid])
GO
GRANT SELECT ON  [dbo].[scap_checklists] TO [ams_group]
GRANT SELECT ON  [dbo].[scap_checklists] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[scap_checklists] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[scap_checklists] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[scap_checklists] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[scap_checklists] TO [ca_itrm_group_ams]
GO