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