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

(-)a/installer/data/mysql/atomicupdate/bug_24287.perl (+18 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    unless ( column_exists('branchtransfers', 'trigger') ) {
5
        $dbh->do(
6
            qq{
7
                ALTER TABLE branchtransfers
8
                ADD
9
                  `trigger` enum('Manual')
10
                AFTER
11
                  comments
12
              }
13
        );
14
    }
15
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 24287 - Add 'trigger' field to transfers table)\n";
18
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 951-956 CREATE TABLE `branchtransfers` ( -- information for items that are in transit be Link Here
951
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
951
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
952
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
952
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
953
  `comments` LONGTEXT, -- any comments related to the transfer
953
  `comments` LONGTEXT, -- any comments related to the transfer
954
  `trigger` ENUM('Manual'), -- what triggered the transfer
954
  PRIMARY KEY (`branchtransfer_id`),
955
  PRIMARY KEY (`branchtransfer_id`),
955
  KEY `frombranch` (`frombranch`),
956
  KEY `frombranch` (`frombranch`),
956
  KEY `tobranch` (`tobranch`),
957
  KEY `tobranch` (`tobranch`),
957
- 

Return to bug 24287