sql-install.php
410 Bytes
<?php
$sql = array();
$sql[] = "CREATE TABLE IF NOT EXISTS `"._DB_PREFIX_.self::prefijo."multiean` (
`id` INT(10) NOT NULL AUTO_INCREMENT,
`id_product` INT(10) NOT NULL,
`id_product_attribute` INT(10) NOT NULL,
`ean13` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_ean_per_product_combination` (`id_product`, `ean13`)
)
COLLATE='utf8_general_ci'
ENGINE=MyIsam;";