CREATE TABLE [dbo].[log_shipping_primary_databases](
	[primary_id] [uniqueidentifier] NOT NULL,
	[primary_database] [sysname] NOT NULL,
	[backup_directory] [nvarchar](500) NOT NULL,
	[backup_share] [nvarchar](500) NOT NULL,
	[backup_retention_period] [int] NOT NULL,
	[backup_job_id] [uniqueidentifier] NOT NULL,
	[monitor_server] [sysname] NOT NULL,
	[user_specified_monitor] [bit] NULL,
	[monitor_server_security_mode] [bit] NOT NULL,
	[last_backup_file] [nvarchar](500) NULL,
	[last_backup_date] [datetime] NULL,
	[backup_compression] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[primary_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[primary_database] 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


USE [msdb]
/****** Object:  Index [nc1lsprimary_databases]    Script Date: 11/19/2013 20:08:20 ******/
CREATE NONCLUSTERED INDEX [nc1lsprimary_databases] ON [dbo].[log_shipping_primary_databases] 
(
	[monitor_server] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [msdb]
/****** Object:  Index [nc2lsprimary_databases]    Script Date: 11/19/2013 20:08:20 ******/
CREATE NONCLUSTERED INDEX [nc2lsprimary_databases] ON [dbo].[log_shipping_primary_databases] 
(
	[user_specified_monitor] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [msdb]
/****** Object:  Index [uc1lsprimary_databases]    Script Date: 11/19/2013 20:08:20 ******/
CREATE UNIQUE NONCLUSTERED INDEX [uc1lsprimary_databases] ON [dbo].[log_shipping_primary_databases] 
(
	[primary_database] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

ALTER TABLE [dbo].[log_shipping_primary_databases] ADD  DEFAULT ((2)) FOR [backup_compression]
GO