MySQL Schema generation

[ivan vercinsky <iv...@pixelpark.com>]

Hello,
I have problem with schema generation with mysql on linux machine.

On W2k, the ant init generates the right sql queries for the database,
But when running the same ant init on linux machine, the generated SQL
queries seem to be broken
Like this one: (check the , next to the UNIQUE (TABLE_NAME))

CREATE TABLE ID_TABLE
(
    ID_TABLE_ID INTEGER NOT NULL AUTO_INCREMENT,
    TABLE_NAME VARCHAR (255) NOT NULL,
    NEXT_ID INTEGER,
    QUANTITY INTEGER,
    PRIMARY KEY(ID_TABLE_ID),
    UNIQUE (TABLE_NAME),
);


Do you have any idea, where is the problem?

Thanx...
	
	
			bym


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: MySQL Schema generation

[Zsombor Gegesy <de...@mailbox.hu>]

Hello ivan,

Monday, September 09, 2002, 2:20:20 PM, you wrote:

iv> Hello,
iv> I have problem with schema generation with mysql on linux machine.

iv> On W2k, the ant init generates the right sql queries for the database,
iv> But when running the same ant init on linux machine, the generated SQL
iv> queries seem to be broken
iv> Like this one: (check the , next to the UNIQUE (TABLE_NAME))
iv> CREATE TABLE ID_TABLE
iv> (
iv>     ID_TABLE_ID INTEGER NOT NULL AUTO_INCREMENT,
iv>     TABLE_NAME VARCHAR (255) NOT NULL,
iv>     NEXT_ID INTEGER,
iv>     QUANTITY INTEGER,
iv>     PRIMARY KEY(ID_TABLE_ID),
iv>     UNIQUE (TABLE_NAME),
iv> );
iv> Do you have any idea, where is the problem?

iv> Thanx...


I run into the same situation, the workaround is here:

http://archives.apache.org/eyebrowse/ReadMsg?listName=turbine-torque-dev@jakarta.apache.org&msgId=435477



Best regards,
 Zsombor                            mailto:deepspace@mailbox.hu



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>