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

(-)a/installer/data/mysql/atomicupdate/bug_12362.perl (+26 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # Add reserve reasons enum
4
    $dbh->do(
5
        qq{
6
            ALTER TABLE
7
                `branchtransfers`
8
            MODIFY COLUMN
9
                `reason` enum(
10
                    'Manual',
11
                    'StockrotationAdvance',
12
                    'StockrotationRepatriation',
13
                    'ReturnToHome',
14
                    'ReturnToHolding',
15
                    'RotatingCollection',
16
                    'Reserve',
17
                    'LostReserve',
18
                    'CancelReserve',
19
                    'TransferCancellation'
20
                )
21
            AFTER `comments`
22
          }
23
    );
24
25
    NewVersion( $DBversion, 12362, "Add 'TransferCancellion' reason to branchtransfers enum");
26
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1530-1536 CREATE TABLE `branchtransfers` ( Link Here
1530
  `datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',
1530
  `datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',
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') 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') 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
- 

Return to bug 12362