View | Details | Raw Unified | Return to bug 31727
Collapse All | Expand All

(-)a/installer/data/mysql/db_revs/220600024.pl (-3 / +10 lines)
Lines 9-15 return { Link Here
9
        my %default_rule_values = (
9
        my %default_rule_values = (
10
            issuelength             => 0,
10
            issuelength             => 0,
11
            hardduedate             => '',
11
            hardduedate             => '',
12
            unseenrenewalsallowed   => '',
12
            unseen_renewals_allowed   => '',
13
            rentaldiscount          => 0,
13
            rentaldiscount          => 0,
14
            decreaseloanholds       => '',
14
            decreaseloanholds       => '',
15
        );
15
        );
Lines 17-23 return { Link Here
17
            $dbh->do(q{
17
            $dbh->do(q{
18
                INSERT IGNORE INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value)
18
                INSERT IGNORE INTO circulation_rules (branchcode, categorycode, itemtype, rule_name, rule_value)
19
                    SELECT branchcode, categorycode, itemtype, ?, ? FROM circulation_rules cr
19
                    SELECT branchcode, categorycode, itemtype, ?, ? FROM circulation_rules cr
20
                        WHERE NOT EXISTS (
20
                        WHERE EXISTS (
21
                            SELECT * FROM circulation_rules cr2
22
                                WHERE
23
                                    cr2.rule_name="suspension_chargeperiod"
24
                                    AND ( (cr2.branchcode=cr.branchcode) OR ( ISNULL(cr2.branchcode) AND ISNULL(cr.branchcode) ) )
25
                                    AND ( (cr2.categorycode=cr.categorycode) OR ( ISNULL(cr2.categorycode) AND ISNULL(cr.categorycode) ) )
26
                                    AND ( (cr2.itemtype=cr.itemtype) OR ( ISNULL(cr2.itemtype) AND ISNULL(cr.itemtype) ) )
27
                        )
28
                        AND NOT EXISTS (
21
                            SELECT * FROM circulation_rules cr2
29
                            SELECT * FROM circulation_rules cr2
22
                                WHERE
30
                                WHERE
23
                                    cr2.rule_name=?
31
                                    cr2.rule_name=?
24
- 

Return to bug 31727