Add documentation on missing backend tables for Voicemail

git-svn-id: http://svn.digium.com/svn/asterisk/branches/1.6.2@286587 f38db490-d61c-443f-a65b-d21fe96a405b

2 files changed, 58 insertions, 0 deletions

diff --git a/contrib/realtime/mysql/voicemail_data.sql b/contrib/realtime/mysql/voicemail_data.sql
new file mode 100644
index 000000000..743bd4492
--- /dev/null
+++ b/contrib/realtime/mysql/voicemail_data.sql
@@ -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
index 000000000..79dc0ead5
--- /dev/null
+++ b/contrib/realtime/mysql/voicemail_messages.sql
@@ -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)
+);