Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Message-ID: <2089401231.1130324095391.JavaMail.jira@ajax.apache.org>
Date: Wed, 26 Oct 2005 12:54:55 +0200 (CEST)
From: "Thomas Dudziak (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Commented: (DDLUTILS-32) I want to be able to specify the
 table type/engine when i create tables in mysql.
In-Reply-To: <1805378890.1129207204797.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

    [ http://issues.apache.org/jira/browse/DDLUTILS-32?page=3Dcomments#acti=
on_12355950 ]=20

Thomas Dudziak commented on DDLUTILS-32:
----------------------------------------

Sorry, I was out-of-country for a couple of days.
I think I'll add this in the next days as it is useful for other things as =
well (eg. switching between unicode and ascii columns for Oracle databases)=
.

> I want to be able to specify the table type/engine when i create tables i=
n mysql.
> -------------------------------------------------------------------------=
--------
>
>          Key: DDLUTILS-32
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-32
>      Project: DdlUtils
>         Type: New Feature
>     Reporter: Christoffer Hammarstr=C3=B6m
>     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=3DInnoDB
> "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 avai=
lable beginning with MySQL 3.23.0, the first version of MySQL for which mul=
tiple storage engines were available."

--=20
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