<query-mapping>
    <description>
      Get the list of users (compact form).
    </description>
    <class name="Gen.Database.Model.Database_Info">
        <comment>information about the database</comment>
        <property type='String' name="name">
            <comment>the database name.</comment>
        </property>
    </class>

    <query name='database-list'>
       <comment>Get the list of databases</comment>
       <sql>show databases</sql>
    </query>

    <query name='table-list'>
       <comment>Get the list of tables in the given database.</comment>
       <sql driver='mysql'>show tables from :name</sql>
    </query>

    <query name='create-database'>
       <comment>Create the database</comment>
       <sql driver='mysql'>create database :name</sql>
    </query>

    <query name='create-user-no-password'>
       <comment>Create the user grant</comment>
       <sql driver='mysql'>grant select, insert, update, delete,
     create, drop, create temporary tables, execute,
     show view on `:name`.* to :user@'localhost'
       </sql>
    </query>

    <query name='create-user-with-password'>
       <comment>Create the user grant</comment>
       <sql driver='mysql'>grant select, insert, update, delete,
     create, create temporary tables, execute,
     show view on `:name`.* to :user@'localhost' identified by :password
       </sql>
    </query>

    <query name='flush-privileges'>
       <comment>Flush the grant privileges</comment>
       <sql driver='mysql'>flush privileges</sql>
    </query>
   
</query-mapping>

<query-mapping package="Gen.Database.Model">
    <description>
      Get the list of users (compact form).
    </description>

    <query name='database-list'>
       <comment>Get the list of databases</comment>
       <sql>show databases</sql>
    </query>

    <query name='table-list'>
       <comment>Get the list of tables in the given database.</comment>
       <sql driver='mysql'>show tables from :name</sql>
    </query>

    <query name='create-database'>
       <comment>Create the database</comment>
       <sql driver='mysql'>create database :name</sql>
    </query>

    <query name='create-user-no-password'>
       <comment>Create the user grant</comment>
       <sql driver='mysql'>grant select, insert, update, delete,
     create, drop, create temporary tables, execute,
     show view on `:name`.* to :user@'localhost'
       </sql>
    </query>

    <query name='create-user-with-password'>
       <comment>Create the user grant</comment>
       <sql driver='mysql'>grant select, insert, update, delete,
     create, create temporary tables, execute,
     show view on `:name`.* to :user@'localhost' identified by :password
       </sql>
    </query>

    <query name='flush-privileges'>
       <comment>Flush the grant privileges</comment>
       <sql driver='mysql'>flush privileges</sql>
    </query>
   
</query-mapping>

Remove the Gen.Database.Model.Database_Info mapping because we don't use it
Remove the Gen.Database.Model.Database_Info mapping because we don't use it
