Table project version history
From Zen Cart(tm) Wiki
Contents |
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
Indexed Fields
- None.
Columns
project_version_id 
- 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.
