Attachment #86673 for bug #22512

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




$DBversion = 'XXX';    # will be replaced by the RM
if ( CheckVersion($DBversion) ) {

    if ( !column_exists( 'accountlines', 'status' ) ) {
        $dbh->do(
            qq{
            ALTER TABLE `accountlines`
            ADD
              `status` varchar(16) DEFAULT NULL
            AFTER
              `accounttype`
          }
        );
    }

    SetVersion($DBversion);
    print "Upgrade to $DBversion done (Bug 22512 - Add status to accountlines)\n";
}

Lines 2676-2681 CREATE TABLE `accountlines` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
2676	`amount` decimal(28,6) default NULL,	2676	`amount` decimal(28,6) default NULL,
2677	`description` LONGTEXT,	2677	`description` LONGTEXT,
2678	`accounttype` varchar(5) default NULL,	2678	`accounttype` varchar(5) default NULL,
		2679	`status` varchar(16) default NULL,
2679	`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE	2680	`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2680	`amountoutstanding` decimal(28,6) default NULL,	2681	`amountoutstanding` decimal(28,6) default NULL,
2681	`lastincrement` decimal(28,6) default NULL,	2682	`lastincrement` decimal(28,6) default NULL,
2682	-

Return to bug 22512

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_22512.perl (+18 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if ( CheckVersion($DBversion) ) {
	3
	4	if ( !column_exists( 'accountlines', 'status' ) ) {
	5	$dbh->do(
	6	qq{
	7	ALTER TABLE `accountlines`
	8	ADD
	9	`status` varchar(16) DEFAULT NULL
	10	AFTER
	11	`accounttype`
	12	}
	13	);
	14	}
	15
	16	SetVersion($DBversion);
	17	print "Upgrade to $DBversion done (Bug 22512 - Add status to accountlines)\n";
	18	}