目前，我正在使用grails和MySQL。我这样创建用户的域类:

class User { 
        String userName 
        String password 
        String fullName 
        String toString(){ 
            "${fullName}" 
        } 
    static constraints = { 
        fullName(); 
        userName(unique:true); 
        password(password:true); 
    } 
} 

id           bigint(20) 
version      bigint(20) 
full_name    varchar(255) 
password     varchar(255) 
user_name    varchar(255) 

user_id      int(20) 
full_name    varchar(255) 
password     varchar(255) 
user_name    varchar(255)  

请您参考如下方法:

要创建自己的表，可以使用映射。Example

class User { 
    String fname 
    String postCode 
 
    static mapping = { 
        table 'userTable'  //your custom table name if you want 
        version false   //turnoff grails version 
        id column:'UserId' 
        firstName column: 'First_Name'   //first name column will be like this 
        postCode type: 'text'  //default Grails varchar() but can make to text 
 
        //or for id you can use composit key of your chioce for id or even a generator 
 
       id composite: ['firstName', 'lastName'] 
    } 
}