SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[SQL_Servers]') AND type in (N'U'))
BEGIN
CREATE TABLE [SQL_Servers](
	[Server] [char](100) NULL,
	[ProductVersion] [char](100) NULL,
	[ProductLevel] [char](100) NULL,
	[ResourceLastUpdateDateTime] [char](100) NULL,
	[ResourceVersion] [char](100) NULL,
	[IsIntegratedSecurityOnly] [varchar](23) NULL,
	[EngineEdition] [varchar](18) NULL,
	[InstanceName] [char](100) NULL,
	[ComputerNamePhysicalNetBIOS] [char](100) NULL,
	[LicenseType] [char](100) NULL,
	[NumLicenses] [char](100) NULL,
	[BuildClrVersion] [char](100) NULL,
	[Collation] [char](100) NULL,
	[CollationID] [char](100) NULL,
	[ComparisonStyle] [char](100) NULL,
	[ProductEdition] [varchar](38) NULL,
	[IsClustered] [varchar](13) NULL,
	[IsFullTextInstalled] [varchar](26) NULL,
	[SqlCharSet] [char](100) NULL,
	[SqlCharSetName] [char](100) NULL,
	[SqlSortOrderID] [char](100) NULL,
	[SqlSortOrderName] [char](100) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'SQL_Servers', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SQL_Servers'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Database_Info]') AND type in (N'U'))
BEGIN
CREATE TABLE [Database_Info](
	[Server] [nvarchar](128) NULL,
	[DatabaseName] [nvarchar](128) NOT NULL,
	[Size] [int] NOT NULL,
	[File_Status] [int] NULL,
	[Name] [nvarchar](128) NOT NULL,
	[Filename] [nvarchar](260) NOT NULL,
	[Status] [nvarchar](128) NULL,
	[Updateability] [nvarchar](128) NULL,
	[User_Access] [nvarchar](128) NULL,
	[Recovery] [nvarchar](128) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'Database_Info', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Database_Info'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Databases]') AND type in (N'U'))
BEGIN
CREATE TABLE [Databases](
	[Server] [nvarchar](128) NULL,
	[DatabaseName] [nvarchar](128) NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'Databases', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Databases'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Backup_History]') AND type in (N'U'))
BEGIN
CREATE TABLE [Backup_History](
	[Server] [char](100) NULL,
	[logical_device_name] [nvarchar](128) NULL,
	[physical_device_name] [nvarchar](260) NULL,
	[expiration_date] [datetime] NULL,
	[name] [nvarchar](128) NULL,
	[description] [nvarchar](255) NULL,
	[user_name] [nvarchar](128) NULL,
	[backup_start_date] [datetime] NULL,
	[backup_finish_date] [datetime] NULL,
	[backup_type] [varchar](8) NULL,
	[backup_size] [numeric](20, 0) NULL,
	[database_name] [nvarchar](128) NULL,
	[Source_Server] [nvarchar](128) NULL,
	[recovery_model] [nvarchar](60) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'Backup_History', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Backup_History'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Jobs]') AND type in (N'U'))
BEGIN
CREATE TABLE [Jobs](
	[Server] [nvarchar](128) NULL,
	[job_id] [uniqueidentifier] NOT NULL,
	[name] [sysname] NOT NULL,
	[Job_Enabled] [tinyint] NOT NULL,
	[description] [nvarchar](512) NULL,
	[notify_level_eventlog] [int] NOT NULL,
	[notify_level_email] [int] NOT NULL,
	[notify_level_netsend] [int] NOT NULL,
	[notify_level_page] [int] NOT NULL,
	[notify_email_operator_id] [int] NOT NULL,
	[date_created] [datetime] NOT NULL,
	[date_modified] [datetime] NULL,
	[Category_Name] [sysname] NOT NULL,
	[next_run_date] [int] NULL,
	[next_run_time] [int] NULL,
	[last_run_outcome] [tinyint] NULL,
	[last_outcome_message] [nvarchar](1024) NULL,
	[last_run_date] [int] NULL,
	[last_run_time] [int] NULL,
	[last_run_duration] [int] NULL,
	[Notify_Operator] [sysname] NULL,
	[email_address] [nvarchar](100) NULL,
	[Package_run_date] [datetime] NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jobs', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jobs'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Jobs_Archive]') AND type in (N'U'))
BEGIN
CREATE TABLE [Jobs_Archive](
	[Server] [nvarchar](128) NULL,
	[job_id] [uniqueidentifier] NOT NULL,
	[name] [sysname] NOT NULL,
	[Job_Enabled] [tinyint] NOT NULL,
	[description] [nvarchar](512) NULL,
	[notify_level_eventlog] [int] NOT NULL,
	[notify_level_email] [int] NOT NULL,
	[notify_level_netsend] [int] NOT NULL,
	[notify_level_page] [int] NOT NULL,
	[notify_email_operator_id] [int] NOT NULL,
	[date_created] [datetime] NOT NULL,
	[date_modified] [datetime] NULL,
	[Category_Name] [sysname] NOT NULL,
	[next_run_date] [int] NULL,
	[next_run_time] [int] NULL,
	[last_run_outcome] [tinyint] NULL,
	[last_outcome_message] [nvarchar](1024) NULL,
	[last_run_date] [int] NULL,
	[last_run_time] [int] NULL,
	[last_run_duration] [int] NULL,
	[Notify_Operator] [sysname] NULL,
	[email_address] [nvarchar](100) NULL,
	[Package_run_date] [datetime] NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jobs_Archive', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jobs_Archive'
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[ServerList_SSIS]') AND type in (N'U'))
BEGIN
CREATE TABLE [ServerList_SSIS](
	[Server] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'Description' , N'SCHEMA',N'dbo', N'TABLE',N'ServerList_SSIS', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'Description', @value=N'Rodneys' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ServerList_SSIS'