I think your are looking for something like this:
Code:
<class name="eg.TTest" table="TTest">
<id name="id" column="id" type="long">
<generator class="native"></generator>
</id>
<properties name="group" unique="true">
<property name="one"/>
<property name="two"/>
<property name="three"/>
</properties>
</class>
which creates:
Code:
create table TTest (
id numeric(19,0) identity not null,
one varchar(255) null,
two varchar(255) null,
three varchar(255) null,
primary key (id),
unique (one, two, three)
)
Urs