                  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)
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_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)
