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

(-)a/installer/data/mysql/atomicupdate/bug_23092.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', 'daterequested') ) {
5
        $dbh->do(
6
            qq{
7
                ALTER TABLE branchtransfers
8
                ADD
9
                  `daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP
10
                AFTER
11
                  `itemnumber`
12
              }
13
        );
14
    }
15
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 23092 - Add 'daterequested' field to transfers table)\n";
18
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 901-906 DROP TABLE IF EXISTS `branchtransfers`; Link Here
901
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
901
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
902
  `branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key
902
  `branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key
903
  `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
903
  `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
904
  `daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date the transfer was requested
904
  `datesent` datetime default NULL, -- the date the transfer was initialized
905
  `datesent` datetime default NULL, -- the date the transfer was initialized
905
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
906
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
906
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907
- 

Return to bug 23092