Possible incorrect unique.vm in mysql

[Peter Frühberger]

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]