drop table asterisk_extensions;

CREATE TABLE asterisk_extensions ( 
 id serial NOT NULL,
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
 exten varchar(20) NOT NULL default '',
--HELP_EN_INFO:exten
--HELP_EN_LONG:extension of the phone
--HELP_NL_INFO:exten
--HELP_NL_LONG:extentie van de telefoon
 priority varchar(20) NOT NULL default '',
--HELP_EN_INFO:priority
--HELP_EN_LONG:range of priority in extension specific dialplan
--HELP_NL_INFO:priority
--HELP_NL_LONG:volgorde van afhandelen van extentie specifieke dialplan
 app varchar(20) NOT NULL default '',
--HELP_EN_INFO:app
--HELP_EN_LONG:application in dialplan
--HELP_NL_INFO:app
--HELP_NL_LONG:applicatie in dialplan
 appdata varchar(128) NOT NULL default '',
--HELP_EN_INFO:appdata
--HELP_EN_LONG:data used in application
--HELP_NL_INFO:appdata
--HELP_NL_LONG:data gebruikt in applicatie
 PRIMARY KEY  (context,exten,priority)
); 
drop table asterisk_hints;

CREATE TABLE asterisk_hints ( 
 id serial NOT NULL,
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
 exten varchar(20) NOT NULL default '',
--HELP_EN_INFO:exten
--HELP_EN_LONG:extension used in dialplan
--HELP_NL_INFO:exten
--HELP_NL_LONG:extentie gebruikt in dialplan
 hint varchar(64) NOT NULL default '',
--HELP_EN_INFO:hint
--HELP_EN_LONG:hint used to specify the name or type of the hint
--HELP_NL_INFO:hint
--HELP_NL_LONG:hint gebruikt om de naam of type te specificeren
 PRIMARY KEY  (exten)
); 
drop table asterisk_queues;

CREATE TABLE asterisk_queues (
 id serial NOT NULL,
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
 name VARCHAR(128) PRIMARY KEY,
--HELP_EN_INFO:name
--HELP_EN_LONG:queue name
--HELP_NL_INFO:name
--HELP_NL_LONG:wachtrij naam
 musiconhold VARCHAR(128),
--HELP_EN_INFO:musiconhold
--HELP_EN_LONG:musiconhold group while in queue
--HELP_NL_INFO:musiconhold
--HELP_NL_LONG:musiconhold groep wanneer er nog geen contact is
 announce VARCHAR(128),
--HELP_EN_INFO:announce
--HELP_EN_LONG:announce sound file name 
--HELP_NL_INFO:announce
--HELP_NL_LONG:announce aankondiging geluids file naam
 context VARCHAR(128),
--HELP_EN_INFO:context
--HELP_EN_LONG:context
--HELP_NL_INFO:context
--HELP_NL_LONG:context
 timeout VARCHAR(11),
--HELP_EN_INFO:timeout
--HELP_EN_LONG:time allowed in queue
--HELP_NL_INFO:timeout
--HELP_NL_LONG:tijd toegestaan in wachtrij
 monitor_join BOOL,
--HELP_EN_INFO:monitor_join
--HELP_EN_LONG:monitor_join
--HELP_NL_INFO:monitor_join
--HELP_NL_LONG:monitor_join
 monitor_format VARCHAR(128),
--HELP_EN_INFO:monitor_format
--HELP_EN_LONG:monitor_format
--HELP_NL_INFO:monitor_format
--HELP_NL_LONG:monitor_format
 queue_youarenext VARCHAR(128),
--HELP_EN_INFO:queue_youarenext
--HELP_EN_LONG:queue_youarenext
--HELP_NL_INFO:queue_youarenext
--HELP_NL_LONG:queue_youarenext
 queue_thereare VARCHAR(128),
--HELP_EN_INFO:queue_thereare
--HELP_EN_LONG:queue_thereare
--HELP_NL_INFO:queue_thereare
--HELP_NL_LONG:queue_thereare
 queue_callswaiting VARCHAR(128),
--HELP_EN_INFO:queue_callswaiting
--HELP_EN_LONG:queue calls waiting
--HELP_NL_INFO:queue_callswaiting
--HELP_NL_LONG:queue gesprekken die wachten
 queue_holdtime VARCHAR(128),
--HELP_EN_INFO:queue_holdtime
--HELP_EN_LONG:queue_holdtime
--HELP_NL_INFO:queue_holdtime
--HELP_NL_LONG:queue_holdtime
 queue_minutes VARCHAR(128),
--HELP_EN_INFO:queue_minutes
--HELP_EN_LONG:queue_minutes
--HELP_NL_INFO:queue_minutes
--HELP_NL_LONG:queue_minutes
 queue_seconds VARCHAR(128),
--HELP_EN_INFO:queue_seconds
--HELP_EN_LONG:queue_seconds
--HELP_NL_INFO:queue_seconds
--HELP_NL_LONG:queue_seconds
 queue_lessthan VARCHAR(128),
--HELP_EN_INFO:queue_lessthan
--HELP_EN_LONG:queue_lessthan
--HELP_NL_INFO:queue_lessthan
--HELP_NL_LONG:queue_lessthan
 queue_thankyou VARCHAR(128),
--HELP_EN_INFO:queue_thankyou
--HELP_EN_LONG:queue_thankyou
--HELP_NL_INFO:queue_thankyou
--HELP_NL_LONG:queue_thankyou
 queue_reporthold VARCHAR(128),
--HELP_EN_INFO:queue_reporthold
--HELP_EN_LONG:queue_reporthold
--HELP_NL_INFO:queue_reporthold
--HELP_NL_LONG:queue_reporthold
 announce_frequency VARCHAR(11),
--HELP_EN_INFO:announce_frequency
--HELP_EN_LONG:announce_frequency
--HELP_NL_INFO:announce_frequency
--HELP_NL_LONG:announce_frequency
 announce_round_seconds VARCHAR(11),
--HELP_EN_INFO:announce_round_seconds
--HELP_EN_LONG:announce_round_seconds
--HELP_NL_INFO:announce_round_seconds
--HELP_NL_LONG:announce_round_seconds
 announce_holdtime VARCHAR(128),
--HELP_EN_INFO:announce_holdtime
--HELP_EN_LONG:announce_holdtime
--HELP_NL_INFO:announce_holdtime
--HELP_NL_LONG:announce_holdtime
 retry VARCHAR(11),
--HELP_EN_INFO:retry
--HELP_EN_LONG:retry
--HELP_NL_INFO:retry
--HELP_NL_LONG:retry
 wrapuptime VARCHAR(11),
--HELP_EN_INFO:wrapuptime
--HELP_EN_LONG:wrapuptime
--HELP_NL_INFO:wrapuptime
--HELP_NL_LONG:wrapuptime
 maxlen VARCHAR(11),
--HELP_EN_INFO:maxlen
--HELP_EN_LONG:maximum callers in queue
--HELP_NL_INFO:maxlen
--HELP_NL_LONG:maximum aantal bellers in wachtrij
 servicelevel VARCHAR(11),
--HELP_EN_INFO:servicelevel
--HELP_EN_LONG:servicelevel
--HELP_NL_INFO:servicelevel
--HELP_NL_LONG:servicelevel
 strategy VARCHAR(128),
--HELP_EN_INFO:strategy
--HELP_EN_LONG:strategy used to ring agents
--HELP_NL_INFO:strategy
--HELP_NL_LONG:strategie om agenten te bellen
 joinempty VARCHAR(128),
--HELP_EN_INFO:joinempty
--HELP_EN_LONG:allowed to join this queue when no agents are connected
--HELP_NL_INFO:joinempty
--HELP_NL_LONG:toegesstaan om in deze wachtrij te staan zonder agenten
 leavewhenempty VARCHAR(128),
--HELP_EN_INFO:leavewhenempty
--HELP_EN_LONG:leavewhenempty
--HELP_NL_INFO:leavewhenempty
--HELP_NL_LONG:leavewhenempty
 eventmemberstatus BOOL,
--HELP_EN_INFO:eventmemberstatus
--HELP_EN_LONG:eventmemberstatus
--HELP_NL_INFO:eventmemberstatus
--HELP_NL_LONG:eventmemberstatus
 eventwhencalled BOOL,
--HELP_EN_INFO:eventwhencalled
--HELP_EN_LONG:eventwhencalled
--HELP_NL_INFO:eventwhencalled
--HELP_NL_LONG:eventwhencalled
 reportholdtime BOOL,
--HELP_EN_INFO:reportholdtime
--HELP_EN_LONG:reportholdtime
--HELP_NL_INFO:reportholdtime
--HELP_NL_LONG:reportholdtime
 memberdelay VARCHAR(11),
--HELP_EN_INFO:memberdelay
--HELP_EN_LONG:memberdelay
--HELP_NL_INFO:memberdelay
--HELP_NL_LONG:memberdelay
 weight VARCHAR(11),
--HELP_EN_INFO:weight
--HELP_EN_LONG:weight
--HELP_NL_INFO:weight
--HELP_NL_LONG:weight
 timeoutrestart BOOL,
--HELP_EN_INFO:timeoutrestart
--HELP_EN_LONG:timeoutrestart
--HELP_NL_INFO:timeoutrestart
--HELP_NL_LONG:timeoutrestart
 periodic_announce VARCHAR(50),
--HELP_EN_INFO:periodic_announce
--HELP_EN_LONG:periodic_announce
--HELP_NL_INFO:periodic_announce
--HELP_NL_LONG:periodic_announce
 periodic_announce_frequency VARCHAR(11),
--HELP_EN_INFO:periodic_announce_frequency
--HELP_EN_LONG:periodic_announce_frequency
--HELP_NL_INFO:periodic_announce_frequency
--HELP_NL_LONG:periodic_announce_frequency
 ringinuse BOOL,
--HELP_EN_INFO:ringinuse
--HELP_EN_LONG:ringinuse
--HELP_NL_INFO:ringinuse
--HELP_NL_LONG:ringinuse
 setinterfacevar BOOL
--HELP_EN_INFO:setinterfacevar
--HELP_EN_LONG:setinterfacevar
--HELP_NL_INFO:setinterfacevar
--HELP_NL_LONG:setinterfacevar
);

drop table asterisk_queue_members;

CREATE TABLE asterisk_queue_members (
 uniqueid serial NOT NULL,
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
 membername varchar(40) NOT NULL default '',
--HELP_EN_INFO:membername
--HELP_EN_LONG:member name
--HELP_NL_INFO:membername
--HELP_NL_LONG:member naam
 queue_name varchar(128) NOT NULL default '',
--HELP_EN_INFO:queue name
--HELP_EN_LONG:queue name
--HELP_NL_INFO:queue name
--HELP_NL_LONG:wachtrij naam
 interface varchar(128) NOT NULL default '',
--HELP_EN_INFO:interface
--HELP_EN_LONG:interface name of the phone
--HELP_NL_INFO:interface
--HELP_NL_LONG:interface naam van de telefoon
 penalty varchar(11) NOT NULL default '',
--HELP_EN_INFO:penalty
--HELP_EN_LONG:penalty
--HELP_NL_INFO:penalty
--HELP_NL_LONG:penalty
 paused varchar(11) NOT NULL default '',
--HELP_EN_INFO:paused
--HELP_EN_LONG:paused status
--HELP_NL_INFO:paused
--HELP_NL_LONG:paused status
 PRIMARY KEY  (queue_name, interface)
);


drop table asterisk_sipconf;

CREATE TABLE asterisk_sipconf (
id serial NOT NULL,
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
name character varying(80) DEFAULT '' NOT NULL, 
--HELP_EN_INFO:Unique name off the peer
--HELP_EN_LONG:peername off the sip phone
--HELP_NL_INFO:Unieke naam van de friend
--HELP_NL_LONG:peename van de sip telefoon
host character varying(31) DEFAULT '' NOT NULL,
--HELP_EN_INFO:host indentification
--HELP_EN_LONG:specifies the host type --> dynamic
--HELP_NL_INFO:host identificatie
--HELP_NL_LONG:specificeert de host type --> dynamisch
accountcode character varying(20),
--HELP_EN_INFO:account code
--HELP_EN_LONG:account code
--HELP_NL_INFO:account code
--HELP_NL_LONG:account code
amaflags character varying(7),
--HELP_EN_INFO:Automated Message Accounting flags
--HELP_EN_LONG:Automated Message Accounting used for CDR
--HELP_NL_INFO:Automated Message Accounting flags
--HELP_NL_LONG:Automated Message Accounting gebruikt voor CDR
callgroup character varying(10),
--HELP_EN_INFO:Callgroup
--HELP_EN_LONG:group which this peer falls into.
--HELP_NL_INFO:Call groep
--HELP_NL_LONG:Groep waar deze peer in valt
callerid character varying(80), 
--HELP_EN_INFO:callerid
--HELP_EN_LONG:id van de caller
--HELP_NL_INFO:callerid
--HELP_NL_LONG:id van de gebruiker
directmedia character varying(3) DEFAULT 'yes',
--HELP_EN_INFO:directmedia
--HELP_EN_LONG:specifies if direct connections are used
--HELP_NL_INFO:directmedia
--HELP_NL_LONG:specificeert of directe verbindingen gebruikt wworden
directmediadeny character varying(95) DEFAULT '' NOT NULL,
--HELP_EN_INFO:directmediadeny
--HELP_EN_LONG:specificies the ip range that will be ignored
--HELP_NL_INFO:directmediadeny
--HELP_NL_LONG:specificeert werlke ip range wordt genegeerd
directmediapermit character varying(95) DEFAULT '' NOT NULL,
--HELP_EN_INFO:directmediapermit
--HELP_EN_LONG:specifies the ip range that will use
--HELP_NL_INFO:directmediapermit
--HELP_NL_LONG:specificeed de ip range die gebruik maakt
context character varying(80),
--HELP_EN_INFO:context name
--HELP_EN_LONG:entry of the context in the dialplan
--HELP_NL_INFO:context naam
--HELP_NL_LONG:ingang van de context binnen het dialplan
subscribecontext character varying(80),
--HELP_EN_INFO:subscribecontext
--HELP_EN_LONG:entry in dialplan for subcribing status of the phone
--HELP_NL_INFO:subcribecontext
--HELP_NL_LONG:ingang binnen het dialplan voor intekenen voor status display van telefoons
defaultip character varying(15),
--HELP_EN_INFO:defaultip
--HELP_EN_LONG:the default ip of the phone
--HELP_NL_INFO:default ip
--HELP_NL_LONG:de default ip adres van de telefoon
dtmfmode character varying(7),
--HELP_EN_INFO:dtmfmode
--HELP_EN_LONG:status for mode of dtmf
--HELP_NL_INFO:dtmfmode
--HELP_NL_LONG:status van de mode van dtmf
fromuser character varying(80),
--HELP_EN_INFO:fromuser
--HELP_EN_LONG:fromuser
--HELP_NL_INFO:fromuser
--HELP_NL_LONG:fromuser
username character varying(80) DEFAULT '' NOT NULL,
--HELP_EN_INFO:username
--HELP_EN_LONG:username of the phone
--HELP_NL_INFO:username
--HELP_NL_LONG:usernaam van de telefoon
fromdomain character varying(80),
--HELP_EN_INFO:fromdomain
--HELP_EN_LONG:domain the phone subcribes to
--HELP_NL_INFO:fromdomain
--HELP_NL_LONG:domain waar binnen de telefoon behoort
insecure character varying(4),
--HELP_EN_INFO:insecure
--HELP_EN_LONG:state of the security level used for the logon
--HELP_NL_INFO:insecure
--HELP_NL_LONG:status van de security hoogte gebruikt voor het inloggen
"call-limit" character varying(4) default '0', 
--HELP_EN_INFO:call-limit
--HELP_EN_LONG:limit of calls
--HELP_NL_INFO:call-limit
--HELP_NL_LONG:hoeveelheid aan oproepen
"language" character varying(2),
--HELP_EN_INFO:language
--HELP_EN_LONG:language
--HELP_NL_INFO:language
--HELP_NL_LONG:taal
mailbox character varying(50),
--HELP_EN_INFO:mailbox
--HELP_EN_LONG:name of the mailbox used
--HELP_NL_INFO:mailbox
--HELP_NL_LONG:naam van de mailbox
md5secret character varying(80),
--HELP_EN_INFO:md5secret
--HELP_EN_LONG:password for the phone md5 encryptd
--HELP_NL_INFO:md5secret
--HELP_NL_LONG:password voor de telefoon met md5 encryptie
nat character varying(5) DEFAULT 'no' NOT NULL,
--HELP_EN_INFO:nat
--HELP_EN_LONG:uses nat
--HELP_NL_INFO:nat
--HELP_NL_LONG:gebruikt nat
permit character varying(95),
--HELP_EN_INFO:permit
--HELP_EN_LONG:ip used
--HELP_NL_INFO:permit
--HELP_NL_LONG:ip die gebruikt worden
deny character varying(95),
--HELP_EN_INFO:deny
--HELP_EN_LONG:ip addresses which are refused
--HELP_NL_INFO:deny
--HELP_NL_LONG:ipadressen die afgewezen worden
mask character varying(95),
--HELP_EN_INFO:mask
--HELP_EN_LONG:mask
--HELP_NL_INFO:mask
--HELP_NL_LONG:mask
pickupgroup character varying(10),
--HELP_EN_INFO:pickupgroup
--HELP_EN_LONG:pickupgroup
--HELP_NL_INFO:pickupgroup
--HELP_NL_LONG:pickupgroup
port character varying(5) DEFAULT '' NOT NULL,
--HELP_EN_INFO:port
--HELP_EN_LONG:port
--HELP_NL_INFO:port
--HELP_NL_LONG:poort
qualify character varying(4) DEFAULT '' NOT NULL,
--HELP_EN_INFO:qualify
--HELP_EN_LONG:time to check if phone stille exists
--HELP_NL_INFO:qualify
--HELP_NL_LONG:tijd voor check of phone aangesloten is
restrictcid character varying(1),
--HELP_EN_INFO:restrictcid
--HELP_EN_LONG:restrictcid
--HELP_NL_INFO:restrictcid
--HELP_NL_LONG:restrictcid
rtptimeout character varying(3),
--HELP_EN_INFO:rtptimeout
--HELP_EN_LONG:rtptimeout
--HELP_NL_INFO:rtptimeout
--HELP_NL_LONG:rtptimeout
rtpholdtimeout character varying(3),
--HELP_EN_INFO:rtpholdtimeout
--HELP_EN_LONG:rtpholdtimeout
--HELP_NL_INFO:rtpholdtimeout
--HELP_NL_LONG:rtpholdtimeout
secret character varying(80),
--HELP_EN_INFO:secret
--HELP_EN_LONG:password
--HELP_NL_INFO:secret
--HELP_NL_LONG:password
"type" character varying DEFAULT 'friend' NOT NULL,
--HELP_EN_INFO:type
--HELP_EN_LONG:type of sip
--HELP_NL_INFO:type
--HELP_NL_LONG:type van sip
disallow character varying(100) DEFAULT 'all',
--HELP_EN_INFO:disallow
--HELP_EN_LONG:codecs which are refused
--HELP_NL_INFO:disallow
--HELP_NL_LONG:codes welke afgewezen worden
allow character varying(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw',
--HELP_EN_INFO:allow
--HELP_EN_LONG:codecs which are used
--HELP_NL_INFO:allow
--HELP_NL_LONG:codecs welke gebruikt worden
musiconhold character varying(100),
--HELP_EN_INFO:musiconhold
--HELP_EN_LONG:group of music on hold
--HELP_NL_INFO:musiconhold
--HELP_NL_LONG:groep van music on hold
mohsuggest character varying(100),
--HELP_EN_INFO:mohsuggest
--HELP_EN_LONG:mohsuggest
--HELP_NL_INFO:mohsuggest
--HELP_NL_LONG:mohsuggest
mohinterpret character varying(100),
--HELP_EN_INFO:mohinterpret
--HELP_EN_LONG:mohinterpret
--HELP_NL_INFO:mohinterpret
--HELP_NL_LONG:mohinterpret
regseconds character varying(25) DEFAULT '0' NOT NULL,
--HELP_EN_INFO:regseconds
--HELP_EN_LONG:registration time in seconds
--HELP_NL_INFO:regseconds
--HELP_NL_LONG:registratie tijd in seconden
ipaddr character varying(15) DEFAULT '' NOT NULL,
--HELP_EN_INFO:ipaddr
--HELP_EN_LONG:ip address used for the phone
--HELP_NL_INFO:ipaddr
--HELP_NL_LONG:ip adres van de telefoon
regexten character varying(80) DEFAULT '' NOT NULL,
--HELP_EN_INFO:regexten
--HELP_EN_LONG:regexten
--HELP_NL_INFO:regexten
--HELP_NL_LONG:regexten
cancallforward character varying(3) DEFAULT 'yes',
--HELP_EN_INFO:cancallforward
--HELP_EN_LONG:cancallforward
--HELP_NL_INFO:cancallforward
--HELP_NL_LONG:cancallforward
lastms character varying(6) DEFAULT '-1' NOT NULL,
--HELP_EN_INFO:lastms
--HELP_EN_LONG:last ping time in ms
--HELP_NL_INFO:lastms
--HELP_NL_LONG:laatste ping tijd in ms
setvar text DEFAULT '' NOT NULL,
--HELP_EN_INFO:setvar
--HELP_EN_LONG:variables used with this channel
--HELP_NL_INFO:setvar
--HELP_NL_LONG:variabelen die gezet zijn voor dit kannal
useclientcode character varying(3) DEFAULT 'yes',
--HELP_EN_INFO:useclientcode
--HELP_EN_LONG:use clientcode
--HELP_NL_INFO:useclientcode
--HELP_NL_LONG:use clientcode
mac character varying(17) DEFAULT '' NOT NULL,
--HELP_EN_INFO:mac
--HELP_EN_LONG:mac address of the phone
--HELP_NL_INFO:mac
--HELP_NL_LONG:mac adres van de telefoon
notifyringing character varying(3) DEFAULT 'yes',
--HELP_EN_INFO:notifyringing
--HELP_EN_LONG:notifyringing
--HELP_NL_INFO:notifyringing
--HELP_NL_LONG:notifyringing
sendrpid character varying(10) DEFAULT 'no',
--HELP_EN_INFO:sendrpid
--HELP_EN_LONG:send remote partyid also via update or info
--HELP_NL_INFO:sendrpid
--HELP_NL_LONG:zend remote party id ook via update of info
defaultuser character varying(80) DEFAULT '' NOT NULL,
--HELP_EN_INFO:defaultuser
--HELP_EN_LONG:defaultuser
--HELP_NL_INFO:defaultuser
--HELP_NL_LONG:defaultuser
fullcontact character varying(128) DEFAULT '' NOT NULL,
--HELP_EN_INFO:fullcontact
--HELP_EN_LONG:updated by asterisk after registration
--HELP_NL_INFO:fullcontact
--HELP_NL_LONG:updated door asterisk na registratie
regserver character varying(64) DEFAULT '' NOT NULL,
--HELP_EN_INFO:regserver
--HELP_EN_LONG:regserver
--HELP_NL_INFO:regserver
--HELP_NL_LONG:regserver
useragent character varying(64) DEFAULT '' NOT NULL
--HELP_EN_INFO:useragent
--HELP_EN_LONG:useragent updated by asterisk after registration
--HELP_NL_INFO:useragent
--HELP_NL_LONG:useragent updated door asterisk na registration
);
drop table asterisk_voicemail_users;

CREATE TABLE asterisk_voicemail_users
(
  uniqueid serial NOT NULL, 
--HELP_EN_INFO:Identifier
--HELP_EN_LONG:Unique identifier for the record
--HELP_NL_INFO:Identifier
--HELP_NL_LONG:Unique identifier van de record
  customer_id character varying(11) NOT NULL DEFAULT 0, 
--HELP_EN_INFO:customer_id
--HELP_EN_LONG:customer_id
--HELP_NL_INFO:customer_id
--HELP_NL_LONG:customer_id
  context character varying(50) NOT NULL DEFAULT 'default',
--HELP_EN_INFO:context
--HELP_EN_LONG:context in dialplan
--HELP_NL_INFO:context
--HELP_NL_LONG:context in dialplan
  mailbox character varying(11) NOT NULL DEFAULT 0, 
--HELP_EN_INFO:mailbox
--HELP_EN_LONG:mailbox extension
--HELP_NL_INFO:mailbox
--HELP_NL_LONG:mailbox extentie
  "password" character varying(5) NOT NULL DEFAULT 0, 
--HELP_EN_INFO:password
--HELP_EN_LONG:mailbox password
--HELP_NL_INFO:password
--HELP_NL_LONG:mailbox password
  fullname character varying(150) NOT NULL DEFAULT '', 
--HELP_EN_INFO:fullname
--HELP_EN_LONG:callerid of the phone
--HELP_NL_INFO:fullname
--HELP_NL_LONG:callerid van de telefoon
  email character varying(50) NOT NULL DEFAULT '', 
--HELP_EN_INFO:email
--HELP_EN_LONG:email address to send voicemail file
--HELP_NL_INFO:email
--HELP_NL_LONG:email adres om voicemail te sturen
  pager character varying(50) NOT NULL DEFAULT '', 
--HELP_EN_INFO:pager
--HELP_EN_LONG:pager
--HELP_NL_INFO:pager
--HELP_NL_LONG:pager
  tz character varying(10) NOT NULL DEFAULT 'central', 
--HELP_EN_INFO:tz
--HELP_EN_LONG:time zone
--HELP_NL_INFO:tz
--HELP_NL_LONG:tijd zone
  attach character varying(4) NOT NULL DEFAULT 'yes', 
--HELP_EN_INFO:attach
--HELP_EN_LONG:attach
--HELP_NL_INFO:attach
--HELP_NL_LONG:attach
  saycid character varying(4) NOT NULL DEFAULT 'yes', 
--HELP_EN_INFO:saycid
--HELP_EN_LONG:saycid
--HELP_NL_INFO:saycid
--HELP_NL_LONG:saycid
  dialout character varying(10) NOT NULL DEFAULT '', 
--HELP_EN_INFO:dialout
--HELP_EN_LONG:dialout
--HELP_NL_INFO:dialout
--HELP_NL_LONG:dialout
  callback character varying(10) NOT NULL DEFAULT '', 
--HELP_EN_INFO:callback
--HELP_EN_LONG:context used for callback from voicemail menu
--HELP_NL_INFO:callback
--HELP_NL_LONG:context van dialplan voor callback vanuit vooicemail menu
  review character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:review
--HELP_EN_LONG:review
--HELP_NL_INFO:review
--HELP_NL_LONG:review
  "operator" character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:operator
--HELP_EN_LONG:operator
--HELP_NL_INFO:operator
--HELP_NL_LONG:operator
  envelope character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:envelope
--HELP_EN_LONG:envelope
--HELP_NL_INFO:envelope
--HELP_NL_LONG:envelope
  sayduration character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:sayduration
--HELP_EN_LONG:sayduration
--HELP_NL_INFO:sayduration
--HELP_NL_LONG:sayduration
  saydurationm smallint NOT NULL DEFAULT 1, 
--HELP_EN_INFO:saydurationm
--HELP_EN_LONG:saydurationm
--HELP_NL_INFO:saydurationm
--HELP_NL_LONG:saydurationm
  sendvoicemail character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:sendvoicemail
--HELP_EN_LONG:sendvoicemail
--HELP_NL_INFO:sendvoicemail
--HELP_NL_LONG:sendvoicemail
  "delete" character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:delete
--HELP_EN_LONG:delete
--HELP_NL_INFO:delete
--HELP_NL_LONG:delete
  nextaftercmd character varying(4) NOT NULL DEFAULT 'yes', 
--HELP_EN_INFO:nextaftercmd
--HELP_EN_LONG:nextaftercmd
--HELP_NL_INFO:nextaftercmd
--HELP_NL_LONG:nextaftercmd
  forcename character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:forcename
--HELP_EN_LONG:forcename
--HELP_NL_INFO:forcename
--HELP_NL_LONG:forcename
  forcegreetings character varying(4) NOT NULL DEFAULT 'no', 
--HELP_EN_INFO:forcegreetings
--HELP_EN_LONG:forcegreetings
--HELP_NL_INFO:forcegreetings
--HELP_NL_LONG:forcegreetings
  hidefromdir character varying(4) NOT NULL DEFAULT 'yes', 
--HELP_EN_INFO:hidefromdir
--HELP_EN_LONG:hidefromdir
--HELP_NL_INFO:hidefromdir
--HELP_NL_LONG:hidefromdir
  stamp timestamp without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
--HELP_EN_INFO:stamp
--HELP_EN_LONG:timestamp
--HELP_NL_INFO:stamp
--HELP_NL_LONG:timestamp
  CONSTRAINT "Primary Key" PRIMARY KEY (uniqueid)
) WITH OIDS;
CREATE UNIQUE INDEX mailbox_context ON asterisk_voicemail_users (mailbox,context); 

