-- Table: dbo.SLSLogShippingConfig
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[SLSLogShippingConfig] (
	[StandbyServer] [sysname] NOT NULL ,
	[LogShippingUser] [sysname] NOT NULL ,
	[LogShippingShare] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ConfigFilesPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ConfigDt] [datetime] NOT NULL 
        CONSTRAINT [dft_SLSLogShippingConfig__ConfigDt] DEFAULT (getdate()),
	[ConfigUser] [sysname] NOT NULL 
        CONSTRAINT [dft_SLSLogShippingConfig__ConfigUser] DEFAULT (suser_sname()),
	CONSTRAINT [pk_SLSLogShippingConfig__StandbyServer] 
        PRIMARY KEY  CLUSTERED 
	(
		[StandbyServer]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO