CREATE TABLE [dbo].[HARTABLEINFO]
(
[VERSIONINDICATOR] [int] NOT NULL,
[CASESENSLOGIN] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARTABLEI__CASES__7C1A6C5A] DEFAULT ('Y'),
[DATABASEID] [int] NOT NULL CONSTRAINT [DF__HARTABLEI__DATAB__7D0E9093] DEFAULT ((0)),
[AUTHENTICATEUSER] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARTABLEI__AUTHE__7E02B4CC] DEFAULT ('Y'),
[SYSVARPW] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARTABLEI__SYSVA__7EF6D905] DEFAULT ('N'),
[VERTRACKUPGRADEDATE] [datetime] NULL CONSTRAINT [DF__HARTABLEI__VERTR__7FEAFD3E] DEFAULT (getutcdate())
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARTABLEINFO table stores the identification of release versions.', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Use internal password-based authentication  (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'AUTHENTICATEUSER'
GO
EXEC sp_addextendedproperty N'Caption', N'Login user name verification is case-sensitive (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'CASESENSLOGIN'
GO
EXEC sp_addextendedproperty N'Caption', N'Database ID (reserve for future )', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'DATABASEID'
GO
EXEC sp_addextendedproperty N'Caption', N'Password system variable enabled (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'SYSVARPW'
GO
EXEC sp_addextendedproperty N'Caption', N'Release identifier', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'VERSIONINDICATOR'
GO
EXEC sp_addextendedproperty N'Caption', N'Date/Time when the HARVERSIONTRACKING table is added to the database schema', 'SCHEMA', N'dbo', 'TABLE', N'HARTABLEINFO', 'COLUMN', N'VERTRACKUPGRADEDATE'
GO