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