Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | int(11) | NO | PRI | auto_increment | |
name | varchar(80) | NO | UNI | (null) | (null) |
host | varchar(31) | NO | (null) | dynamic | (null) |
nat | varchar(5) | NO | (null) | no | (null) |
type | enum('user','peer','friend') | NO | (null) | friend | (null) |
accountcode | varchar(20) | YES | (null) | (null) | |
amaflags | varchar(13) | YES | (null) | (null) | |
call-limit | smallint(5) unsigned | YES | (null) | (null) | |
callgroup | varchar(10) | YES | (null) | (null) | |
callerid | varchar(80) | YES | (null) | (null) | |
cancallforward | char(3) | YES | (null) | yes | (null) |
canreinvite | char(3) | YES | (null) | yes | (null) |
context | varchar(80) | YES | (null) | from-softphone | (null) |
defaultip | varchar(15) | YES | (null) | (null) | |
dtmfmode | varchar(7) | YES | (null) | (null) | |
fromuser | varchar(80) | YES | (null) | (null) | |
fromdomain | varchar(80) | YES | (null) | (null) | |
insecure | varchar(4) | YES | (null) | (null) | |
language | char(2) | YES | (null) | (null) | |
mailbox | varchar(50) | YES | (null) | (null) | |
md5secret | varchar(80) | YES | (null) | (null) | |
deny | varchar(95) | YES | (null) | (null) | |
permit | varchar(95) | YES | (null) | (null) | |
mask | varchar(95) | YES | (null) | (null) | |
musiconhold | varchar(100) | YES | (null) | (null) | |
pickupgroup | varchar(10) | YES | (null) | (null) | |
qualify | char(3) | YES | (null) | no | (null) |
regexten | varchar(80) | YES | (null) | (null) | |
restrictcid | char(3) | YES | (null) | (null) | |
rtptimeout | char(3) | YES | (null) | (null) | |
rtpholdtimeout | char(3) | YES | (null) | (null) | |
secret | varchar(80) | YES | (null) | (null) | |
setvar | varchar(100) | YES | (null) | (null) | |
disallow | varchar(100) | YES | (null) | all | (null) |
allow | varchar(100) | YES | (null) | ulaw | (null) |
fullcontact | varchar(80) | NO | (null) | (null) | (null) |
ipaddr | varchar(15) | NO | (null) | (null) | (null) |
port | smallint(5) unsigned | NO | (null) | 0 | (null) |
regserver | varchar(100) | YES | (null) | (null) | |
regseconds | int(11) | NO | (null) | 0 | (null) |
defaultuser | varchar(80) | NO | (null) | (null) | (null) |
subscribecontext | varchar(80) | YES | (null) | (null) | |
lastms | int(10) unsigned | NO | (null) | 0 | (null) |
useragent | varchar(45) | NO | (null) | (null) | (null) |