| 
      
            Lines 2602-2608
          CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
      
      
        Link Here
      
     | 
  
        
          | 2602 | 
            `gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged  | 
          2602 | 
            `gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged  | 
        
        
          | 2603 | 
            `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor  | 
          2603 | 
            `discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor  | 
        
        
          | 2604 | 
            `fax` varchar(50) default NULL, -- vendor fax number  | 
          2604 | 
            `fax` varchar(50) default NULL, -- vendor fax number  | 
        
          
            
              | 2605 | 
                `deliverytime` int(11) default NULL, -- vendor delivery time  | 
              2605 | 
                deliverytime int(11) default NULL, -- vendor delivery time  | 
            
        
          | 2606 | 
            PRIMARY KEY  (`id`),  | 
          2606 | 
            PRIMARY KEY  (`id`),  | 
        
        
          | 2607 | 
            KEY `listprice` (`listprice`),  | 
          2607 | 
            KEY `listprice` (`listprice`),  | 
        
        
          | 2608 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
          2608 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
        
            
              | 2609 | 
              -   | 
               | 
               |