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

(-)a/installer/data/mysql/atomicupdate/bug18427.perl (+17 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    # In order to be overcomplete, we check if the situation is what we expect
5
    if( !index_exists( 'serialitems', 'PRIMARY' ) ) {
6
        if( index_exists( 'serialitems', 'serialitemsidx' ) ) {
7
            $dbh->do(q|
8
ALTER TABLE serialitems ADD PRIMARY KEY (itemnumber), DROP INDEX serialitemsidx;
9
            |);
10
        } else {
11
            $dbh->do(q|ALTER TABLE serialitems ADD PRIMARY KEY (itemnumber)|);
12
        }
13
    }
14
15
    SetVersion( $DBversion );
16
    print "Upgrade to $DBversion done (Bug 18427 - Add a primary key to serialitems)\n";
17
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2436-2442 DROP TABLE IF EXISTS `serialitems`; Link Here
2436
CREATE TABLE `serialitems` (
2436
CREATE TABLE `serialitems` (
2437
	`itemnumber` int(11) NOT NULL,
2437
	`itemnumber` int(11) NOT NULL,
2438
	`serialid` int(11) NOT NULL,
2438
	`serialid` int(11) NOT NULL,
2439
	UNIQUE KEY `serialitemsidx` (`itemnumber`),
2439
    PRIMARY KEY (`itemnumber`),
2440
	KEY `serialitems_sfk_1` (`serialid`),
2440
	KEY `serialitems_sfk_1` (`serialid`),
2441
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2441
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2442
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2442
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2443
- 

Return to bug 18427