79 lines
3.2 KiB
PHP
79 lines
3.2 KiB
PHP
<?php
|
|
/**
|
|
* Please read the terms of the CLUF license attached to this module(cf "licences" folder)
|
|
*
|
|
* @author Línea Gráfica E.C.E. S.L.
|
|
* @copyright Lineagrafica.es - Línea Gráfica E.C.E. S.L. all rights reserved.
|
|
* @license https://www.lineagrafica.es/licenses/license_en.pdf
|
|
* https://www.lineagrafica.es/licenses/license_es.pdf
|
|
* https://www.lineagrafica.es/licenses/license_fr.pdf
|
|
*/
|
|
|
|
$sql = array(
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_orders` (
|
|
`id_order` INT(11) NOT NULL,
|
|
`id_customer` INT(11) NOT NULL,
|
|
`hash` VARCHAR(60) NOT NULL,
|
|
`voted` INT(11) NOT NULL,
|
|
`sent` INT(11) NOT NULL,
|
|
`date_email` DATETIME NOT NULL,
|
|
`date_email2` DATETIME NOT NULL,
|
|
UNIQUE KEY `id_order` (`id_order`),
|
|
KEY `id_customer` (`id_customer`,`hash`,`voted`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb').' CHARSET=utf8',
|
|
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_status` (
|
|
`id_order_status` INT(11) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id_order_status`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb'),
|
|
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_productcomments` (
|
|
`id_productcomment` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`id_product` INT(11) NOT NULL,
|
|
`id_product_attribute` INT(11) NOT NULL,
|
|
`id_customer` INT(11) NOT NULL,
|
|
`id_lang` INT(11) NOT NULL,
|
|
`stars` INT(11) NOT NULL,
|
|
`nick` VARCHAR(255) NOT NULL,
|
|
`title` VARCHAR(255),
|
|
`comment` TEXT,
|
|
`answer` TEXT,
|
|
`active` TINYINT(1) NOT NULL,
|
|
`position` INT(11) NOT NULL,
|
|
`date` DATETIME NOT NULL,
|
|
PRIMARY KEY (`id_productcomment`),
|
|
KEY `date` (`date`,`id_customer`,`id_product`,`stars`,`id_lang`,`active`,`position`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb').' CHARSET=utf8',
|
|
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_storecomments` (
|
|
`id_storecomment` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`id_order` INT(11) NOT NULL,
|
|
`id_customer` INT(11) NOT NULL,
|
|
`id_lang` INT(11) NOT NULL,
|
|
`stars` INT(11) NOT NULL,
|
|
`nick` VARCHAR(255) NOT NULL,
|
|
`title` VARCHAR(255),
|
|
`comment` TEXT,
|
|
`answer` TEXT,
|
|
`active` TINYINT(1) NOT NULL,
|
|
`position` INT(11) NOT NULL,
|
|
`date` DATETIME NOT NULL,
|
|
PRIMARY KEY (`id_storecomment`),
|
|
KEY `date` (`date`,`id_customer`,`id_order`,`stars`,`id_lang`,`active`,`position`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb').' CHARSET=utf8',
|
|
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_customergroups` (
|
|
`id_customer_group` INT(11) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id_customer_group`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb'),
|
|
|
|
'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'lgcomments_multistore` (
|
|
`id_shop` INT(11) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id_shop`)
|
|
) ENGINE='.(defined('ENGINE_TYPE') ? ENGINE_TYPE : 'Innodb'),
|
|
);
|
|
|
|
foreach ($sql as $query) {
|
|
Db::getInstance()->execute($query);
|
|
}
|