The default mysql engine provides a hint at least as to where you messed up with your schema definition if it doesn't load, however as of 1.0.4 the idbmysql cli only gives.
mysql> CREATE TABLE `song` (
-> `id` bigint unsigned NOT NULL
-> ) ENGINE=InfiniDB DEFAULT CHARSET=utf8;
ERROR 138 (HY000): The syntax or the data type(s) is not supported by InfiniDB. Please check the InfiniDB syntax guide for supported syntax or data types.
So you have to work the schema line by line which is painful at the very least. Is it correct to say the infinidb engine doesn't support the unsigned version of bigint (if so i didn't see it in the datatypes documentation)? This doesn't make sence to waste have the space for a large id when the data source that will populate the DW is monotonic and starting at 0.