installer/data/mysql/db_revs/220600003.pl

   1 use Modern::Perl;
   2
   3 return {
   4     bug_number  => 30924,
   5     description => "Add missing RecallCancellation option to branchtransfers.reason ENUM",
   6     up => sub {
   7         my ($args) = @_;
   8         my ($dbh) = @$args{qw(dbh)};
   9
  10         # Add RecallCancellation ENUM option to branchtransfers.reason
  11         $dbh->do(q{
  12             ALTER TABLE branchtransfers MODIFY COLUMN reason
  13             ENUM('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer'
  14         });
  15     },
  16 };