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 |
- |
|
|