hbm2ddl=update with mysql5 & innodb: should update foreign key definition ------------------------------------------------------------------------- Key: HHH-2263 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2263 Project: Hibernate3 Type: Improvement Versions: 3.2.0.cr4 Environment: Hibernate 3.2.0.cr4 mysql-standard-5.0.27 InnoDB Reporter: Andres Gonzalez If i have this: <set name="actividadesSector" inverse="true" cascade="all"> <key column="id_sector"/> <one-to-many class="ActividadSector"/> </set> , execute hbm2ddl and then i change the mapping to: <set name="actividadesSector" inverse="true" cascade="all"> <key column="id_sector" on-delete="cascade"/> <one-to-many class="ActividadSector"/> </set> and execute again with hbm2ddl=auto it does nothing and it should: ALTER TABLE ActividadSector DROP FOREIGN KEY FKBC9......; ALTER TABLE ActividadSector ADD CONSTRAINT FKBC9D49E394F112A0 FOREIGN KEY (`id_sector`) REFERENCES Sector (id) ON DELETE CASCADE; (i did it manually, it works) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira