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 2441-2447 DROP TABLE IF EXISTS `serialitems`; Link Here
2441
CREATE TABLE `serialitems` (
2441
CREATE TABLE `serialitems` (
2442
	`itemnumber` int(11) NOT NULL,
2442
	`itemnumber` int(11) NOT NULL,
2443
	`serialid` int(11) NOT NULL,
2443
	`serialid` int(11) NOT NULL,
2444
	UNIQUE KEY `serialitemsidx` (`itemnumber`),
2444
    PRIMARY KEY (`itemnumber`),
2445
	KEY `serialitems_sfk_1` (`serialid`),
2445
	KEY `serialitems_sfk_1` (`serialid`),
2446
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2446
	CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE,
2447
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2447
	CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
2448
- 

Return to bug 18427