Attachment #97450 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 stockrotation states to trigger enum
    $dbh->do(
        qq{
            ALTER TABLE
                `branchtransfers`
            MODIFY COLUMN
                `trigger` enum(
                    'MANUAL',
                    'StockrotationAdvance',
                    'StockrotationRepatriation',
                    'ReturnToHome',
                    'ReturnToHolding'
                )
            AFTER `comments`
          }
    );

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

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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
951	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination	951	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination
952	`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to	952	`tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
953	`comments` LONGTEXT, -- any comments related to the transfer	953	`comments` LONGTEXT, -- any comments related to the transfer
954	`trigger` ENUM('MANUAL', 'StockrotationAdvance', 'StockrotationRepatriation'), -- what triggered the transfer	954	`trigger` ENUM('MANUAL', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding'), -- what triggered the transfer
955	PRIMARY KEY (`branchtransfer_id`),	955	PRIMARY KEY (`branchtransfer_id`),
956	KEY `frombranch` (`frombranch`),	956	KEY `frombranch` (`frombranch`),
957	KEY `tobranch` (`tobranch`),	957	KEY `tobranch` (`tobranch`),
958	-

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 stockrotation states to trigger enum
	5	$dbh->do(
	6	qq{
	7	ALTER TABLE
	8	`branchtransfers`
	9	MODIFY COLUMN
	10	`trigger` 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' triggers to branchtransfers enum)\n";
	23	}