1 DROP TABLE IF EXISTS voicemail;
2 CREATE TABLE voicemail (
3 -- All of these column names are very specific, including "uniqueid". Do not change them if you wish voicemail to work.
4 uniqueid INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
6 context CHAR(80) NOT NULL DEFAULT 'default',
7 -- Mailbox number. Should be numeric.
8 mailbox CHAR(80) NOT NULL,
9 -- Must be numeric. Negative if you don't want it to be changed from VoicemailMain
10 password CHAR(80) NOT NULL,
11 -- Used in email and for Directory app
13 -- Email address (will get sound file if attach=yes)
15 -- Email address (won't get sound file)
17 -- Attach sound file to email - YES/no
19 -- Which sound format to attach
21 -- Send email from this address
23 -- Prompts in alternative language
25 -- Alternative timezone, as defined in voicemail.conf
27 -- Delete voicemail from server after sending email notification - yes/NO
28 deletevoicemail CHAR(3),
29 -- Read back CallerID information during playback - yes/NO
31 -- Allow user to send voicemail from within VoicemailMain - YES/no
32 sendvoicemail CHAR(3),
33 -- Listen to voicemail and approve before sending - yes/NO
35 -- Warn user a temporary greeting exists - yes/NO
36 tempgreetwarn CHAR(3),
37 -- Allow '0' to jump out during greeting - yes/NO
39 -- Hear date/time of message within VoicemailMain - YES/no
41 -- Hear length of message within VoicemailMain - yes/NO
43 -- Minimum duration in minutes to say
45 -- Force new user to record name when entering voicemail - yes/NO
47 -- Force new user to record greetings when entering voicemail - yes/NO
48 forcegreetings CHAR(3),
49 -- Context in which to dial extension for callback
51 -- Context in which to dial extension (from advanced menu)
53 -- Context in which to execute 0 or * escape during greeting
55 -- Maximum messages in a folder (100 if not specified)
57 -- Increase DB gain on recorded message by this amount (0.0 means none)
59 -- IMAP user for authentication (if using IMAP storage)
61 -- IMAP password for authentication (if using IMAP storage)
62 imappassword VARCHAR(80),