|
Lines 20707-20712
if( CheckVersion( $DBversion ) ) {
Link Here
|
| 20707 |
note |
20707 |
note |
| 20708 |
); |
20708 |
); |
| 20709 |
|
20709 |
|
|
|
20710 |
$dbh->do(q| |
| 20711 |
DELETE i FROM issuingrules i |
| 20712 |
LEFT JOIN itemtypes it ON i.itemtype=it.itemtype |
| 20713 |
WHERE it.itemtype IS NULL |
| 20714 |
|); |
| 20715 |
$dbh->do(q| |
| 20716 |
DELETE i FROM issuingrules i |
| 20717 |
LEFT JOIN branches b ON i.branchcode=b.branchcode |
| 20718 |
WHERE b.branchcode IS NULL |
| 20719 |
|); |
| 20720 |
$dbh->do(q| |
| 20721 |
DELETE i FROM issuingrules i |
| 20722 |
LEFT JOIN categories c ON i.categorycode=c.categorycode |
| 20723 |
WHERE c.categorycode IS NULL |
| 20724 |
|); |
| 20710 |
if ( column_exists( 'issuingrules', 'categorycode' ) ) { |
20725 |
if ( column_exists( 'issuingrules', 'categorycode' ) ) { |
| 20711 |
foreach my $column ( @columns ) { |
20726 |
foreach my $column ( @columns ) { |
| 20712 |
$dbh->do(" |
20727 |
$dbh->do(" |
| 20713 |
- |
|
|