|
Lines 3049-3055
CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti
Link Here
|
| 3049 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
3049 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
| 3050 |
PRIMARY KEY (`itemnumber`), |
3050 |
PRIMARY KEY (`itemnumber`), |
| 3051 |
KEY `ordernumber` (`ordernumber`), |
3051 |
KEY `ordernumber` (`ordernumber`), |
| 3052 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3052 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
3053 |
CONSTRAINT `aqorders_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3053 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3054 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 3054 |
|
3055 |
|
| 3055 |
|
3056 |
|