installer/data/mysql/db_revs/220600058.pl

   1 use Modern::Perl;
   2
   3 return {
   4     bug_number => "30944",
   5     description => "Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation",
   6     up => sub {
   7         my ($args) = @_;
   8         my ($dbh, $out) = @$args{qw(dbh out)};
   9
  10         $dbh->do(q{
  11             ALTER TABLE branchtransfers MODIFY COLUMN cancellation_reason ENUM('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer cancellation'
  12         });
  13     },
  14 };