iVend Database Database : CfgOfflineUpdateInformation Table

Creation Date

10/8/2018 5:57 PM

File Group

PRIMARY

Text File Group

System Object

Published for Replication

Rows

0

Data Space Used

0.00 KB

Index Space Used

0.00 KB

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

UpgradeKey

VarWChar

50

Version

VarWChar

50

MCDownloadCompleted

Boolean

1

((0))

MCDownloadDate

DBTimeStamp

4

POSDownloadCompleted

Boolean

1

((0))

POSDownloadDate

DBTimeStamp

4

RepDownloadCompleted

Boolean

1

((0))

RepDownloadDate

DBTimeStamp

4

IntegreationDownloadCompleted

Boolean

1

((0))

IntegrationDownloadDate

DBTimeStamp

4

UpgServDownloadCompleted

Boolean

1

((0))

UpgServDownloadDate

DBTimeStamp

4

ApiDownloadCompleted

Boolean

1

ApiDownloadDate

DBTimeStamp

4

APiServDownloadCompleted

Boolean

1

ApiServDownloadDate

DBTimeStamp

4

ConfigDownloadCompleted

Boolean

1

ConfigDownloadDate

DBTimeStamp

4

DatabaseDownloadCompleted

Boolean

1

DatabaseDownloadDate

DBTimeStamp

4

UpgradeDownloadCompleted

Boolean

1

UpgradeDownloadDate

DBTimeStamp

4

DisplayOrder

Integer

4

Index

Description

Primary

Unique

PK_CfgOfflineUpdateDetails

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgOfflineUpdateInformation](

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

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

[MCDownloadCompleted] [bit] NOT NULL,

[MCDownloadDate] [datetime] NULL,

[POSDownloadCompleted] [bit] NOT NULL,

[POSDownloadDate] [datetime] NULL,

[RepDownloadCompleted] [bit] NOT NULL,

[RepDownloadDate] [datetime] NULL,

[IntegreationDownloadCompleted] [bit] NOT NULL,

[IntegrationDownloadDate] [datetime] NULL,

[UpgServDownloadCompleted] [bit] NOT NULL,

[UpgServDownloadDate] [datetime] NULL,

[ApiDownloadCompleted] [bit] NOT NULL,

[ApiDownloadDate] [datetime] NULL,

[APiServDownloadCompleted] [bit] NOT NULL,

[ApiServDownloadDate] [datetime] NULL,

[ConfigDownloadCompleted] [bit] NOT NULL,

[ConfigDownloadDate] [datetime] NULL,

[DatabaseDownloadCompleted] [bit] NOT NULL,

[DatabaseDownloadDate] [datetime] NULL,

[UpgradeDownloadCompleted] [bit] NOT NULL,

[UpgradeDownloadDate] [datetime] NULL,

[DisplayOrder] [int] NULL,

CONSTRAINT [PK_CfgOfflineUpdateDetails] 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].[CfgOfflineUpdateInformation] ADD CONSTRAINT [DF_CfgOfflineUpdateDetails_MCDownloadCompleted] DEFAULT ((0)) FOR [MCDownloadCompleted]

ALTER TABLE [dbo].[CfgOfflineUpdateInformation] ADD CONSTRAINT [DF_CfgOfflineUpdateDetails_POSDownloadCompleted] DEFAULT ((0)) FOR [POSDownloadCompleted]

ALTER TABLE [dbo].[CfgOfflineUpdateInformation] ADD CONSTRAINT [DF_CfgOfflineUpdateDetails_RepDownloadCompleted] DEFAULT ((0)) FOR [RepDownloadCompleted]

ALTER TABLE [dbo].[CfgOfflineUpdateInformation] ADD CONSTRAINT [DF_CfgOfflineUpdateDetails_IntegreationDownloadCompleted] DEFAULT ((0)) FOR [IntegreationDownloadCompleted]

ALTER TABLE [dbo].[CfgOfflineUpdateInformation] ADD CONSTRAINT [DF_CfgOfflineUpdateDetails_UpgServDownloadCompleted] DEFAULT ((0)) FOR [UpgServDownloadCompleted]