Attachment #100628 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 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', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection'), -- what triggered the transfer	909	`reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve'), -- 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 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	}