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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1148-1153 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1148
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1148
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1149
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1149
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1150
  PRIMARY KEY (`issue_id`),
1150
  PRIMARY KEY (`issue_id`),
1151
  UNIQUE KEY `itemnumber` (`itemnumber`),
1151
  KEY `issuesborridx` (`borrowernumber`),
1152
  KEY `issuesborridx` (`borrowernumber`),
1152
  KEY `itemnumber_idx` (`itemnumber`),
1153
  KEY `itemnumber_idx` (`itemnumber`),
1153
  KEY `branchcode_idx` (`branchcode`),
1154
  KEY `branchcode_idx` (`branchcode`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 11237-11242 if ( CheckVersion($DBversion) ) { Link Here
11237
    SetVersion($DBversion);
11237
    SetVersion($DBversion);
11238
}
11238
}
11239
11239
11240
$DBversion = 'XXX';
11241
if ( CheckVersion($DBversion) ) {
11242
    my $create_table_issues = @{ $dbh->selectall_arrayref(q|SHOW CREATE TABLE issues|) }[0]->[1];
11243
    if ($create_table_issues !~ m|UNIQUE KEY.*itemnumber| ) {
11244
        $dbh->do(q|ALTER TABLE issues ADD CONSTRAINT UNIQUE KEY (itemnumber)|);
11245
    }
11246
    print "Update to $DBversion done (Bug 14978: Make sure issues.itemnumber is a unique key)\n";
11247
    SetVersion($DBversion);
11248
}
11249
11240
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11250
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11241
# SEE bug 13068
11251
# SEE bug 13068
11242
# if there is anything in the atomicupdate, read and execute it.
11252
# if there is anything in the atomicupdate, read and execute it.
11243
- 

Return to bug 14978