home *** CD-ROM | disk | FTP | other *** search
/ Billboard Music Guide 1997 / BMG_10.iso / media / data / database.tbl < prev    next >
Text File  |  1996-03-07  |  3KB  |  147 lines
  1. (table
  2.     ("tables"
  3.         (list
  4.             (table
  5.                 ("name" "ALBUM")
  6.                 ("file" "album.dat")
  7.                 ("install" "no")
  8.             )
  9.             (table
  10.                 ("name" "NAME")
  11.                 ("file" "name.dat")
  12.                 ("install" "no")
  13.             )
  14.             (table
  15.                 ("name" "DESC")
  16.                 ("file" "desc.dat")
  17.                 ("install" "min")
  18.             )
  19. ;            (table
  20. ;                ("name" "GLOSSARY")
  21. ;                ("file" "glossary.dat")
  22. ;                ("install" "no")
  23. ;            )
  24.             (table
  25.                 ("name" "CATEGORY")
  26.                 ("file" "category.dat")
  27.                 ("install" "no")
  28.             )
  29.             (table
  30.                 ("name" "BBCHART")
  31.                 ("file" "bbchart.dat")
  32.                 ("install" "no")
  33.             )
  34.             (table
  35.                 ("name" "AUDIO CLIPS")
  36.                 ("file" "audclip.dat")
  37.                 ("install" "min")
  38.             )
  39.             (table
  40.                 ("name" "VIDEO CLIPS")
  41.                 ("file" "movies.dat")
  42.                 ("install" "min")
  43.             )
  44.         )
  45.     )
  46.     ("indexes"
  47.         (list
  48.             (table
  49.                 ("name" "ALBUM A_ID")    ; key = a_id, value = record number
  50.                 ("file" "albumaid.idx")
  51.                 ("install" "max")
  52.             )
  53.             (table
  54.                 ("name" "ALBUM P_ID")    ; key = p_id, value = record number
  55.                 ("file" "albumpid.idx")
  56.                 ("install" "max")
  57.             )
  58. ;            (table
  59. ;                ("name" "ALBUM GENRE")    ; key = genre code, value = record number
  60. ;                ("file" "albgenre.idx")
  61. ;                ("install" "min")
  62. ;            )
  63.             (table
  64.                 ("name" "NAME P_ID")    ; key = p_id, value = record number
  65.                 ("file" "namepid.idx")
  66.                 ("install" "max")
  67.             )
  68. ;            (table
  69. ;                ("name" "NAME GENRE")    ; key = genre code, value = record number
  70. ;                ("file" "namegenr.idx")
  71. ;                ("install" "min")
  72. ;            )
  73.             (table
  74.                 ("name" "ALBUM TITLES")    ; key = album title, value = record number
  75.                 ("file" "albtitle.idx")
  76.                 ("install" "no")
  77.             )
  78.             (table
  79.                 ("name" "BAND NAMES")    ; key = band keyname, value = record number
  80.                 ("file" "bandname.idx")
  81.                 ("install" "no")
  82.             )
  83.             (table
  84.                 ("name" "BB CHART DATE") ; key = date, value = record number
  85.                 ("file" "bbchdate.idx")
  86.                 ("install" "min")
  87.             )
  88.             (table
  89.                 ("name" "BB CHART DAYS") ; key = MMYY, value = list of DDs for days available
  90.                 ("file" "bbchdays.idx")
  91.                 ("install" "min")
  92.             )
  93.             (table
  94.                 ("name" "DESC D_ID")    ; key = d_id, value = record number
  95.                 ("file" "descdid.idx")
  96.                 ("install" "min")
  97.             )
  98.             (table
  99.                 ("name" "CATEGORY GENRE")    ; key = genre code, value = record number
  100.                 ("file" "catgenre.idx")
  101.                 ("install" "min")
  102.             )
  103.             (table
  104.                 ("name" "ALBUM RESULTS")    ; key = RECORD NUMBER, value = album title string
  105.                 ("file" "albrslt.idx")
  106.                 ("install" "max")
  107.             )
  108.             (table
  109.                 ("name" "NAME RESULTS")    ; key = RECORD NUMBER, value = album title string
  110.                 ("file" "namerslt.idx")
  111.                 ("install" "max")
  112.             )
  113.             (table
  114.                 ("name" "PHOTO P_ID")    ; key = p_id, value = record number (only p_id's which have photos are here)
  115.                 ("file" "photopid.idx")
  116.                 ("install" "min")
  117.             )
  118.             (table
  119.                 ("name" "MOVIES A_ID")    ; key = a_id, value = record number in movies.dat
  120.                 ("file" "movieaid.idx")
  121.                 ("install" "min")
  122.             )
  123.             (table
  124.                 ("name" "MOVIES P_ID")    ; key = p_id, value = record number in movies.dat
  125.                 ("file" "moviepid.idx")
  126.                 ("install" "min")
  127.             )
  128.             (table
  129.                 ("name" "AUDIO A_ID")    ; key = a_id, value = record number in audclip.dat
  130.                 ("file" "clipaid.idx")
  131.                 ("install" "min")
  132.             )
  133.             (table
  134.                 ("name" "AUDIO P_ID")    ; key = p_id, value = record number in audclip.dat
  135.                 ("file" "clippid.idx")
  136.                 ("install" "min")
  137.             )
  138.         )
  139.     )
  140.     ("keyword index"
  141.         (table
  142.             ("ARCHIVE" "words.dat")
  143.             ("INDEX" "words.idx")
  144.             ("install" "no")
  145.         )
  146.     )
  147. )