<?php
/**
 * NOTICE OF LICENSE.
 *
 * This source file is subject to a commercial license from Common-Services Co., Ltd.
 * Use, copy, modification or distribution of this source file without written
 * license agreement from the SARL SMC is strictly forbidden.
 * In order to obtain a license, please contact us: support.mondialrelay@common-services.com
 * ...........................................................................
 * INFORMATION SUR LA LICENCE D'UTILISATION
 *
 * L'utilisation de ce fichier source est soumise a une licence commerciale
 * concedee par la societe Common-Services Co., Ltd.
 * Toute utilisation, reproduction, modification ou distribution du present
 * fichier source sans contrat de licence ecrit de la part de la Common-Services Co. Ltd. est
 * expressement interdite.
 * Pour obtenir une licence, veuillez contacter Common-Services Co., Ltd. a l'adresse:
 *            support.mondialrelay@common-services.com
 * ...........................................................................
 *
 * @author    Alexandre D.
 * @copyright Copyright (c) 2011-2015 Common Services Co Ltd - 90/25 Sukhumvit 81 - 10260 Bangkok - Thailand
 * @license   Commercial license
 * Support by mail  :  support.mondialrelay@common-services.com
 */

$sql = array();

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_history` (
		`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`order` TEXT NOT NULL,
		`exp` TEXT NOT NULL,
		`url_a4` VARCHAR(1000) NOT NULL,
		`url_a5` VARCHAR(1000) NOT NULL,
		PRIMARY KEY (`id`)
	) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_method` (
		`id_mr_method` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`name` VARCHAR(255) NOT NULL,
		`country_list` VARCHAR(1000) NOT NULL,
		`col_mode` VARCHAR(3) NOT NULL,
		`dlv_mode` VARCHAR(3) NOT NULL,
		`insurance` VARCHAR(3) NOT NULL DEFAULT "0",
		`id_carrier` int(10) NOT NULL,
		`is_deleted` int(10) NOT NULL,
		PRIMARY KEY (`id_mr_method`)
	)  ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_method_shop` (
		`id_mr_method_shop` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`id_mr_method` int(10) unsigned NOT NULL,
		`id_shop` int(10) unsigned NOT NULL,
		PRIMARY KEY (`id_mr_method_shop`)
	) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_selected` (
		`id_mr_selected` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`id_customer` int(10) unsigned DEFAULT NULL,
		`id_method` int(10) unsigned DEFAULT NULL,
		`id_cart` int(10) unsigned DEFAULT NULL,
		`id_order` int(10) unsigned DEFAULT NULL,
		`MR_poids` varchar(7) DEFAULT NULL,
		`MR_NbColis` int(1) DEFAULT 1,
		`MR_insurance` int(11) NOT NULL DEFAULT "0",
		`MR_Selected_Num` varchar(6) DEFAULT NULL,
		`MR_Selected_LgAdr1` varchar(36) DEFAULT NULL,
		`MR_Selected_LgAdr2` varchar(36) DEFAULT NULL,
		`MR_Selected_LgAdr3` varchar(36) DEFAULT NULL,
		`MR_Selected_LgAdr4` varchar(36) DEFAULT NULL,
		`MR_Selected_CP` varchar(10) DEFAULT NULL,
		`MR_Selected_Ville` varchar(32) DEFAULT NULL,
		`MR_Selected_Pays` varchar(2) DEFAULT NULL,
		`url_suivi` varchar(1000) DEFAULT NULL,
		`url_etiquette` varchar(1000) DEFAULT NULL,
		`exp_number` varchar(8) DEFAULT NULL,
		`date_add` datetime NOT NULL,
		`date_upd` datetime NOT NULL,
		PRIMARY KEY (`id_mr_selected`)
	) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

$sql[] =
    'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_session` (
  		`id_session` int(10) unsigned NOT NULL AUTO_INCREMENT,
	  	`alias` varchar(64) DEFAULT NULL,
	  	PRIMARY KEY (`id_session`)
	) ENGINE='._MYSQL_ENGINE_.' AUTO_INCREMENT=2000 DEFAULT CHARSET=utf8;';

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_session_detail` (
		`id_session_detail` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`id_session` INT(10) UNSIGNED NOT NULL,
		`id_order` INT(10) UNSIGNED NOT NULL,
		`weight` DECIMAL(20,6) NOT NULL DEFAULT "0.000000",
		PRIMARY KEY (`id_session_detail`)
	) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8';

$sql[] = '
	CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'mr_otp` (
		`id_otp` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`id_customer` INT(10) UNSIGNED NOT NULL,
		`otp` VARCHAR(32) NOT NULL DEFAULT "",
		`date_add` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
		PRIMARY KEY (`id_otp`)
	) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8';

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