-- Table: dbo.ArchUtilDBConfig
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[ArchUtilDBConfig] (
	[DatabaseName] [sysname] NOT NULL ,
	[SQLServerName] [sysname] NOT NULL CONSTRAINT [dft_ArchUtilDBConfig__SQLServerName] DEFAULT (@@servername),
	[IncludeDBScript] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeDBScript] DEFAULT ('True'),
	[IncludeDataTypes] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeDataTypes] DEFAULT ('True'),
	[IncludeDefaults] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeDefaults] DEFAULT ('True'),
	[IncludeFunctions] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeFunctions] DEFAULT ('True'),
	[IncludeProcedures] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeProcedures] DEFAULT ('True'),
	[IncludeRoles] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeRoles] DEFAULT ('True'),
	[IncludeRules] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeRules] DEFAULT ('True'),
	[IncludeTables] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeTables] DEFAULT ('True'),
	[IncludeTriggers] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeTriggers] DEFAULT ('True'),
	[IncludeUsers] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeUsers] DEFAULT ('True'),
	[IncludeViews] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [dft_ArchUtilDBConfig_IncludeViews] DEFAULT ('True'),
	CONSTRAINT [pk_ArchUtilDBConfig__DatabaseName] PRIMARY KEY  CLUSTERED 
	(
		[DatabaseName]
	)  ON [PRIMARY] ,
	CONSTRAINT [fk_ArchUtilDBConfig__SQLServerName__to__ArchUtilSrvConfig] FOREIGN KEY 
	(
		[SQLServerName]
	) REFERENCES [dbo].[ArchUtilSrvConfig] (
		[SQLServerName]
	),
	CONSTRAINT [chk_ArchUtilDBConfig__SQLServerName] CHECK ([SQLServerName] = @@servername),
	CONSTRAINT [ck_ArchUtilDBConfig_DatabaseName] CHECK (db_id([DatabaseName]) is not null),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeDataTypes] CHECK ([IncludeDataTypes] = 'False' or [IncludeDataTypes] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeDBScript] CHECK ([IncludeDBScript] = 'False' or [IncludeDBScript] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeDefaults] CHECK ([IncludeDefaults] = 'False' or [IncludeDefaults] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeFunctions] CHECK ([IncludeFunctions] = 'False' or [IncludeFunctions] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeProcedures] CHECK ([IncludeProcedures] = 'False' or [IncludeProcedures] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeRoles] CHECK ([IncludeRoles] = 'False' or [IncludeRoles] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeRules] CHECK ([IncludeRules] = 'False' or [IncludeRules] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeTables] CHECK ([IncludeTables] = 'False' or [IncludeTables] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeTriggers] CHECK ([IncludeTriggers] = 'False' or [IncludeTriggers] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeUsers] CHECK ([IncludeUsers] = 'False' or [IncludeUsers] = 'True'),
	CONSTRAINT [ck_ArchUtilDBConfig_IncludeViews] CHECK ([IncludeViews] = 'False' or [IncludeViews] = 'True')
) ON [PRIMARY]
GO