Lines 2784-2793
CREATE TABLE `aqorders` (
Link Here
|
2784 |
-- |
2784 |
-- |
2785 |
|
2785 |
|
2786 |
DROP TABLE IF EXISTS `aqorders_items`; |
2786 |
DROP TABLE IF EXISTS `aqorders_items`; |
2787 |
CREATE TABLE `aqorders_items` ( |
2787 |
CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisitions process |
2788 |
`ordernumber` int(11) NOT NULL, |
2788 |
`ordernumber` int(11) NOT NULL, -- the order this item is attached to (aqorders.ordernumber) |
2789 |
`itemnumber` int(11) NOT NULL, |
2789 |
`itemnumber` int(11) NOT NULL, -- the item number for this item (items.itemnumber) |
2790 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2790 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
2791 |
PRIMARY KEY (`itemnumber`), |
2791 |
PRIMARY KEY (`itemnumber`), |
2792 |
KEY `ordernumber` (`ordernumber`) |
2792 |
KEY `ordernumber` (`ordernumber`) |
2793 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2793 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2794 |
- |
|
|