##(remark) drop table if exists `#(tableName)`; CREATE TABLE `#(tableName)` ( #for(x : fieldList) #set( field=x.field ,field=field.substring(0, 1).toLowerCase() + field.substring(1) ,isMust = x.isMust? "not null" : "" ,autoIncrement = "id".equals(field)? "auto_increment" : "" ) #if(field != "id") `#(field)` #(x.fieldType) #(isMust) #(autoIncrement) comment '#(x.remark)', #end #end PRIMARY KEY (`#(fieldList[0].field)`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '#(remark)';