As far as I know, you CAN define and index name, but you need not. For
example, I have thested the following works with mysql 5.0
CREATE TABLE `test` (`test` VARCHAR( 10 ) NOT NULL , UNIQUE (test))
So in my eyes, the SQL generated by Torque is perfectly valid. Or did I
miss something ?
Thomas
Peter Frühberger <[EMAIL PROTECTED]> schrieb am 13.03.2008
11:46:08:
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
