USE [Inventory]
GO


/****** Object:  Table [dbo].[DatabaseDetails]    ******/

CREATE TABLE [dbo].[DatabaseDetails](
	[InstanceName] [varchar](128) NOT NULL,
	[DatabaseID] [int] NOT NULL,
	[DatabaseName] [varchar](128) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[DatabaseGuid] [varchar](36) NULL,
	[FamilyGuid] [varchar](36) NULL,
	[Owner] [varchar](60) NULL,
	[AccessDesc] [varchar](60) NULL,
	[RecoveryModel] [varchar](60) NULL,
	[CompatibilityLevel] [int] NULL,
	[State] [tinyint] NULL,
	[StateDesc] [varchar](60) NULL,
	[PageVerify] [varchar](60) NULL,
	[AllowSnapshotIsolation] [varchar](60) NULL,
	[ANSINULLDefault] [tinyint] NULL,
	[ANSINULLSEnabled] [tinyint] NULL,
	[ANSIPaddingsEnabled] [tinyint] NULL,
	[ANSIWarningsEnabled] [tinyint] NULL,
	[ArithmeticAbortEnabled] [tinyint] NULL,
	[AutoCLOSE] [tinyint] NULL,
	[AutoCreateStats] [tinyint] NULL,
	[AutoShrink] [tinyint] NULL,
	[AutoUpdateStatsAsync] [tinyint] NULL,
	[AutoUpdateStats] [tinyint] NULL,
	[CloseCursorsOnCommitEnabled] [tinyint] NULL,
	[ConcatenateNullYieldsNull] [tinyint] NULL,
	[CrossDatabaseOwnershipChainingEnabled] [tinyint] NULL,
	[DateCorrelationOptimizationEnabled] [tinyint] NULL,
	[DatabaseReadOnly] [tinyint] NULL,
	[DefaultCursor] [tinyint] NULL,
	[EncryptionEnabled] [tinyint] NULL,
	[NumericRoundAbort] [tinyint] NULL,
	[Parameterization] [tinyint] NULL,
	[QuotedIdentifiersEnabled] [tinyint] NULL,
	[ReadCommittedSnapshot] [tinyint] NULL,
	[RecursiveTriggersEnabled] [tinyint] NULL,
	[ServiceBrokerEnabled] [tinyint] NULL,
	[Trustworthy] [tinyint] NULL,
	[Published] [tinyint] NULL,
	[Subscribed] [tinyint] NULL,
	[MergPublish] [tinyint] NULL,
	[Distributor] [tinyint] NULL,
	[CollationName] [varchar](128) NULL,
	[LogReuseWait] [varchar](60) NULL,
	[Mod_Dt] [datetime] NULL,
	[Mod_User] [varchar](255) NULL,
	[Retired] [bit] NULL,
 CONSTRAINT [PK_DatabaseDetails] PRIMARY KEY CLUSTERED 
(
	[InstanceName] ASC,
	[DatabaseID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[DatabaseDetails] ADD  CONSTRAINT [DF_DatabaseDetails_ModDt]  DEFAULT (getdate()) FOR [Mod_Dt]
GO

ALTER TABLE [dbo].[DatabaseDetails] ADD  CONSTRAINT [DF_DatabaseDetails_ModUser]  DEFAULT (suser_sname()) FOR [Mod_User]
GO

ALTER TABLE [dbo].[DatabaseDetails] ADD  CONSTRAINT [DF_DatabaseDetails_Retired]  DEFAULT ((0)) FOR [Retired]
GO





/****** Object:  Table [dbo].[DatabaseDetails_STAGE]    ******/

CREATE TABLE [dbo].[DatabaseDetails_STAGE](
	[InstanceName] [varchar](128) NULL,
	[DatabaseID] [int] NULL,
	[DatabaseName] [varchar](128) NULL,
	[CreateDate] [datetime] NULL,
	[DatabaseGuid] [varchar](36) NULL,
	[FamilyGuid] [varchar](36) NULL,
	[Owner] [varchar](60) NULL,
	[AccessDesc] [varchar](60) NULL,
	[RecoveryModel] [varchar](60) NULL,
	[CompatibilityLevel] [int] NULL,
	[State] [tinyint] NULL,
	[StateDesc] [varchar](60) NULL,
	[PageVerify] [varchar](60) NULL,
	[AllowSnapshotIsolation] [varchar](60) NULL,
	[ANSINULLDefault] [tinyint] NULL,
	[ANSINULLSEnabled] [tinyint] NULL,
	[ANSIPaddingsEnabled] [tinyint] NULL,
	[ANSIWarningsEnabled] [tinyint] NULL,
	[ArithmeticAbortEnabled] [tinyint] NULL,
	[AutoCLOSE] [tinyint] NULL,
	[AutoCreateStats] [tinyint] NULL,
	[AutoShrink] [tinyint] NULL,
	[AutoUpdateStatsAsync] [tinyint] NULL,
	[AutoUpdateStats] [tinyint] NULL,
	[CloseCursorsOnCommitEnabled] [tinyint] NULL,
	[ConcatenateNullYieldsNull] [tinyint] NULL,
	[CrossDatabaseOwnershipChainingEnabled] [tinyint] NULL,
	[DateCorrelationOptimizationEnabled] [tinyint] NULL,
	[DatabaseReadOnly] [tinyint] NULL,
	[DefaultCursor] [tinyint] NULL,
	[EncryptionEnabled] [tinyint] NULL,
	[NumericRoundAbort] [tinyint] NULL,
	[Parameterization] [tinyint] NULL,
	[QuotedIdentifiersEnabled] [tinyint] NULL,
	[ReadCommittedSnapshot] [tinyint] NULL,
	[RecursiveTriggersEnabled] [tinyint] NULL,
	[ServiceBrokerEnabled] [tinyint] NULL,
	[Trustworthy] [tinyint] NULL,
	[Published] [tinyint] NULL,
	[Subscribed] [tinyint] NULL,
	[MergPublish] [tinyint] NULL,
	[Distributor] [tinyint] NULL,
	[CollationName] [varchar](128) NULL,
	[LogReuseWait] [varchar](60) NULL
) ON [PRIMARY]

GO





/****** Object:  Table [dbo].[DatabaseBackups]   ******/

CREATE TABLE [dbo].[DatabaseBackups](
	[InstanceName] [varchar](128) NOT NULL,
	[DatabaseName] [varchar](128) NOT NULL,
	[RecoveryModel] [varchar](12) NULL,
	[BackupStartDate] [datetime] NOT NULL,
	[BackupFinishDate] [datetime] NOT NULL,
	[Expiration] [datetime] NULL,
	[BackupSetFileNumber] [int] NULL,
	[BackupSetMediaSetID] [int] NOT NULL,
	[BackupMediaFamilyMediaId] [int] NULL,
	[BackupSetFirstFamilyNum] [tinyint] NULL,
	[BackupSetLastFamilyNum] [tinyint] NULL,
	[BackupMediaFamilySeqNum] [tinyint] NOT NULL,
	[TotalStripes] [int] NOT NULL,
	[BackupSizeKB] [bigint] NULL,
	[CompressedBackupSizeKB] [bigint] NULL,
	[BackupSetName] [varchar](255) NULL,
	[BackupType] [varchar](12) NULL,
	[PhysicalDeviceName] [varchar](255) NULL,
 CONSTRAINT [PK_DatabaseBackups_TEMP] PRIMARY KEY CLUSTERED 
(
	[InstanceName] ASC,
	[DatabaseName] ASC,
	[BackupStartDate] ASC,
	[BackupFinishDate] ASC,
	[BackupSetMediaSetID] ASC,
	[BackupMediaFamilySeqNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO






/****** Object:  Table [dbo].[DatabaseFileInfo]    ******/

CREATE TABLE [dbo].[DatabaseFileInfo](
	[InstanceName] [varchar](128) NOT NULL,
	[AuditDt] [datetime] NOT NULL,
	[DatabaseName] [varchar](128) NOT NULL,
	[FileGroupname] [varchar](128) NOT NULL,
	[LogicalName] [varchar](128) NOT NULL,
	[PhysicalFileName] [varchar](512) NULL,
	[FileType] [char](1) NULL,
	[FileSizeMB] [decimal](12, 2) NULL,
	[FileUsedMB] [decimal](12, 2) NULL,
	[MaxSizeMB] [int] NULL,
	[GrowthIncrement] [int] NULL,
	[GrowthType] [varchar](8) NULL,
 CONSTRAINT [PK_DatabaseFileInfo] PRIMARY KEY CLUSTERED 
(
	[InstanceName] ASC,
	[AuditDt] ASC,
	[DatabaseName] ASC,
	[FileGroupname] ASC,
	[LogicalName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO