title: need sphinx configuration for the non integer primary key
body: <p>i want to create <code>sphinx</code> search for following table structure: </p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `books` (
    `productID` varchar(20) NOT NULL,
    `productName` varchar(256) NOT NULL,
    `ISBN` varchar(20) NOT NULL,
    `author` varchar(256) DEFAULT NULL,
    `productPrice` float(10,2) NOT NULL,
    `discount` float(10,2) NOT NULL,
    `brandID` int(11) NOT NULL,
    `qty` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL,
    PRIMARY KEY (`productID`),
    KEY `status` (`status`),
    KEY `ISBN` (`ISBN`),
    KEY `author` (`author`),
    KEY `brandID` (`brandID`),
    KEY `books_index` (`productName`)
  ) ENGINE=innodb DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>I can't alter the <code>productID</code> column in above table..</p>
  
  <p>i have dependency tables for <code>author</code> and <code>Brands</code></p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `authors` (
        `authorID` ini(11) NOT NULL,
        `author_name` varchar(256) NOT NULL
        PRIMARY KEY (`authorID`)
      ) ENGINE=innodb DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE IF NOT EXISTS `brands` (
        `brandID` ini(11) NOT NULL,
        `brandName` varchar(256) NOT NULL
        PRIMARY KEY (`brandID`)
      ) ENGINE=innodb DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>please some one provide configuration for <code>sphinx</code> search.</p>
  
  <p>i am using following config.</p>
  
  <pre><code>source src1
  {
          type                    = mysql
  
  
          sql_query               = SELECT CRC32(productID) as productid,productID,productName,ISBN,brandID,author FROM sapna_ecom_products
  
          sql_attr_uint           = productID
          sql_field_string        = ISBN
          sql_field_string        = productName
          sql_field_string        = brandID
          sql_attr_multi         = uint brandID from field; SELECT brandID,brandName FROM sapna_ecom_brands
          sql_attr_multi         = uint author from field; SELECT authorID,author_name FROM sapna_ecom_authors
  
          sql_query_info          = SELECT productID,productName,ISBN,brandID,author  FROM sapna_ecom_products  WHERE CRC32(productID)=$id
  }
  </code></pre>
  
  <p>I am getting results if i search by <code>productName</code> but not for <code>author</code> and <code>brand</code></p>
  
  <p>My aim is to get the results if user search any by <code>productName</code> or <code>author</code> or <code>brand</code></p>
  
  <p>Please somebody provide me suitable configuration..</p>
  
  <p>thanks..</p>