Bug 31727 - Database query results ================================== Step 3 results = 47 rows/rules +----+------------+--------------+----------+----------------------------------+-----------------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+-----------------------+ | 1 | NULL | NULL | NULL | norenewalbefore | | | 2 | NULL | NULL | NULL | rentaldiscount | 0 | | 3 | NULL | NULL | NULL | holds_per_record | 2 | | 4 | NULL | NULL | NULL | issuelength | 5 | | 5 | NULL | NULL | NULL | opacitemholds | Y | | 6 | NULL | NULL | NULL | article_requests | no | | 7 | NULL | NULL | NULL | hardduedate | | | 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | | 9 | NULL | NULL | NULL | firstremind | 0 | | 10 | NULL | NULL | NULL | maxissueqty | 5 | | 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | | 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 13 | NULL | NULL | NULL | holds_per_day | | | 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | | 15 | NULL | NULL | NULL | no_auto_renewal_after | | | 16 | NULL | NULL | NULL | fine | 0 | | 17 | NULL | NULL | NULL | finedays | 2 | | 18 | NULL | NULL | NULL | hardduedatecompare | -1 | | 19 | NULL | NULL | NULL | renewalperiod | 5 | | 20 | NULL | NULL | NULL | overduefinescap | 0.00 | | 21 | NULL | NULL | NULL | onshelfholds | 1 | | 22 | NULL | NULL | NULL | auto_renew | 0 | | 23 | NULL | NULL | NULL | lengthunit | days | | 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 25 | NULL | NULL | NULL | renewalsallowed | 5 | | 26 | NULL | NULL | NULL | reservesallowed | | | 27 | NULL | NULL | NULL | chargeperiod | | | 28 | NULL | NULL | NULL | daysmode | | | 29 | NULL | NULL | NULL | unseen_renewals_allowed | | | 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 31 | NULL | NULL | NULL | note | | | 32 | NULL | NULL | NULL | decreaseloanholds | | | 33 | NULL | NULL | NULL | holdallowed | from_any_library | | 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | | 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | | 36 | NULL | NULL | NULL | max_holds | 25 | | 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | | 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 39 | FRL | NULL | NULL | max_holds | 15 | | 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | | 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | | 43 | MPL | NULL | NULL | max_holds | 10 | | 44 | SPL | NULL | NULL | holdallowed | from_home_library | | 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | | 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | | 47 | SPL | NULL | NULL | max_holds | 5 | +----+------------+--------------+----------+----------------------------------+-----------------------+ 47 rows in set (0.000 sec) Step 5 result = now have 63 rows/rules: 47 + 15 (3 libraries x 5 extra rules) + 1 (extra rule for unseenrenewalsallowed for NULL - see row 51) +----+------------+--------------+----------+----------------------------------+-----------------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+-----------------------+ | 1 | NULL | NULL | NULL | norenewalbefore | | | 2 | NULL | NULL | NULL | rentaldiscount | 0 | | 3 | NULL | NULL | NULL | holds_per_record | 2 | | 4 | NULL | NULL | NULL | issuelength | 5 | | 5 | NULL | NULL | NULL | opacitemholds | Y | | 6 | NULL | NULL | NULL | article_requests | no | | 7 | NULL | NULL | NULL | hardduedate | | | 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | | 9 | NULL | NULL | NULL | firstremind | 0 | | 10 | NULL | NULL | NULL | maxissueqty | 5 | | 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | | 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 13 | NULL | NULL | NULL | holds_per_day | | | 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | | 15 | NULL | NULL | NULL | no_auto_renewal_after | | | 16 | NULL | NULL | NULL | fine | 0 | | 17 | NULL | NULL | NULL | finedays | 2 | | 18 | NULL | NULL | NULL | hardduedatecompare | -1 | | 19 | NULL | NULL | NULL | renewalperiod | 5 | | 20 | NULL | NULL | NULL | overduefinescap | 0.00 | | 21 | NULL | NULL | NULL | onshelfholds | 1 | | 22 | NULL | NULL | NULL | auto_renew | 0 | | 23 | NULL | NULL | NULL | lengthunit | days | | 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 25 | NULL | NULL | NULL | renewalsallowed | 5 | | 26 | NULL | NULL | NULL | reservesallowed | | | 27 | NULL | NULL | NULL | chargeperiod | | | 28 | NULL | NULL | NULL | daysmode | | | 29 | NULL | NULL | NULL | unseen_renewals_allowed | | | 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 31 | NULL | NULL | NULL | note | | | 32 | NULL | NULL | NULL | decreaseloanholds | | | 33 | NULL | NULL | NULL | holdallowed | from_any_library | | 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | | 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | | 36 | NULL | NULL | NULL | max_holds | 25 | | 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | | 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 39 | FRL | NULL | NULL | max_holds | 15 | | 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | | 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | | 43 | MPL | NULL | NULL | max_holds | 10 | | 44 | SPL | NULL | NULL | holdallowed | from_home_library | | 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | | 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | | 47 | SPL | NULL | NULL | max_holds | 5 | | 48 | FRL | NULL | NULL | rentaldiscount | 0 | | 49 | MPL | NULL | NULL | rentaldiscount | 0 | | 50 | SPL | NULL | NULL | rentaldiscount | 0 | | 51 | NULL | NULL | NULL | unseenrenewalsallowed | | | 52 | FRL | NULL | NULL | unseenrenewalsallowed | | | 53 | MPL | NULL | NULL | unseenrenewalsallowed | | | 54 | SPL | NULL | NULL | unseenrenewalsallowed | | | 58 | FRL | NULL | NULL | decreaseloanholds | | | 59 | MPL | NULL | NULL | decreaseloanholds | | | 60 | SPL | NULL | NULL | decreaseloanholds | | | 61 | FRL | NULL | NULL | hardduedate | | | 62 | MPL | NULL | NULL | hardduedate | | | 63 | SPL | NULL | NULL | hardduedate | | | 64 | FRL | NULL | NULL | issuelength | 0 | | 65 | MPL | NULL | NULL | issuelength | 0 | | 66 | SPL | NULL | NULL | issuelength | 0 | +----+------------+--------------+----------+----------------------------------+-----------------------+ 63 rows in set (0.000 sec) Step 9 result = now have 48 row/rules: still have one extra rule - row 51 +----+------------+--------------+----------+----------------------------------+-----------------------+ | id | branchcode | categorycode | itemtype | rule_name | rule_value | +----+------------+--------------+----------+----------------------------------+-----------------------+ | 1 | NULL | NULL | NULL | norenewalbefore | | | 2 | NULL | NULL | NULL | rentaldiscount | 0 | | 3 | NULL | NULL | NULL | holds_per_record | 2 | | 4 | NULL | NULL | NULL | issuelength | 5 | | 5 | NULL | NULL | NULL | opacitemholds | Y | | 6 | NULL | NULL | NULL | article_requests | no | | 7 | NULL | NULL | NULL | hardduedate | | | 8 | NULL | NULL | NULL | maxonsiteissueqty | 5 | | 9 | NULL | NULL | NULL | firstremind | 0 | | 10 | NULL | NULL | NULL | maxissueqty | 5 | | 11 | NULL | NULL | NULL | maxsuspensiondays | 5 | | 12 | NULL | NULL | NULL | no_auto_renewal_after_hard_limit | | | 13 | NULL | NULL | NULL | holds_per_day | | | 14 | NULL | NULL | NULL | cap_fine_to_replacement_price | | | 15 | NULL | NULL | NULL | no_auto_renewal_after | | | 16 | NULL | NULL | NULL | fine | 0 | | 17 | NULL | NULL | NULL | finedays | 2 | | 18 | NULL | NULL | NULL | hardduedatecompare | -1 | | 19 | NULL | NULL | NULL | renewalperiod | 5 | | 20 | NULL | NULL | NULL | overduefinescap | 0.00 | | 21 | NULL | NULL | NULL | onshelfholds | 1 | | 22 | NULL | NULL | NULL | auto_renew | 0 | | 23 | NULL | NULL | NULL | lengthunit | days | | 24 | NULL | NULL | NULL | chargeperiod_charge_at | 0 | | 25 | NULL | NULL | NULL | renewalsallowed | 5 | | 26 | NULL | NULL | NULL | reservesallowed | | | 27 | NULL | NULL | NULL | chargeperiod | | | 28 | NULL | NULL | NULL | daysmode | | | 29 | NULL | NULL | NULL | unseen_renewals_allowed | | | 30 | NULL | NULL | NULL | suspension_chargeperiod | 1 | | 31 | NULL | NULL | NULL | note | | | 32 | NULL | NULL | NULL | decreaseloanholds | | | 33 | NULL | NULL | NULL | holdallowed | from_any_library | | 34 | NULL | NULL | NULL | patron_maxissueqty | 20 | | 35 | NULL | NULL | NULL | patron_maxonsiteissueqty | 20 | | 36 | NULL | NULL | NULL | max_holds | 25 | | 37 | FRL | NULL | NULL | patron_maxissueqty | 10 | | 38 | FRL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 39 | FRL | NULL | NULL | max_holds | 15 | | 40 | MPL | NULL | NULL | holdallowed | from_local_hold_group | | 41 | MPL | NULL | NULL | patron_maxonsiteissueqty | 5 | | 42 | MPL | NULL | NULL | patron_maxissueqty | 5 | | 43 | MPL | NULL | NULL | max_holds | 10 | | 44 | SPL | NULL | NULL | holdallowed | from_home_library | | 45 | SPL | NULL | NULL | patron_maxissueqty | 16 | | 46 | SPL | NULL | NULL | patron_maxonsiteissueqty | 8 | | 47 | SPL | NULL | NULL | max_holds | 5 | | 51 | NULL | NULL | NULL | unseen_renewals_allowed | | +----+------------+--------------+----------+----------------------------------+-----------------------+ 48 rows in set (0.001 sec)