Re: InnoDB tables for MySQL

2009-02-16 Thread jfmxl
I noticed that the models' database definitions created using MySQL > > always create MyISAM tables, but to use functional constraints on > > foreign keys one must use InnoDB tables in MySQL. > > > Is there someway to change the table type created from MyISAM to > > MyIn

Re: InnoDB tables for MySQL

2009-02-15 Thread Alex Gaynor
tables, but to use functional constraints on > foreign keys one must use InnoDB tables in MySQL. > > Is there someway to change the table type created from MyISAM to > MyInnoDB with MySQL? > > > By adding: DATABASE_OPTIONS = { "init_command": "SET stora

InnoDB tables for MySQL

2009-02-15 Thread jfmxl
Hi, I read through the tutorials and thank you very much! They are well designed and very helpful. I noticed that the models' database definitions created using MySQL always create MyISAM tables, but to use functional constraints on foreign keys one must use InnoDB tables in MySQL