Table project version history

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.6


Description

Stores the historical records of version information for Zen Cart system components: PHP files, and database. When properly used, this table archives records from the project_version table prior to them being updated by whatever upgrade is taking place at a given time.


Table Details

Primary Key

project_version_id

Indexed Fields

None.


Columns

project_version_id Primary Key

A unique, auto incremented value, to identify each project version history record.
Type: tinyint(3)
Null: No
Default:
Extra: auto_increment


project_version_key

A unique alphanumeric value to identify each project version record.
Type: varchar(40)
Null: No
Default:


project_version_major

The "major" component of the version number. ie: "1"
Type: varchar(20)
Null: No
Default:


project_version_minor

The "minor" component of the version number, usually several parts, separated by periods. ie: "3.6"
Type: varchar(20)
Null: No
Default:


project_version_patch

If this version record is in relation to a patch, this is the patch-level indicator.
Type: varchar(20)
Null: No
Default:


project_version_comment

Comments, if any, explaining the nature of this version record. Often will be used to denote whether this was an upgrade or not, and perhaps what the upgrade was "from".
Type: varchar(250)
Null: No
Default:


project_version_date_applied

The date on which this version record was generated ... ie: the date the patch was applied.
Type: datetime
Null: No
Default: 0001-01-01 01:01:01


Default Entries

project_version_id: 1
project_version_key: Zen-Cart Main
project_version_major: 1
project_version_minor: 3.6
project_version_patch:
project_version_comment: Fresh Installation
project_version_date_applied: Will always be the date and time Zen Cart™ was initially installed.


project_version_id: 2
project_version_key: Zen-Cart Database
project_version_major: 1
project_version_minor: 3.6
project_version_patch:
project_version_comment: Fresh Installation
project_version_date_applied: Will always be the date and time Zen Cart™ was initially installed.