When generating the database, the database drops & recreates fine, but the inserts for sample data are written in the wrong order so that some inserts are done before requisite rows are inserted thus violating foreign key contraints. How do I generate sample data where the inserts are done in the correct order… OR … generate the database by dropping/creating tables, doing the inserts, then the alter table statements? (MySQL 5.0.5+, VP-UMP v9.0 build 20120418, Mac OSX).
Would it be possible that you can provide your project to us for testing? You can send it to firstname.lastname@example.org. Thanks!