doc/tex/odbcstorage.tex

   1
   2
   3 ODBC Storage allows you to store voicemail messages within a database
   4 instead of using a file.  This is \textbf{not} a full realtime engine and
   5 \textbf{only} supports ODBC.  The table description for the "voicemessages"
   6 table is as follows:
   7
   8 \begin{verbatim}
   9 +----------------+-------------+------+-----+---------+-------+
  10 | Field          | Type        | Null | Key | Default | Extra |
  11 +----------------+-------------+------+-----+---------+-------+
  12 | msgnum         | int(11)     | YES  |     | NULL    |       |
  13 | dir            | varchar(80) | YES  | MUL | NULL    |       |
  14 | context        | varchar(80) | YES  |     | NULL    |       |
  15 | macrocontext   | varchar(80) | YES  |     | NULL    |       |
  16 | callerid       | varchar(40) | YES  |     | NULL    |       |
  17 | origtime       | varchar(40) | YES  |     | NULL    |       |
  18 | duration       | varchar(20) | YES  |     | NULL    |       |
  19 | mailboxuser    | varchar(80) | YES  |     | NULL    |       |
  20 | mailboxcontext | varchar(80) | YES  |     | NULL    |       |
  21 | recording      | longblob    | YES  |     | NULL    |       |
  22 +----------------+-------------+------+-----+---------+-------+
  23 \end{verbatim}
  24
  25 The database name (from \path{/etc/asterisk/res_odbc.conf}) is in the
  26 "odbcstorage" variable in the general section of voicemail.conf.
  27
  28 You may modify the voicemessages table name by using
  29 odbctable=??? in voicemail.conf.
  30
  31