Adding additional options while creating tables

[sequelize]

Adding additional options while creating tables

[sdepold]

Hmm could u please add a comment to the relevant lines ^_^ I can't find them :> One major issue with the original version of sequelize was the crappy code structure. What do you think about the current code(-structure) ?

[pvsundarram]

Hi,
I like the new interface, better than what it was before. And it was fairly easy for me to get around the code.
AFAIK the table options such as collation, default character set, engine etc, only come in the end and are all separated by whitespace in a 'create table statement'.

https://github.com/pinetechlabs/sequelize/blob/rewrite/lib/sequelize/query-generator.js#L11
https://github.com/pinetechlabs/sequelize/blob/rewrite/lib/sequelize/query-generator.js#L22-25
https://github.com/pinetechlabs/sequelize/blob/rewrite/lib/sequelize/model-definition.js#L54

Additional table creation options could be separately passed inside options:
{
tableOptions : {
ENGINE : 'innodb',
'DEFAULT CHARACTER SET' : 'big5'
}
}

[sdepold]

i build this on my own. you can now define the engine for all models via:

sequelize = new Sequelize(db, user, pw, {define: { engine: 'InnoDB' }})

or via:

Person = sequelize.define('Person', { name: Sequelize.STRING }, { engine: 'InnoDB' })