Files
2019-11-20 07:44:43 +01:00

27 lines
1.1 KiB
PHP

<?php
/**
* Module Partial Shipment - Main file
*
* @author My Addons <contact@myaddons.io>
* @copyright 2017 My Addons
* @license myaddons.io
* @version 1.0.0
* @since File available since Release 1.0
*/
$sql = array(
'partial_shipment' => 'CREATE TABLE IF NOT EXISTS`'._DB_PREFIX_.'bt_partial_shipment` (
`id_partial_shipment` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`id_order` int(11) NOT NULL,
`tracking_number` varchar(255) NOT NULL,
`date_add` datetime NOT NULL
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;',
'partial_shipment_detail' => 'CREATE TABLE IF NOT EXISTS`'._DB_PREFIX_.'bt_partial_shipment_detail` (
`id_partial_shipment_detail` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`id_partial_shipment` int(11) NOT NULL,
`id_order_detail` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`date_add` datetime NOT NULL
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;',
);