[dbo].[AuditTrail]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	189
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	11:42:02 AM Friday, March 26, 2010

Name	Data Type	Max Length (Bytes)	Identity
UserAction	varchar(255)	255
DocumentType	varchar(255)	255
LoginUser	varchar(255)	255
ActionID	int	4	1 - 1
ObjectID	varchar(255)	255
DateCreated	datetime	8
DocVersion	varchar(255)	255

	Name	Columns	Unique
	PK_AuditTrail_ActionID	ActionID
	objectindex	ObjectID

SQL Script

CREATE TABLE [dbo].[AuditTrail]
(
[UserAction] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LoginUser] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActionID] [int] NOT NULL IDENTITY(1, 1),
[ObjectID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateCreated] [datetime] NULL,
[DocVersion] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AuditTrail] ADD CONSTRAINT [PK_AuditTrail_ActionID] PRIMARY KEY CLUSTERED ([ActionID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [objectindex] ON [dbo].[AuditTrail] ([ObjectID]) ON [PRIMARY]
GO