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