- Модуль: sale
- Путь к файлу: ~/bitrix/modules/sale/lib/location/import/import.php
- Класс: BitrixSaleLocationImportis
- Вызов: is::dropIndexes
protected function dropIndexes($certainIndex = false)
{
$locationTable = LocationLocationTable::getTableName();
$locationNameTable = LocationNameLocationTable::getTableName();
$map = array(
$locationTable => array(
'IX_B_SALE_LOC_MARGINS',
'IX_B_SALE_LOC_MARGINS_REV',
'IX_B_SALE_LOC_PARENT',
'IX_B_SALE_LOC_DL',
'IX_B_SALE_LOC_TYPE',
// old indexes
'IXS_LOCATION_COUNTRY_ID',
'IXS_LOCATION_REGION_ID',
'IXS_LOCATION_CITY_ID',
// for mssql, the same
'IX_B_SALE_LOCATION_1',
'IX_B_SALE_LOCATION_2',
'IX_B_SALE_LOCATION_3'
),
$locationNameTable => array('IX_B_SALE_LOC_NAME_NAME_U', 'IX_B_SALE_LOC_NAME_LI_LI')
);
foreach($map as $tableName => $indexes)
{
foreach($indexes as $index)
{
if($certainIndex !== false && $certainIndex != $index)
continue;
$this->dropIndexByName($index, $tableName);
}
}
}