Pages for other versions: devel 3.5 3.4 Older versions: 3.3 3.2 3.1 3.0 2.4 2.3 2.2 2.1 1.11 1.10 1.9 1.8 1.7 1.6 1.5 1.4
OpenSIPS database tables
Edited by Henning Westerholt Norman Brandinger Copyright © 2007 OpenSIPS development Team
Table 1-1. Table "acc"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
method
string
16
'' no A method is the primary function that a request is meant to invoke on a server.
from_tag
string
64
'' no The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.
to_tag
string
64
'' no The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.
callid
string
64
'' no Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
sip_code
string
3
'' no SIP reply code
sip_reason
string
32
'' no SIP reply reason
time
datetime
not specified
default no Date and time when this record was written.
Table 1-2. Table "acc" indexes
name type links description callid_idx
default callid
Table 1-3. Table "missed_calls"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
method
string
16
'' no A method is the primary function that a request is meant to invoke on a server.
from_tag
string
64
'' no The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.
to_tag
string
64
'' no The tag parameter serves as a general mechanism to identify a dialog, which is the combination of the Call-ID along with two tags, one from participant in the dialog.
callid
string
64
'' no Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
sip_code
string
3
'' no SIP reply code
sip_reason
string
32
'' no SIP reply reason
time
datetime
not specified
default no Date and time when this record was written.
Table 1-4. Table "missed_calls" indexes
name type links description callid_idx
default callid
Table 2-1. Table "dbaliases"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
alias_username
string
64
'' no Alias username / phone number
alias_domain
string
64
'' no Alias domain name
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
Table 2-2. Table "dbaliases" indexes
name type links description alias_idx
unique alias_username, alias_domain
target_idx
default username, domain
Table 3-1. Table "subscriber"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
password
string
25
'' no Password
email_address
string
64
'' no Email address
ha1
string
64
'' no md5(username:realm:password)
ha1b
string
64
'' no md5(username@domain:realm:password)
rpid
string
64
NULL yes The SIP Remote-Party-ID header identifies the calling party and includes user, party, screen and privacy headers that specify how a call is presented and screened.
Table 3-2. Table "subscriber" indexes
name type links description account_idx
unique username, domain
username_idx
default username
Table 4-1. Table "usr_preferences"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
uuid
string
64
'' no Unique user ID
username
string
128
0 no Username / phone number
domain
string
64
'' no Domain name
attribute
string
32
'' no AVP attribute
type
int
11
0 no AVP type
value
string
128
'' no AVP value
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this record was last modified.
Table 4-2. Table "usr_preferences" indexes
name type links description ua_idx
default uuid, attribute
uda_idx
default username, domain, attribute
value_idx
default value
Table 5-1. Table "carrierroute"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
carrier
unsigned int
10
0 no This column contains the carrier id.
domain
string
64
'' no This column contains the route domain. Additional domains could be used for example as fallback.
scan_prefix
string
64
'' no This column contains the scan prefix, which define the matching portion of a phone number.
flags
unsigned int
11
0 no This column contains the flags used for rule matching.
mask
unsigned int
11
0 no This column contains the mask that is applied to the message flags before rule matching.
prob
float
not specified
0 no Name of column containing the probability. The probability value is used to distribute the traffic between several gateways.
strip
unsigned int
11
0 no Name of the column containing the number of digits to be stripped of the userpart of an URI before prepending rewrite_prefix.
rewrite_host
string
128
'' no Name of column containing rewrite prefixes. Here you can define a rewrite prefix for the localpart of the SIP URI.
rewrite_prefix
string
64
'' no Rewrite prefix for the localpart of the SIP URI.
rewrite_suffix
string
64
'' no Rewrite suffix for the localpart of the SIP URI.
description
string
255
NULL yes A comment for the route entry, useful for larger routing tables.
Table 5-2. Table "carrierfailureroute"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
carrier
unsigned int
10
0 no This column contains the carrier id.
domain
string
64
'' no This column contains the route domain. Additional domains could be used for example as fallback.
scan_prefix
string
64
'' no This column contains the scan prefix, which define the matching portion of a phone number.
host_name
string
128
'' no This column contains the routing destination used for rule matching.
reply_code
string
3
'' no This column contains the reply code used for rule matching.
flags
unsigned int
11
0 no This column contains the flags used for rule matching.
mask
unsigned int
11
0 no This column contains the mask that is applied to the message flags before rule matching.
next_domain
string
64
'' no This column contains the route domain that should be used for the next routing attempt.
description
string
255
NULL yes A comment for the route entry, useful for larger routing tables.
Table 5-3. Table "route_tree"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
carrier
string
64
NULL yes This column contains the carrier name.
Table 6-1. Table "closeddial"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
cd_username
string
64
'' no Closed dial username
cd_domain
string
64
'' no Closed dial domain
group_id
string
64
'' no Attribute use to group usernames
new_uri
string
128
'' no New URI
Table 6-2. Table "closeddial" indexes
name type links description cd_idx1
unique username, domain, cd_domain, cd_username, group_id
cd_idx2
default group_id
cd_idx3
default cd_username
cd_idx4
default username
Table 7-1. Table "cpl"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
username
string
64
default no
domain
string
64
'' no
cpl_xml
text
not specified
default yes
cpl_bin
text
not specified
default yes
Table 7-2. Table "cpl" indexes
name type links description account_idx
unique username, domain
Table 8-1. Table "dialog"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
hash_entry
unsigned int
10
default no Number of the hash entry in the dialog hash table
hash_id
unsigned int
10
default no The ID on the hash entry
callid
string
255
default no Call-ID of the dialog
from_uri
string
128
default no The URI of the FROM header (as per INVITE)
from_tag
string
64
default no The tag parameter serves as a general mechanism to
identify a dialog, which is the combination of the Call-ID along
with two tags, one from participant in the dialog.
to_uri
string
128
default no The URI of the TO header (as per INVITE)
to_tag
string
64
default no The tag parameter serves as a general mechanism to
identify a dialog, which is the combination of the Call-ID along
with two tags, one from participant in the dialog.
caller_cseq
string
7
default no Last Cseq number on the caller side.
callee_cseq
string
7
default no Last Cseq number on the caller side.
caller_route_set
text
512
default yes Route set on the caller side.
callee_route_set
text
512
default yes Route set on on the caller side.
caller_contact
string
128
default no Caller's contact uri.
callee_contact
string
128
default no Callee's contact uri.
caller_sock
string
64
default no Local socket used to communicate with caller
callee_sock
string
64
default no Local socket used to communicate with callee
state
unsigned int
10
default no The state of the dialog.
start_time
unsigned int
10
default no The timestamp (unix time) when the dialog was confirmed.
timeout
unsigned int
10
default no The timestamp (unix time) when the dialog will expire.
Table 8-2. Table "dialog" indexes
name type links description hash_idx
default hash_entry, hash_id
Table 9-1. Table "dialplan"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
dpid
int
11
default no Dialplan ID.
pr
int
11
default no Priority of rule.
match_op
int
11
default no Matching operator for rule (0-equal, 1-regexp).
match_exp
string
64
default no Matching expresion (regexp or string).
match_len
int
11
default no Length of the matching expresion (used only for equal operator).
subst_exp
string
64
default no Substitution expresion.
repl_exp
string
32
default no Replacement expresion (sed like).
attrs
string
32
default no General attributes string to be returned in case of rule matching.
Table 10-1. Table "dispatcher"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
setid
int
not specified
0 no Destination set id
destination
string
192
'' no Destination SIP address
flags
int
not specified
0 no Flags of destination SIP address
description
string
64
'' no Description for this destination
Table 11-1. Table "domain"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
domain
string
64
'' no Domain name
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this record was last modified.
Table 11-2. Table "domain" indexes
name type links description domain_idx
unique domain
Table 12-1. Table "domainpolicy"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
rule
string
255
default no Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs.
type
string
255
default no Domain policy rule type. In the case of federation names, this is "fed". For standard referrals according to draft-lendl-speermint-technical-policy-00, this is "std". For direct domain lookups, this is "dom". Default value is "type".
att
string
255
default yes It contains the AVP's name. If the rule stored in this row triggers, than dp_can_connect() will add an AVP with that name.
val
string
128
default yes It contains the values for AVPs created by dp_can_connect(). Default value is "val"
description
string
255
default no Comment about the rule
Table 12-2. Table "domainpolicy" indexes
name type links description rav_idx
unique rule, att, val
rule_idx
default rule
Table 13-1. Table "dr_gateways"
name type size default null key extra attributes description gwid
unsigned int
10
default no primary autoincrement GW unique ID - used to link the GW from
the routing rules
type
unsigned int
11
0 no Type/class of the GW (user defined)
address
string
128
default no GW/destination address as name/IP[:port]
strip
unsigned int
11
0 no Number of digits to be striped out for the begining
of the username when using this GW/destination
pri_prefix
string
16
NULL yes String to prefix the username of RURI when using
this GW/destination
attrs
string
255
NULL yes Generic string describing GW attributes - this string is
to be interpreted from the script
description
string
128
'' no Text description of the GW/destination
Table 13-2. Table "dr_rules"
name type size default null key extra attributes description ruleid
unsigned int
10
default no primary autoincrement Rule unique ID
groupid
string
255
default no The ID(s) of the routing group(s) this rule is to be
used for - comma separeted list of numerical Ids
prefix
string
64
default no Numerical prefix to match this rule
timerec
string
255
default no Time recurrence used for matching this rule.
priority
int
11
0 no Priority of this rule (among rules with same prefix
and timerec).
routeid
unsigned int
11
0 no Route block (from cfg script) to be called when rule
matches.
gwlist
string
255
default no Reference to the GWs/destinations to be used when
rule matches.
description
string
128
'' no Text description of the rule
Table 13-3. Table "dr_gw_lists"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
gwlist
string
255
default no Reference to the GWs/destinations from the list.
description
string
128
'' no Text description of the GW list
Table 13-4. Table "dr_groups"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
username
string
64
default no Username part of user
domain
string
128
'' no Domain part of user
groupid
string
255
default no The ID of the routing group the user belongs to.
description
string
128
'' no Text description of the group/user
Table 15-1. Table "grp"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
grp
string
64
'' no Group name
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this record was last modified.
Table 15-2. Table "grp" indexes
name type links description account_group_idx
unique username, domain, grp
Table 15-3. Table "re_grp"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
reg_exp
string
128
'' no Regular expression
group_id
int
11
0 no Group ID
Table 15-4. Table "re_grp" indexes
name type links description group_idx
default group_id
Table 16-1. Table "imc_rooms"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
name
string
64
default no Name of the room
domain
string
64
default no Domain of the room
flag
int
11
default no Flags
Table 16-2. Table "imc_rooms" indexes
name type links description name_domain_idx
unique name, domain
Table 16-3. Table "imc_members"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
default no Username
domain
string
64
default no Domain
room
string
64
default no
flag
int
11
default no Flags
Table 16-4. Table "imc_members" indexes
name type links description account_room_idx
unique username, domain, room
Table 17-1. Table "gw"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement
gw_name
string
128
default no Gateway Name
grp_id
unsigned int
not specified
default no Gateway ID
ip_addr
string
15
default no IP Address of the gateway
port
unsigned short
not specified
default yes Port of the gateway
uri_scheme
unsigned char
not specified
default yes URI scheme of the gateway
transport
unsigned char
not specified
default yes Transport type to be used for the gateway
strip
unsigned char
not specified
default yes The number of digits to strip from Request URI user part before inserting tag
tag
string
16
NULL yes Request URI user part tag
flags
unsigned int
not specified
0 no Gateway specific flags
Table 17-2. Table "gw" indexes
name type links description gw_name_idx
unique gw_name
grp_id_idx
default grp_id
Table 17-3. Table "lcr"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement
prefix
string
16
NULL yes Prefix of Request URI user part
from_uri
string
64
NULL yes Pattern that is matched to caller's URI
grp_id
unsigned int
not specified
default no Group ID
priority
unsigned int
not specified
default no Priority
Table 17-4. Table "lcr" indexes
name type links description prefix_idx
default prefix
from_uri_idx
default from_uri
grp_id_idx
default grp_id
Table 18-1. Table "load_balancer"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID of the destination
group_id
unsigned int
11
0 no The group the destination belongs to
dst_uri
string
128
default no Destination address as a SIP URI
resources
string
255
default no String with the definition of the resource provided
by the destination and the capacity of each resource
description
string
128
'' no Text description of the destination
Table 19-1. Table "silo"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
src_addr
string
128
'' no Source address - From URI
dst_addr
string
128
'' no Destination address - To URI
username
string
64
'' no SIP domain of target user
domain
string
64
'' no Username / phone number of target user
inc_time
int
not specified
0 no Incoming time
exp_time
int
not specified
0 no Expiration time
snd_time
int
not specified
0 no Reminder send time
ctype
string
32
'text/plain' no Content type
body
binary
not specified
'' no Body of the message
Table 19-2. Table "silo" indexes
name type links description account_idx
default username, domain
Table 20-1. Table "nh_sockets"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
rtpproxy_sock
text
not specified
default no A list of sockets use to connect to a set of RTPProxy.
Example: "udp:localhost:12221 udp:localhost:12222".
set_id
unsigned int
10
default no The ID of the RTPProxy set.
Table 21-1. Table "pdt"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
sdomain
string
128
default no Source domain
prefix
string
32
default no Prefix found in the username part of R-URI.
domain
string
128
'' no Domain corresponding to (sdomain, prefix) pair where the message must be sent.
Table 21-2. Table "pdt" indexes
name type links description sdomain_prefix_idx
unique sdomain, prefix
Table 22-1. Table "trusted"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
src_ip
string
50
default no Source address is equal to source address of request
proto
string
4
default no Transport protocol is either "any" or equal to transport protocol of request. Possible values that can be stored are "any", "udp", "tcp", "tls", and "sctp".
from_pattern
string
64
NULL yes Regular expression matches From URI of request.
tag
string
32
default yes Tag
Table 22-2. Table "trusted" indexes
name type links description peer_idx
default src_ip
Table 22-3. Table "address"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
grp
unsigned short
5
0 no Group
ip_addr
string
15
default no IP address
mask
char
not specified
32 no Network mask
port
unsigned short
5
0 no Port
Table 23-1. Table "presentity"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
username
string
64
default no User name
domain
string
64
default no Domain
event
string
64
default no Event
etag
string
64
default no User name
expires
int
11
default no Expires
received_time
int
11
default no Reveived time
body
binary
not specified
default no
sender
string
128
default no Sender contact
Table 23-2. Table "presentity" indexes
name type links description presentity_idx
unique username, domain, event, etag
Table 23-3. Table "active_watchers"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
presentity_uri
string
128
default no Presence URI
watcher_username
string
64
default no From User
watcher_domain
string
64
default no From Domain
to_user
string
64
default no To User
to_domain
string
64
default no To Domain
event
string
64
'presence' no Event description
event_id
string
64
default yes Event ID
to_tag
string
64
default no TO tag
from_tag
string
64
default no From tag
callid
string
64
default no Call ID
local_cseq
int
11
default no Local cseq
remote_cseq
int
11
default no Remote cseq
contact
string
64
default no Contact
record_route
text
not specified
default yes Record route
expires
int
11
default no Expires
status
int
11
2 no Status
reason
string
64
default no Reason
version
int
11
0 no Version
socket_info
string
64
default no Socket info
local_contact
string
128
default no Local contact
Table 23-4. Table "active_watchers" indexes
name type links description active_watchers_idx
unique presentity_uri, callid, to_tag, from_tag
Table 23-5. Table "watchers"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
presentity_uri
string
128
default no Presentity Uri
watcher_username
string
64
default no Watcher User
watcher_domain
string
64
default no Watcher Domain
event
string
64
'presence' no Event description
status
int
11
default no Status
reason
string
64
default yes Reason
inserted_time
int
11
default no
Table 23-6. Table "watchers" indexes
name type links description watcher_idx
unique presentity_uri, watcher_username, watcher_domain, event
Table 23-7. Table "xcap"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
username
string
64
default no User name
domain
string
64
default no Domain
doc
binary
not specified
default no doc
doc_type
int
11
default no Document type
etag
string
64
default no Document Etag
source
int
11
default no Entity inserting the record
doc_uri
string
128
default no Document uri
port
int
11
default no XCAP server port
Table 23-8. Table "xcap" indexes
name type links description account_doc_type_idx
unique username, domain, doc_type, doc_uri
source_idx
default source
Table 23-9. Table "pua"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
pres_uri
string
128
default no URI
pres_id
string
64
default no ID
event
int
11
default no Event
expires
int
11
default no Expires
desired_expires
int
11
default no Desired Expires
flag
int
11
default no Flags
etag
string
64
default no Etag
tuple_id
string
64
default yes Tuple ID
watcher_uri
string
128
default no Watcher URI
call_id
string
64
default no Call ID
to_tag
string
64
default no To tag
from_tag
string
64
default no To tag
cseq
int
11
default no
record_route
text
not specified
default yes Record route
contact
string
128
default no Contact
remote_contact
string
128
default no Remote contact
version
int
11
default no
extra_headers
text
not specified
default no Extra Headers
aliases This table for the registrar module is similar to the "location" table, (the aliases index makes lookup of missed calls much faster). Thus, the function lookup("alias") can be used to map aliases to AORs. More information is available at: http://www.opensips.org/html/docs/modules/1.5.xregistrar.html . Most people uses the dbaliases table with the alias_db module now.
Table 24-1. Table "aliases"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no Alias Username / Phone Number
domain
string
64
NULL yes Domain name
contact
string
255
'' no Contact header field value provides a URI whoses meaning depends on the type of request or response it is in.
received
string
128
NULL yes Received IP:PORT in the format SIP:IP:PORT
path
string
128
NULL yes Path Header(s) per RFC 3327
expires
datetime
not specified
'2020-05-28 21:32:15' no Date and time when this entry expires.
q
float
10,2
1.0 no Value used for preferential routing.
callid
string
255
'Default-Call-ID' no Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
cseq
int
11
13 no CSeq header field contains a single decimal sequence number and the request method.
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this entry was last modified.
flags
int
11
0 no Flags
cflags
int
11
0 no CFlags
user_agent
string
255
'' no User-Agent header field contains information about the UAC originating the request.
socket
string
64
NULL yes Socket used to connect to OpenSIPS. For example: UDP:IP:PORT
methods
int
11
NULL yes Flags that indicate the SIP Methods this contact will accept.
Table 24-2. Table "aliases" indexes
name type links description alias_idx
default username, domain, contact
Table 25-1. Table "rls_presentity"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
rlsubs_did
string
255
default no Resource list subscribe dialog id
resource_uri
string
128
default no List Uri
content_type
string
64
default no Event
presence_state
binary
not specified
default no
expires
int
11
default no Expires
updated
int
11
default no Update flag
auth_state
int
11
default no Watcher authorization state
reason
string
64
default no reason for watcher authorization state
Table 25-2. Table "rls_presentity" indexes
name type links description rls_presentity_idx
unique rlsubs_did, resource_uri
updated_idx
default updated
Table 25-3. Table "rls_watchers"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
presentity_uri
string
128
default no Presence URI
to_user
string
64
default no To user
to_domain
string
64
default no To domain
watcher_username
string
64
default no From user
watcher_domain
string
64
default no From domain
event
string
64
'presence' no Event description
event_id
string
64
default yes Event ID
to_tag
string
64
default no To tag
from_tag
string
64
default no From tag
callid
string
64
default no Call ID
local_cseq
int
11
default no Local cseq
remote_cseq
int
11
default no Remote cseq
contact
string
64
default no Contact
record_route
text
not specified
default yes Record route
expires
int
11
default no Expires
status
int
11
2 no Status
reason
string
64
default no Reason
version
int
11
0 no Version
socket_info
string
64
default no Socket info
local_contact
string
128
default no Local contact
Table 25-4. Table "rls_watchers" indexes
name type links description rls_watcher_idx
unique presentity_uri, callid, to_tag, from_tag
Table 26-1. Table "sip_trace"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
time_stamp
datetime
not specified
'1900-01-01 00:00:01' no Recording date
callid
string
255
'' no call ID from SIP message
traced_user
string
128
'' no SIP URI of the user being traced
msg
text
not specified
default no Full SIP message
method
string
32
'' no SIP method name
status
string
128
'' no SIP reply status
fromip
string
50
'' no Source IP address
toip
string
50
'' no Destination IP address
fromtag
string
64
'' no From tag
direction
string
4
'' no Destination IP address
Table 26-2. Table "sip_trace" indexes
name type links description traced_user_idx
default traced_user
date_idx
default time_stamp
fromip_idx
default fromip
callid_idx
default callid
Table 27-1. Table "speed_dial"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
sd_username
string
64
'' no Speed dial username
sd_domain
string
64
'' no Speed dial domain
new_uri
string
128
'' no New URI
fname
string
64
'' no First name
lname
string
64
'' no Last name
description
string
64
'' no Description
Table 27-2. Table "speed_dial" indexes
name type links description speed_dial_idx
unique username, domain, sd_domain, sd_username
Table 28-1. Table "version"
name type size default null key extra attributes description table_name
string
32
default no
table_version
unsigned int
not specified
0 no
Table 28-2. Table "version" indexes
name type links description t_name_idx
unique table_name
Table 29-1. Table "uri"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement
username
string
64
'' no Username / phone number
domain
string
64
'' no Domain name
uri_user
string
64
'' no Username / phone number
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this record was last modified.
Table 29-2. Table "uri" indexes
name type links description account_idx
unique username, domain, uri_user
Table 30-1. Table "userblacklist"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no The user that is used for the blacklist lookup.
domain
string
64
'' no The domain that is used for the blacklist lookup.
prefix
string
64
'' no The prefix that is matched for the blacklist.
whitelist
char
1
0 no Specify if this a blacklist (0) or a whitelist (1) entry.
Table 30-2. Table "userblacklist" indexes
name type links description userblacklist_idx
default username, domain, prefix
Table 30-3. Table "globalblacklist"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
prefix
string
64
'' no The prefix that is matched for the blacklist.
whitelist
char
1
0 no Specify if this a blacklist (0) or a whitelist (1) entry.
description
string
255
NULL yes A comment for the entry.
Table 30-4. Table "globalblacklist" indexes
name type links description globalblacklist_idx
default prefix
Table 31-1. Table "location"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
username
string
64
'' no Username / phone number
domain
string
64
NULL yes Domain name
contact
string
255
'' no Contact header field value provides a URI whoses meaning depends on the type of request or response it is in.
received
string
128
NULL yes Received IP:PORT in the format SIP:IP:PORT
path
string
128
NULL yes Path Header(s) per RFC 3327
expires
datetime
not specified
'2020-05-28 21:32:15' no Date and time when this entry expires.
q
float
10,2
1.0 no Value used for preferential routing.
callid
string
255
'Default-Call-ID' no Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client.
cseq
int
11
13 no CSeq header field contains a single decimal sequence number and the request method.
last_modified
datetime
not specified
'1900-01-01 00:00:01' no Date and time when this entry was last modified.
flags
int
11
0 no Flags
cflags
int
11
0 no CFlags
user_agent
string
255
'' no User-Agent header field contains information about the UAC originating the request.
socket
string
64
NULL yes Socket used to connect to OpenSIPS. For example: UDP:IP:PORT
methods
int
11
NULL yes Flags that indicate the SIP Methods this contact will accept.
Table 31-2. Table "location" indexes
name type links description account_contact_idx
default username, domain, contact
