1 CREATE TABLE `refund_lost_item_fee_rules` (
2 `branchcode` varchar(10) NOT NULL default '',
3 `refund` tinyint(1) NOT NULL default 0,
4 PRIMARY KEY (`branchcode`)
5 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
7 INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
8 VALUES( 'RefundLostOnReturnControl',
10 'If a lost item is returned, choose which branch to pick rules for refunding.',
11 'CheckinLibrary|PatronLibrary|ItemHomeBranch|ItemHoldingbranch',
14 INSERT INTO refund_lost_item_fee_rules (branchcode,refund)
15 SELECT '*', COALESCE(value,'1') FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn';
17 DELETE FROM systempreferences WHERE variable = 'RefundLostItemFeeOnReturn';
19 -- $DBversion = "16.06.00.XXX";
20 -- if ( CheckVersion($DBversion) ) {
22 -- CREATE TABLE `refund_lost_item_fee_rules` (
23 -- `branchcode` varchar(10) NOT NULL default '',
24 -- `refund` tinyint(1) NOT NULL default 0,
25 -- PRIMARY KEY (`branchcode`)
26 -- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
29 -- INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
30 -- VALUES( 'RefundLostOnReturnControl',
32 -- 'If a lost item is returned, choose which branch to pick rules for refunding.',
33 -- 'CheckinLibrary|PatronLibrary|ItemHomeBranch|ItemHoldingbranch',
36 -- # Pick the old syspref as the default rule
38 -- INSERT INTO refund_lost_item_fee_rules (branchcode,refund)
39 -- SELECT '*', COALESCE(value,'1') FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn'
41 -- # Delete the old syspref
43 -- DELETE IGNORE FROM systempreferences
44 -- WHERE variable='RefundLostItemFeeOnReturn'
47 -- print "Upgrade to $DBversion done (Bug 14048: Change RefundLostItemFeeOnReturn to be branch specific)\n";
48 -- SetVersion($DBversion);