db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Fr├╝hberger <Peter.Fruehber...@hte-company.de>
Subject Possible incorrect unique.vm in mysql
Date Thu, 13 Mar 2008 10:46:08 GMT
I am using version 3.3-RC3 of the torque maven plugin.


The following snippet of code:
<unique name="NAME_IDX">
<unique-column name="NAME"/>	
</unique>

generates the following mysql code:

Create ...
	...
    UNIQUE (NAME)
);

The unique index name (NAME_IDX) is missing, it should correctly be:

Create ...
	UNIQUE NAME_IDX (NAME);
);


changing the unique.vm in sql/base/mysql/unique.vm from
#foreach ($unique in $table.Unices) 
UNIQUE($unique.ColumnList), 
#end

to
#foreach ($unique in $table.Unices) 
UNIQUE $unique.Name ($unique.ColumnList), 
#end


fixes this problem for me.

Thx
Peter Fr├╝hberger
(sorry for sending through an exchange server ;-))




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message