README.odbcstorage 1.5 KB

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