Example Joomla! component with separated install SQL files running in order presented in this manifest file

modularsqlexample.xml

<?xml version="1.0" encoding="utf-8"?>
<extension type="component" version="3.9" method="upgrade" client="administrator">
    <name>com_modularsqlexample</name>
    <author>example</author>
    <creationDate>0000-00-00</creationDate>
    <copyright>(C) example. All rights reserved.</copyright>
    <license>http://www.gnu.org/copyleft/gpl.html</license>
    <authorEmail>modularsql@example.com</authorEmail>
    <authorUrl>example.com</authorUrl>
    <version>1.0.0</version>
    <description>Example Joomla! component with separated install SQL files running in order presented in this manifest file</description>

    <install>
        <sql>
            <file driver="mysql" charset="utf8">sql/install.sql</file>
            <file driver="mysql" charset="utf8">sql/data-step-1.sql</file>
            <file driver="mysql" charset="utf8">sql/data-step-2.sql</file>
            <file driver="mysql" charset="utf8">sql/data-step-3.sql</file>
            <file driver="mysql" charset="utf8">sql/data-final-step.sql</file>
        </sql>
    </install>

    <uninstall>
        <sql>
            <file driver="mysql" charset="utf8">sql/uninstall.sql</file>
        </sql>
    </uninstall>

    <update>
        <schemas>
            <schemapath type="mysql">sql/updates/mysql</schemapath>
        </schemas>
    </update>
    
    <administration>
        <menu>COM_MODULARSQLEXAMPLE</menu>

        <files folder="admin">
            <filename>index.html</filename>
            <filename>modularsqlexample.php</filename>
        </files>
    </administration>
</extension>