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

(-)a/installer/data/mysql/db_revs/211200018.pl (-2 / +8 lines)
Lines 88-97 Notes: <<recalls.recallnotes>>', 'print') Link Here
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', '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
        }
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 1557-1564 CREATE TABLE `branchtransfers` ( Link Here
1557
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1557
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1558
  `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1558
  `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1559
  `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1559
  `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1560
  `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',
1560
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
1561
  `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',
1561
  `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',
1562
  PRIMARY KEY (`branchtransfer_id`),
1562
  PRIMARY KEY (`branchtransfer_id`),
1563
  KEY `frombranch` (`frombranch`),
1563
  KEY `frombranch` (`frombranch`),
1564
  KEY `tobranch` (`tobranch`),
1564
  KEY `tobranch` (`tobranch`),
1565
- 

Return to bug 30600