<?xml version="1.0"?>
<glom_document database_title="Openismus Film Manager" is_example="true" translation_original_locale="en_US" format_version="3">
<connection server="localhost" user="" database="glom_film_production_manager1" self_hosted="true" port="5435" try_other_ports="false" hosting_mode="postgres_self"/>
<table name="accommodation" title="Accommodation">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Unterkunft"/>
<trans loc="en_GB" val="Accommodation"/>
</trans_set>
<fields>
<field name="accommodation_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Accommodation ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Unterkunft ID"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentare"/>
</trans_set>
</field>
<field name="address_street" type="Text" title="Street">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Strasse"/>
</trans_set>
</field>
<field name="address_town" type="Text" title="Town">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Ort"/>
</trans_set>
</field>
<field name="address_county" type="Text" title="County">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Bundesland/Kanton"/>
</trans_set>
</field>
<field name="address_country" type="Text" title="Country">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Land"/>
</trans_set>
</field>
<field name="address_postcode" type="Text" title="Postcode">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Postleitzahl"/>
</trans_set>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
<field name="name" type="Text" title="Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
</fields>
<relationships>
<relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
<trans_set>
<trans loc="de_DE" val="Kontakte"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="accommodation">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2">
<data_layout_item name="accommodation_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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_group name="details" columns_count="2">
<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_group name="address" title="Address">
<trans_set>
<trans loc="de_DE" val="Addresse"/>
<trans loc="en_GB" val="Address"/>
</trans_set>
<data_layout_item name="address_town" 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="address_street" 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="address_county" 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="address_country" 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="address_postcode" 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_group name="contact" title="Contact">
<trans_set>
<trans loc="de_DE" val="Kontakt"/>
<trans loc="en_GB" val="Contact"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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_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_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="accommodation">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="accommodation_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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="address_town" 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="address_country" 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="cars" title="Cars">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Autos"/>
<trans loc="en_GB" val="Cars"/>
</trans_set>
<fields>
<field name="car_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Car ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Auto ID"/>
</trans_set>
</field>
<field name="manufacturer" type="Text" title="Manufacturer">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Hersteller"/>
</trans_set>
</field>
<field name="model" type="Text" title="Model">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Model"/>
</trans_set>
</field>
<field name="registration" type="Text" title="Registration">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kennzeichnung"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="comment" type="Text" title="Comment">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
</fields>
<relationships/>
<data_layouts>
<data_layout name="details" parent_table="cars">
<data_layout_groups>
<data_layout_group name="main"/>
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="car_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="registration" 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_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_item name="manufacturer" 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="model" 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="comment" 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="characters" title="Characters">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Besetzung"/>
<trans loc="en_GB" val="Cast"/>
</trans_set>
<fields>
<field name="character_id" primary_key="true" unique="true" type="Number" title="Cast ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Besetzung ID"/>
</trans_set>
</field>
<field name="character" type="Text" title="Character">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Charakter"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts_actor" choices_related_field="contact_id" choices_related_second="name_full"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
<field name="mainpart" default_value="FALSE" type="Boolean" title="Main Part">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Hauptrolle"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="contacts_actor" key="contact_id" other_table="contacts" other_key="contact_id" title="Actor">
<trans_set>
<trans loc="de_DE" val="Schauspieler"/>
<trans loc="en_GB" val="Actor"/>
</trans_set>
</relationship>
<relationship name="scenes" key="character_id" other_table="scene_cast" other_key="cast_id" title="Scenes">
<trans_set>
<trans loc="en_GB" val="Scenes"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="cast">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_group name="actor" title="Actor">
<trans_set>
<trans loc="de_DE" val="Schauspieler"/>
<trans loc="en_GB" val="Actor"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" 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="address_street1" relationship="contacts_actor" 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="address_street2" relationship="contacts_actor" 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="address_town" relationship="contacts_actor" 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="address_country" relationship="contacts_actor" 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="address_postcode" relationship="contacts_actor" 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="picture" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="agent_id" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" 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_group name="agent">
<trans_set>
<trans loc="en_GB" val="Actor's Agent"/>
</trans_set>
<data_layout_item name="agent_id" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" 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="tel_work" relationship="contacts_actor" related_relationship="agent" 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_portal relationship="scenes">
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="description" relationship="scene" 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_portal>
<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_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="cast">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<title_custom use_custom="true" title="Actor's Contact ID">
<trans_set>
<trans loc="de_DE" val="Schauspieler Kontakt ID"/>
</trans_set>
</title_custom>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Actor's Name">
<trans_set>
<trans loc="de_DE" val="Schauspieler Name"/>
</trans_set>
</title_custom>
</data_layout_item>
<data_layout_item name="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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="characters">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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_group name="details" columns_count="2" title="Details">
<data_layout_item name="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_group name="actor" title="Actor">
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" 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_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_portal relationship="scenes">
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="overview_name" relationship="scene" 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="interior_or_exterior" relationship="scene" 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="day_or_night" relationship="scene" 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="minutes" relationship="scene" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_portal>
</data_layout_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="characters">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Actor"/>
</data_layout_item>
<data_layout_item name="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports>
<report name="cast_list" title="Cast List">
<data_layout_groups>
<data_layout_group>
<data_layout_item_header>
<data_layout_item name="org_name" relationship="system_properties" 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="org_logo" relationship="system_properties" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_item_header>
<data_layout_item_groupby border_width="0.05">
<sortby>
<data_layout_item name="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" editable="true" use_default_formatting="true" sort_ascending="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</data_layout_item>
</sortby>
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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="name_full" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Actor">
<trans_set>
<trans loc="de_DE" val="Schauspieler"/>
</trans_set>
</title_custom>
</data_layout_item>
<data_layout_item name="picture" relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item_verticalgroup>
<data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Agent"/>
</data_layout_item>
<data_layout_item name="tel_work" relationship="contacts_actor" related_relationship="agent" 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_verticalgroup>
</data_layout_item_groupby>
</data_layout_group>
</data_layout_groups>
<trans_set>
<trans loc="de_DE" val="Besetzungsliste"/>
<trans loc="en_GB" val="Cast List"/>
</trans_set>
</report>
</reports>
<print_layouts/>
</table>
<table name="companies" title="Companies">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Firmen"/>
<trans loc="en_GB" val="Companies"/>
</trans_set>
<fields>
<field name="company_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Company ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Firma ID"/>
</trans_set>
</field>
<field name="name" type="Text" title="Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="logo" type="Image" title="Logo">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="website" type="Text" title="Web Site">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Website"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="staff" key="company_id" other_table="contacts" other_key="company_id" auto_create="true" allow_edit="true" title="Staff">
<trans_set>
<trans loc="de_DE" val="Angestellte"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="companies">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="company_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<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="logo" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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_item name="website" 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_portal relationship="staff">
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_first" 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="name_last" 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="tel_work" 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="email" 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_portal>
</data_layout_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="companies">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="company_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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="contacts" default="true" title="Contacts">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Kontakte"/>
<trans loc="en_GB" val="Contacts"/>
</trans_set>
<fields>
<field name="contact_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
<field name="name_first" type="Text" title="First Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Vorname"/>
</trans_set>
</field>
<field name="name_middle" type="Text" title="Second Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Zweiter Name"/>
</trans_set>
</field>
<field name="name_last" type="Text" title="Last Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Familiename"/>
</trans_set>
</field>
<field name="name_title" type="Text" title="Title">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
<custom_choice_list>
<custom_choice value="Mr"/>
<custom_choice value="Ms"/>
<custom_choice value="Mrs"/>
<custom_choice value="Miss"/>
<custom_choice value="Dr"/>
<custom_choice value="Prof"/>
</custom_choice_list>
</formatting>
<trans_set>
<trans loc="de_DE" val="Titel"/>
</trans_set>
</field>
<field name="address_street2" type="Text" title="Street (line 2)">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Strasse (2)"/>
</trans_set>
</field>
<field name="address_town" type="Text" title="Town">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Ort"/>
</trans_set>
</field>
<field name="address_state" type="Text" title="State">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Bundesland/Kanton"/>
</trans_set>
</field>
<field name="address_country" type="Text" title="Country">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
<custom_choice_list>
<custom_choice value="Germany"/>
<custom_choice value="United Kingdom"/>
<custom_choice value="USA"/>
<custom_choice value="France"/>
<custom_choice value="Spain"/>
</custom_choice_list>
</formatting>
<trans_set>
<trans loc="de_DE" val="Land"/>
</trans_set>
</field>
<field name="address_postcode" type="Text" title="Postcode">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Postleitzahl"/>
</trans_set>
</field>
<field name="date_of_birth" type="Date" title="Date Of Birth">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Geburtsdatum"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentare"/>
</trans_set>
</field>
<field name="name_full" type="Text" title="Full Name">
<calculation>return record["name_first"] + " " + record["name_last"]</calculation>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Vollständiger Name"/>
</trans_set>
</field>
<field name="company_id" type="Number" title="Company ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="company" choices_related_field="company_id" choices_related_second="name"/>
<trans_set>
<trans loc="de_DE" val="Firma ID"/>
</trans_set>
</field>
<field name="picture" type="Image" title="Picture">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Bild"/>
</trans_set>
</field>
<field name="tel_home" type="Text" title="Home Telephone">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Telefon (Privat)"/>
</trans_set>
</field>
<field name="tel_mobile" type="Text" title="Mobile Telephone">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Telefon (Handy)"/>
</trans_set>
</field>
<field name="tel_fax" type="Text" title="Fax">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="tel_work" type="Text" title="Work Telephone">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Telefon (Buro)"/>
</trans_set>
</field>
<field name="email" type="Text" title="Email">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="E-Mail"/>
</trans_set>
</field>
<field name="address_street1" type="Text" title="Street (line 1)">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Strasse (1)"/>
</trans_set>
</field>
<field name="website" type="Text" title="Web Site">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Website"/>
</trans_set>
</field>
<field name="agent_id" type="Number" title="Agent ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="agent" choices_related_field="contact_id" choices_related_second="name_full"/>
</field>
<field name="stagename" type="Text" title="Stagename">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Künstlername"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="company" key="company_id" other_table="companies" other_key="company_id" auto_create="true" allow_edit="true" title="Company">
<trans_set>
<trans loc="de_DE" val="Firma"/>
</trans_set>
</relationship>
<relationship name="agent" key="agent_id" other_table="contacts" other_key="contact_id" title="Agent"/>
<relationship name="crew" key="contact_id" other_table="crew" other_key="contact_id" title="Crew"/>
<relationship name="cast" key="contact_id" other_table="characters" other_key="contact_id" title="Cast"/>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="contacts">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="header" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" 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_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_notebook name="notebook_contact">
<data_layout_group name="name" title="Name">
<trans_set>
<trans loc="de_DE" val="Name"/>
<trans loc="en_GB" val="Name"/>
</trans_set>
<data_layout_item name="name_title" 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="name_first" 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="name_middle" 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="name_last" 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_group name="company" title="Company">
<trans_set>
<trans loc="de_DE" val="Firma"/>
<trans loc="en_GB" val="Company"/>
</trans_set>
<data_layout_item name="company_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="company" 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_group name="address" title="Address">
<trans_set>
<trans loc="de_DE" val="Addresse"/>
<trans loc="en_GB" val="Address"/>
</trans_set>
<data_layout_item name="address_street1" 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="address_street2" 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="address_town" 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="address_state" 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="address_country" 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="address_postcode" 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_group name="telephone" title="Telephone">
<trans_set>
<trans loc="de_DE" val="Telefon"/>
<trans loc="en_GB" val="Telephone"/>
</trans_set>
<data_layout_item name="tel_work" 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="tel_mobile" 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="tel_home" 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="tel_fax" 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_group name="agent" title="Agent">
<trans_set>
<trans loc="de_DE" val="Agent"/>
<trans loc="en_GB" val="Agent"/>
</trans_set>
<data_layout_item name="agent_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="agent" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom/>
</data_layout_item>
</data_layout_group>
</data_layout_notebook>
<data_layout_notebook name="notebook_related">
<data_layout_group name="crew" title="Crew">
<trans_set>
<trans loc="de_DE" val="Crew"/>
<trans loc="en_GB" val="Crew"/>
</trans_set>
<data_layout_portal relationship="crew">
<data_layout_item name="crew_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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_portal>
</data_layout_group>
<data_layout_group name="cast" title="Cast">
<trans_set>
<trans loc="de_DE" val="Cast"/>
<trans loc="en_GB" val="Cast"/>
</trans_set>
<data_layout_portal relationship="cast">
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" 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="mainpart" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_portal>
</data_layout_group>
</data_layout_notebook>
<data_layout_item name="email" 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="website" 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="date_of_birth" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="picture" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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="true" format_text_multiline_height_lines="6"/>
</data_layout_item>
</data_layout_group>
</data_layout_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="contacts">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="contact_id" editable="true" use_default_formatting="true" column_width="100">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<title_custom/>
</data_layout_item>
<data_layout_item name="name_first" editable="true" use_default_formatting="true" column_width="100">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</data_layout_item>
<data_layout_item name="name_last" editable="true" use_default_formatting="true" column_width="100">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</data_layout_item>
<data_layout_item name="address_country" editable="true" use_default_formatting="true" column_width="100">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</data_layout_item>
<data_layout_item name="name" relationship="company" editable="true" use_default_formatting="true" column_width="100">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom title="Company Name">
<trans_set>
<trans loc="de_DE" val="Firma Name"/>
</trans_set>
</title_custom>
</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>
<report name="by_country" title="Contacts By Country">
<data_layout_groups>
<data_layout_group>
<data_layout_item_groupby>
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
<data_layout_item name="name_full" 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_groupby>
</data_layout_group>
</data_layout_groups>
</report>
<report name="by_country_by_town" title="By Country, By Town">
<data_layout_groups>
<data_layout_group>
<data_layout_item_groupby>
<data_layout_item_groupby>
<data_layout_item name="character_id" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
<data_layout_item name="name_full" 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="address_postcode" 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_groupby>
</data_layout_item_groupby>
</data_layout_group>
</data_layout_groups>
</report>
</reports>
<print_layouts/>
</table>
<table name="crew" title="Crew">
<example_rows/>
<trans_set>
<trans loc="en_GB" val="Crew"/>
</trans_set>
<fields>
<field name="crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Crew ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="dept_id" type="Number" title="Department ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departments" choices_related_field="departments_id" choices_related_second="name"/>
<trans_set>
<trans loc="de_DE" val="Abteilung ID"/>
</trans_set>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
<trans_set>
<trans loc="de_DE" val="Kontakten"/>
<trans loc="en_GB" val="Contacts"/>
</trans_set>
</relationship>
<relationship name="departments" key="dept_id" other_table="departments" other_key="departments_id" title="Departments">
<trans_set>
<trans loc="de_DE" val="Abteilungen"/>
<trans loc="en_GB" val="Departments"/>
</trans_set>
</relationship>
<relationship name="scenes" key="crew_id" other_table="scene_crew" other_key="department_id" title="Scenes">
<trans_set>
<trans loc="de_DE" val="Szenen"/>
<trans loc="en_GB" val="Scenes"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="crew">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="department_id" editable="true" use_default_formatting="true">
<formatting/>
</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_group>
<data_layout_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_group name="department" title="Department">
<trans_set>
<trans loc="de_DE" val="Abteilung"/>
<trans loc="en_GB" val="Department"/>
</trans_set>
<data_layout_item name="dept_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="departments" 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_group name="contact" title="Contact">
<trans_set>
<trans loc="de_DE" val="Kontakt"/>
<trans loc="en_GB" val="Contact"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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 name="address" title="Address">
<trans_set>
<trans loc="de_DE" val="Addresse"/>
<trans loc="en_GB" val="Address"/>
</trans_set>
<data_layout_item name="address_street1" relationship="contacts" 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="address_street2" relationship="contacts" 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="address_town" relationship="contacts" 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="address_state" relationship="contacts" 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="address_country" relationship="contacts" 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="address_postcode" relationship="contacts" 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_group name="agent" title="Agent">
<trans_set>
<trans loc="de_DE" val="Agent"/>
<trans loc="en_GB" val="Agent"/>
</trans_set>
<data_layout_item name="agent_id" relationship="contacts" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" related_relationship="agent" 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_group>
<data_layout_portal relationship="scenes">
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="overview_name" relationship="scenes" 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_portal>
<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_group>
</data_layout_groups>
</data_layout>
<data_layout name="list" parent_table="crew">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="crew_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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="dept_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="departments" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Department Name">
<trans_set>
<trans loc="de_DE" val="Abteilungsname"/>
</trans_set>
</title_custom>
</data_layout_item>
</data_layout_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports>
<report name="crew_list" title="Crew List">
<data_layout_groups>
<data_layout_group>
<data_layout_item_groupby border_width="0.05">
<groupby name="name" relationship="departments" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Department Name">
<trans_set>
<trans loc="de_DE" val="Abteilungsname"/>
</trans_set>
</title_custom>
</groupby>
<sortby>
<data_layout_item name="name_last" relationship="contacts" editable="true" use_default_formatting="true" sort_ascending="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</data_layout_item>
</sortby>
<data_layout_item name="department_id" editable="true" use_default_formatting="true">
<formatting/>
</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_verticalgroup>
<data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom/>
</data_layout_item>
<data_layout_item name="address_street1" relationship="contacts" 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="address_street2" relationship="contacts" 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="address_town" relationship="contacts" 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="address_state" relationship="contacts" 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="address_country" relationship="contacts" 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="address_postcode" relationship="contacts" 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_verticalgroup>
<data_layout_item_verticalgroup>
<data_layout_item name="name_full" relationship="contacts" related_relationship="agent" 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_verticalgroup>
<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_item_groupby>
</data_layout_group>
</data_layout_groups>
<trans_set>
<trans loc="de_DE" val="Stabliste"/>
</trans_set>
</report>
</reports>
<print_layouts/>
</table>
<table name="deliveries" title="Deliveries">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Lieferungen"/>
<trans loc="en_GB" val="Deliveries"/>
</trans_set>
<fields>
<field name="delivery_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Delivery ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Lieferung ID"/>
</trans_set>
</field>
<field name="arrival_date" type="Number" title="Arrival Date">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Lieferungsdatum"/>
</trans_set>
</field>
<field name="departure_contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="departure_contact" choices_related_field="contact_id" choices_related_second="name_full"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
<field name="arrival_contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="arrival_contact" choices_related_field="contact_id" choices_related_second="name_full"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
<field name="arrival_time" type="Time" title="Arrival Time">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Lieferungszeit"/>
</trans_set>
</field>
<field name="arrival_place" type="Text" title="Arrival Place">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Lieferungsaddresse"/>
</trans_set>
</field>
<field name="departure_time" type="Time" title="Departure Time">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Sendungszeit"/>
</trans_set>
</field>
<field name="departure_date" type="Date" title="Departure Date">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Sendungsdatum"/>
</trans_set>
</field>
<field name="departure_place" type="Text" title="Departure Place">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Sendungsaddresse"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentare"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="departure_contact" key="departure_contact_id" other_table="contacts" other_key="contact_id" title="Departure Contact">
<trans_set>
<trans loc="de_DE" val="Sendungskontakt"/>
</trans_set>
</relationship>
<relationship name="arrival_contact" key="arrival_contact_id" other_table="contacts" other_key="contact_id" title="Arrival Contact">
<trans_set>
<trans loc="de_DE" val="Empfaengerkontakt"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="list" parent_table="deliveries">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="delivery_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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="name_full" relationship="departure_contact" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Departure Name">
<trans_set>
<trans loc="de_DE" val="Sendername"/>
</trans_set>
</title_custom>
</data_layout_item>
<data_layout_item name="departure_place" 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="departure_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="arrival_contact" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Arrival Name">
<trans_set>
<trans loc="de_DE" val="Empfängerkontakt"/>
</trans_set>
</title_custom>
</data_layout_item>
<data_layout_item name="arrival_place" 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="arrival_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
</data_layout_groups>
</data_layout>
<data_layout name="details" parent_table="deliveries">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2">
<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="delivery_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2">
<data_layout_group name="departure" title="Departure">
<trans_set>
<trans loc="de_DE" val="Departure"/>
<trans loc="en_GB" val="Departure"/>
</trans_set>
<data_layout_item name="departure_contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="departure_contact" 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="departure_place" 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="departure_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="departure_time" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="arrival" title="Arrival">
<trans_set>
<trans loc="de_DE" val="Arrival"/>
<trans loc="en_GB" val="Arrival"/>
</trans_set>
<data_layout_item name="arrival_contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="arrival_contact" 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="arrival_place" 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="arrival_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
</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>
<table name="departments" title="Departments">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Abteilungen"/>
<trans loc="en_GB" val="Departments"/>
</trans_set>
<fields>
<field name="departments_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Department ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Abteilung ID"/>
</trans_set>
</field>
<field name="name" type="Text" title="Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="department_crew" key="departments_id" other_table="crew" other_key="dept_id" auto_create="true" allow_edit="true" title="Department Crew">
<trans_set>
<trans loc="de_DE" val="Abteilung Crew"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="departments">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="departments_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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_group name="details" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_portal relationship="department_crew">
<data_layout_item name="crew_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<title_custom/>
</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="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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_portal>
<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_group>
</data_layout_groups>
</data_layout>
<data_layout name="list_related_related_department_crew" parent_table="crew">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="description" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
<data_layout_item name="name_full" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
</data_layout_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports/>
<print_layouts/>
</table>
<table name="equipment" title="Equipment">
<example_rows/>
<trans_set>
<trans loc="en_GB" val="Equipment"/>
</trans_set>
<fields>
<field name="equipment_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Equipment ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="en_GB" val="Equipment ID"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
<trans loc="en_GB" val="Description"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
<trans loc="en_GB" val="Comments"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="scenes" key="equipment_id" other_table="scene_equipment" other_key="equipment_id" title="Scenes">
<trans_set>
<trans loc="de_DE" val="Szenen"/>
<trans loc="en_GB" val="Scenes"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="equipment">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<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_portal relationship="scenes">
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="overview_name" relationship="scene" 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_portal>
<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_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports/>
<print_layouts/>
</table>
<table name="journeys" title="Journeys">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Fahrten"/>
<trans loc="en_GB" val="Journeys"/>
</trans_set>
<fields>
<field name="journey_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Journey ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Fahrt ID"/>
</trans_set>
</field>
<field name="comment" type="Text" title="Comment">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="arrival_date" type="Date" title="Arrival Date">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="arrival_time" type="Time" title="Arrival Time">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="arrival_place" type="Text" title="Arrival Place">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="departure_date" type="Date" title="Departure Date">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="departure_time" type="Time" title="Departure Time">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="departure_place" type="Text" title="Departure Place">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
<trans_set>
<trans loc="de_DE" val="Kontakt ID"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts">
<trans_set>
<trans loc="de_DE" val="Kontakte"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="list" parent_table="journeys">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="journey_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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="arrival_place" 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="arrival_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="departure_place" 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="departure_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
</data_layout_groups>
</data_layout>
<data_layout name="details" parent_table="journeys">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2">
<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="journey_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2">
<data_layout_group name="person" title="Person">
<trans_set>
<trans loc="de_DE" val="Person"/>
<trans loc="en_GB" val="Person"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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_group name="departure" title="Departure">
<trans_set>
<trans loc="de_DE" val="Departure"/>
<trans loc="en_GB" val="Departure"/>
</trans_set>
<data_layout_item name="departure_place" 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="departure_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="departure_time" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="arrival" title="Arrival">
<trans_set>
<trans loc="de_DE" val="Arrival"/>
<trans loc="en_GB" val="Arrival"/>
</trans_set>
<data_layout_item name="arrival_place" 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="arrival_date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="arrival_time" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
</data_layout_group>
<data_layout_item name="comment" 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="locations" title="Locations">
<example_rows/>
<trans_set>
<trans loc="en_GB" val="Locations"/>
</trans_set>
<fields>
<field name="location_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Location ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="name" type="Text" title="Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="address_street" type="Text" title="Street">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Strasse"/>
</trans_set>
</field>
<field name="address_town" type="Text" title="Town">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Stadt"/>
</trans_set>
</field>
<field name="address_county" type="Text" title="County">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Land"/>
</trans_set>
</field>
<field name="address_country" type="Text" title="Country">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Staat"/>
</trans_set>
</field>
<field name="address_postcode" type="Text" title="Postcode">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Postleitzahl"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contacts" choices_related_field="contact_id" choices_related_second="name_full"/>
</field>
<field name="rent" type="Number" title="Rent">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
</fields>
<relationships>
<relationship name="scenes" key="location_id" other_table="scenes" other_key="location_id" auto_create="true" allow_edit="true" title="Scenes">
<trans_set>
<trans loc="de_DE" val="Szenen"/>
</trans_set>
</relationship>
<relationship name="contacts" key="contact_id" other_table="contacts" other_key="contact_id" title="Contacts"/>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="locations">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2">
<data_layout_item name="location_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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_group name="details" columns_count="2">
<data_layout_group name="address" title="Address">
<trans_set>
<trans loc="de_DE" val="Addresse"/>
<trans loc="en_GB" val="Address"/>
</trans_set>
<data_layout_item name="address_street" 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="address_town" 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="address_county" 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="address_country" 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="address_postcode" 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_group name="contact_person" title="Contact Person">
<trans_set>
<trans loc="de_DE" val="Contact Person"/>
</trans_set>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contacts" 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_group>
<data_layout_portal relationship="scenes">
<data_layout_item name="date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="time" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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="day_or_night" 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="location_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_portal>
<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="list" parent_table="locations">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="location_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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="address_town" 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="address_country" 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>
<report name="locations_list" show_table_title="true">
<data_layout_groups>
<data_layout_group>
<data_layout_item name="location_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" 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="address_town" 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>
<trans_set>
<trans loc="de_DE" val="Locations List"/>
</trans_set>
</report>
</reports>
<print_layouts/>
</table>
<table name="scene_cast" hidden="true" title="Scene Cast">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Szene Besetzung"/>
<trans loc="en_GB" val="Scene Cast"/>
</trans_set>
<fields>
<field name="scene_cast_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Cast ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Szene Besetzung ID"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="cast_id" type="Number" title="Cast ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="cast" choices_related_field="character_id" choices_related_second="character"/>
<trans_set>
<trans loc="de_DE" val="Besetzung ID"/>
</trans_set>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Szene ID"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="cast" key="cast_id" other_table="characters" other_key="character_id" title="Cast">
<trans_set>
<trans loc="de_DE" val="Besetzung"/>
<trans loc="en_GB" val="Cast"/>
</trans_set>
</relationship>
<relationship name="scene" key="scene_id" other_table="scenes" other_key="scene_id">
<trans_set>
<trans loc="de_DE" val="Szene"/>
<trans loc="en_GB" val="Scene"/>
</trans_set>
</relationship>
</relationships>
<data_layouts/>
<reports/>
<print_layouts/>
</table>
<table name="scene_costume" hidden="true" title="Scene Costume">
<example_rows/>
<fields>
<field name="scene_costume_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Costume ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
</field>
<field name="scene_id" type="Number" title="Scene Id">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
</fields>
<relationships/>
<data_layouts/>
<reports/>
<print_layouts/>
</table>
<table name="scene_crew" hidden="true" title="Scene Crew">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Szene Crew"/>
<trans loc="en_GB" val="Scene Crew"/>
</trans_set>
<fields>
<field name="scene_crew_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Crew ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Szene Crew ID"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="scenes" choices_related_field="scene_id" choices_related_second="description"/>
<trans_set>
<trans loc="de_DE" val="Szene ID"/>
</trans_set>
</field>
<field name="department_id" type="Number" title="Department ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="department" choices_related_field="departments_id" choices_related_second="name"/>
</field>
</fields>
<relationships>
<relationship name="department" key="department_id" other_table="departments" other_key="departments_id" title="Department"/>
<relationship name="scenes" key="scene_id" other_table="scenes" other_key="scene_id" title="Scenes">
<trans_set>
<trans loc="de_DE" val="Szenen"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="scene_crew">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="scene_crew_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<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_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="department_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="department" 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_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports/>
<print_layouts/>
</table>
<table name="scene_equipment" hidden="true">
<example_rows/>
<trans_set>
<trans loc="en_GB" val="Scene Equipment"/>
</trans_set>
<fields>
<field name="scene_equipment_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Equipment ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="en_GB" val="scene_equipment ID"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
<trans loc="en_GB" val="Comments"/>
</trans_set>
</field>
<field name="equipment_id" type="Number" title="Equipment ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="equipment" choices_related_field="equipment_id" choices_related_second="description"/>
<trans_set>
<trans loc="en_GB" val="Equipment ID"/>
</trans_set>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="en_GB" val="Scene ID"/>
</trans_set>
</field>
</fields>
<relationships>
<relationship name="equipment" key="equipment_id" other_table="equipment" other_key="equipment_id">
<trans_set>
<trans loc="en_GB" val="Equipment"/>
</trans_set>
</relationship>
<relationship name="scene" key="scene_id" other_table="scenes" other_key="scene_id">
<trans_set>
<trans loc="en_GB" val="Scene"/>
</trans_set>
</relationship>
</relationships>
<data_layouts>
<data_layout name="list" parent_table="scene_equipment">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="scene_equipment_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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="scene_extras" hidden="true" title="Scene Extras">
<example_rows/>
<fields>
<field name="scene_extras_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Extras ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="contact_id" type="Number" title="Contact ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="contact" choices_related_field="contact_id" choices_related_second="name_full"/>
</field>
</fields>
<relationships>
<relationship name="contact" key="contact_id" other_table="contacts" other_key="contact_id" title="Contact"/>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="scene_extras">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<data_layout_item name="scene_extras_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2" title="Details">
<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_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contact" 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_group>
</data_layout_groups>
</data_layout>
</data_layouts>
<reports/>
<print_layouts/>
</table>
<table name="scene_makeup" hidden="true" title="Scene Makeup">
<example_rows/>
<fields>
<field name="scene_makeup_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Makeup ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
</fields>
<relationships/>
<data_layouts/>
<reports/>
<print_layouts/>
</table>
<table name="scene_props" hidden="true" title="Scene Props">
<example_rows/>
<fields>
<field name="scene_props_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Props ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
</field>
<field name="scene_id" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
</fields>
<relationships/>
<data_layouts/>
<reports/>
<print_layouts/>
</table>
<table name="scenes" title="Scenes">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Szenen"/>
<trans loc="en_GB" val="Scenes"/>
</trans_set>
<fields>
<field name="scene_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Szene ID"/>
</trans_set>
</field>
<field name="comments" type="Text" title="Comments">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Kommentar"/>
</trans_set>
</field>
<field name="description" type="Text" title="Description">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Beschreibung"/>
</trans_set>
</field>
<field name="location_id" type="Number" title="Location ID">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="location" choices_related_field="location_id" choices_related_second="name"/>
</field>
<field name="date" type="Date" title="Date">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Termin"/>
</trans_set>
</field>
<field name="time" type="Time" title="Time">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Zeit"/>
</trans_set>
</field>
<field name="minutes" type="Number" title="Stop (minutes)">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places_restricted="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Stunde"/>
</trans_set>
</field>
<field name="day_or_night" type="Text" title="Day/Night">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
<custom_choice_list>
<custom_choice value="Nacht"/>
<custom_choice value="Tag"/>
<custom_choice value="Morgens"/>
<custom_choice value="Abends"/>
<custom_choice value="Daemmerung"/>
</custom_choice_list>
</formatting>
<trans_set>
<trans loc="de_DE" val="Day/Night"/>
</trans_set>
</field>
<field name="interior_or_exterior" type="Text" title="Interior/Exterior">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true" format_text_multiline_height_lines="6">
<custom_choice_list>
<custom_choice value="Interior"/>
<custom_choice value="Exterior"/>
</custom_choice_list>
</formatting>
<trans_set>
<trans loc="de_DE" val="Interior/Exterior"/>
</trans_set>
</field>
<field name="name" type="Text" title="Name">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<trans_set>
<trans loc="de_DE" val="Szene"/>
</trans_set>
</field>
<field name="overview_name" type="Text" title="Scene">
<calculation>if(record["name"]):
return record["name"]
else:
return record.related["location"]["name"]
</calculation>
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
</field>
<field name="pages" type="Number" title="Pages">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
<field name="script_day" type="Number" title="Script Day">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</field>
</fields>
<relationships>
<relationship name="location" key="location_id" other_table="locations" other_key="location_id" title="Locations">
<trans_set>
<trans loc="en_GB" val="Locations"/>
</trans_set>
</relationship>
<relationship name="scene_crew" key="scene_id" other_table="scene_crew" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Crew">
<trans_set>
<trans loc="de_DE" val="Szene Crew"/>
<trans loc="en_GB" val="Scene Crew"/>
</trans_set>
</relationship>
<relationship name="scene_cast" key="scene_id" other_table="scene_cast" other_key="scene_id" auto_create="true" allow_edit="true" title="Cast">
<trans_set>
<trans loc="de_DE" val="Szene Besetzung"/>
<trans loc="en_GB" val="Scene Cast"/>
</trans_set>
</relationship>
<relationship name="scene_equipment" key="scene_id" other_table="scene_equipment" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Equipment">
<trans_set>
<trans loc="en_GB" val="Scene Equipment"/>
</trans_set>
</relationship>
<relationship name="scene_extras" key="scene_id" other_table="scene_extras" other_key="scene_id" auto_create="true" allow_edit="true" title="Extras"/>
<relationship name="scene_props" key="scene_id" other_table="scene_props" other_key="scene_id" auto_create="true" allow_edit="true" title="Props"/>
<relationship name="scene_costume" key="scene_id" other_table="scene_costume" auto_create="true" allow_edit="true" title="Costume"/>
<relationship name="scene_makeup" key="scene_id" other_table="scene_makeup" other_key="scene_id" auto_create="true" allow_edit="true" title="Additional Makeup"/>
</relationships>
<data_layouts>
<data_layout name="details" parent_table="scenes">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_group name="overview" columns_count="2" title="Overview">
<trans_set>
<trans loc="de_DE" val="Übersicht"/>
<trans loc="en_GB" val="Overview"/>
</trans_set>
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="overview_name" 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="minutes" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="script_day" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</data_layout_group>
<data_layout_group name="details" columns_count="2" title="Details">
<trans_set>
<trans loc="de_DE" val="Details"/>
<trans loc="en_GB" val="Details"/>
</trans_set>
<data_layout_item name="name" 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_text>
<formatting/>
<text title="The location name will be used if the name is empty."/>
</data_layout_text>
<data_layout_group name="scenario" title="Scenario">
<trans_set>
<trans loc="de_DE" val="Stimmung"/>
</trans_set>
<data_layout_item name="interior_or_exterior" 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="day_or_night" 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_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="pages" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_group name="location" title="Location">
<trans_set>
<trans loc="de_DE" val="Location"/>
<trans loc="en_GB" val="Location"/>
</trans_set>
<data_layout_item name="location_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="location" 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="name_full" relationship="location" related_relationship="contacts" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Contact Name"/>
</data_layout_item>
<data_layout_item name="address_street" relationship="location" 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="address_town" relationship="location" 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="address_postcode" relationship="location" 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_group>
</data_layout_group>
<data_layout_group name="details_lower">
<data_layout_notebook name="notebook">
<data_layout_portal relationship="scene_cast">
<data_layout_item name="cast_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="character" relationship="cast" 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="name_full" relationship="cast" related_relationship="contacts_actor" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
<title_custom use_custom="true" title="Actor's Name"/>
</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_portal>
<data_layout_portal relationship="scene_extras">
<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="contact_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name_full" relationship="contact" 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_portal>
<data_layout_portal relationship="scene_props">
<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_portal>
<data_layout_portal relationship="scene_costume">
<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_portal>
<data_layout_portal relationship="scene_crew">
<data_layout_item name="department_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="name" relationship="department" 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_portal>
<data_layout_portal relationship="scene_equipment">
<data_layout_item name="equipment_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="description" relationship="equipment" 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_portal>
<data_layout_portal relationship="scene_makeup">
<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_portal>
</data_layout_notebook>
<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="list" parent_table="scenes">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="overview_name" 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="interior_or_exterior" 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="day_or_night" 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="date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="minutes" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</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_group>
</data_layout_groups>
</data_layout>
<data_layout name="list_related_related_scene_crew" parent_table="scene_crew">
<data_layout_groups>
<data_layout_group name="main">
<data_layout_item name="contact_id" editable="true" use_default_formatting="true">
<formatting/>
</data_layout_item>
<data_layout_item name="name_full" editable="true" use_default_formatting="true">
<formatting/>
</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>
<report name="locations_list" show_table_title="true">
<data_layout_groups>
<data_layout_group>
<data_layout_item_groupby>
<groupby name="date" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</groupby>
<sortby>
<data_layout_item name="time" editable="true" use_default_formatting="true" sort_ascending="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
</sortby>
<data_layout_item name="scene_id" editable="true" use_default_formatting="true">
<formatting format_thousands_separator="true" format_decimal_places="2"/>
</data_layout_item>
<data_layout_item name="interior_or_exterior" 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="day_or_night" 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_groupby>
</data_layout_group>
</data_layout_groups>
<trans_set>
<trans loc="de_DE" val="Locations List"/>
</trans_set>
</report>
</reports>
<print_layouts/>
</table>
<table name="teams" hidden="true" title="Teams">
<example_rows/>
<trans_set>
<trans loc="de_DE" val="Teams"/>
<trans loc="en_GB" val="Teams"/>
</trans_set>
<fields>
<field name="teams_id" primary_key="true" unique="true" auto_increment="true" type="Number">
<calculation/>
<formatting format_thousands_separator="true" format_decimal_places="2"/>
<trans_set>
<trans loc="de_DE" val="Teams ID"/>
</trans_set>
</field>
</fields>
<relationships/>
<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/>
<table_privs table_name="accommodation" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cars" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="companies" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="contacts" priv_view="true" priv_edit="true"/>
<table_privs table_name="crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="deliveries" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="departments" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="equipment" 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="invoice_lines" priv_view="true" priv_edit="true"/>
<table_privs table_name="invoices" priv_view="true" priv_edit="true"/>
<table_privs table_name="journeys" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="locations" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="products" priv_view="true"/>
<table_privs table_name="roles" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_equipment" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scenes" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="teams" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="test" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<group name="accounts"/>
<table_privs table_name="accommodation" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cars" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="companies" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="contacts" priv_view="true" priv_edit="true"/>
<table_privs table_name="crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="deliveries" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="departments" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="equipment" 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="invoice_lines" priv_view="true" priv_edit="true"/>
<table_privs table_name="invoices" priv_view="true" priv_edit="true"/>
<table_privs table_name="journeys" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="locations" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="products" priv_view="true"/>
<table_privs table_name="roles" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_equipment" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scenes" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="teams" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="test" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<group name="glom_developer" developer="true"/>
<table_privs table_name="accommodation" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cars" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="companies" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="contacts" priv_view="true" priv_edit="true"/>
<table_privs table_name="crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="deliveries" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="departments" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="equipment" 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="invoice_lines" priv_view="true" priv_edit="true"/>
<table_privs table_name="invoices" priv_view="true" priv_edit="true"/>
<table_privs table_name="journeys" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="locations" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="products" priv_view="true"/>
<table_privs table_name="roles" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_equipment" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scenes" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="teams" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="test" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<group name="personnel_department"/>
<table_privs table_name="accommodation" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cars" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="companies" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="contacts" priv_view="true" priv_edit="true"/>
<table_privs table_name="crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="deliveries" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="departments" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="equipment" 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="invoice_lines" priv_view="true" priv_edit="true"/>
<table_privs table_name="invoices" priv_view="true" priv_edit="true"/>
<table_privs table_name="journeys" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="locations" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="products" priv_view="true"/>
<table_privs table_name="roles" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_cast" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_crew" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scene_equipment" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="scenes" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="staff" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="teams" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
<table_privs table_name="test" priv_view="true" priv_edit="true" priv_create="true" priv_delete="true"/>
</groups>
<library_modules/></glom_document>
distrib
>
Mandriva
>
2010.0
>
i586
>
media
>
contrib-release
>
by-pkgid
>
dc43f4b90faf8066564cd72a38595b0e
>
files
>
11
