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

(-)a/installer/data/mysql/atomicupdate/bug_28294.perl (+28 lines)
Line 0 Link Here
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
                `reason` enum(
11
                    'Manual',
12
                    'StockrotationAdvance',
13
                    'StockrotationRepatriation',
14
                    'ReturnToHome',
15
                    'ReturnToHolding',
16
                    'RotatingCollection',
17
                    'Reserve',
18
                    'LostReserve',
19
                    'CancelReserve',
20
                    'TransferCancellation',
21
                    'WrongTransfer'
22
                )
23
            AFTER `comments`
24
          }
25
    );
26
27
    NewVersion( $DBversion, 28294, "Add 'WrongTransfer' to branchtransfers.reason enum");
28
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1554-1560 CREATE TABLE `branchtransfers` ( Link Here
1554
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1554
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1555
  `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1555
  `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1556
  `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1556
  `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1557
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
1557
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','WrongTransfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
1558
  `cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer cancellation',
1558
  `cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer cancellation',
1559
  PRIMARY KEY (`branchtransfer_id`),
1559
  PRIMARY KEY (`branchtransfer_id`),
1560
  KEY `frombranch` (`frombranch`),
1560
  KEY `frombranch` (`frombranch`),
1561
- 

Return to bug 28294