Here is a copy of the pimdb structure in INNODB format with foreign key references.
I hope it saves someone all the time it took for me to make it.
I had to make a lot of assumptions based on table and column names so there may be some references that are incorrect, if so please let me know.
I also found that there were many rows in the free db that were missing references that needed to be fixed in order to conform to the structure.
Thank you.
pimdb structure using INNODB storage engine.