title: Multiple indexes in Solr
body: <p>I want to index two tables from MySQL using Apache Solr. Please see my data-config and schema files below.</p>
  
  <pre><code>&lt;dataConfig&gt; 
   &lt;dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test" user="root" password="root" batchSize="1" /&gt;  
   &lt;document name="tb_location"&gt;   
    &lt;entity name="tb_location" query="SELECT * FROM tb_location"&gt;    
     &lt;field column="loc_code" name="id"/&gt;    
     &lt;field column="loc_code" name="loc_code"/&gt;    
     &lt;field column="loc_name" name="loc_name"/&gt; 
     &lt;field column="loc_name" name="loc_name_ci"/&gt; 
     &lt;field column="ADM1_FULL_NAME" name="state"/&gt;         
    &lt;/entity&gt;  
   &lt;/document&gt;
   &lt;document name="person"&gt;   
    &lt;entity name="person" query="SELECT * FROM person"&gt;    
     &lt;field column="id" name="personid"/&gt;    
     &lt;field column="fname" name="fname"/&gt;    
     &lt;field column="lname" name="lname"/&gt; 
     &lt;field column="town" name="town"/&gt;       
    &lt;/entity&gt;  
   &lt;/document&gt;
  &lt;/dataConfig&gt;
  </code></pre>
  
  <p>Schema.xml</p>
  
  <pre><code> &lt;field name="id" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt; -
      &lt;field name="loc_code" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="loc_name" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="loc_name_ci" type="string_ci" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="state" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
  
      &lt;field name="personid" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="fname" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="lname" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
      &lt;field name="town" type="string" indexed="true" stored="true" required="true" multiValued="false" /&gt;
  </code></pre>
  
  <p>Also i created unique id for each tables (id and personid). But when i execute the dataimport module, nothing is fetched or indexed. Can someone help me to figure out where exactly the problem ?</p>