<?xml version="1.0" encoding="UTF-8"?>
<database>
    <global>
        <table name="table_name" no-site-reference="1" engine="InnoDB">
            <field type="varchar(255)">groups</field>
            <field type="varchar(255)">var</field>
            <field type="varchar(20)">datatype</field>
            <field type="varchar(200)">datadefine</field>
            <field type="text">de</field>
            <field type="text">de_edit</field>
            <field type="text">en</field>
            <field type="text">en_edit</field>

            <!-- NULL explicitly allowed -->
            <field type="TEXT" null="1">changes</field>

            <primary>field1,field2</primary>
            <index>groups</index>


            <comment>This is a table comment</comment>
        </table>
    </global>

    <projects>
        <!--
              automatic site connect,
              site id is automatically added and at an update the attributes automaticly updated / inserted
        -->
        <table name="project_extra_table_name">
            <field type="text">emotion_image</field>
            <field type="int(12)">release_until</field>
            <field type="bigint(20)">emotion_folder</field>

            <comment>This is a table comment</comment>
        </table>

        <!--
              data table only for certain sites
              specific the site types in site-types="" attribute ... you can use shell wild cards
        -->
        <table name="project_extra_table_name" site-types="quiqqer/*,my/plugin:types*">
            <field type="text">emotion_image</field>
            <field type="int(12)">release_until</field>
            <field type="bigint(20)">emotion_folder</field>
        </table>


        <!-- no automatic site relationship, update, insert -->
        <table name="project_extra_table_name" no-auto-update="1" no-site-reference="1">
            <field type="text">emotion_image</field>
            <field type="int(12)">release_until</field>
            <field type="bigint(20)">emotion_folder</field>
        </table>

    </projects>
</database>
