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 the order of their prefixed numbers 
due to foreign key constraints:

    00_create_component_tables.sql
    01_create_tcs_tables.sql
    02_create_cferr_tables.sql

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

    # Views can be recreated at any time
    99_create_views.sql

Conversion to DB format w/ history (~Jan 2010)
----------------------------------
use sqlplus as above and input the conversion *.sql, execute 
gate2wing mcmid between step1 and 3. Macros are located in ./SQLmodifications


Modifications in v0.5.5 (Dec 2010)
---------------------------------
apply the changes in ./SQLmodification/ChangeTablesForv0.5.5.sql
then recreate views with 99_create_views.sql