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