Adding index key in Grails' Domain

Question

I tried following this reference and this is now my domain's code:

class SnbrActVector {

    long nid
    String term
    double weight

    static mapping = {
        version false
        nid index:'Nid_Idx'
    }

    static constraints = {
        term(blank:false)
    }
}

What I want is to do is to add an index key for 'nid' column. I dropped the existing table and run the app again so the table is then recreated. However, when i check for list of indices, I can't see a 'Nid_Idx', only available is 'PRIMARY'. Do I have to manually create the index and name it 'Nid_idx in my mysql database?

Thanks.

Answer 1

You might need to add the column name to get it to fire e.g.

static mapping = {
        version false
        nid column:'nid', index:'Nid_Idx'
    }

Answer 2

Your syntax is correct so it might be another problem or a Grails bug. My advice :

1. Create a new grails application (grails create-app) with SnbrActVector as the only domain (grails create-domain...). Copy your code inside.
2. Check that your DataSource.groovy file has dbCreate = "create-drop"
3. Verify the indices of the SnbrActVector table.

If you see an index created for nid column, then it means that the problemn is in your application (you might not have used "create-drop" or something else)

If the index is NOT created => This is a grails bug and you should open a JIRA issue here