<?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;',
);