-- Table: dbo.SQLQAUserHistory
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[SQLQAUserHistory] (
	[LastBatchDt] [datetime] NOT NULL ,
	[spid] [int] NOT NULL ,
	[login] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[host] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[NTUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[buffer] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LastObservedDt] [datetime] NULL ,
	CONSTRAINT [pkc_SQLQAUserHistory__LastBatchDt__spid] 
        PRIMARY KEY  CLUSTERED 
	(
		[LastBatchDt],
		[spid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IXN_SQLQAUserHistory__NTUser] ON [dbo].[SQLQAUserHistory]([NTUser]) ON [INDEXES]
GO