db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Cooper <dcoo...@fvt.com>
Subject Re: InnoDB tables in MySQL
Date Tue, 09 Nov 2004 04:47:57 GMT
Stefan Clos wrote:

>torque-gen generates Myisam tables in MySQL.
>Can i edit the src/sql/*-schema.sql file manually do add 
>"type=InnoDB" ? 
>Is there a way to to generate automatically InnoDB tables from a torque
>schema?
>
>Thanks,
>
>Stefan
>
>  
>
Hi Stefan:

I modified it by editing:

/templates/sql/base/mysql/db.props

Modify the default table type near the end of the file:

# See mysql docs for valid table type names.
# For example, if you wanted to use the transactional type InnoDB,
# then specify "tableType = InnoDB"
tableType = InnoDB

Regards,

Dan



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message