Lines 739-745
CREATE TABLE `aqorders` (
Link Here
|
739 |
`cancellationreason` mediumtext DEFAULT NULL COMMENT 'reason of cancellation', |
739 |
`cancellationreason` mediumtext DEFAULT NULL COMMENT 'reason of cancellation', |
740 |
`order_internalnote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for staff', |
740 |
`order_internalnote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for staff', |
741 |
`order_vendornote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for vendor', |
741 |
`order_vendornote` longtext DEFAULT NULL COMMENT 'notes related to this order line, made for vendor', |
742 |
`purchaseordernumber` longtext DEFAULT NULL COMMENT 'not used? always NULL', |
|
|
743 |
`basketno` int(11) DEFAULT NULL COMMENT 'links this order line to a specific basket (aqbasket.basketno)', |
742 |
`basketno` int(11) DEFAULT NULL COMMENT 'links this order line to a specific basket (aqbasket.basketno)', |
744 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this order line was last modified', |
743 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the date and time this order line was last modified', |
745 |
`rrp` decimal(13,2) DEFAULT NULL COMMENT 'the retail cost for this line item', |
744 |
`rrp` decimal(13,2) DEFAULT NULL COMMENT 'the retail cost for this line item', |
746 |
- |
|
|