[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=all ]
Thomas Dudziak resolved DDLUTILS-32:
------------------------------------
Resolution: Fixed
I've added this facility, but slightly enhanced. You can also specify for which
tables to apply the parameter, and you can state all parameters that MySql
supports (there is no check of the validity of the parameter or its value):
<writeSchemaSqlToFile failonerror="false"
alterdatabase="false"
outputfile="test.sql">
<parameter name="ENGINE"
value="INNODB"
platforms="MySql"
tables="test1,test2,test"/>
<parameter name="ENGINE"
value="MEMORY"
platforms="MySql"
table="test3"/>
<parameter name="ROW_FORMAT"
value="COMPRESSED"
platforms="MySql"/>
</writeSchemaSqlToFile>
> I want to be able to specify the table type/engine when i create tables in
> mysql.
> ---------------------------------------------------------------------------------
>
> Key: DDLUTILS-32
> URL: http://issues.apache.org/jira/browse/DDLUTILS-32
> Project: DdlUtils
> Type: New Feature
> Reporter: Christoffer Hammarström
> Assignee: Thomas Dudziak
> Attachments: DDLUTILS-32.patch
>
> In MySQL, a table type or engine can be specified after the "create table"
> statement, like so:
> CREATE TABLE table
> (
> column INTEGER
> ) ENGINE=InnoDB
> "TYPE" is a synonym for "ENGINE".
> http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is
> the preferred term, but cannot be used before MySQL 4.0.18. TYPE is available
> beginning with MySQL 3.23.0, the first version of MySQL for which multiple
> storage engines were available."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
