We want to create unique indexes on some Microsoft SQL Server tables, indexes formed by two table fields (not part of the table key), we can create them but they are not marked as UNIQUE, we have to mark them UNIQUE manually or by an sql script. Is there to create them with the UNIQUE flag activated?

We have tested setting unique=”true” on both fields but with no success. Any suggestion?

Thanks in advance.


<class name="ToolbarProperty" table="TOOLBAR_PROPERTY">

<id name="id" column="ID">
<generator class="identity"/>
</id>

<property name="value" column="VALUE" not-null="true"/>

<many-to-one name="toolbar" column="TOOLBAR_ID" class="Toolbar" index=”index1”/>
<many-to-one name="toolbarTypeProperty" column="TOOLBAR_TYPE_PROPERTY_ID" class="ToolbarTypeProperty" index=”index1”/>

</class>