Lines 3098-3104
CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti
Link Here
|
3098 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
3098 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
3099 |
PRIMARY KEY (`itemnumber`), |
3099 |
PRIMARY KEY (`itemnumber`), |
3100 |
KEY `ordernumber` (`ordernumber`), |
3100 |
KEY `ordernumber` (`ordernumber`), |
3101 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3101 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
3102 |
CONSTRAINT `aqorders_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
3102 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3103 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3103 |
|
3104 |
|
3104 |
|
3105 |
|