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 9585-9590 if ( CheckVersion($DBversion) ) { Link Here
9585
    SetVersion ($DBversion);
9585
    SetVersion ($DBversion);
9586
}
9586
}
9587
9587
9588
$DBversion = '3.17.00.XXX';
9589
if ( CheckVersion($DBversion) ) {
9590
    $dbh->do(q|
9591
        DELETE aqorders_items.*
9592
        FROM aqorders_items
9593
        LEFT JOIN items ON items.itemnumber=aqorders_items.itemnumber
9594
        WHERE items.itemnumber IS NULL
9595
    |);
9596
    $dbh->do(q|
9597
        ALTER TABLE aqorders_items ADD FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
9598
    |);
9599
    print "Upgrade to $DBversion done (Bug 12555 - Add a foreign key on aqorders_items.itemnumber)\n";
9600
    SetVersion($DBversion);
9601
}
9602
9588
=head1 FUNCTIONS
9603
=head1 FUNCTIONS
9589
9604
9590
=head2 TableExists($table)
9605
=head2 TableExists($table)
9591
- 

Return to bug 12555