function upgrade_module_2_0_13($object)
{
$query = 'ALTER TABLE `' . _DB_PREFIX_ . 'layered_product_attribute` DROP PRIMARY KEY';
$return = Db::getInstance()->execute($query);
$query = 'ALTER TABLE `' . _DB_PREFIX_ . 'layered_product_attribute` ADD PRIMARY KEY (`id_attribute`, `id_product`, `id_shop`)';
$return &= Db::getInstance()->execute($query);
if (check_index('layered_product_attribute', 'id_attribute_group')) {
$query = 'ALTER TABLE `' . _DB_PREFIX_ . 'layered_product_attribute` DROP KEY `id_attribute_group`';
$return &= Db::getInstance()->execute($query);
}
$query = 'ALTER TABLE `' . _DB_PREFIX_ . 'layered_product_attribute` ADD UNIQUE KEY `id_attribute_group` (`id_attribute_group`,`id_attribute`,`id_product`,`id_shop`)';
$return &= Db::getInstance()->execute($query);
return $return;
}
function check_killtables()
{
$qry = DBFactory::getDBQuery();
$query = 'SELECT kll_dmgtaken FROM kb3_kills LIMIT 1';
$result = mysql_query($query);
if ($result) {
return;
}
$qry->execute('ALTER TABLE `kb3_kills` ADD `kll_dmgtaken` INT(11) NOT NULL DEFAULT \'0\'');
$qry = DBFactory::getDBQuery();
$query = 'SELECT ind_dmgdone FROM kb3_inv_detail LIMIT 1';
$result = mysql_query($query);
if ($result) {
return;
}
$qry->execute('ALTER TABLE `kb3_inv_detail` ADD `ind_dmgdone` INT(11) NOT NULL DEFAULT \'0\'');
}
check_commenttable();
check_navigationtable();
check_commenttablerow();
check_shipvaltable();
check_invdetail();
check_pilots();
check_contracts();
check_index();
check_index_invcrp();
check_index_invall();
check_tblstrct1();
check_tblstrct5();
check_tblstrct6();
check_killtables();
