diff options
Diffstat (limited to 'doc/odbcstorage.tex')
| -rw-r--r-- | doc/odbcstorage.tex | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/doc/odbcstorage.tex b/doc/odbcstorage.tex new file mode 100644 index 000000000..97d1c94f1 --- /dev/null +++ b/doc/odbcstorage.tex @@ -0,0 +1,29 @@ +ODBC Storage allows you to store voicemail messages within a database +instead of using a file. This is *not* a full realtime engine and +*only* supports ODBC. The table description for the "voicemessages" +table is as follows: + +\begin{verbatim} ++----------------+-------------+------+-----+---------+-------+ +| Field | Type | Null | Key | Default | Extra | ++----------------+-------------+------+-----+---------+-------+ +| msgnum | int(11) | YES | | NULL | | +| dir | varchar(80) | YES | MUL | NULL | | +| context | varchar(80) | YES | | NULL | | +| macrocontext | varchar(80) | YES | | NULL | | +| callerid | varchar(40) | YES | | NULL | | +| origtime | varchar(40) | YES | | NULL | | +| duration | varchar(20) | YES | | NULL | | +| mailboxuser | varchar(80) | YES | | NULL | | +| mailboxcontext | varchar(80) | YES | | NULL | | +| recording | longblob | YES | | NULL | | ++----------------+-------------+------+-----+---------+-------+ +\end{verbatim} + +The database name (from /etc/asterisk/res\_odbc.conf) is in the +"odbcstorage" variable in the general section of voicemail.conf. + +You may modify the voicemessages table name by using +odbctable=??? in voicemail.conf. + + |