Удаление касс с сервера УКМ : УКМ-4

$query = "select * from trm_in_pos p, trm_in_store s where p.store_id=s.store_id and s.name not like 'Demo%' and p.name like '%удалить%'" # получить список 'cash_id' касс для удаления
$tmp = Connect-MySqlServer -Credential $credential_MySQL -ComputerName 'UKMSERVER' -Database ukmserver -CommandTimeOut 7200
$pos = Invoke-MySqlQuery -Query $query -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
$query = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'cash_id' and TABLE_SCHEMA='ukmserver' AND TABLE_NAME NOT IN ('local_auth_account_journal','local_auth_account_journal_bak20170209', 'local_auth_account_journal_bak20170904','local_auth_certificate_account','local_auth_certificate_account_bak20170209','local_auth_certificate_account_bak20170904','local_auth_account_journal_oper_type','local_auth_account', 'trm_in_pos')" # получить список таблиц с колонкой 'cash_id'
$tables = Invoke-MySqlQuery -Query $query -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
foreach ($cash in $pos.cash_id)
{
    foreach ($table in $tables.TABLE_NAME)
    {
        $query = "delete from $table where cash_id=$cash"
        Write-Host $query
        Invoke-MySqlQuery -Query $query 
    }
$query = "delete from trm_in_pos where cash_id=$cash"
        Write-Host "Удалена касса $cash"
        Invoke-MySqlQuery -Query $query 
}
$tmp = Disconnect-MySqlServer