Thx for your reply,
Yes it is totally correct for mysql to create unique index without
special naming. mysql just uses the Name auf die Index-column as the
unique index name.
But, if you do want to specify your own index naming, it is not
possible. The name attribut from <unique name="..."> is ignored totally.
In my opinion, torque should treat this like the following:
if ("unique name" is specified) {
unique $uniq.name ('column')
}
else {
unique ('column')
}
Thx
Peter
Am Donnerstag, den 13.03.2008, 14:36 +0100 schrieb Thomas Fischer:
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
