<?php
/**
 *  @author    Alexandre DEBUSSCHÈRE <alexandre@kosmonaft.dev>
 *  @copyright 2021 Kosmonaft.dev
 *  @license   Commercial
 */

if (!defined('_PS_VERSION_')) {
    exit;
}

$sql = [];

$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mrmax_cache` (
    `id_mrmax_cache` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(64) NOT NULL,
    `value` text,
    `ttl` datetime NOT NULL,
    `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `date_upd` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY  (`id_mrmax_cache`),
    UNIQUE KEY `u_name` (`name`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mrmax_delivery` (
      `id_mrmax_delivery` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
      `id_cart` int(11) NOT NULL,
      `type` varchar(4) NOT NULL,
      `prid` varchar(6) DEFAULT NULL,
      `weight` FLOAT(5) DEFAULT NULL,
      `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `date_upd` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`id_mrmax_delivery`),
      KEY `id_cart_i` (`id_cart`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8';

$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mrmax_tracking` (
      `id_mrmax_tracking` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
      `id_order` int(11) NOT NULL,
      `id_step` int(2) NOT NULL,
      `label_short` varchar(512) NOT NULL,
      `label_long` varchar(512) NOT NULL,
      `status` varchar(32) DEFAULT NULL,
      `code` varchar(7) DEFAULT NULL,
      `date` datetime DEFAULT NULL,
      `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `date_upd` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`id_mrmax_tracking`),
      KEY `id_order_i` (`id_order`),
      UNIQUE KEY `id_order_code_i` (`id_order`, `code`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8';

$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mrmax_carrier` (
    `id_mrmax_carrier` INT(11) NOT NULL AUTO_INCREMENT,
    `id_reference` INT(11) NOT NULL,
    `delivery_mode` VARCHAR(3) NOT NULL,
    `insurance` VARCHAR(2) NOT NULL,
    PRIMARY KEY (`id_mrmax_carrier`),
    UNIQUE KEY `u_id_reference` (`id_reference`)
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8';

foreach ($sql as $query) {
    if (Db::getInstance()->execute($query) == false) {
        return false;
    }
}