use master
go
Create Database SecurityLog
go
use SecurityLog
go
--Drop table Audit
CREATE TABLE [Audit] (
	[EventLog] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[RecordNumber] [int] NULL ,
	[TimeGenerated] [datetime] NULL ,
	[TimeWritten] [datetime] NULL ,
	[EventID] [int] NULL ,
	[EventType] [int] NULL ,
	[EventTypeName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EventCategory] [int] NULL ,
	[EventCategoryName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SourceName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Strings] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ComputerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Message] [varchar] (1255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Data] [varchar] (1255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

go
sp_addlogin 'TrainAudit','ECE2F287','SecurityLog'
go
sp_adduser 'TrainAudit'
go
sp_addrolemember 'db_datareader','TrainAudit'
go
sp_addrolemember 'db_datawriter','TrainAudit'
go