jBPM creates two indices for each foreign key column on MySQL ------------------------------------------------------------- Key: JBPM-2143 URL: https://jira.jboss.org/jira/browse/JBPM-2143 Project: JBoss jBPM Issue Type: Bug Security Level: Public (Everyone can see) Components: Core Engine Affects Versions: jBPM 3.2.5.SP5 Reporter: Jiri Pechanec The SQL scripts for MySQL contains two independent index creations for each indexed foreign key column - see sample create index IDX_LOG_SOURCENODE on JBPM_LOG (SOURCENODE_); alter table JBPM_LOG add index FK_LOG_SOURCENODE (SOURCENODE_), add constraint FK_LOG_SOURCENODE foreign key (SOURCENODE_) references JBPM_NODE (ID_); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira