|
Line 0
Link Here
|
|
|
1 |
$DBversion = 'XXX'; # will be replaced by the RM |
| 2 |
if( CheckVersion( $DBversion ) ) { |
| 3 |
|
| 4 |
$dbh->do(q{ |
| 5 |
CREATE TABLE `circulation_rules` ( |
| 6 |
`id` int(11) NOT NULL auto_increment, |
| 7 |
`branchcode` varchar(10) NULL default NULL, |
| 8 |
`categorycode` varchar(10) NULL default NULL, |
| 9 |
`itemtype` varchar(10) NULL default NULL, |
| 10 |
`rule_name` varchar(32) NOT NULL, |
| 11 |
`rule_value` varchar(32) NOT NULL, |
| 12 |
PRIMARY KEY (`id`), |
| 13 |
KEY `branchcode` (`branchcode`), |
| 14 |
KEY `categorycode` (`categorycode`), |
| 15 |
KEY `itemtype` (`itemtype`), |
| 16 |
KEY `rule_name` (`rule_name`), |
| 17 |
UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) |
| 18 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 19 |
}); |
| 20 |
|
| 21 |
$dbh->do(q{ |
| 22 |
INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
| 23 |
SELECT branchcode, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules |
| 24 |
}); |
| 25 |
|
| 26 |
$dbh->do(q{ |
| 27 |
INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value ) |
| 28 |
SELECT NULL, categorycode, NULL, 'max_holds', max_holds FROM branch_borrower_circ_rules |
| 29 |
}); |
| 30 |
|
| 31 |
$dbh->do(q{ |
| 32 |
ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds |
| 33 |
}); |
| 34 |
|
| 35 |
$dbh->do(q{ |
| 36 |
ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds |
| 37 |
}); |
| 38 |
|
| 39 |
SetVersion( $DBversion ); |
| 40 |
print "Upgrade to $DBversion done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)\n"; |
| 41 |
} |