Hello super joomlers!
A new Joomla! core juicy trick just for you.
Did you know that you can use multiple sql files for the install process of your custom component?
They are red sequentially following the order in the xml manifest file of your component
Here is an example. Pay close attention to the install part.