if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[syslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[syslog]
GO

CREATE TABLE [dbo].[syslog] (
	[DateTimeLocal] [datetime] NULL ,
	[DateTimeUTC] [datetime] NULL ,
	[DateTimeRFC822Local] [char] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DateTimeRFC822UTC] [char] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IPAddressSource] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[HostnameSource] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PortSource] [int] NULL ,
	[IPAddressDestination] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PortDestination] [int] NULL ,
	[Facility] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[FacilityCode] [smallint] NULL ,
	[Priority] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PriorityCode] [smallint] NULL ,
	[MessageText] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField4] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField5] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField6] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField7] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField8] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField9] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField10] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField11] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField12] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField13] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField14] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField15] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomField16] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

