<?xml version="1.0"?>
<glom_document database_title="Openismus Film Manager" is_example="true" translation_original_locale="en_US">
  <connection server="localhost" user="" database="glom_film_production_manager1"/>
  
  
  
  
  
  



<table name="accommodation" title="Accommodation"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentare"/></trans_set></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Ort"/></trans_set></field><field name="address_county" type="Text" title="County"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Bundesland/Kanton"/></trans_set></field><field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Land"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Postleitzahl"/></trans_set></field><field name="contact_id" type="Number" title="Contact ID"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1"><data_layout_item name="accommodation_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2"><data_layout_item name="description" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="address" columns_count="1" sequence="1" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_county" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="contact" columns_count="1" sequence="2" 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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="accommodation_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="cars" title="Cars"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Hersteller"/></trans_set></field><field name="model" type="Text" title="Model"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Model"/></trans_set></field><field name="registration" type="Text" title="Registration"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Kennzeichnung"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="comment" type="Text" title="Comment"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><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" columns_count="1" sequence="1"/><data_layout_group name="overview" columns_count="2" sequence="2" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="car_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="registration" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="3" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="model" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comment" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="characters" title="Characters"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Charakter"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="contact_id" type="Number" title="Contact ID"><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"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="mainpart" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2" title="Details"><trans_set><trans loc="de_DE" val="Details"/><trans loc="en_GB" val="Details"/></trans_set><data_layout_group name="actor" columns_count="1" sequence="1" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street1" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street2" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="picture" relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="8"><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" sequence="9"><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" sequence="10"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="agent" columns_count="1" sequence="2"><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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_work" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_portal relationship="scenes" name="" columns_count="1" sequence="3"><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="3"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="6"><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="characters"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2" title="Details"><data_layout_item name="mainpart" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="actor" columns_count="1" sequence="2" title="Actor"><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_portal relationship="scenes" name="" columns_count="1" sequence="3"><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="interior_or_exterior" relationship="scene" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="day_or_night" relationship="scene" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="minutes" relationship="scene" editable="true" use_default_formatting="true" sequence="5"><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" columns_count="1" sequence="1"><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="3"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/><title_custom use_custom="true" title="Actor"/></data_layout_item><data_layout_item name="mainpart" editable="true" use_default_formatting="true" sequence="5"><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 name="" columns_count="1"><data_layout_item_header name="" columns_count="1" sequence="1"><data_layout_item name="org_name" relationship="system_properties" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="org_logo" relationship="system_properties" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_header><data_layout_item_groupby name="" columns_count="1" sequence="2" border_width="0.05"><sortby><data_layout_item name="mainpart" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2" sort_ascending="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></sortby><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item_verticalgroup name="" columns_count="1" sequence="5"><data_layout_item name="name_full" relationship="contacts_actor" related_relationship="agent" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></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>

</table><table name="companies" title="Companies"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="logo" type="Image" title="Logo"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="website" type="Text" title="Web Site"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="company_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="logo" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="website" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_portal relationship="staff" name="" columns_count="1" sequence="3"><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_work" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="email" editable="true" use_default_formatting="true" sequence="5"><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="companies"><data_layout_groups><data_layout_group name="main" columns_count="1" sequence="1"><data_layout_item name="company_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="contacts" default="true" title="Contacts"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Vorname"/></trans_set></field><field name="name_middle" type="Text" title="Second Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Zweiter Name"/></trans_set></field><field name="name_last" type="Text" title="Last Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Familiename"/></trans_set></field><field name="name_title" type="Text" title="Title"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><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)"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Strasse (2)"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Ort"/></trans_set></field><field name="address_state" type="Text" title="State"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Bundesland/Kanton"/></trans_set></field><field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Postleitzahl"/></trans_set></field><field name="date_of_birth" type="Date" title="Date Of Birth"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentare"/></trans_set></field><field name="name_full" calculation="return record[&quot;name_first&quot;] + &quot; &quot; + record[&quot;name_last&quot;]" type="Text" title="Full Name"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Vollst&#xE4;ndiger Name"/></trans_set></field><field name="company_id" type="Number" title="Company ID"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Telefon (Privat)"/></trans_set></field><field name="tel_mobile" type="Text" title="Mobile Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Telefon (Handy)"/></trans_set></field><field name="tel_fax" type="Text" title="Fax"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="tel_work" type="Text" title="Work Telephone"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Telefon (Buro)"/></trans_set></field><field name="email" type="Text" title="Email"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="E-Mail"/></trans_set></field><field name="address_street1" type="Text" title="Street (line 1)"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Strasse (1)"/></trans_set></field><field name="website" type="Text" title="Web Site"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Website"/></trans_set></field><field name="agent_id" type="Number" title="Agent ID"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="K&#xFC;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" columns_count="1" sequence="1"><data_layout_group name="header" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="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" columns_count="1" sequence="1"><data_layout_group name="name" columns_count="1" sequence="1" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_first" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_middle" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="company" columns_count="1" sequence="2" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="address" columns_count="1" sequence="3" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street2" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_state" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="telephone" columns_count="1" sequence="4" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_mobile" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_home" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="tel_fax" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="agent" columns_count="1" sequence="5" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/><title_custom/></data_layout_item></data_layout_group></data_layout_notebook><data_layout_notebook name="notebook_related" columns_count="1" sequence="2"><data_layout_group name="crew" columns_count="1" sequence="1" title="Crew"><trans_set><trans loc="de_DE" val="Crew"/><trans loc="en_GB" val="Crew"/></trans_set><data_layout_portal relationship="crew" name="" columns_count="1" sequence="1"><data_layout_item name="crew_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal></data_layout_group><data_layout_group name="cast" columns_count="1" sequence="2" title="Cast"><trans_set><trans loc="de_DE" val="Cast"/><trans loc="en_GB" val="Cast"/></trans_set><data_layout_portal relationship="cast" name="" columns_count="1" sequence="1"><data_layout_item name="character_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="character" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="mainpart" editable="true" use_default_formatting="true" sequence="3"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="website" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date_of_birth" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="picture" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></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" columns_count="1" sequence="1"><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_last" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="4"><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" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="6"><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="by_country" title="Contacts By Country"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><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="name_full" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></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 name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><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="name_full" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_groupby></data_layout_item_groupby></data_layout_group></data_layout_groups></report></reports>

</table><table name="crew" title="Crew"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="dept_id" type="Number" title="Department ID"><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"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="department_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2" title="Details"><trans_set><trans loc="de_DE" val="Details"/><trans loc="en_GB" val="Details"/></trans_set><data_layout_group name="department" columns_count="1" sequence="1" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="contact" columns_count="1" sequence="2" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="address" columns_count="1" sequence="3" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street2" relationship="contacts" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" relationship="contacts" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_state" relationship="contacts" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" relationship="contacts" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" relationship="contacts" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="agent" columns_count="1" sequence="4" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group><data_layout_portal relationship="scenes" name="" columns_count="1" sequence="3"><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="crew_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="3"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="dept_id" editable="true" use_default_formatting="true" sequence="5"><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" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/><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 name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1" border_width="0.05"><groupby name="name" relationship="departments" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="1" sort_ascending="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></sortby><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="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item_verticalgroup name="" columns_count="1" sequence="2"><data_layout_item name="name_full" relationship="contacts" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/><title_custom/></data_layout_item><data_layout_item name="address_street1" relationship="contacts" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_street2" relationship="contacts" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" relationship="contacts" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_state" relationship="contacts" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" relationship="contacts" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" relationship="contacts" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_item_verticalgroup><data_layout_item_verticalgroup name="" columns_count="1" sequence="3"><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"/></data_layout_item></data_layout_item_verticalgroup><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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>

</table><table name="deliveries" title="Deliveries"><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"><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"><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"><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"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Lieferungsaddresse"/></trans_set></field><field name="departure_time" type="Time" title="Departure Time"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Sendungsaddresse"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentare"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" columns_count="1" sequence="1"><data_layout_item name="delivery_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="departure_contact" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_date" editable="true" use_default_formatting="true" sequence="5"><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" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/><title_custom use_custom="true" title="Arrival Name"><trans_set><trans loc="de_DE" val="Empf&#xE4;ngerkontakt"/></trans_set></title_custom></data_layout_item><data_layout_item name="arrival_place" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_date" editable="true" use_default_formatting="true" sequence="8"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1"><data_layout_item name="description" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="delivery_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2"><data_layout_group name="departure" columns_count="1" sequence="1" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_place" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_date" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_time" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="arrival" columns_count="1" sequence="2" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_place" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_date" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_time" editable="true" use_default_formatting="true" sequence="5"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="departments" title="Departments"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="departments_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="1" sequence="2" title="Details"><trans_set><trans loc="de_DE" val="Details"/><trans loc="en_GB" val="Details"/></trans_set><data_layout_portal relationship="department_crew" name="" sequence="1"><data_layout_item name="crew_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="3"><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" sequence="4"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="equipment" title="Equipment"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/><trans loc="en_GB" val="Description"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="equipment_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_portal relationship="scenes" name="" columns_count="1" sequence="2"><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="journeys" title="Journeys"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="arrival_date" type="Date" title="Arrival Date"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="arrival_time" type="Time" title="Arrival Time"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="arrival_place" type="Text" title="Arrival Place"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="departure_date" type="Date" title="Departure Date"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="departure_time" type="Time" title="Departure Time"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="departure_place" type="Text" title="Departure Place"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="contact_id" type="Number" title="Contact ID"><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" columns_count="1" sequence="1"><data_layout_item name="journey_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_place" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_date" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_place" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_date" editable="true" use_default_formatting="true" sequence="7"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1"><data_layout_item name="description" editable="true" use_default_formatting="true"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="journey_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2"><data_layout_group name="person" columns_count="1" sequence="1" 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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="departure" columns_count="1" sequence="2" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_date" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="departure_time" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="arrival" columns_count="1" sequence="3" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_date" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="arrival_time" editable="true" use_default_formatting="true" sequence="3"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="locations" title="Locations"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="name" type="Text" title="Name"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="address_street" type="Text" title="Street"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Strasse"/></trans_set></field><field name="address_town" type="Text" title="Town"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Stadt"/></trans_set></field><field name="address_county" type="Text" title="County"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Land"/></trans_set></field><field name="address_country" type="Text" title="Country"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Staat"/></trans_set></field><field name="address_postcode" type="Text" title="Postcode"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Postleitzahl"/></trans_set></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="contact_id" type="Number" title="Contact ID"><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"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1"><data_layout_item name="location_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2"><data_layout_group name="address" columns_count="1" sequence="1" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_county" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="contact_person" columns_count="1" sequence="2" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group><data_layout_portal relationship="scenes" name="" columns_count="1" sequence="3"><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="time" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="day_or_night" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="location_id" editable="true" use_default_formatting="true" sequence="6"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="location_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_country" editable="true" use_default_formatting="true" sequence="4"><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="locations_list" show_table_title="true"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item name="location_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups><trans_set><trans loc="de_DE" val="Locations List"/></trans_set></report></reports>

</table><table name="scene_cast" hidden="true" title="Scene Cast"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="cast_id" type="Number" title="Cast ID"><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"><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/>

</table><table name="scene_costume" hidden="true" title="Scene Costume"><fields><field name="scene_costume_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Costume ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></field><field name="scene_id" type="Number" title="Scene Id"><formatting format_thousands_separator="true" format_decimal_places="2"/></field></fields><relationships/><data_layouts/><reports/>

</table><table name="scene_crew" hidden="true" title="Scene Crew"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="scene_id" type="Number" title="Scene ID"><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"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="scene_crew_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="department_id" editable="true" use_default_formatting="true" sequence="3"><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="scene_equipment" hidden="true"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><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"><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"><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" columns_count="1" sequence="1"><data_layout_item name="scene_equipment_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="equipment_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="scene_extras" hidden="true" title="Scene Extras"><fields><field name="scene_extras_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Extras ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></field><field name="scene_id" type="Number" title="Scene ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="contact_id" type="Number" title="Contact ID"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><data_layout_item name="scene_extras_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="2" title="Details"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="4"><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" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group></data_layout_groups></data_layout></data_layouts><reports/>

</table><table name="scene_makeup" hidden="true" title="Scene Makeup"><fields><field name="scene_makeup_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Makeup ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></field><field name="scene_id" type="Number" title="Scene ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field></fields><relationships/><data_layouts/><reports/>

</table><table name="scene_props" hidden="true" title="Scene Props"><fields><field name="scene_props_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Scene Props ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="comments" type="Text" title="Comments"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/></field><field name="scene_id" type="Number" title="Scene ID"><formatting format_thousands_separator="true" format_decimal_places="2"/></field></fields><relationships/><data_layouts/><reports/>

</table><table name="scenes" title="Scenes"><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"><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"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Kommentar"/></trans_set></field><field name="description" type="Text" title="Description"><formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true"/><trans_set><trans loc="de_DE" val="Beschreibung"/></trans_set></field><field name="location_id" type="Number" title="Location ID"><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"><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"><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)"><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"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><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"><formatting format_thousands_separator="true" format_decimal_places="2" choices_custom="true"><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"><formatting format_thousands_separator="true" format_decimal_places="2"/><trans_set><trans loc="de_DE" val="Szene"/></trans_set></field><field name="overview_name" calculation="if(record[&quot;name&quot;]):&#10;    return record[&quot;name&quot;]&#10;else:&#10;    return record.related[&quot;location&quot;][&quot;name&quot;]&#10;" type="Text" title="Scene"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="pages" type="Number" title="Pages"><formatting format_thousands_separator="true" format_decimal_places="2"/></field><field name="script_day" type="Number" title="Script Day"><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" columns_count="1" sequence="1"><data_layout_group name="overview" columns_count="2" sequence="1" title="Overview"><trans_set><trans loc="de_DE" val="&#xDC;bersicht"/><trans loc="en_GB" val="Overview"/></trans_set><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="overview_name" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="minutes" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="script_day" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_group name="details" columns_count="2" sequence="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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_text sequence="2"><text title="The location name will be used if the name is empty."/></data_layout_text><data_layout_group name="scenario" columns_count="1" sequence="3" 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" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="day_or_night" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="pages" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_group name="location" columns_count="1" sequence="7" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="location" related_relationship="contacts" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/><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" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_town" relationship="location" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="address_postcode" relationship="location" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_group></data_layout_group></data_layout_group><data_layout_group name="details_lower" columns_count="1" sequence="2"><data_layout_notebook name="notebook" columns_count="1" sequence="1"><data_layout_portal relationship="scene_cast" name="" columns_count="1" sequence="1"><data_layout_item name="cast_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" relationship="cast" related_relationship="contacts_actor" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/><title_custom use_custom="true" title="Actor's Name"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_extras" name="" columns_count="1" sequence="2"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="2"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_props" name="" columns_count="1" sequence="3"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_costume" name="" columns_count="1" sequence="4"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_crew" name="" sequence="5"><data_layout_item name="department_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_equipment" name="" columns_count="1" sequence="6"><data_layout_item name="equipment_id" editable="true" use_default_formatting="true" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal><data_layout_portal relationship="scene_makeup" name="" columns_count="1" sequence="7"><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item></data_layout_portal></data_layout_notebook><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="scene_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="overview_name" editable="true" use_default_formatting="true" sequence="2"><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" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="day_or_night" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="date" editable="true" use_default_formatting="true" sequence="5"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="minutes" editable="true" use_default_formatting="true" sequence="6"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="7"><formatting format_thousands_separator="true" format_decimal_places="2"/></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" columns_count="1" sequence="1"><data_layout_item name="contact_id" editable="true" use_default_formatting="true" sequence="1"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="name_full" editable="true" use_default_formatting="true" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="comments" editable="true" use_default_formatting="true" sequence="3"><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="locations_list" show_table_title="true"><data_layout_groups><data_layout_group name="" columns_count="1"><data_layout_item_groupby name="" columns_count="1" sequence="1"><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" sequence="1" 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" sequence="1"><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" sequence="2"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="day_or_night" editable="true" use_default_formatting="true" sequence="3"><formatting format_thousands_separator="true" format_decimal_places="2"/></data_layout_item><data_layout_item name="description" editable="true" use_default_formatting="true" sequence="4"><formatting format_thousands_separator="true" format_decimal_places="2"/></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>

</table><table name="teams" hidden="true" title="Teams"><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"><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/>

</table><groups><!--These are only used when recreating a database from an example file. The actual access-control is on the server, of course.--><group name=""/><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"/><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></glom_document>
