aboutsummaryrefslogtreecommitdiffstats
path: root/doc/README.odbcstorage
blob: 9b85fc5bc200dd70891a15544ff9e5d3ad04de81 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
ODBC Voicemail Storage
======================

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:

+--------------+-------------+------+-----+---------+-------+
| 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    |       |
| recording    | longblob    | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+

The database name (from /etc/asterisk/res_odbc.conf) is in the 
"odbcstorage" variable in the general section.

Mark