Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: "Joe Porcheddu" <jporcheddu@tek-tools.com>
To: ddlutils-user@db.apache.org
Subject: Does DdlUtils support MySQL MyISAM?
Date: Fri, 11 Apr 2008 13:31:00 -0500
Message-ID: <000901c89c02$31150d30$800101df@tektools.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcibJltKVhwDAeoRQS20vttBUEZFNAA28Egw

Hello,

I have an existing table created in MySQL 4.1. The create table syntax is as
follows:

CREATE TABLE sometable
(
     deviceId INTEGER DEFAULT 0 NOT NULL,
     plexId INTEGER NOT NULL AUTO_INCREMENT,
     volumeId INTEGER,
     PRIMARY KEY (deviceId, plexId)
) ENGINE=MyISAM;

When I export this table using DdlUtils, then try to import the schema to a
new database, I get the following error:

[ddlToDatabase] SQL Command CREATE TABLE sometable
[ddlToDatabase] (
[ddlToDatabase]     deviceId INTEGER DEFAULT 0 NOT NULL,
[ddlToDatabase]     plexId INTEGER NOT NULL AUTO_INCREMENT,
[ddlToDatabase]     volumeId INTEGER,
[ddlToDatabase]     PRIMARY KEY (deviceId, plexId)
[ddlToDatabase] ) failed with: Incorrect table definition; there can be only
one auto column and it must be defined as a key

The create table syntax is failing because DdlUtils fails to append the
"ENGINE=MyISAM" to the end of the CREAT TABLE statement. Is there a way to
configure DdlUtils to do this?


Thanks,
Joe