                  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                    char(10) unsigned  Primary Key
DESCRIPTION             char(255)
NAME_TEMPLATE           char(255)
PROGRAM_CODE            char(255)
CHAIN_LOG               enum('N','Y')
TRACK_GROUP             char(10)           From GROUPS.NAME
AUTOSPOT_GROUP          char(10)           From GROUPS.NAME
AUTO_REFRESH            enum('N','Y')
DEFAULT_LOG_SHELFLIFE   int(11)
ELR_SHELFLIFE           int(11)
TFC_PATH                char(255)
TFC_PREIMPORT_CMD       text
TFC_WIN_PATH            char(255)
TFC_WIN_PREIMPORT_CMD   text
TFC_IMPORT_TEMPLATE     char(64)           From IMPORT_TEMPLATES.NAME
TFC_LABEL_CART          char(32)
TFC_TRACK_CART          char(32)
TFC_CART_OFFSET         int(11)
TFC_CART_LENGTH         int(11)
TFC_TITLE_OFFSET        int(11)
TFC_TITLE_LENGTH        int(11)
TFC_START_OFFSET        int(11)            RETIRED as of DB v119
TFC_START_LENGTH        int(11)            RETIRED as of DB v119
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_LENGTH_OFFSET       int(11)
TFC_LENGTH_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                char(255)
MUS_PREIMPORT_CMD       text
MUS_WIN_PATH            char(255)
MUS_WIN_PREIMPORT_CMD   text
MUS_IMPORT_TEMPLATE     char(64)           From IMPORT_TEMPLATES.NAME
MUS_LABEL_CART          char(32)
MUS_TRACK_CART          char(32)
MUS_BREAK_STRING        char(64)
MUS_TRACK_STRING        char(64)
MUS_CART_OFFSET         int(11)
MUS_CART_LENGTH         int(11)
MUS_TITLE_OFFSET        int(11)
MUS_TITLE_LENGTH        int(11)
MUS_START_OFFSET        int(11)            RETIRED as of DB v119
MUS_START_LENGTH        int(11)            RETIRED as of DB v119
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_LENGTH_OFFSET       int(11)
MUS_LENGTH_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)
CLOCK0                  char(64)           RDLogManager Clock Name
CLOCK1                  char(64)           RDLogManager Clock Name
CLOCK2                  char(64)           RDLogManager Clock Name
CLOCK3                  char(64)           RDLogManager Clock Name
CLOCK4                  char(64)           RDLogManager Clock Name
CLOCK5                  char(64)           RDLogManager Clock Name
CLOCK6                  char(64)           RDLogManager Clock Name
CLOCK7                  char(64)           RDLogManager Clock Name
CLOCK8                  char(64)           RDLogManager Clock Name
CLOCK9                  char(64)           RDLogManager Clock Name
CLOCK10                 char(64)           RDLogManager Clock Name
CLOCK11                 char(64)           RDLogManager Clock Name
CLOCK12                 char(64)           RDLogManager Clock Name
CLOCK13                 char(64)           RDLogManager Clock Name
CLOCK14                 char(64)           RDLogManager Clock Name
CLOCK15                 char(64)           RDLogManager Clock Name
CLOCK16                 char(64)           RDLogManager Clock Name
CLOCK17                 char(64)           RDLogManager Clock Name
CLOCK18                 char(64)           RDLogManager Clock Name
CLOCK19                 char(64)           RDLogManager Clock Name
CLOCK20                 char(64)           RDLogManager Clock Name
CLOCK21                 char(64)           RDLogManager Clock Name
CLOCK22                 char(64)           RDLogManager Clock Name
CLOCK23                 char(64)           RDLogManager Clock Name
CLOCK24                 char(64)           RDLogManager Clock Name
CLOCK25                 char(64)           RDLogManager Clock Name
CLOCK26                 char(64)           RDLogManager Clock Name
CLOCK27                 char(64)           RDLogManager Clock Name
CLOCK28                 char(64)           RDLogManager Clock Name
CLOCK29                 char(64)           RDLogManager Clock Name
CLOCK30                 char(64)           RDLogManager Clock Name
CLOCK31                 char(64)           RDLogManager Clock Name
CLOCK32                 char(64)           RDLogManager Clock Name
CLOCK33                 char(64)           RDLogManager Clock Name
CLOCK34                 char(64)           RDLogManager Clock Name
CLOCK35                 char(64)           RDLogManager Clock Name
CLOCK36                 char(64)           RDLogManager Clock Name
CLOCK37                 char(64)           RDLogManager Clock Name
CLOCK38                 char(64)           RDLogManager Clock Name
CLOCK39                 char(64)           RDLogManager Clock Name
CLOCK40                 char(64)           RDLogManager Clock Name
CLOCK41                 char(64)           RDLogManager Clock Name
CLOCK42                 char(64)           RDLogManager Clock Name
CLOCK43                 char(64)           RDLogManager Clock Name
CLOCK44                 char(64)           RDLogManager Clock Name
CLOCK45                 char(64)           RDLogManager Clock Name
CLOCK46                 char(64)           RDLogManager Clock Name
CLOCK47                 char(64)           RDLogManager Clock Name
CLOCK48                 char(64)           RDLogManager Clock Name
CLOCK49                 char(64)           RDLogManager Clock Name
CLOCK50                 char(64)           RDLogManager Clock Name
CLOCK51                 char(64)           RDLogManager Clock Name
CLOCK52                 char(64)           RDLogManager Clock Name
CLOCK53                 char(64)           RDLogManager Clock Name
CLOCK54                 char(64)           RDLogManager Clock Name
CLOCK55                 char(64)           RDLogManager Clock Name
CLOCK56                 char(64)           RDLogManager Clock Name
CLOCK57                 char(64)           RDLogManager Clock Name
CLOCK58                 char(64)           RDLogManager Clock Name
CLOCK59                 char(64)           RDLogManager Clock Name
CLOCK60                 char(64)           RDLogManager Clock Name
CLOCK61                 char(64)           RDLogManager Clock Name
CLOCK62                 char(64)           RDLogManager Clock Name
CLOCK63                 char(64)           RDLogManager Clock Name
CLOCK64                 char(64)           RDLogManager Clock Name
CLOCK65                 char(64)           RDLogManager Clock Name
CLOCK66                 char(64)           RDLogManager Clock Name
CLOCK67                 char(64)           RDLogManager Clock Name
CLOCK68                 char(64)           RDLogManager Clock Name
CLOCK69                 char(64)           RDLogManager Clock Name
CLOCK60                 char(64)           RDLogManager Clock Name
CLOCK61                 char(64)           RDLogManager Clock Name
CLOCK62                 char(64)           RDLogManager Clock Name
CLOCK63                 char(64)           RDLogManager Clock Name
CLOCK64                 char(64)           RDLogManager Clock Name
CLOCK65                 char(64)           RDLogManager Clock Name
CLOCK66                 char(64)           RDLogManager Clock Name
CLOCK67                 char(64)           RDLogManager Clock Name
CLOCK68                 char(64)           RDLogManager Clock Name
CLOCK69                 char(64)           RDLogManager Clock Name
CLOCK70                 char(64)           RDLogManager Clock Name
CLOCK71                 char(64)           RDLogManager Clock Name
CLOCK72                 char(64)           RDLogManager Clock Name
CLOCK73                 char(64)           RDLogManager Clock Name
CLOCK74                 char(64)           RDLogManager Clock Name
CLOCK75                 char(64)           RDLogManager Clock Name
CLOCK76                 char(64)           RDLogManager Clock Name
CLOCK77                 char(64)           RDLogManager Clock Name
CLOCK78                 char(64)           RDLogManager Clock Name
CLOCK79                 char(64)           RDLogManager Clock Name
CLOCK80                 char(64)           RDLogManager Clock Name
CLOCK81                 char(64)           RDLogManager Clock Name
CLOCK82                 char(64)           RDLogManager Clock Name
CLOCK83                 char(64)           RDLogManager Clock Name
CLOCK84                 char(64)           RDLogManager Clock Name
CLOCK85                 char(64)           RDLogManager Clock Name
CLOCK86                 char(64)           RDLogManager Clock Name
CLOCK87                 char(64)           RDLogManager Clock Name
CLOCK88                 char(64)           RDLogManager Clock Name
CLOCK89                 char(64)           RDLogManager Clock Name
CLOCK90                 char(64)           RDLogManager Clock Name
CLOCK91                 char(64)           RDLogManager Clock Name
CLOCK92                 char(64)           RDLogManager Clock Name
CLOCK93                 char(64)           RDLogManager Clock Name
CLOCK94                 char(64)           RDLogManager Clock Name
CLOCK95                 char(64)           RDLogManager Clock Name
CLOCK96                 char(64)           RDLogManager Clock Name
CLOCK97                 char(64)           RDLogManager Clock Name
CLOCK98                 char(64)           RDLogManager Clock Name
CLOCK99                 char(64)           RDLogManager Clock Name
CLOCK100                char(64)           RDLogManager Clock Name
CLOCK101                char(64)           RDLogManager Clock Name
CLOCK102                char(64)           RDLogManager Clock Name
CLOCK103                char(64)           RDLogManager Clock Name
CLOCK104                char(64)           RDLogManager Clock Name
CLOCK105                char(64)           RDLogManager Clock Name
CLOCK106                char(64)           RDLogManager Clock Name
CLOCK107                char(64)           RDLogManager Clock Name
CLOCK108                char(64)           RDLogManager Clock Name
CLOCK109                char(64)           RDLogManager Clock Name
CLOCK110                char(64)           RDLogManager Clock Name
CLOCK111                char(64)           RDLogManager Clock Name
CLOCK112                char(64)           RDLogManager Clock Name
CLOCK113                char(64)           RDLogManager Clock Name
CLOCK114                char(64)           RDLogManager Clock Name
CLOCK115                char(64)           RDLogManager Clock Name
CLOCK116                char(64)           RDLogManager Clock Name
CLOCK117                char(64)           RDLogManager Clock Name
CLOCK118                char(64)           RDLogManager Clock Name
CLOCK119                char(64)           RDLogManager Clock Name
CLOCK120                char(64)           RDLogManager Clock Name
CLOCK121                char(64)           RDLogManager Clock Name
CLOCK122                char(64)           RDLogManager Clock Name
CLOCK123                char(64)           RDLogManager Clock Name
CLOCK124                char(64)           RDLogManager Clock Name
CLOCK125                char(64)           RDLogManager Clock Name
CLOCK126                char(64)           RDLogManager Clock Name
CLOCK127                char(64)           RDLogManager Clock Name
CLOCK128                char(64)           RDLogManager Clock Name
CLOCK129                char(64)           RDLogManager Clock Name
CLOCK130                char(64)           RDLogManager Clock Name
CLOCK131                char(64)           RDLogManager Clock Name
CLOCK132                char(64)           RDLogManager Clock Name
CLOCK133                char(64)           RDLogManager Clock Name
CLOCK134                char(64)           RDLogManager Clock Name
CLOCK135                char(64)           RDLogManager Clock Name
CLOCK136                char(64)           RDLogManager Clock Name
CLOCK137                char(64)           RDLogManager Clock Name
CLOCK138                char(64)           RDLogManager Clock Name
CLOCK139                char(64)           RDLogManager Clock Name
CLOCK140                char(64)           RDLogManager Clock Name
CLOCK141                char(64)           RDLogManager Clock Name
CLOCK142                char(64)           RDLogManager Clock Name
CLOCK143                char(64)           RDLogManager Clock Name
CLOCK144                char(64)           RDLogManager Clock Name
CLOCK145                char(64)           RDLogManager Clock Name
CLOCK146                char(64)           RDLogManager Clock Name
CLOCK147                char(64)           RDLogManager Clock Name
CLOCK148                char(64)           RDLogManager Clock Name
CLOCK149                char(64)           RDLogManager Clock Name
CLOCK150                char(64)           RDLogManager Clock Name
CLOCK151                char(64)           RDLogManager Clock Name
CLOCK152                char(64)           RDLogManager Clock Name
CLOCK153                char(64)           RDLogManager Clock Name
CLOCK154                char(64)           RDLogManager Clock Name
CLOCK155                char(64)           RDLogManager Clock Name
CLOCK156                char(64)           RDLogManager Clock Name
CLOCK157                char(64)           RDLogManager Clock Name
CLOCK158                char(64)           RDLogManager Clock Name
CLOCK159                char(64)           RDLogManager Clock Name
CLOCK160                char(64)           RDLogManager Clock Name
CLOCK161                char(64)           RDLogManager Clock Name
CLOCK162                char(64)           RDLogManager Clock Name
CLOCK163                char(64)           RDLogManager Clock Name
CLOCK164                char(64)           RDLogManager Clock Name
CLOCK165                char(64)           RDLogManager Clock Name
CLOCK166                char(64)           RDLogManager Clock Name
CLOCK167                char(64)           RDLogManager Clock Name
