ODBC 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:

Table 11.1: voicemessages Table Schema

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
flag	varchar(8)	Yes		NULL
mailboxuser	varchar(80)	Yes		NULL
mailboxcontext	varchar(80)	Yes		NULL
recording	longblob	Yes		NULL

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=table_name in voicemail.conf.