Difference between revisions of "Table project version history"

From Zen Cart(tm) Wiki
Jump to: navigation, search
(1.3.6)
Line 1: Line 1:
{{Template:menuBarDevelopers}}
 
== 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 ===
 
:[[Table project_version_history#project_version_id|project_version_id]]
 
 
=== Indexed Fields ===
 
:None.
 
 
 
== Columns ==
 
=== project_version_id [[Image:Primary_key.gif|Primary Key]]===
 
:A unique, auto incremented value, to identify each project version history record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(3)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|-
 
| Extra: || auto_increment
 
|}
 
</BLOCKQUOTE>
 
 
 
=== project_version_key ===
 
:A unique alphanumeric value to identify each project version record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(40)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== project_version_major ===
 
:The "major" component of the version number.  ie: "1"
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(20)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== project_version_minor ===
 
:The "minor" component of the version number, usually several parts, separated by periods. ie: "3.6"
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(20)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== project_version_patch ===
 
:If this version record is in relation to a patch, this is the patch-level indicator.
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(20)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== 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".
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(250)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== project_version_date_applied ===
 
:The date on which this version record was generated ... ie: the date the patch was applied.
 
<BLOCKQUOTE>
 
{|
 
| Type: || datetime
 
|-
 
| Null: || No
 
|-
 
| Default: || 0001-01-01 01:01:01
 
|}
 
</BLOCKQUOTE>
 
 
 
== Default Entries ==
 
<BLOCKQUOTE>
 
{|
 
|  [[Table project_version#project_version_id|project_version_id]]: || 1
 
|-
 
|  [[Table project_version#project_version_key|project_version_key]]: || Zen-Cart Main
 
|-
 
|  [[Table project_version#project_version_major|project_version_major]]: || 1
 
|-
 
|  [[Table project_version#project_version_minor|project_version_minor]]: || 3.6
 
|-
 
|  [[Table project_version#project_version_patch|project_version_patch]]: ||
 
|-
 
|  [[Table project_version#project_version_comment|project_version_comment]]: || Fresh Installation
 
|-
 
|  [[Table project_version#project_version_date_applied|project_version_date_applied]]: || ''Will always be the date and time Zen Cart&trade; was initially installed.''
 
|}
 
</BLOCKQUOTE>
 
 
 
<BLOCKQUOTE>
 
{|
 
|  [[Table project_version#project_version_id|project_version_id]]: || 2
 
|-
 
|  [[Table project_version#project_version_key|project_version_key]]: || Zen-Cart Database
 
|-
 
|  [[Table project_version#project_version_major|project_version_major]]: || 1
 
|-
 
|  [[Table project_version#project_version_minor|project_version_minor]]: || 3.6
 
|-
 
|  [[Table project_version#project_version_patch|project_version_patch]]: ||
 
|-
 
|  [[Table project_version#project_version_comment|project_version_comment]]: || Fresh Installation
 
|-
 
|  [[Table project_version#project_version_date_applied|project_version_date_applied]]: || ''Will always be the date and time Zen Cart&trade; was initially installed.''
 
|}
 
</BLOCKQUOTE>
 

Revision as of 00:35, 5 December 2007