UPDATE Options SET OptionValue = '2.5.2' WHERE OptionID = 14;

/****** Object:  Table [dbo].[EventLogEntries]    Script Date: 10/09/2012 14:40:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[EventLogEntries](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ServerID] [int] NOT NULL,
	[InstanceId] [bigint] NOT NULL,
	[Source] [nvarchar](255) NOT NULL,
	[Message] [nvarchar](2048) NULL,
	[TimeGenerated] [datetime] NOT NULL,
	[Type] [nvarchar](50) NOT NULL,
	[Level] [int] NOT NULL,
	[Category] [nvarchar](100) NOT NULL,
	[User] [nvarchar](255) NULL,
	[Keywords] [nvarchar](100) NOT NULL,
 CONSTRAINT [PK_EventLog] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UlsEventEntries]    Script Date: 10/11/2012 08:10:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UlsEventEntries](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TimeGenerated] [datetime] NOT NULL,
	[ServerID] [int] NOT NULL,
	[Process] [nvarchar](100) NOT NULL,
	[Thread] [nvarchar](20) NOT NULL,
	[Product] [nvarchar](100) NOT NULL,
	[Category] [nvarchar](50) NOT NULL,
	[EventID] [nvarchar](15) NOT NULL,
	[Level] [int] NOT NULL,
	[Message] [nvarchar](2048) NULL,
	[Correlation] [nvarchar](50) NULL,
 CONSTRAINT [PK_UlsEventEntries] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[MonitoredServers]    Script Date: 10/11/2012 07:48:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MonitoredServers](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ServerName] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_MonitoredServers] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

UPDATE Features SET EditionID=10
WHERE EditionID = 1
GO
UPDATE Features SET EditionID=20
WHERE EditionID = 2
GO
UPDATE Features SET EditionID=30
WHERE EditionID = 3
GO 

UPDATE Editions SET EditionID=10
WHERE EditionID = 1
GO
UPDATE Editions SET EditionID=20
WHERE EditionID = 2
GO
UPDATE Editions SET EditionID=30
WHERE EditionID = 3
GO 
