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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 3074-3080 CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti Link Here
3074
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched
3074
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched
3075
  PRIMARY KEY  (`itemnumber`),
3075
  PRIMARY KEY  (`itemnumber`),
3076
  KEY `ordernumber` (`ordernumber`),
3076
  KEY `ordernumber` (`ordernumber`),
3077
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE
3077
  CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3078
  CONSTRAINT `aqorders_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
3078
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3079
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3079
3080
3080
3081
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 8974-8979 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
8974
    SetVersion($DBversion);
8974
    SetVersion($DBversion);
8975
}
8975
}
8976
8976
8977
$DBversion = '3.17.00.XXX';
8978
if ( CheckVersion($DBversion) ) {
8979
    $dbh->do(q|
8980
        DELETE aqorders_items.*
8981
        FROM aqorders_items
8982
        LEFT JOIN items ON items.itemnumber=aqorders_items.itemnumber
8983
        WHERE items.itemnumber IS NULL
8984
    |);
8985
    $dbh->do(q|
8986
        ALTER TABLE aqorders_items ADD FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE
8987
    |);
8988
    print "Upgrade to $DBversion done (Bug 12555 - Add a foreign key on aqorders_items.itemnumber)\n";
8989
    SetVersion($DBversion);
8990
}
8991
8977
=head1 FUNCTIONS
8992
=head1 FUNCTIONS
8978
8993
8979
=head2 TableExists($table)
8994
=head2 TableExists($table)
8980
- 

Return to bug 12555