-- Table: dbo.fraglist
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[fraglist] (
	[DatabaseName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ObjectOwner] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ObjectName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ObjectId] [int] NULL ,
	[IndexName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[IndexId] [int] NULL ,
	[Lvl] [int] NULL ,
	[CountPages] [int] NULL ,
	[CountRows] [int] NULL ,
	[MinRecSize] [int] NULL ,
	[MaxRecSize] [int] NULL ,
	[AvgRecSize] [int] NULL ,
	[ForRecCount] [int] NULL ,
	[Extents] [int] NULL ,
	[ExtentSwitches] [int] NULL ,
	[AvgFreeBytes] [int] NULL ,
	[AvgPageDensity] [int] NULL ,
	[ScanDensity] [decimal](18, 0) NULL ,
	[BestCount] [int] NULL ,
	[ActualCount] [int] NULL ,
	[LogicalFrag] [decimal](18, 0) NULL ,
	[ExtentFrag] [decimal](18, 0) NULL ,
	[RecCreatedDt] [datetime] NOT NULL 
        CONSTRAINT [dft__fraglist__RecCreatedDt] DEFAULT (getdate()),
	[Status] [tinyint] NULL CONSTRAINT [dft__fraglist__Status] DEFAULT (0),
	[SecondsToMaintain] [int] NULL ,
	[SecondsToShowContig] [int] NULL ,
	CONSTRAINT [pkc_fraglist__DatabaseName__ObjectOwner__ObjectName__IndexName_RecCreatedDt] 
        PRIMARY KEY  CLUSTERED 
	(
		[DatabaseName],
		[ObjectOwner],
		[ObjectName],
		[IndexName],
		[RecCreatedDt]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO