Attachment #134618 for bug #30600

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




                INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (27, 'manage_recalls', 'Manage recalls for patrons')
            });

            # Add Recall ENUM option to branchtransfers.reason
            $dbh->do(q{
                ALTER TABLE branchtransfers MODIFY COLUMN reason
                ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'TransferCancellation', 'Recall')
            });

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

        }

Lines 1564-1571 CREATE TABLE `branchtransfers` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
1564	`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',	1564	`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1565	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',	1565	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1566	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',	1566	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1567	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','CancelRecall') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',	1567	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
1568	`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost', 'WrongTransfer','Recall','CancelRecall') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer cancellation',	1568	`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','CancelRecall') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer cancellation',
1569	PRIMARY KEY (`branchtransfer_id`),	1569	PRIMARY KEY (`branchtransfer_id`),
1570	KEY `frombranch` (`frombranch`),	1570	KEY `frombranch` (`frombranch`),
1571	KEY `tobranch` (`tobranch`),	1571	KEY `tobranch` (`tobranch`),
1572	-

Return to bug 30600

Lines 88-97 Notes: <<recalls.recallnotes>>', 'print') Link Here

(-)a/installer/data/mysql/db_revs/211200018.pl (-2 / +8 lines)
88	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (27, 'manage_recalls', 'Manage recalls for patrons')	88	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (27, 'manage_recalls', 'Manage recalls for patrons')
89	});	89	});
90		90
91	# Add Recall and CancelReserve ENUM options to branchtransfers.reason	91	# Add Recall ENUM option to branchtransfers.reason
92	$dbh->do(q{	92	$dbh->do(q{
93	ALTER TABLE branchtransfers MODIFY COLUMN reason	93	ALTER TABLE branchtransfers MODIFY COLUMN reason
94	ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'Recall', 'CancelRecall')	94	ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'TransferCancellation', 'Recall')
		95	});
		96
		97	# Add CancelRecall ENUM option to branchtransfers.cancellation_reason
		98	$dbh->do(q{
		99	ALTER TABLE branchtransfers MODIFY COLUMN cancellation_reason
		100	ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost', 'WrongTransfer', 'CancelRecall')
95	});	101	});
96		102
97	}	103	}