Lines 3202-3207
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3202 |
KEY `budget_id` (`budget_id`), |
3202 |
KEY `budget_id` (`budget_id`), |
3203 |
KEY `parent_ordernumber` (`parent_ordernumber`), |
3203 |
KEY `parent_ordernumber` (`parent_ordernumber`), |
3204 |
KEY `orderstatus` (`orderstatus`), |
3204 |
KEY `orderstatus` (`orderstatus`), |
|
|
3205 |
CONSTRAINT aqorders_created_by FOREIGN KEY (created_by) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE, |
3205 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3206 |
CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
3206 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
3207 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
3207 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
3208 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |