<?php
/**
* 2007-2016 PrestaShop.
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author    PrestaShop SA <contact@prestashop.com>
*  @copyright 2007-2016 PrestaShop SA
*  @license   http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

$sql = array();
/*
$sql[] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'innovatives_supplier_shop` (
  `id_innovatives_supplier_shop`  int(11) NOT NULL auto_increment,
  `id_innovatives_supplier` int(11) NOT NULL,
  `id_shop` int(11) NOT NULL  DEFAULT \'1\',
  PRIMARY KEY (`id_innovatives_supplier_shop`,`id_innovatives_supplier`,`id_shop`)
)ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8' ;
*/
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'innovatives_supplier` (
	          `id_innovatives_supplier` int(11) NOT NULL AUTO_INCREMENT,	          	 
               `id_product` int(11)  NULL,	
                `id_order` int(11) NULL,
				`id_supplier` int(11) NULL,
				`id_supplier_reference` int(11) NULL,
                 `comment`	TEXT NULL,	
                `id_shop` INTEGER UNSIGNED NOT NULL DEFAULT \'1\',
			   `id_shop_group` INTEGER UNSIGNED NOT NULL DEFAULT \'1\',				 
	           PRIMARY KEY (`id_innovatives_supplier`)
	           ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ';

$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'innovatives_mini_amount` (
	          `id_innovatives_mini_amount` int(11) NOT NULL AUTO_INCREMENT,	          	 
               `id_supplier` int(11) NOT  NULL,	
                `mini_amount` varchar(250),						
	           PRIMARY KEY (`id_innovatives_mini_amount`)
	           ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ';

$sql[] = 'ALTER TABLE `'._DB_PREFIX_.'supplier` ADD `email` varchar(250)  NOT NULL';