aboutsummaryrefslogtreecommitdiffstats
path: root/trunk/contrib/scripts/vmdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'trunk/contrib/scripts/vmdb.sql')
-rw-r--r--trunk/contrib/scripts/vmdb.sql66
1 files changed, 0 insertions, 66 deletions
diff --git a/trunk/contrib/scripts/vmdb.sql b/trunk/contrib/scripts/vmdb.sql
deleted file mode 100644
index 0b1fc38f1..000000000
--- a/trunk/contrib/scripts/vmdb.sql
+++ /dev/null
@@ -1,66 +0,0 @@
-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
-);