[DDLUTILS-32] I want to be able to specify the table type/engine when i create tables in mysql.

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0 RC1
• Component/s: Core - MySql
• Assignee: Thomas Dudziak
• Reporter: Christoffer Hammarström
• Created: 13/Oct/05 21:39
• Updated: 04/Jun/07 02:33
• Resolved: 27/Nov/05 03:36

Description

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."