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