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();