Attachment #72015 for bug #18786

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_18786.perl (+10 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	if ( !column_exists( 'accountlines', 'payment_type' ) ) {
	5	$dbh->do( "ALTER TABLE accountlines ADD `payment_type` varchar(80) default NULL AFTER accounttype" );
	6	}
	7
	8	SetVersion( $DBversion );
	9	print "Upgrade to $DBversion done (Bug 18786 - Add ability to create custom payment types)\n";
	10	}

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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
2681	`description` LONGTEXT,	2681	`description` LONGTEXT,
2682	`dispute` LONGTEXT,	2682	`dispute` LONGTEXT,
2683	`accounttype` varchar(5) default NULL,	2683	`accounttype` varchar(5) default NULL,
		2684	`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
2684	`amountoutstanding` decimal(28,6) default NULL,	2685	`amountoutstanding` decimal(28,6) default NULL,
2685	`lastincrement` decimal(28,6) default NULL,	2686	`lastincrement` decimal(28,6) default NULL,
2686	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,	2687	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2687	-

Return to bug 18786