|
| $timestamp = '20130118214807' |
|
| $description |
|
| $author = 'Eric Lee (WEFC_Toronto)' |
|
| $queries |
|
| $timestamp = 'YYYYMMDDHHMMSS' |
|
| $description = 'Describe what your update does' |
|
| $author = 'Say who you are' |
|
| $queries |
|
|
| HtmlInfo () |
|
| HtmlQueries () |
|
| ApplyUpdates () |
|
| CheckStatus () |
|
| SetStatus ($st) |
|
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:
- fannie/install/updates/20130118214807.php