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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1144-1149 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1144
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1144
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1145
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1145
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1146
  PRIMARY KEY (`issue_id`),
1146
  PRIMARY KEY (`issue_id`),
1147
  UNIQUE KEY `itemnumber` (`itemnumber`),
1147
  KEY `issuesborridx` (`borrowernumber`),
1148
  KEY `issuesborridx` (`borrowernumber`),
1148
  KEY `itemnumber_idx` (`itemnumber`),
1149
  KEY `itemnumber_idx` (`itemnumber`),
1149
  KEY `branchcode_idx` (`branchcode`),
1150
  KEY `branchcode_idx` (`branchcode`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 11054-11059 if ( CheckVersion($DBversion) ) { Link Here
11054
    SetVersion($DBversion);
11054
    SetVersion($DBversion);
11055
}
11055
}
11056
11056
11057
$DBversion = 'XXX';
11058
if ( CheckVersion($DBversion) ) {
11059
    my $create_table_issues = @{ $dbh->selectall_arrayref(q|SHOW CREATE TABLE issues|) }[0]->[1];
11060
    if ($create_table_issues !~ m|UNIQUE KEY.*itemnumber| ) {
11061
        $dbh->do(q|ALTER TABLE issues ADD CONSTRAINT UNIQUE KEY (itemnumber)|);
11062
    }
11063
    print "Update to $DBversion done (Bug 14978: Make sure issues.itemnumber is a unique key)\n";
11064
    SetVersion($DBversion);
11065
}
11066
11057
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11067
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11058
# SEE bug 13068
11068
# SEE bug 13068
11059
# if there is anything in the atomicupdate, read and execute it.
11069
# if there is anything in the atomicupdate, read and execute it.
11060
- 

Return to bug 14978