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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 3098-3104 CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti Link Here
3098
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched
3098
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched
3099
  PRIMARY KEY  (`itemnumber`),
3099
  PRIMARY KEY  (`itemnumber`),
3100
  KEY `ordernumber` (`ordernumber`),
3100
  KEY `ordernumber` (`ordernumber`),
3101
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE
3101
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3102
  CONSTRAINT `aqorders_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
3102
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3103
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3103
3104
3104
3105
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 9573-9578 if ( CheckVersion($DBversion) ) { Link Here
9573
    SetVersion($DBversion);
9573
    SetVersion($DBversion);
9574
}
9574
}
9575
9575
9576
$DBversion = '3.17.00.XXX';
9577
if ( CheckVersion($DBversion) ) {
9578
    $dbh->do(q|
9579
        DELETE aqorders_items.*
9580
        FROM aqorders_items
9581
        LEFT JOIN items ON items.itemnumber=aqorders_items.itemnumber
9582
        WHERE items.itemnumber IS NULL
9583
    |);
9584
    $dbh->do(q|
9585
        ALTER TABLE aqorders_items ADD FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
9586
    |);
9587
    print "Upgrade to $DBversion done (Bug 12555 - Add a foreign key on aqorders_items.itemnumber)\n";
9588
    SetVersion($DBversion);
9589
}
9590
9576
=head1 FUNCTIONS
9591
=head1 FUNCTIONS
9577
9592
9578
=head2 TableExists($table)
9593
=head2 TableExists($table)
9579
- 

Return to bug 12555