TABLE magicDSRun, magicDSFile
TITLE Destreak Runs
FILE  destreakRun.php
MENU  ipp.dist.dat

# the following WHERE clauses are added to all queries joined by AND

WHERE magicDSRun.magic_ds_id = magicDSFile.magic_ds_id

#     field                    size  format  name         show    link to                  extras
FIELD magicDSRun.magic_ds_id,  5, %d,     Destreak ID
FIELD magicDSRun.magic_id,     5, %d,     Magic ID
FIELD magicDSRun.inv_magic_id, 5, %d,     Inv Magic ID
FIELD magicDSRun.state,        5, %s,     State
FIELD magicDSRun.stage,        5, %s,     Stage
FIELD magicDSRun.stage_id,     5, %d,     Stage ID
FIELD magicDSFile.component,   5, %s,     Component
FIELD magicDSFile.streak_frac, 5, %.3f,   Streak Frac
FIELD magicDSRun.cam_id,       5, %d,     Camera ID
FIELD magicDSRun.label,        10, %s,     Label
FIELD magicDSRun.data_group,   8, %s,     Data Group
FIELD magicDSRun.outroot,      10, %s,     Out Root
FIELD magicDSRun.recoveryroot, 5, %d,     Recov. Root
FIELD magicDSRun.re_place,     5, %d,     Replace
FIELD magicDSRun.remove,       5, %d,     Remove
FIELD magicDSRun.fault,        5, %d,     Run Fault
FIELD magicDSFile.fault,       5, %d,     File Fault
FIELD magicDSRun.note,         5, %s,     Note
