iVend Database Database : CfgUpgradeProgressInformation 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

Description

VarWChar

4000

Status

VarWChar

500

StatusTime

DBTimeStamp

4

(getdate())

UpgradeType

VarWChar

500

UpgradeTypeKey

Integer

4

((0))

Index

Description

Primary

Unique

PK_CfgUpgradeProgressInformation

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[CfgUpgradeProgressInformation](

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

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

[Status] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[StatusTime] [datetime] NOT NULL,

[UpgradeType] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpgradeTypeKey] [int] NULL,

CONSTRAINT [PK_CfgUpgradeProgressInformation] 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].[CfgUpgradeProgressInformation] ADD CONSTRAINT [DF_CfgUpgradeProgressInformation_StatusTime] DEFAULT (getdate()) FOR [StatusTime]

ALTER TABLE [dbo].[CfgUpgradeProgressInformation] ADD CONSTRAINT [DF_CfgUpgradeProgressInformation_UpgradeTypeKey] DEFAULT ((0)) FOR [UpgradeTypeKey]