| 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) |