[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12358632 ] Christoffer Hammarström commented on DDLUTILS-32: - Great, thanks! 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
[jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12331984 ] Christoffer Hammarström commented on DDLUTILS-32: - To clarify, this patch allows the following syntax: writeschemasqltofile outputfile=ddl.sql parameter name=ENGINE value=InnoDB/ /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
