public static function dropForeignKeys()
{
if (!self::$counter) {
$resource = Mage::getModel('core/resource');
$connection = $resource->getConnection('core_write');
$FKscope = array('sales_flat_quote_item' => array('FK_SALES_QUOTE_ITEM_SALES_QUOTE', 'FK_SALES_FLAT_QUOTE_ITEM_PARENT_ITEM', 'FK_SALES_QUOTE_ITEM_CATALOG_PRODUCT_ENTITY', 'FK_SALES_QUOTE_ITEM_STORE', 'FK_B201DEB5DE51B791AF5C5BF87053C5A7', 'FK_SALES_FLAT_QUOTE_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID'), 'cataloginventory_stock_status' => array('FK_CATALOGINVENTORY_STOCK_STATUS_STOCK', 'FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE', 'FK_CATINV_STOCK_STS_STOCK_ID_CATINV_STOCK_STOCK_ID'), 'catalog_product_website' => array('FK_CATALOG_PRODUCT_WEBSITE_WEBSITE'), 'catalog_product_entity_int' => array('FK_CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE', 'FK_CATALOG_PRODUCT_ENTITY_INT_STORE', 'FK_CATALOG_PRODUCT_ENTITY_INT_PRODUCT_ENTITY'), 'aw_collpur_rewrite' => array('FK_DEAL_STORE'), 'sales_flat_order_item' => array('IDX_ORDER', 'IDX_STORE_ID', 'IDX_PRODUCT_ID', 'FK_SALES_FLAT_ORDER_ITEM_PARENT'), 'sales_flat_order' => array('IDX_STORE_ID', 'IDX_CUSTOMER_ID', 'FK_SALES_FLAT_ORDER_CUSTOMER', 'FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID'), 'downloadable_link_purchased' => array('FK_DL_LNK_PURCHASED_CSTR_ID_CSTR_ENTT_ENTT_ID'));
foreach ($FKscope as $table => $fks) {
foreach ($fks as $fk) {
try {
$connection->exec(new Zend_Db_Expr("ALTER TABLE `{$table}` DROP FOREIGN KEY `{$fk}`"));
$connection->exec(new Zend_Db_Expr("ALTER TABLE `{$table}` DROP KEY `{$fk}`"));
} catch (Exception $e) {
}
}
}
self::$counter = 1;
}
}
public function setup()
{
AW_Collpur_Test_Model_Mocks_Foreignresetter::dropForeignKeys();
parent::setup();
}
