-- Table: dbo.ProceduresFoundInCache
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[ProceduresFoundInCache] (
	[ProcedureName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[DatabaseName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[LastFoundDt] [datetime] NULL ,
	[RecCreatedDt] [datetime] NULL 
        CONSTRAINT [dft_ProceduresFoundInCache__LastFoundDt] DEFAULT (getdate()),
	[FoundCount] [int] NOT NULL 
        CONSTRAINT [dft_ProceduresFoundInCache__FoundCount] DEFAULT (1),
	CONSTRAINT [pk_ProceduresFoundInCache__ProcedureName__DatabaseName] 
        PRIMARY KEY  CLUSTERED 
	(
		[ProcedureName],
		[DatabaseName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO