Lines 3074-3080
CREATE TABLE `aqorders_items` ( -- information on items entered in the acquisiti
Link Here
|
3074 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
3074 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order item was last touched |
3075 |
PRIMARY KEY (`itemnumber`), |
3075 |
PRIMARY KEY (`itemnumber`), |
3076 |
KEY `ordernumber` (`ordernumber`), |
3076 |
KEY `ordernumber` (`ordernumber`), |
3077 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE |
3077 |
CONSTRAINT aqorders_items_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
3078 |
CONSTRAINT `aqorders_items_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
3078 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3079 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3079 |
|
3080 |
|
3080 |
|
3081 |
|