Hi Chip,

the CMS_EventLog table was part of the 1.6 -> 1.6b upgrade. Below, you can find the script. It is the complete SQL upgrade script for 1.6 -> 1.6b, there were no other database changes.

CREATE TABLE [CMS_EventLog] (
[EventID] [int] IDENTITY (1, 1) NOT NULL ,
[EventType] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[EventTime] [datetime] NOT NULL ,
[Source] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[EventCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[UserID] [int] NULL ,
[UserName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IPAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[NodeID] [int] NULL ,
[NodeNamePath] [nvarchar] (450) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EventDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE INDEX [IX_CMS_EventLog] ON [dbo].[CMS_EventLog]([EventType])

CREATE INDEX [IX_CMS_EventLog_1] ON [dbo].[CMS_EventLog]([EventTime])

CREATE INDEX [IX_CMS_EventLog_2] ON [dbo].[CMS_EventLog]([Source])

CREATE INDEX [IX_CMS_EventLog_3] ON [dbo].[CMS_EventLog]([EventCode])

CREATE INDEX [IX_CMS_EventLog_4] ON [dbo].[CMS_EventLog]([UserID])

CREATE INDEX [IX_CMS_EventLog_5] ON [dbo].[CMS_EventLog]([UserName])

CREATE INDEX [IX_CMS_EventLog_6] ON [dbo].[CMS_EventLog]([NodeID])

CREATE INDEX [IX_CMS_EventLog_7] ON [dbo].[CMS_EventLog]([NodeNamePath])





ALTER TABLE [CMS_EventLog] WITH NOCHECK ADD
CONSTRAINT [PK_CMS_EventLog] PRIMARY KEY CLUSTERED
(
[EventID]
) ON [PRIMARY]