Attachment #94352 for bug #23049

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




          }
    );

    # Add any unexpected accounttype codes to debit_types as appropriate
    $dbh->do(
        qq{
          INSERT IGNORE INTO account_debit_types (
            code,
            description,
            can_be_added_manually,
            default_amount,
            is_system
          )
          SELECT
            SUBSTR(accounttype, 1, 80),
            "Unexpected type found during upgrade",
            1,
            NULL,
            0
          FROM
            accountlines
          WHERE
            amount > 0
        }
    );

    # Adding debit_type_code to accountlines
    unless ( column_exists('accountlines', 'debit_type_code') ) {
        $dbh->do(
- 

Return to bug 23049

Lines 105-110 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (-1 / +23 lines)
105	}	105	}
106	);	106	);
107		107
		108	# Add any unexpected accounttype codes to debit_types as appropriate
		109	$dbh->do(
		110	qq{
		111	INSERT IGNORE INTO account_debit_types (
		112	code,
		113	description,
		114	can_be_added_manually,
		115	default_amount,
		116	is_system
		117	)
		118	SELECT
		119	SUBSTR(accounttype, 1, 80),
		120	"Unexpected type found during upgrade",
		121	1,
		122	NULL,
		123	0
		124	FROM
		125	accountlines
		126	WHERE
		127	amount > 0
		128	}
		129	);
		130
108	# Adding debit_type_code to accountlines	131	# Adding debit_type_code to accountlines
109	unless ( column_exists('accountlines', 'debit_type_code') ) {	132	unless ( column_exists('accountlines', 'debit_type_code') ) {
110	$dbh->do(	133	$dbh->do(
111	-