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_);