Attachment #100621 for bug #24298

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




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

    # Add return reasons to enum
    $dbh->do(
        qq{
            ALTER TABLE
                `branchtransfers`
            MODIFY COLUMN
                `reason` enum(
                    'Manual',
                    'StockrotationAdvance',
                    'StockrotationRepatriation',
                    'ReturnToHome',
                    'ReturnToHolding'
                )
            AFTER `comments`
          }
    );

    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 24296 - Add 'return' reasons to branchtransfers enum)\n";
}

Lines 906-912 CREATE TABLE `branchtransfers` ( -- information for items that are in transit be Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
906	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination	906	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907	`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to	907	`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
908	`comments` LONGTEXT, -- any comments related to the transfer	908	`comments` LONGTEXT, -- any comments related to the transfer
909	`reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation'), -- what triggered the transfer	909	`reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding'), -- what triggered the transfer
910	PRIMARY KEY (`branchtransfer_id`),	910	PRIMARY KEY (`branchtransfer_id`),
911	KEY `frombranch` (`frombranch`),	911	KEY `frombranch` (`frombranch`),
912	KEY `tobranch` (`tobranch`),	912	KEY `tobranch` (`tobranch`),
913	-

Return to bug 24298

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_24298.perl (+23 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	# Add return reasons to enum
	5	$dbh->do(
	6	qq{
	7	ALTER TABLE
	8	`branchtransfers`
	9	MODIFY COLUMN
	10	`reason` enum(
	11	'Manual',
	12	'StockrotationAdvance',
	13	'StockrotationRepatriation',
	14	'ReturnToHome',
	15	'ReturnToHolding'
	16	)
	17	AFTER `comments`
	18	}
	19	);
	20
	21	SetVersion( $DBversion );
	22	print "Upgrade to $DBversion done (Bug 24296 - Add 'return' reasons to branchtransfers enum)\n";
	23	}