From c97add69549e3bf68b12dafec764c8e0615eb255 Mon Sep 17 00:00:00 2001 From: Tilghman Lesher Date: Thu, 18 Jan 2007 17:52:56 +0000 Subject: Merged revisions 51236 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.4 ................ r51236 | tilghman | 2007-01-18 11:49:41 -0600 (Thu, 18 Jan 2007) | 10 lines Merged revisions 51235 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.2 ........ r51235 | tilghman | 2007-01-18 11:42:17 -0600 (Thu, 18 Jan 2007) | 2 lines Document all the fields, including the indication that "uniqueid" should not be renamed. ........ ................ git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@51237 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- contrib/scripts/vmdb.sql | 77 ++++++++++++++++++++++++++++++++++++++++-------- 1 file changed, 65 insertions(+), 12 deletions(-) (limited to 'contrib') diff --git a/contrib/scripts/vmdb.sql b/contrib/scripts/vmdb.sql index 92553bbc6..0b1fc38f1 100644 --- a/contrib/scripts/vmdb.sql +++ b/contrib/scripts/vmdb.sql @@ -1,13 +1,66 @@ -drop table if exists users; -create table users ( -context VARCHAR(80) NOT NULL, -mailbox VARCHAR(80) NOT NULL, -password VARCHAR(80) NOT NULL DEFAULT '', -fullname VARCHAR(80) NOT NULL DEFAULT '', -email VARCHAR(80) NOT NULL DEFAULT '', -pager VARCHAR(80) NOT NULL DEFAULT '', -options VARCHAR(160) NOT NULL DEFAULT '', -imapuser VARCHAR(80) DEFAULT NULL, -imappassword VARCHAR(80) DEFAULT NULL, -PRIMARY KEY (context, mailbox) +DROP TABLE IF EXISTS voicemail; +CREATE TABLE voicemail ( + -- All of these column names are very specific, including "uniqueid". Do not change them if you wish voicemail to work. + uniqueid INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY, + -- Mailbox context. + context CHAR(80) NOT NULL DEFAULT 'default', + -- Mailbox number. Should be numeric. + mailbox CHAR(80) NOT NULL, + -- Must be numeric. Negative if you don't want it to be changed from VoicemailMain + password CHAR(80) NOT NULL, + -- Used in email and for Directory app + fullname CHAR(80), + -- Email address (will get sound file if attach=yes) + email CHAR(80), + -- Email address (won't get sound file) + pager CHAR(80), + -- Attach sound file to email - YES/no + attach CHAR(3), + -- Which sound format to attach + attachfmt CHAR(10), + -- Send email from this address + serveremail CHAR(80), + -- Prompts in alternative language + language CHAR(20), + -- Alternative timezone, as defined in voicemail.conf + tz CHAR(30), + -- Delete voicemail from server after sending email notification - yes/NO + deletevoicemail CHAR(3), + -- Read back CallerID information during playback - yes/NO + saycid CHAR(3), + -- Allow user to send voicemail from within VoicemailMain - YES/no + sendvoicemail CHAR(3), + -- Listen to voicemail and approve before sending - yes/NO + review CHAR(3), + -- Warn user a temporary greeting exists - yes/NO + tempgreetwarn CHAR(3), + -- Allow '0' to jump out during greeting - yes/NO + operator CHAR(3), + -- Hear date/time of message within VoicemailMain - YES/no + envelope CHAR(3), + -- Hear length of message within VoicemailMain - yes/NO + sayduration CHAR(3), + -- Minimum duration in minutes to say + saydurationm INT(3), + -- Force new user to record name when entering voicemail - yes/NO + forcename CHAR(3), + -- Force new user to record greetings when entering voicemail - yes/NO + forcegreetings CHAR(3), + -- Context in which to dial extension for callback + callback CHAR(80), + -- Context in which to dial extension (from advanced menu) + dialout CHAR(80), + -- Context in which to execute 0 or * escape during greeting + exitcontext CHAR(80), + -- Maximum length of message (in seconds) + maxmessage INT(5), + -- Maximum messages in a folder (100 if not specified) + maxmsg INT(5), + -- Increase DB gain on recorded message by this amount (0.0 means none) + volgain DECIMAL(5,2), + -- IMAP user for authentication (if using IMAP storage) + imapuser VARCHAR(80), + -- IMAP password for authentication (if using IMAP storage) + imappassword VARCHAR(80), + stamp timestamp ); -- cgit v1.2.3