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

(-)a/installer/data/mysql/atomicupdate/bug_28294.pl (+30 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
                    'Recall',
22
                    'RecallCancellation',
23
                    'WrongTransfer'
24
                )
25
            AFTER `comments`
26
          }
27
    );
28
29
    NewVersion( $DBversion, 28294, "Add 'WrongTransfer' to branchtransfers.reason enum");
30
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1692-1698 CREATE TABLE `branchtransfers` ( Link Here
1692
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1692
  `datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled',
1693
  `tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1693
  `tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1694
  `comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer',
1694
  `comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer',
1695
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer',
1695
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','WrongTransfer') DEFAULT NULL COMMENT 'what triggered the transfer',
1696
  `cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation',
1696
  `cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation',
1697
  PRIMARY KEY (`branchtransfer_id`),
1697
  PRIMARY KEY (`branchtransfer_id`),
1698
  KEY `frombranch` (`frombranch`),
1698
  KEY `frombranch` (`frombranch`),
1699
- 

Return to bug 28294