Maintaining the position of columns in Grails/GORM
Posted
by firnnauriel
on Stack Overflow
See other posts from Stack Overflow
or by firnnauriel
Published on 2010-04-06T07:37:25Z
Indexed on
2010/04/06
7:43 UTC
Read the original article
Hit count: 228
Is there a way to fix the position of the columns in a domain? I have this domain:
class SnbrActVector {
int nid
String term
double weight
static mapping = {
version false
id(generator: 'assigned')
}
static constraints = {
nid(blank:false)
term(blank:false)
weight(blank:false)
}
}
This is the schema of the table generated:
CREATE TABLE `fractor_grailsDEV`.`snbr_act_vector` (
`id` bigint(20) NOT NULL,
`weight` double NOT NULL,
`term` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`nid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
It seems that the order of the columns were reversed. Is there a way to make it like this? (order is nid, term, weight)
CREATE TABLE `fractor_grailsDEV`.`snbr_act_vector` (
`id` bigint(20) NOT NULL,
`nid` int(11) NOT NULL,
`term` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`weight` double NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
© Stack Overflow or respective owner