CORE POS - Fannie
The CORE POS back end
Protected Attributes | List of all members
update_20130118214807 Class Reference
Inheritance diagram for update_20130118214807:
UpdateObj

Protected Attributes

 $timestamp = '20130118214807'
 
 $description
 
 $author = 'Eric Lee (WEFC_Toronto)'
 
 $queries
 
- Protected Attributes inherited from UpdateObj
 $timestamp = 'YYYYMMDDHHMMSS'
 
 $description = 'Describe what your update does'
 
 $author = 'Say who you are'
 
 $queries
 

Additional Inherited Members

- Public Member Functions inherited from UpdateObj
 HtmlInfo ()
 
 HtmlQueries ()
 
 ApplyUpdates ()
 
 CheckStatus ()
 
 SetStatus ($st)
 

Member Data Documentation

update_20130118214807::$description
protected
Initial value:
= 'If you have run update 20130118214806 to change the data type of upc in
<br />products, productBackup and prodExtra
<br />and it succeeded but removed the leading zeroes from upc run this update to restore them.
<br />When all is well run update 20130118214808 to drop the special backups of
<br />products, productBackup and prodExtra that were made by update 20130118214805.
<br />These changes were tested under MySQL 5.1'
update_20130118214807::$queries
protected
Initial value:
= array(
'op' => array(
"UPDATE productBackup SET upc = LPAD(upc,13,'0') WHERE CHAR_LENGTH(upc) <> 13",
"UPDATE prodExtra SET upc = LPAD(upc,13,'0') WHERE CHAR_LENGTH(upc) < 13",
"UPDATE products SET upc = LPAD(upc,13,'0') WHERE CHAR_LENGTH(upc) < 13"
),
'trans' => array(),
'archive' => array()
)

The documentation for this class was generated from the following file: