Attachment #97539 for bug #24436

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




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

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

    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 24299 - Add 'reserve' reasons 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	`reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection'), -- what triggered the transfer	954	`reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve'), -- 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 24436

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_24436.perl (+27 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	# Add reserve reasons 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	'RotatingCollection',
	17	'Reserve',
	18	'LostReserve',
	19	'CancelReserve'
	20	)
	21	AFTER `comments`
	22	}
	23	);
	24
	25	SetVersion( $DBversion );
	26	print "Upgrade to $DBversion done (Bug 24299 - Add 'reserve' reasons to branchtransfers enum)\n";
	27	}