48 lines
1.8 KiB
PHP
48 lines
1.8 KiB
PHP
<?php
|
|
/**
|
|
* Module My Easy ERP Web In Color
|
|
*
|
|
* @author Web In Color - addons@webincolor.fr
|
|
* @version 2.7.0
|
|
* @uses Prestashop modules
|
|
* @since 1.0 - mai 2014
|
|
* @package Wic ERP
|
|
* @copyright Copyright © 2016, Web In Color
|
|
* @license http://www.webincolor.fr
|
|
*/
|
|
|
|
if (!defined('_PS_VERSION_')) {
|
|
exit;
|
|
}
|
|
|
|
/**
|
|
* object module available
|
|
*/
|
|
function upgrade_module_2_8($object)
|
|
{
|
|
$upgrade_version = '2.8';
|
|
|
|
try {
|
|
Db::getInstance()->execute('CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'erp_order_receipt_dlc_bbd` (
|
|
`id_erp_order_receipt_dlc_bbd` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
|
`id_erp_order_receipt_history` int(11) unsigned NOT NULL,
|
|
`batch_number` varchar(50) DEFAULT \'\',
|
|
`dlc` datetime,
|
|
`bbd` datetime,
|
|
`current_stock` tinyint(1) NOT NULL DEFAULT \'0\',
|
|
`quantity` int(11) unsigned NOT NULL,
|
|
`date_add` datetime NOT NULL,
|
|
PRIMARY KEY (`id_erp_order_receipt_dlc_bbd`),
|
|
KEY `id_erp_order_receipt_history` (`id_erp_order_receipt_history`),
|
|
KEY `batch_number` (`batch_number`),
|
|
KEY `dlc` (`dlc`),
|
|
KEY `bbd` (`bbd`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;');
|
|
} catch (Exception $e) {
|
|
$e->getMessage();
|
|
}
|
|
|
|
Configuration::updateValue('WIC_ERP_VERSION', $upgrade_version);
|
|
return true;
|
|
}
|