|
Lines 3089-3104
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
| 3089 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3089 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3090 |
|
3090 |
|
| 3091 |
-- |
3091 |
-- |
| 3092 |
-- Table structure for table `aqorderusers` |
3092 |
-- Table structure for table `aqorder_users` |
| 3093 |
-- |
3093 |
-- |
| 3094 |
|
3094 |
|
| 3095 |
DROP TABLE IF EXISTS `aqorderusers`; |
3095 |
DROP TABLE IF EXISTS `aqorder_users`; |
| 3096 |
CREATE TABLE aqorderusers ( |
3096 |
CREATE TABLE aqorder_users ( |
| 3097 |
ordernumber int(11) NOT NULL, |
3097 |
ordernumber int(11) NOT NULL, |
| 3098 |
borrowernumber int(11) NOT NULL, |
3098 |
borrowernumber int(11) NOT NULL, |
| 3099 |
PRIMARY KEY (ordernumber, borrowernumber), |
3099 |
PRIMARY KEY (ordernumber, borrowernumber), |
| 3100 |
CONSTRAINT aqorderusers_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 aqorderusers_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 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3102 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3103 |
|
3103 |
|
| 3104 |
-- |
3104 |
-- |