1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
3 if ( column_exists( 'branch_borrower_circ_rules', 'maxissueqty' ) ) {
5 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
6 SELECT categorycode, branchcode, NULL, 'maxissueqty', maxissueqty
7 FROM branch_borrower_circ_rules
10 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
11 SELECT categorycode, branchcode, NULL, 'maxonsiteissueqty', maxonsiteissueqty
12 FROM branch_borrower_circ_rules
14 $dbh->do("DROP TABLE branch_borrower_circ_rules");
17 if ( column_exists( 'default_borrower_circ_rules', 'maxissueqty' ) ) {
19 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
20 SELECT categorycode, NULL, NULL, 'maxissueqty', maxissueqty
21 FROM default_borrower_circ_rules
24 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
25 SELECT categorycode, NULL, NULL, 'maxonsiteissueqty', maxonsiteissueqty
26 FROM default_borrower_circ_rules
28 $dbh->do("DROP TABLE default_borrower_circ_rules");
31 if ( column_exists( 'default_circ_rules', 'maxissueqty' ) ) {
33 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
34 SELECT NULL, NULL, NULL, 'maxissueqty', maxissueqty
35 FROM default_circ_rules
38 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
39 SELECT NULL, NULL, NULL, 'maxonsiteissueqty', maxonsiteissueqty
40 FROM default_circ_rules
42 $dbh->do("ALTER TABLE default_circ_rules DROP COLUMN maxissueqty, DROP COLUMN maxonsiteissueqty");
45 if ( column_exists( 'default_branch_circ_rules', 'maxissueqty' ) ) {
47 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
48 SELECT NULL, branchcode, NULL, 'maxissueqty', maxissueqty
49 FROM default_branch_circ_rules
52 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
53 SELECT NULL, NULL, NULL, 'maxonsiteissueqty', maxonsiteissueqty
54 FROM default_branch_circ_rules
56 $dbh->do("ALTER TABLE default_branch_circ_rules DROP COLUMN maxissueqty, DROP COLUMN maxonsiteissueqty");
59 if ( column_exists( 'issuingrules', 'maxissueqty' ) ) {
61 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
62 SELECT categorycode, branchcode, itemtype, 'maxissueqty', maxissueqty
66 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
67 SELECT categorycode, branchcode, itemtype, 'maxonsiteissueqty', maxonsiteissueqty
70 $dbh->do("ALTER TABLE issuingrules DROP COLUMN maxissueqty, DROP COLUMN maxonsiteissueqty");
73 SetVersion( $DBversion );
74 print "Upgrade to $DBversion done (Bug 18925 - Move maxissueqty and maxonsiteissueqty to circulation_rules)\n";