Table project version

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

Database Version

1.3.6


Description

Stores the current version information for Zen Cart system components: PHP files, and database.


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 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_patch1

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


project_version_patch2

If this version record is in relation to a patch on a version that already has a patch, this is the patch-level indicator for patch edition #2.
Type: varchar(20)
Null: No
Default:


project_version_patch1_source

An alphanumeric indicator of where the patch came from.
Type: varchar(20)
Null: No
Default:


project_version_patch2_source

An alphanumeric indicator of where the patch came from.
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_patch1:
project_version_patch2:
project_version_patch1_source:
project_version_patch2_source:
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_patch1:
project_version_patch2:
project_version_patch1_source:
project_version_patch2_source:
project_version_comment: Fresh Installation
project_version_date_applied: Will always be the date and time Zen Cart™ was initially installed.