-- Table: dbo.ArchUtilSrvConfig
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[ArchUtilSrvConfig] (
	[SQLServerName] [sysname] NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__SQLServerName] DEFAULT (@@servername),
	[VSSShare] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__VSSShare] DEFAULT ('\\[Network Path to srcsafe.ini]\ -or- [Drive]:\[Local Path to srcsafe.ini]\'),
	[VSSRootProject] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__VSSRootProject] DEFAULT ('$/[Existing SourceSafe Root Project]/'),
	[VSSUserName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__VSSUserName] DEFAULT (substring(suser_sname(),(charindex('\',suser_sname()) + 1),datalength(suser_sname()))),
	[VSSPassword] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__VSSPassword] DEFAULT (''),
	[LocalWorkingFolder] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__LocalWorkingFolder] DEFAULT ('\\[Network Share\[Existing Folder]\ -or- [Drive]:\[Existing Folder]\'),
	[LicensedCompany] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__LicensedCompany] DEFAULT (''),
	[LicensedUser] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__LicensedUser] DEFAULT (''),
	[LicenseCode] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig__LicenseCode] DEFAULT ('Unlicensed Trial Software'),
	[IncludeAlerts] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeAlerts] DEFAULT ('True'),
	[IncludeBackupDevices] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeBackupDevices] DEFAULT ('True'),
	[IncludeJobs] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeJobs] DEFAULT ('True'),
	[IncludeLocalDTSPackages] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeLocalDTSPackages] DEFAULT ('True'),
	[IncludeLogins] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeLogins] DEFAULT ('True'),
	[IncludeLinkedServers] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeLinkedServers] DEFAULT ('True'),
	[IncludeRepositoryDTSPackages] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeRepositoryDTSPackages] DEFAULT ('True'),
	[IncludeOperators] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeOperators] DEFAULT ('True'),
	[IncludeServerConfiguration] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeServerConfiguration] DEFAULT ('True'),
	[IncludeServerRoles] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_IncludeServerRoles] DEFAULT ('True'),
	[RecCreatedDt] [datetime] NOT NULL CONSTRAINT [dft_ArchUtilSrvConfig_RecCreatedDt] DEFAULT (getdate()),
	CONSTRAINT [pk_ArchUtilSrvConfig__SQLServerName] PRIMARY KEY  CLUSTERED 
	(
		[SQLServerName]
	)  ON [PRIMARY] ,
	CONSTRAINT [chk_ArchUtilSrvConfig__SQLServerName] CHECK ([SQLServerName] = @@servername),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeAlerts] CHECK ([IncludeAlerts] = 'False' or [IncludeAlerts] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeBackupDevices] CHECK ([IncludeBackupDevices] = 'False' or [IncludeBackupDevices] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeJobs] CHECK ([IncludeJobs] = 'False' or [IncludeJobs] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeLinkedServers] CHECK ([IncludeLinkedServers] = 'False' or [IncludeLinkedServers] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeLocalDTSPackages] CHECK ([IncludeLocalDTSPackages] = 'False' or [IncludeLocalDTSPackages] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeLogins] CHECK ([IncludeLogins] = 'False' or [IncludeLogins] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeOperators] CHECK ([IncludeOperators] = 'False' or [IncludeOperators] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeRepositoryDTSPackages] CHECK ([IncludeRepositoryDTSPackages] = 'False' or [IncludeRepositoryDTSPackages] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeServerConfiguration] CHECK ([IncludeServerConfiguration] = 'False' or [IncludeServerConfiguration] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_IncludeServerRoles] CHECK ([IncludeServerRoles] = 'False' or [IncludeServerRoles] = 'True'),
	CONSTRAINT [ck_ArchUtilSrvConfig_LocalWorkingFolder] CHECK ([LocalWorkingFolder] like '\\%' or [LocalWorkingFolder] like '[A-Z]:\%'),
	CONSTRAINT [ck_ArchUtilSrvConfig_LocalWorkingFolder_TrailingWhack] CHECK (right([LocalWorkingFolder],1) = '\'),
	CONSTRAINT [ck_ArchUtilSrvConfig_VSSRootProject] CHECK ([VSSRootProject] like '$/%'),
	CONSTRAINT [ck_ArchUtilSrvConfig_VSSShare] CHECK ([VSSShare] like '\\%' or [VSSShare] like '[A-Z]:\%' or [VSSShare] = 'None - Script Only'),
	CONSTRAINT [ck_ArchUtilSrvConfig_VSSShare_TrailingWhack] CHECK (right([VSSShare],1) = '\' or [VSSShare] = 'None - Script Only')
) ON [PRIMARY]
GO