Attachment #74147 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 2685-2690 CREATE TABLE `accountlines` ( Link Here

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

Return to bug 18786