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

(-)a/installer/data/mysql/atomicupdate/bug_26057.perl (+9 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 

            

            

              4
              
    if( !column_exists( 'branchtransfers', 'datecancelled' ) ) {

            

            

              5
              
        $dbh->do( "ALTER TABLE `branchtransfers` ADD COLUMN `datecancelled` datetime default NULL AFTER `datearrived`" );

            

            

              6
              
    }

            

            

              7
              

            

            

              8
              
    NewVersion( $DBversion, 26057, "Add datecancelled field to branchtransfers");

            

            

              9
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +1 lines)




  

    
      
            Lines 936-941
          CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
      
      
        Link Here
      
    
  

        

          936
          
  `datesent` datetime default NULL, -- the date the transfer was initialized

          936
          
  `datesent` datetime default NULL, -- the date the transfer was initialized

        

        

          937
          
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from

          937
          
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from

        

        

          938
          
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination

          938
          
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination

        

            

              
              
              939
              
  `datecancelled` datetime default NULL, -- the date the transfer was cancelled

            

        

          939
          
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to

          940
          
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to

        

        

          940
          
  `comments` LONGTEXT, -- any comments related to the transfer

          941
          
  `comments` LONGTEXT, -- any comments related to the transfer

        

        

          941
          
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve'), -- what triggered the transfer

          942
          
  `reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve'), -- what triggered the transfer

        

            

              942
              
- 

              
              
            






  

  Return to bug 26057