| 
      
            Lines 2904-2910
          CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
      
      
        Link Here
      
     | 
  
        
          | 2904 | 
            PRIMARY KEY  (`id`),  | 
          2904 | 
            PRIMARY KEY  (`id`),  | 
        
        
          | 2905 | 
            KEY `listprice` (`listprice`),  | 
          2905 | 
            KEY `listprice` (`listprice`),  | 
        
        
          | 2906 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
          2906 | 
            KEY `invoiceprice` (`invoiceprice`),  | 
        
          
            
              | 2907 | 
                KEY `name` (`name`(255)),  | 
              2907 | 
                KEY `name` (`name`),  | 
            
        
          | 2908 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
          2908 | 
            CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
        
        
          | 2909 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2909 | 
            CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2910 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
          2910 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  | 
        
            
              | 2911 | 
              -   | 
               | 
               |