summaryrefslogtreecommitdiff
path: root/doc/README.odbcstorage
diff options
context:
space:
mode:
authorMark Spencer <markster@digium.com>2005-01-07 06:19:37 +0000
committerMark Spencer <markster@digium.com>2005-01-07 06:19:37 +0000
commit50b11dab9ebe22e207ea971845e2cd246bca41b3 (patch)
tree2b710b912cd4ebe845707a3bbaaf436f0f267be7 /doc/README.odbcstorage
parent094f2cb6116f7bb9085654a1862af08cf8b94bd0 (diff)
Add missing schema (bug #3216)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@4701 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'doc/README.odbcstorage')
-rwxr-xr-xdoc/README.odbcstorage25
1 files changed, 25 insertions, 0 deletions
diff --git a/doc/README.odbcstorage b/doc/README.odbcstorage
new file mode 100755
index 000000000..9b85fc5bc
--- /dev/null
+++ b/doc/README.odbcstorage
@@ -0,0 +1,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