I tried the following with sybase, and it works :-))
Code:
<class name="eg.Customer" table="tCustomer">
<id name="id" column="id" type="long">
<generator class="native"></generator>
</id>
<property name="email" index="idx_group idx_email" />
<property name="password" index="idx_group"/>
</class>
which creates the following schema commands:
Code:
create table tCustomer (
id numeric(19,0) identity not null,
email varchar(255) null,
password varchar(255) null,
primary key (id)
)
create index idx_email on tCustomer (email)
create index idx_group on tCustomer (email, password)
Urs
Login
FAQ
Search
