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

(-)a/installer/data/mysql/atomicupdate/bug_18936.perl (-37 / +36 lines)
Lines 1-45 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
	my @columns = qw(
3
    my @columns = qw(
4
		restrictedtype
4
        restrictedtype
5
		rentaldiscount
5
        rentaldiscount
6
		fine
6
        fine
7
		finedays
7
        finedays
8
		maxsuspensiondays
8
        maxsuspensiondays
9
		firstremind
9
        firstremind
10
		chargeperiod
10
        chargeperiod
11
		chargeperiod_charge_at
11
        chargeperiod_charge_at
12
		accountsent
12
        accountsent
13
		issuelength
13
        issuelength
14
		lengthunit
14
        lengthunit
15
		hardduedate
15
        hardduedate
16
		hardduedatecompare
16
        hardduedatecompare
17
		renewalsallowed
17
        renewalsallowed
18
		renewalperiod
18
        renewalperiod
19
		norenewalbefore
19
        norenewalbefore
20
		auto_renew
20
        auto_renew
21
		no_auto_renewal_after
21
        no_auto_renewal_after
22
		no_auto_renewal_after_hard_limit
22
        no_auto_renewal_after_hard_limit
23
		reservesallowed
23
        reservesallowed
24
		holds_per_record
24
        holds_per_record
25
		overduefinescap
25
        overduefinescap
26
		cap_fine_to_replacement_price
26
        cap_fine_to_replacement_price
27
		onshelfholds
27
        onshelfholds
28
		opacitemholds
28
        opacitemholds
29
		article_requests
29
        article_requests
30
	);
30
    );
31
31
32
    if ( column_exists( 'issuingrules', 'categorycode' ) ) {
32
    if ( column_exists( 'issuingrules', 'categorycode' ) ) {
33
		foreach my $column ( @columns ) {
33
        foreach my $column ( @columns ) {
34
			$dbh->do("
34
            $dbh->do("
35
				INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
35
                INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
36
				SELECT categorycode, branchcode, itemtype, 'column', $column
36
                SELECT categorycode, branchcode, itemtype, \'$column\', $column
37
				FROM issuingrules
37
                FROM issuingrules
38
			");
38
            ");
39
		}
39
        }
40
        $dbh->do("DROP TABLE issuingrules");
40
        $dbh->do("DROP TABLE issuingrules");
41
    }
41
    }
42
42
43
    SetVersion( $DBversion );
43
    SetVersion( $DBversion );
44
    print "Upgrade to $DBversion done (Bug 18930 - Move lost item refund rules to circulation_rules table)\n";
44
    print "Upgrade to $DBversion done (Bug 18936: Convert issuingrules fields to circulation_rules)\n";
45
}
45
}
46
- 

Return to bug 18936