I have a problem with mappings, created SQL is incorrect.
idea is to get schema from MSSQL to MySQL

Hibernate version:
1.0.2
Mapping documents:

Carrier:

<bag name="CostEquationList" table="Cost_Equation" cascade="all" fetch="join" inverse="true" lazy="false">
<key column="Carrier_Id" />
<one-to-many class="My.Data.CostEquation, My.Data" />
</bag>

CostEquation:

<many-to-one name="CarrierId" column="Carrier_ID" class="My.Data.Carrier, My.Data" />

Now, in SQL schema, I get invalid DDL for CostEquation because Carrier_ID exists there twice. What can I do?

Spell both columns the same way, i.e. either _ID or _Id.

Make the case of "Carrier_Id" to be same?

Gert

Thank You, this really helped :) spell, spell, spell ...