[jbpm-issues] [JBoss JIRA] Resolved: (JBPM-2143) jBPM creates two indices for each foreign key column on MySQL

jBPM creates two indices for each foreign key column on MySQL ------------------------------------------------------------- Key: JBPM-2143 URL: https://jira.jboss.org/jira/browse/JBPM-2143 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Components: Runtime Engine Affects Versions: jBPM 3.2.5.SP5 Reporter: Jiri Pechanec Assignee: Alejandro Guizar Fix For: jBPM 3.2.9 Attachments: mylyn-context.zip Original Estimate: 0 minutes Remaining Estimate: 0 minutes 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_);