-- Table: dbo.BackupConfig
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[BackupConfig] (
	[DatabaseName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[BackupServerName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
        CONSTRAINT [dft_BackupServerName] DEFAULT (@@servername),
	[BackupScheduleSet] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
        CONSTRAINT [dft_BackupScheduleSet] DEFAULT ('default'),
	[IncludeRestore] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
        CONSTRAINT [dft_IncludeRestore] DEFAULT ('no'),
	[RestoreServerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeBackupPackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeBackupPackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeBackupPackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ArchivePackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [dft_ArchivePackageName] ,
	[ArchivePackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ArchivePackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BackupPackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [dft_BackupPackageName] ,
	[BackupPackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT,
	[BackupPackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterBackupPackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterBackupPackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterBackupPackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeRestorePackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeRestorePackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BeforeRestorePackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[RestorePackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [dft_RestorePackageName] ,
	[RestorePackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT ,
	[RestorePackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterRestorePackageName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterRestorePackageUNCFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AfterRestorePackageGlobalVariables] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[RecCreatedDt] [datetime] NOT NULL CONSTRAINT [dft_BackupConfig__RecCreatedDt] DEFAULT (getdate()),
	[RecCreatedUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
        CONSTRAINT [dft_BackupConfig__RecCreatedUser] DEFAULT (suser_sname()),
	[RecUpdatedDt] [datetime] NOT NULL CONSTRAINT [dft_BackupConfig__RecUpdatedDt] DEFAULT (getdate()),
	[RecUpdatedUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
        CONSTRAINT [dft_BackupConfig__RecUpdatedUser] DEFAULT (suser_sname()),
	CONSTRAINT [pkc_BackupConfig__DatabaseName__BackupServerName__BackupScheduleSet] PRIMARY KEY  CLUSTERED 
	(
		[DatabaseName],
		[BackupServerName],
		[BackupScheduleSet]
	)  ON [PRIMARY] ,
	CONSTRAINT [ck_AfterBackupPackageGlobalVariables] CHECK (left([AfterBackupPackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_AfterBackupPackageUNCFile] CHECK (left([AfterBackupPackageUNCFile],2) = '\\'),
	CONSTRAINT [ck_AfterRestorePackageGlobalVariables] CHECK (left([AfterRestorePackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_AfterRestorePackageUNCFile] CHECK (left([AfterRestorePackageUNCFile],2) = '\\'),
	CONSTRAINT [ck_ArchivePackageGlobalVariables] CHECK (left([ArchivePackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_BackupPackageGlobalVariables] CHECK (left([BackupPackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_BeforeBackupPackageGlobalVariables] CHECK (left([BeforeBackupPackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_BeforeBackupPackageUNCFile] CHECK (left([BeforeBackupPackageUNCFile],2) = '\\'),
	CONSTRAINT [ck_BeforeRestorePackageGlobalVariables] CHECK (left([BeforeRestorePackageGlobalVariables],2) = '/A'),
	CONSTRAINT [ck_BeforeRestorePackageUNCFile] CHECK (left([BeforeRestorePackageUNCFile],2) = '\\'),
	CONSTRAINT [ck_IncludeRestore] CHECK ([IncludeRestore] = 'no' or [IncludeRestore] = 'yes'),
	CONSTRAINT [ck_RestorePackageGlobalVariables] CHECK (left([RestorePackageGlobalVariables],2) = '/A')
) ON [PRIMARY]
GO