1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 unless (TableExists('circulation_rules')){
6 CREATE TABLE `circulation_rules` (
7 `id` int(11) NOT NULL auto_increment,
8 `branchcode` varchar(10) NULL default NULL,
9 `categorycode` varchar(10) NULL default NULL,
10 `itemtype` varchar(10) NULL default NULL,
11 `rule_name` varchar(32) NOT NULL,
12 `rule_value` varchar(32) NOT NULL,
14 KEY `branchcode` (`branchcode`),
15 KEY `categorycode` (`categorycode`),
16 KEY `itemtype` (`itemtype`),
17 KEY `rule_name` (`rule_name`),
18 UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
24 INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value )
25 SELECT branchcode, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM branch_borrower_circ_rules
29 INSERT INTO circulation_rules ( branchcode, categorycode, itemtype, rule_name, rule_value )
30 SELECT NULL, categorycode, NULL, 'max_holds', COALESCE( max_holds, '' ) FROM default_borrower_circ_rules
34 ALTER TABLE branch_borrower_circ_rules DROP COLUMN max_holds
38 ALTER TABLE default_borrower_circ_rules DROP COLUMN max_holds
41 SetVersion( $DBversion );
42 print "Upgrade to $DBversion done (Bug 18887 - Introduce new table 'circulation_rules', use for 'max_holds' rules)\n";