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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 3093-3101 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3093
--
3093
--
3094
3094
3095
DROP TABLE IF EXISTS `aqorder_users`;
3095
DROP TABLE IF EXISTS `aqorder_users`;
3096
CREATE TABLE aqorder_users (
3096
CREATE TABLE aqorder_users ( -- Mapping orders to patrons for notification sending
3097
    ordernumber int(11) NOT NULL,
3097
    ordernumber int(11) NOT NULL, -- the order this patrons receive notifications from (aqorders.ordernumber)
3098
    borrowernumber int(11) NOT NULL,
3098
    borrowernumber int(11) NOT NULL, -- the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber)
3099
    PRIMARY KEY (ordernumber, borrowernumber),
3099
    PRIMARY KEY (ordernumber, borrowernumber),
3100
    CONSTRAINT aqorder_users_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3100
    CONSTRAINT aqorder_users_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3101
    CONSTRAINT aqorder_users_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3101
    CONSTRAINT aqorder_users_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3102
- 

Return to bug 12648