title: Adding index key in Grails' Domain
body: <p>I tried following this <a href="http://www.grails.org/doc/1.0.x/guide/5.%20Object%20Relational%20Mapping%20%28GORM%29.html" rel="nofollow noreferrer">reference</a> and this is now my domain's code:</p>
  
  <pre><code>class SnbrActVector {
  
      long nid
      String term
      double weight
  
      static mapping = {
          version false
          nid index:'Nid_Idx'
      }
  
      static constraints = {
          term(blank:false)
      }
  }
  </code></pre>
  
  <p>What I want is to do is to add an index key for the <code>nid</code> column. I dropped the existing table and ran the app again so the table is then recreated. However, when I check for list of indices, I can't see an <code>Nid_Idx</code>, only <code>PRIMARY</code>. Do I have to manually create the index and name it <code>Nid_idx</code> in my mysql database?</p>