-- Table: dbo.SpaceUsedHistory
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[SpaceUsedHistory] (
	[Server] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Database] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FileGroup] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FileName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[File] [int] NULL ,
	[Path] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IsPrimaryFile] [bit] NULL ,
	[Size] [int] NULL ,
	[SizeInKB] [float] NULL ,
	[SpaceAvailableInMB] [int] NULL ,
	[FileGrowth] [int] NULL ,
	[FileGrowthInKB] [float] NULL ,
	[FileGrowthType] [int] NULL ,
	[MaximumSize] [int] NULL ,
	[RecCreatedDt] [datetime] NOT NULL 
        CONSTRAINT [dft_SpaceUsedHistory__RecCreatedDt] DEFAULT (getdate()),
	[RecCreatedUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
        CONSTRAINT [dft_SpaceUsedHistory__RecCreatedUser] DEFAULT (suser_sname()),
	CONSTRAINT pk_SpaceUsedHistory__RecCreatedDt__Server__Database__FileGroup__FileName] 
        PRIMARY KEY  CLUSTERED 
	(
		[RecCreatedDt],
		[Server],
		[Database],
		[FileGroup],
		[FileName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO