Merged revisions 286588 via svnmerge from
authorTilghman Lesher <tilghman@meg.abyt.es>
Tue, 14 Sep 2010 05:08:18 +0000 (05:08 +0000)
committerTilghman Lesher <tilghman@meg.abyt.es>
Tue, 14 Sep 2010 05:08:18 +0000 (05:08 +0000)
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
  r286588 | tilghman | 2010-09-14 00:07:16 -0500 (Tue, 14 Sep 2010) | 9 lines

  Merged revisions 286587 via svnmerge from
  https://origsvn.digium.com/svn/asterisk/branches/1.6.2

  ........
    r286587 | tilghman | 2010-09-14 00:06:05 -0500 (Tue, 14 Sep 2010) | 2 lines

    Add documentation on missing backend tables for Voicemail
  ........
................

git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@286589 65c4cc65-6c06-0410-ace0-fbb531ad65f3

contrib/realtime/mysql/voicemail_data.sql [new file with mode: 0644]
contrib/realtime/mysql/voicemail_messages.sql [new file with mode: 0644]

diff --git a/contrib/realtime/mysql/voicemail_data.sql b/contrib/realtime/mysql/voicemail_data.sql
new file mode 100644 (file)
index 0000000..743bd44
--- /dev/null
@@ -0,0 +1,29 @@
+DROP TABLE IF EXISTS voicemail_data;
+CREATE TABLE voicemail_data (
+       -- Path to the recording
+       filename CHAR(255) NOT NULL PRIMARY KEY,
+       -- Mailbox number (without context)
+       origmailbox CHAR(80),
+       -- Dialplan context
+       context CHAR(80),
+       -- Dialplan context, if voicemail was invoked from a macro
+       macrocontext CHAR(80),
+       -- Dialplan extension
+       exten CHAR(80),
+       -- Dialplan priority
+       priority INT(5),
+       -- Name of the channel, when message was left
+       callerchan CHAR(80),
+       -- CallerID on the channel, when message was left
+       callerid CHAR(80),
+       -- Contrary to the name, origdate is a full datetime, in localized format
+       origdate CHAR(30),
+       -- Same date as origdate, but in Unixtime
+       origtime INT(11),
+       -- Value of the channel variable VM_CATEGORY, if set
+       category CHAR(30),
+       -- Length of the message, in seconds
+       duration INT(11)
+);
+
+
diff --git a/contrib/realtime/mysql/voicemail_messages.sql b/contrib/realtime/mysql/voicemail_messages.sql
new file mode 100644 (file)
index 0000000..79dc0ea
--- /dev/null
@@ -0,0 +1,29 @@
+-- While this does not use the realtime backend, for brevity, we include this table here, as well.
+DROP TABLE IF EXISTS voicemail_messages;
+CREATE TABLE voicemail_messages (
+       -- Logical directory
+       dir CHAR(255),
+       -- Message number within the logical directory
+       msgnum INT(4),
+       -- Dialplan context
+       context CHAR(80),
+       -- Dialplan context, if Voicemail was invoked from a macro
+       macrocontext CHAR(80),
+       -- CallerID, when the message was left
+       callerid CHAR(80),
+       -- Date when the message was left, in Unixtime
+       origtime INT(11),
+       -- Length of the message, in seconds
+       duration INT(11),
+       -- The recording itself
+       recording BLOB,
+       -- Text flags indicating urgency of the message
+       flag CHAR(30),
+       -- Value of channel variable VM_CATEGORY, if set
+       category CHAR(30),
+       -- Owner of the mailbox
+       mailboxuser CHAR(30),
+       -- Context of the owner of the mailbox
+       mailboxcontext CHAR(30),
+       PRIMARY KEY (dir, msgnum)
+);