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

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 439-450 CREATE TABLE `branchrelations` ( -- this table links libraries/branches to group Link Here
439
439
440
DROP TABLE IF EXISTS `branchtransfers`;
440
DROP TABLE IF EXISTS `branchtransfers`;
441
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
441
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
442
  `branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key
442
  `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
443
  `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
443
  `datesent` datetime default NULL, -- the date the transfer was initialized
444
  `datesent` datetime default NULL, -- the date the transfer was initialized
444
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
445
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
445
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
446
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
446
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
447
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
447
  `comments` mediumtext, -- any comments related to the transfer
448
  `comments` mediumtext, -- any comments related to the transfer
449
  PRIMARY KEY (`branchtransfer_id`),
448
  KEY `frombranch` (`frombranch`),
450
  KEY `frombranch` (`frombranch`),
449
  KEY `tobranch` (`tobranch`),
451
  KEY `tobranch` (`tobranch`),
450
  KEY `itemnumber` (`itemnumber`),
452
  KEY `itemnumber` (`itemnumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 9875-9880 if ( CheckVersion($DBversion) ) { Link Here
9875
    SetVersion($DBversion);
9875
    SetVersion($DBversion);
9876
}
9876
}
9877
9877
9878
$DBversion = "3.19.00.XXX";
9879
if ( CheckVersion($DBversion) ) {
9880
    $dbh->do("ALTER TABLE branchtransfers ADD COLUMN branchtransfer_id int(12) NOT NULL auto_increment FIRST, ADD CONSTRAINT PRIMARY KEY (branchtransfer_id);");
9881
    print "Upgrade to $DBversion done (Bug 13743 - Primary key for issues-table)\n";
9882
    SetVersion ($DBversion);
9883
}
9884
9878
$DBversion = "3.19.00.014";
9885
$DBversion = "3.19.00.014";
9879
if ( CheckVersion($DBversion) ) {
9886
if ( CheckVersion($DBversion) ) {
9880
    $dbh->do(q|
9887
    $dbh->do(q|
9881
- 

Return to bug 14187