to little info in here to be able to help you. If it can't even create the table use these error codes to try and find a possible cause... We've never seen this before, so it is likely something outside jbpm
Is it connected with http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnMySQL?
This error type is described here http://forums.mysql.com/read.php?25,15717,25969.
The cause of this is Foreign key constraint is incorrectly formed. Maybe did the script which was in those article be a wrong? What the script and Mysql version did you use? I used 5.0.45. For which version of mysql does the provided script work stable?
I've used the script with MySQL 5.028 successfully.