| Lines 3055-3061
          CREATE TABLE `aqorders` ( -- information related to the basket line items
      
      
        Link Here | 
        
          | 3055 |   `cancellationreason` text default NULL, -- reason of cancellation | 3055 |   `cancellationreason` text default NULL, -- reason of cancellation | 
        
          | 3056 |   `order_internalnote` mediumtext, -- notes related to this order line, made for staff | 3056 |   `order_internalnote` mediumtext, -- notes related to this order line, made for staff | 
        
          | 3057 |   `order_vendornote` mediumtext, -- notes related to this order line, made for vendor | 3057 |   `order_vendornote` mediumtext, -- notes related to this order line, made for vendor | 
            
              | 3058 |   `supplierreference` mediumtext, -- not used? always NULL |  |  | 
        
          | 3059 |   `purchaseordernumber` mediumtext, -- not used? always NULL | 3058 |   `purchaseordernumber` mediumtext, -- not used? always NULL | 
        
          | 3060 |   `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) | 3059 |   `basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) | 
        
          | 3061 |   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified | 3060 |   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |