One of the nice things about the Solar Framework is the ability to define table layout within the models.. Its not something you have to do but when you do Solar will auto create the table if it does not exist. [...] Auto create however has 2 issues.. 1. Pre populating data, 2. Table settings outside of Solar's realm (like temp tables). This however is really easy to solve by extending Solar.
His code sets up a custom model that loads in a SQL file and executes it into the database you've set up. Each line is split and looped through to ensure that those databases without multiple query support will still cooperate.