<?xml version="1.0"?>
<glom_document xmlns="http://glom.org/glom_document" format_version="5" translation_original_locale="en_US" database_title="My Dessert">
  <connection hosting_mode="postgres_self" server="localhost" try_other_ports="false" database="glom_mydessert" port="5433"/>
  <table name="dessert" title="Dessert">
    <fields>
      <field name="dessert_id" primary_key="true" auto_increment="true" type="Number" title="dessert ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="description" type="Text" title="Description">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
      </field>
      <field name="comments" type="Text" title="Comments">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
      </field>
      <field name="dessert_nm" type="Text" title="Dessert Name">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
      </field>
    </fields>
    <relationships/>
    <data_layouts>
      <data_layout name="list" parent_table="dessert">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="dessert_id" editable="true" use_default_formatting="true" column_width="93">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_nm" editable="true" use_default_formatting="true" column_width="122">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="description" editable="true" use_default_formatting="true" column_width="313">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="comments" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
      <data_layout name="details" parent_table="dessert">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="dessert_id" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_nm" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="description" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="comments" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
    </data_layouts>
    <reports/>
    <print_layouts/>
  </table>
  <table name="dessert_flavor" title="Dessert-Flavor Join">
    <fields>
      <field name="dessert_flavor_id" primary_key="true" auto_increment="true" type="Number" title="dessert_flavor ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="dessert_id" type="Number" title="Dessert ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="flavor_id" type="Number" title="Flavor ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
    </fields>
    <relationships>
      <relationship name="dessert_name_rel" key="dessert_id" other_table="dessert" other_key="dessert_id" title="Dessert Name Rel"/>
      <relationship name="flavor_name_rel" key="flavor_id" other_table="flavor" other_key="flavor_id" title="Flavor Name Rel"/>
    </relationships>
    <data_layouts>
      <data_layout name="list" parent_table="dessert_flavor">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="dessert_flavor_id" editable="true" use_default_formatting="true" column_width="133">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_id" editable="true" column_width="86">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="dessert_name_rel" choices_related_field="dessert_id" choices_related_second="dessert_nm"/>
            </data_layout_item>
            <data_layout_item name="dessert_nm" relationship="dessert_name_rel" use_default_formatting="true" column_width="116">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="flavor_id" editable="true" column_width="73">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="flavor_name_rel" choices_related_field="flavor_id" choices_related_second="flavor_nm"/>
            </data_layout_item>
            <data_layout_item name="flavor_nm" relationship="flavor_name_rel" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
      <data_layout name="details" parent_table="dessert_flavor">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_text title="*** Better to edit from List tab ***">
              <text/>
              <formatting font="Sans Bold 16"/>
            </data_layout_text>
            <data_layout_item name="dessert_flavor_id" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_id" editable="true">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="dessert_name_rel" choices_related_field="dessert_id" choices_related_second="dessert_nm"/>
            </data_layout_item>
            <data_layout_item name="dessert_nm" relationship="dessert_name_rel" use_default_formatting="true">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="flavor_id" editable="true">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="flavor_name_rel" choices_related_field="flavor_id" choices_related_second="flavor_nm"/>
            </data_layout_item>
            <data_layout_item name="flavor_nm" relationship="flavor_name_rel" use_default_formatting="true">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
    </data_layouts>
    <reports/>
    <print_layouts/>
  </table>
  <table name="flavor" title="Flavor">
    <fields>
      <field name="flavor_id" primary_key="true" auto_increment="true" type="Number" title="flavor ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="comments" type="Text" title="Comments">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
      </field>
      <field name="flavor_nm" type="Text" title="Flavor Name">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
      </field>
    </fields>
    <relationships/>
    <data_layouts>
      <data_layout name="list" parent_table="flavor">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="flavor_id" editable="true" use_default_formatting="true" column_width="70">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="flavor_nm" editable="true" use_default_formatting="true" column_width="145">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="comments" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
      <data_layout name="details" parent_table="flavor">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="flavor_id" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="flavor_nm" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="comments" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
    </data_layouts>
    <reports/>
    <print_layouts/>
  </table>
  <table name="my_dessert" title="My Dessert">
    <fields>
      <field name="my_dessert_id" primary_key="true" auto_increment="true" type="Number" title="my_dessert ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="comments" type="Text" title="Comments">
        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
      </field>
      <field name="dessert_dt" type="Date" title="Desert Date">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="dessert_id" type="Number" title="Dessert ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
      <field name="flavor_id" type="Number" title="Flavor ID">
        <formatting format_thousands_separator="true" format_decimal_places="2"/>
      </field>
    </fields>
    <relationships>
      <relationship name="my_dessert_name_rel" key="dessert_id" other_table="dessert" other_key="dessert_id" title="My Dessert Name Rel"/>
      <relationship name="flavor_choices" key="dessert_id" other_table="dessert_flavor" other_key="dessert_id" title="Flavor Choices"/>
      <relationship name="my_flavor_name_rel" key="flavor_id" other_table="flavor" other_key="flavor_id" title="My Flavor Name Rel"/>
    </relationships>
    <data_layouts>
      <data_layout name="list" parent_table="my_dessert">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="my_dessert_id" editable="true" use_default_formatting="true" column_width="117">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_dt" editable="true" use_default_formatting="true" column_width="99">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_id" editable="true" use_default_formatting="true" column_width="86">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_nm" relationship="my_dessert_name_rel" use_default_formatting="true" column_width="103">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="flavor_id" editable="true" use_default_formatting="true" column_width="73">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="flavor_nm" relationship="my_flavor_name_rel" use_default_formatting="true" column_width="103">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
            <data_layout_item name="comments" use_default_formatting="true">
              <title_custom/>
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
      <data_layout name="details" parent_table="my_dessert">
        <data_layout_groups>
          <data_layout_group name="main">
            <data_layout_item name="my_dessert_id" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_item name="dessert_dt" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2"/>
            </data_layout_item>
            <data_layout_group name="dessert" columns_count="2">
              <data_layout_item name="dessert_id" editable="true">
                <title_custom/>
                <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="my_dessert_name_rel" choices_related_field="dessert_id" choices_related_second="dessert_nm"/>
              </data_layout_item>
              <data_layout_item name="dessert_nm" relationship="my_dessert_name_rel" use_default_formatting="true">
                <title_custom/>
                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
              </data_layout_item>
            </data_layout_group>
            <data_layout_group name="flavor" columns_count="2">
              <data_layout_item name="flavor_id" editable="true">
                <title_custom/>
                <formatting format_thousands_separator="true" format_decimal_places="2" choices_restricted="true" choices_related="true" choices_related_relationship="flavor_choices" choices_related_field="flavor_id"/>
              </data_layout_item>
              <data_layout_item name="flavor_nm" relationship="my_flavor_name_rel" use_default_formatting="true">
                <title_custom/>
                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
              </data_layout_item>
            </data_layout_group>
            <data_layout_item name="comments" editable="true" use_default_formatting="true">
              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
            </data_layout_item>
          </data_layout_group>
        </data_layout_groups>
      </data_layout>
    </data_layouts>
    <reports/>
    <print_layouts/>
  </table>
  <groups><!--These are only used when recreating a database from an example file. The actual access-control is on the server, of course.-->
    <group name="glom_developer">
      <table_privs table_name="dessert" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
      <table_privs table_name="dessert_flavor" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
      <table_privs table_name="flavor" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
      <table_privs table_name="glom_system_preferences" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
      <table_privs table_name="my_dessert" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
    </group>
  </groups>
  <library_modules/></glom_document>
