-- Table: dbo.ArchUtilChanges
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[ArchUtilChanges] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[SQLServerName] [sysname] NOT NULL ,
	[DatabaseName] [sysname] NULL ,
	[VSSItem] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[VSSParent] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[VSSItemType] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ChangeAction] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[RecCreatedDt] [datetime] NOT NULL CONSTRAINT [dft_ArchUtilChanges__RecCreatedDt] DEFAULT (getdate()),
	CONSTRAINT [pk_ArchUtilChanges__Id] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] ,
	CONSTRAINT [fk_ArchUtilChanges__SQLServerName__to__ArchUtilSrvConfig] FOREIGN KEY 
	(
		[SQLServerName]
	) REFERENCES [dbo].[ArchUtilSrvConfig] (
		[SQLServerName]
	)
) ON [PRIMARY]
GO