Attachment #120684 for bug #24434

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




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

    # Add 'WrongTransfer' to branchtransfers cancellation_reason enum
    $dbh->do(
        q{
            ALTER TABLE
                `branchtransfers`
            MODIFY COLUMN
                `cancellation_reason` enum(
                    'Manual',
                    'StockrotationAdvance',
                    'StockrotationRepatriation',
                    'ReturnToHome',
                    'ReturnToHolding',
                    'RotatingCollection',
                    'Reserve',
                    'LostReserve',
                    'CancelReserve',
                    'ItemLost',
                    'WrongTransfer'
                )
            AFTER `comments`
          }
    );

    NewVersion( $DBversion, 24434, "Add 'WrongTransfer' to branchtransfers.cancellation_reason enum");
}

Lines 1531-1537 CREATE TABLE `branchtransfers` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
1531	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',	1531	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1532	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',	1532	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1533	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve', 'TransferCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',	1533	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve', 'TransferCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
1534	`cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost') default NULL COMMENT 'what triggered the transfer cancellation',	1534	`cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost', 'WrongTransfer') default NULL COMMENT 'what triggered the transfer cancellation',
1535	PRIMARY KEY (`branchtransfer_id`),	1535	PRIMARY KEY (`branchtransfer_id`),
1536	KEY `frombranch` (`frombranch`),	1536	KEY `frombranch` (`frombranch`),
1537	KEY `tobranch` (`tobranch`),	1537	KEY `tobranch` (`tobranch`),
1538	-

Return to bug 24434

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_24434.perl (+28 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	# Add 'WrongTransfer' to branchtransfers cancellation_reason enum
	5	$dbh->do(
	6	q{
	7	ALTER TABLE
	8	`branchtransfers`
	9	MODIFY COLUMN
	10	`cancellation_reason` enum(
	11	'Manual',
	12	'StockrotationAdvance',
	13	'StockrotationRepatriation',
	14	'ReturnToHome',
	15	'ReturnToHolding',
	16	'RotatingCollection',
	17	'Reserve',
	18	'LostReserve',
	19	'CancelReserve',
	20	'ItemLost',
	21	'WrongTransfer'
	22	)
	23	AFTER `comments`
	24	}
	25	);
	26
	27	NewVersion( $DBversion, 24434, "Add 'WrongTransfer' to branchtransfers.cancellation_reason enum");
	28	}