Lines 2604-2610
CREATE TABLE `aqorders` (
Link Here
|
2604 |
`listprice` decimal(28,6) default NULL, |
2604 |
`listprice` decimal(28,6) default NULL, |
2605 |
`totalamount` decimal(28,6) default NULL, |
2605 |
`totalamount` decimal(28,6) default NULL, |
2606 |
`datereceived` date default NULL, |
2606 |
`datereceived` date default NULL, |
2607 |
`booksellerinvoicenumber` mediumtext, |
2607 |
`invoiceid` int(11) default NULL, |
2608 |
`freight` decimal(28,6) default NULL, |
2608 |
`freight` decimal(28,6) default NULL, |
2609 |
`unitprice` decimal(28,6) default NULL, |
2609 |
`unitprice` decimal(28,6) default NULL, |
2610 |
`quantityreceived` smallint(6) NOT NULL default 0, |
2610 |
`quantityreceived` smallint(6) NOT NULL default 0, |
Lines 2634-2640
CREATE TABLE `aqorders` (
Link Here
|
2634 |
KEY `biblionumber` (`biblionumber`), |
2634 |
KEY `biblionumber` (`biblionumber`), |
2635 |
KEY `budget_id` (`budget_id`), |
2635 |
KEY `budget_id` (`budget_id`), |
2636 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
2636 |
CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, |
2637 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE |
2637 |
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
2638 |
CONSTRAINT `aqorders_ibfk_3` FOREIGN KEY (`invoiceid`) REFERENCES `invoices` (`invoiceid`) ON DELETE SET NULL ON UPDATE CASCADE |
2638 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2639 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2639 |
|
2640 |
|
2640 |
|
2641 |
|
Lines 2651-2656
CREATE TABLE `aqorders_items` (
Link Here
|
2651 |
KEY `ordernumber` (`ordernumber`) |
2652 |
KEY `ordernumber` (`ordernumber`) |
2652 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2653 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2653 |
|
2654 |
|
|
|
2655 |
|
2656 |
-- |
2657 |
-- Table structure for table `invoices` |
2658 |
-- |
2659 |
|
2660 |
DROP TABLE IF EXISTS `invoices`; |
2661 |
CREATE TABLE `invoices` ( |
2662 |
`invoiceid` int(11) NOT NULL AUTO_INCREMENT, |
2663 |
`invoicenumber` varchar(80) NOT NULL, |
2664 |
`booksellerid` int(11) NOT NULL, |
2665 |
`shipmentdate` date default NULL, |
2666 |
`billingdate` date default NULL, |
2667 |
`closedate` date default NULL, |
2668 |
`shipmentcost` decimal(28,6) default NULL, |
2669 |
`shipmentcost_budgetid` int(11) default NULL, |
2670 |
PRIMARY KEY (`invoiceid`), |
2671 |
CONSTRAINT `invoices_fk_aqbooksellerid` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
2672 |
CONSTRAINT `invoices_fk_shipmentcost_budgetid` FOREIGN KEY (`shipmentcost_budgetid`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE SET NULL ON UPDATE CASCADE |
2673 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2674 |
|
2675 |
|
2654 |
-- |
2676 |
-- |
2655 |
-- Table structure for table `fieldmapping` |
2677 |
-- Table structure for table `fieldmapping` |
2656 |
-- |
2678 |
-- |