Database
========

For each competition, a seperate `.sdf` timing database file has to be created.
This file holds information about the competitors, competition format and results.

**Do not use `File`>`Import database`, or try to reuse an existing database file!**
This often introduces bugs between software versions in the :ref:`Timing manager` which are almost impossible to resolve without in-depth knowledge of the workings of the software.

Create a database file
----------------------

In the :ref:`Timing manager` choose `File`>`New`.

Save the file using the naming scheme as defined in :ref:`File naming`.

Setup the event
---------------

Open the `Event` tab:

    - Enter the name of the competition. This name is used for printouts.
    - Set the location, also used for printouts
    - Set the level to `National` (default) or `International` (when people from multiple countries participate)
    - Set the nation as `IOC country code <https://en.wikipedia.org/wiki/List_of_IOC_country_codes>`_ , used for printouts
    - Set the competition date
    - Set Type as `standard`
    - Set format:

        - Champions_Trophy: for trophy formats
        - Team_Relay: for team relay formats
        - Single_Points_Based: for individual competitions:

          In the field that show up after Single_Points_Based, enter:

            - RankPointsReversed: The athlete winning a discipline gets n points, where n is the number of athletes in the discipline. Used for Rookie and Women competitions
            - PointsTable: To use a custom mapping per round for the number of points for each place. Used for a World Championship format.

    - #Timer per stand: Set to the number of timers per stand
    - DQ Penalty: **Keep default** When an athlete gets a DQ for a discipline, increase his time with this penalty value
    - Impulse interval: **Keep default** Show a warning when the timekeepers times deviate more than this value
    - Max deviation videotime: **Keep default** Show a warning when the average timekeepers time deviate more than this value from the videotime
    - Datahub Event Id: The `Event Id` for this competition on the Datahub, used for downloading competitors and uploading results
    - Live Event Id: The ID for this event on the liveresults system. This value is appended to the URL, e.g. http://live.stihl-timbersports.com/VALUE. Set to same id as `Datahub Event Id`


Setup disciplines
-----------------


Setup rounds
------------

Add competitors
---------------

Create starting orders
----------------------

Setup advancements
------------------

For the World Championship format and trophies, advancements can be used to setup starting orders for later rounds.
Based on the athletes performance in heats, rounds or overall, a starting order can be created.