|
Lines 21-43
if( CheckVersion( $DBversion ) ) {
Link Here
|
| 21 |
}); |
21 |
}); |
| 22 |
} |
22 |
} |
| 23 |
|
23 |
|
| 24 |
$dbh->do(q{ |
24 |
|
| 25 |
INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
25 |
if (column_exists('branch_borrower_circ_rules', 'max_holds') ){ |
| 26 |
SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules |
26 |
$dbh->do(q{ |
| 27 |
}); |
27 |
INSERT IGNORE INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
| 28 |
|
28 |
SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules |
| 29 |
$dbh->do(q{ |
29 |
}); |
| 30 |
INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
30 |
|
| 31 |
SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules |
31 |
$dbh->do(q{ |
| 32 |
}); |
32 |
ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds |
| 33 |
|
33 |
}); |
| 34 |
$dbh->do(q{ |
34 |
} |
| 35 |
ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds |
35 |
|
| 36 |
}); |
36 |
if (column_exists('default_borrower_circ_rules', 'max_holds') ){ |
| 37 |
|
37 |
$dbh->do(q{ |
| 38 |
$dbh->do(q{ |
38 |
INSERT IGNORE INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
| 39 |
ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds |
39 |
SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules |
| 40 |
}); |
40 |
}); |
|
|
41 |
|
| 42 |
$dbh->do(q{ |
| 43 |
ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds |
| 44 |
}); |
| 45 |
} |
| 41 |
|
46 |
|
| 42 |
SetVersion( $DBversion ); |
47 |
SetVersion( $DBversion ); |
| 43 |
print "Upgrade to $DBversion done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)\n"; |
48 |
print "Upgrade to $DBversion done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)\n"; |
| 44 |
- |
|
|