                  SERVICES Table Layout for Rivendell

The SERVICES table holds data concerning each audio service configured
on the system.  Following is the layout of a record in the SERVICES
table:

FIELD NAME              TYPE                      REMARKS
------------------------------------------------------------------------------
NAME                        varchar(10) unsigned  Primary Key
DESCRIPTION                 varchar(191)
BYPASS_MODE                 enum('N','Y')
NAME_TEMPLATE               varchar(191)
DESCRIPTION_TEMPLATE        varchar(191)
PROGRAM_CODE                varchar(191)
CHAIN_LOG                   enum('N','Y')
SUB_EVENT_INHERITANCE       int(11)               0=Inherit from parent event,
                                                  1=Inherit from scheduler file
TRACK_GROUP                 varchar(10)           From GROUPS.NAME
AUTOSPOT_GROUP              varchar(10)           From GROUPS.NAME
AUTO_REFRESH                enum('N','Y')
DEFAULT_LOG_SHELFLIFE       int(11)
LOG_SHELFLIFE_ORIGIN        int(11)               0=Air Date, 1=Log Creation
ELR_SHELFLIFE               int(11)
INCLUDE_MUS_IMPORT_MARKERS  enum('N','Y')
INCLUDE_TFC_IMPORT_MARKERS  enum('N','Y')
TFC_PATH                    varchar(191)
TFC_PREIMPORT_CMD           text
TFC_WIN_PATH                varchar(191)
TFC_WIN_PREIMPORT_CMD       text
TFC_IMPORT_TEMPLATE         varchar(64)           From IMPORT_TEMPLATES.NAME
TFC_LABEL_CART              varchar(32)
TFC_TRACK_CART              varchar(32)
TFC_CART_OFFSET             int(11)
TFC_CART_LENGTH             int(11)
TFC_TITLE_OFFSET            int(11)
TFC_TITLE_LENGTH            int(11)
TFC_HOURS_OFFSET            int(11)
TFC_HOURS_LENGTH            int(11)
TFC_MINUTES_OFFSET          int(11)
TFC_MINUTES_LENGTH          int(11)
TFC_SECONDS_OFFSET          int(11)
TFC_SECONDS_LENGTH          int(11)
TFC_LEN_HOURS_OFFSET        int(11)
TFC_LEN_HOURS_LENGTH        int(11)
TFC_LEN_MINUTES_OFFSET      int(11)
TFC_LEN_MINUTES_LENGTH      int(11)
TFC_LEN_SECONDS_OFFSET      int(11)
TFC_LEN_SECONDS_LENGTH      int(11)
TFC_DATA_OFFSET             int(11)
TFC_DATA_LENGTH             int(11)
TFC_EVENT_ID_OFFSET         int(11)
TFC_EVENT_ID_LENGTH         int(11)
TFC_ANNC_TYPE_OFFSET        int(11)
TFC_ANNC_TYPE_LENGTH        int(11)
MUS_PATH                    varchar(191)
MUS_PREIMPORT_CMD           text
MUS_WIN_PATH                varchar(191)
MUS_WIN_PREIMPORT_CMD       text
MUS_IMPORT_TEMPLATE         varchar(64)           From IMPORT_TEMPLATES.NAME
MUS_LABEL_CART              varchar(32)
MUS_TRACK_CART              varchar(32)
MUS_BREAK_STRING            varchar(64)
MUS_TRACK_STRING            varchar(64)
MUS_CART_OFFSET             int(11)
MUS_CART_LENGTH             int(11)
MUS_TITLE_OFFSET            int(11)
MUS_TITLE_LENGTH            int(11)
MUS_HOURS_OFFSET            int(11)
MUS_HOURS_LENGTH            int(11)
MUS_MINUTES_OFFSET          int(11)
MUS_MINUTES_LENGTH          int(11)
MUS_SECONDS_OFFSET          int(11)
MUS_SECONDS_LENGTH          int(11)
MUS_LEN_HOURS_OFFSET        int(11)
MUS_LEN_HOURS_LENGTH        int(11)
MUS_LEN_MINUTES_OFFSET      int(11)
MUS_LEN_MINUTES_LENGTH      int(11)
MUS_LEN_SECONDS_OFFSET      int(11)
MUS_LEN_SECONDS_LENGTH      int(11)
MUS_DATA_OFFSET             int(11)
MUS_DATA_LENGTH             int(11)
MUS_EVENT_ID_OFFSET         int(11)
MUS_EVENT_ID_LENGTH         int(11)
MUS_ANNC_TYPE_OFFSET        int(11)
MUS_ANNC_TYPE_LENGTH        int(11)
MUS_TRANS_TYPE_OFFSET       int(11)
MUS_TRANS_TYPE_LENGTH       int(11)
MUS_TIME_TYPE_OFFSET        int(11)
MUS_TIME_TYPE_LENGTH        int(11)
