|
Lines 187-194
if ( not $noaction ) {
Link Here
|
| 187 |
$schema->storage->txn_begin; |
187 |
$schema->storage->txn_begin; |
| 188 |
|
188 |
|
| 189 |
my $query = qq| |
189 |
my $query = qq| |
| 190 |
DELETE relationships FROM relationships |
190 |
DELETE borrower_relationships FROM borrower_relationships |
| 191 |
LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id ) |
191 |
LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id ) |
| 192 |
$where |
192 |
$where |
| 193 |
|; |
193 |
|; |
| 194 |
my $sth = $dbh->prepare($query); |
194 |
my $sth = $dbh->prepare($query); |
|
Lines 232-239
if ( not $noaction ) {
Link Here
|
| 232 |
|; |
232 |
|; |
| 233 |
|
233 |
|
| 234 |
my $query = qq| |
234 |
my $query = qq| |
| 235 |
DELETE relationships FROM relationships |
235 |
DELETE borrower_relationships FROM borrower_relationships |
| 236 |
LEFT JOIN borrowers ON ( borrowers.borrowernumber = relationships.guarantee_id ) |
236 |
LEFT JOIN borrowers ON ( borrowers.borrowernumber = borrower_relationships.guarantee_id ) |
| 237 |
$where |
237 |
$where |
| 238 |
|; |
238 |
|; |
| 239 |
my $sth = $dbh->prepare($query); |
239 |
my $sth = $dbh->prepare($query); |
| 240 |
- |
|
|