diff options
author | seanbright <seanbright@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-12-16 01:52:32 +0000 |
---|---|---|
committer | seanbright <seanbright@f38db490-d61c-443f-a65b-d21fe96a405b> | 2008-12-16 01:52:32 +0000 |
commit | 192f2916cf9eab154c1f86c2a103ee0264112868 (patch) | |
tree | f0740e2146fef38b661e6ab5d71e9e9fe139a44c /doc | |
parent | 4e37275b2fed5c56802e3fc0a0743ca331ecd7ba (diff) |
Use tables instead of ASCII art. Also change a bit of minor formatting.
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@164565 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'doc')
-rw-r--r-- | doc/tex/odbcstorage.tex | 48 |
1 files changed, 25 insertions, 23 deletions
diff --git a/doc/tex/odbcstorage.tex b/doc/tex/odbcstorage.tex index fed96e9d1..43b3e0ed1 100644 --- a/doc/tex/odbcstorage.tex +++ b/doc/tex/odbcstorage.tex @@ -2,30 +2,32 @@ ODBC Storage allows you to store voicemail messages within a database instead of using a file. This is \textbf{not} a full realtime engine and -\textbf{only} supports ODBC. The table description for the "voicemessages" +\textbf{only} supports ODBC. The table description for the \texttt{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 \path{/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. +\begin{table}[h] +\begin{center} +\begin{tabular}{ | l | l | c | c | l | l | } +\hline +Field & Type & Null & Key & Default & Extra \\ \hline \hline +msgnum & int(11) & Yes & & NULL & \\ \hline +dir & varchar(80) & Yes & MUL & NULL & \\ \hline +context & varchar(80) & Yes & & NULL & \\ \hline +macrocontext & varchar(80) & Yes & & NULL & \\ \hline +callerid & varchar(40) & Yes & & NULL & \\ \hline +origtime & varchar(40) & Yes & & NULL & \\ \hline +duration & varchar(20) & Yes & & NULL & \\ \hline +mailboxuser & varchar(80) & Yes & & NULL & \\ \hline +mailboxcontext & varchar(80) & Yes & & NULL & \\ \hline +recording & longblob & Yes & & NULL & \\ +\hline +\end{tabular} +\end{center} +\caption{\texttt{voicemessages} Table Schema} +\end{table} +The database name (from \path{/etc/asterisk/res_odbc.conf}) is in the +\texttt{odbcstorage} variable in the general section of \path{voicemail.conf}. +You may modify the \texttt{voicemessages} table name by using +\texttt{odbctable=\textit{table\_name}} in \path{voicemail.conf}. |