You can create the database in MySQL using the DDL(foodmart schema.sql) provided in this project. Then get the derby edition of foodmart from the project like Pivot4J ...

for example {ine,nodcl}. They specify extra options on how things in created DDL should be. Currently supported options are: Drop statements are created with ddlx_drop() function. ddlx_drop(oid) ...