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

(-)a/installer/data/mysql/atomicupdate/bug_24436.perl (+27 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    # Add reserve reasons enum
5
    $dbh->do(
6
        qq{
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
                )
21
            AFTER `comments`
22
          }
23
    );
24
25
    SetVersion( $DBversion );
26
    print "Upgrade to $DBversion done (Bug 24299 - Add 'reserve' reasons to branchtransfers enum)\n";
27
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 906-912 CREATE TABLE `branchtransfers` ( -- information for items that are in transit be Link Here
906
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
906
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
907
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
908
  `comments` LONGTEXT, -- any comments related to the transfer
908
  `comments` LONGTEXT, -- any comments related to the transfer
909
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection'), -- what triggered the transfer
909
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve'), -- what triggered the transfer
910
  PRIMARY KEY (`branchtransfer_id`),
910
  PRIMARY KEY (`branchtransfer_id`),
911
  KEY `frombranch` (`frombranch`),
911
  KEY `frombranch` (`frombranch`),
912
  KEY `tobranch` (`tobranch`),
912
  KEY `tobranch` (`tobranch`),
913
- 

Return to bug 24436