iVend Database Database : CfgUpgradeInformation Table

Creation Date

10/8/2018 5:57 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

9

Data Space Used

8.00 KB

Index Space Used

8.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

UpgradeKey

VarWChar

50

Version

VarWChar

50

VersionDescription

VarWChar

4000

AllowUpgrade

Boolean

1

((0))

Upgraded

Boolean

1

VersionDetails

VarWChar

1000

UpdateType

Integer

4

((2))

HasMCUpdate

Boolean

1

((0))

HasPOSUpdate

Boolean

1

((0))

HasDBUpdate

Boolean

1

((0))

HasAPIUpdate

Boolean

1

((0))

HasReplicationUpdate

Boolean

1

((0))

HasIntegrationUpdate

Boolean

1

((0))

HasAPIServiceUpdate

Boolean

1

((0))

HasUpgradeServiceUpdate

Boolean

1

((0))

HasConfigMgrUpdate

Boolean

1

((0))

IsTestUpdate

Boolean

1

((0))

DisplayOrder

Integer

4

HasOfflineUpdates

Boolean

1

HasOfflineUpdatesAllowed

Boolean

1

HasOfflineDownloadCompleted

Boolean

1

Index

Description

Primary

Unique

PK_CfgUpgradeInformation

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgUpgradeInformation](

[UpgradeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Version] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[VersionDescription] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllowUpgrade] [bit] NULL,

[Upgraded] [bit] NULL,

[VersionDetails] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpdateType] [int] NOT NULL,

[HasMCUpdate] [bit] NOT NULL,

[HasPOSUpdate] [bit] NOT NULL,

[HasDBUpdate] [bit] NOT NULL,

[HasAPIUpdate] [bit] NOT NULL,

[HasReplicationUpdate] [bit] NOT NULL,

[HasIntegrationUpdate] [bit] NOT NULL,

[HasAPIServiceUpdate] [bit] NOT NULL,

[HasUpgradeServiceUpdate] [bit] NOT NULL,

[HasConfigMgrUpdate] [bit] NOT NULL,

[IsTestUpdate] [bit] NOT NULL,

[DisplayOrder] [int] NULL,

[HasOfflineUpdates] [bit] NULL,

[HasOfflineUpdatesAllowed] [bit] NULL,

[HasOfflineDownloadCompleted] [bit] NULL,

CONSTRAINT [PK_CfgUpgradeInformation] PRIMARY KEY CLUSTERED

(

[UpgradeKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_AllowUpgrade] DEFAULT ((0)) FOR [AllowUpgrade]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_UpdateType] DEFAULT ((2)) FOR [UpdateType]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasMCUpdate] DEFAULT ((0)) FOR [HasMCUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasPOSUpdate] DEFAULT ((0)) FOR [HasPOSUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasDBUpdate] DEFAULT ((0)) FOR [HasDBUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasAPIUpdate] DEFAULT ((0)) FOR [HasAPIUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasReplicationUpdate] DEFAULT ((0)) FOR [HasReplicationUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasIntegrationUpdate] DEFAULT ((0)) FOR [HasIntegrationUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasAPIServiceUpdate] DEFAULT ((0)) FOR [HasAPIServiceUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasUpgradeServiceUpdate] DEFAULT ((0)) FOR [HasUpgradeServiceUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_HasConfigMgrUpdate] DEFAULT ((0)) FOR [HasConfigMgrUpdate]

ALTER TABLE [dbo].[CfgUpgradeInformation] ADD CONSTRAINT [DF_CfgUpgradeInformation_IsTestUpdate] DEFAULT ((0)) FOR [IsTestUpdate]