wingDB/sql
==========

This directory contains the SQL code to create the tables for the TRD
Configuration DB (wingDB).

It should only be necessary to load the tables once. Reloading the
tables will destroy all data stored in then, and should therefore be
avoided.

Documentation of the table structure can be found in the doc directory.

The table structure is not complete yet: calibration tables (gain,
temperature ADC) and error lists are still missing, but the system
will be operational without them.


Installation
------------

The SQL code can be executed with SQL*Plus:

    sqlplus user/password@database < sql_script.sql

The SQL files have to be loaded in a certain order due to foreign key
constraints:

    create_component_tables.sql
    create_tcs_tables.sql
    create_cferr_tables.sql

    # ORI tables (ori, oricfg) added Sep 30 2008:
    create_ori_tables.sql

    # Views can be recreated at any time
    create_views.sql