OpenSIPS database tables
Copyright © 2007-2013 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.
duration
unsigned int
11
0 no Call duration (from 200OK INVITE to BYE request) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)
setuptime
unsigned int
11
0 no Call initialization duration - (from INVITE request to 200 OK INVITE) - this filed is populated only if CDR support is enabled in ACC module (see cdr_flag parameter)
created
datetime
not specified
NULL yes The call creation date and time.
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 "b2b_entities"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
type
int
2
default no Entity type: 0-server, 1-client
state
int
2
default no Dialog state
ruri
string
128
default yes RURI(stored only for server entities to correctly match CANCEL)
from_uri
string
128
default no From URI
to_uri
string
128
default no To URI
from_dname
string
64
default yes From display name
to_dname
string
64
default yes To display name
tag0
string
64
default no TO tag
tag1
string
64
default yes From tag
callid
string
64
default no Call ID
cseq0
int
11
default no Cseq0
cseq1
int
11
default yes Cseq1
contact0
string
128
default no Contact0
contact1
string
128
default yes Contact1
route0
text
not specified
default yes Record route 0
route1
text
not specified
default yes Record route 1
sockinfo_srv
string
64
default yes Socket Info
param
string
128
default no Logic parameter
lm
int
11
default no Last method
lrc
int
11
default yes Last reply code
lic
int
11
default yes Last invite cseq
leg_cseq
int
11
default yes Leg cseq
leg_route
text
not specified
default yes Leg route
leg_tag
string
64
default yes Leg tag
leg_contact
string
128
default yes Leg contact
leg_sockinfo
string
128
default yes Leg sockinfo
Table 5-2. Table "b2b_entities" indexes
name type links description b2b_entities_idx
unique type, tag0, tag1, callid
b2b_entities_param
default param
Table 5-3. Table "b2b_logic"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Unique ID
si_key
string
64
default no Scenario instantiation key
scenario
string
64
default no Scenario id
sstate
int
2
default no Scenario State
next_sstate
int
2
default no Next Scenario State
sparam0
string
64
default yes Scenario id
sparam1
string
64
default yes Scenario id
sparam2
string
64
default yes Scenario id
sparam3
string
64
default yes Scenario id
sparam4
string
64
default yes Scenario id
sdp
text
64
default yes Scenario id
lifetime
int
10
0 no Lifetime
e1_type
int
2
default no E1 type
e1_sid
string
64
default no E1 Scenario ID
e1_from
string
128
default no E1 From URI
e1_to
string
128
default no E1 To URI
e1_key
string
64
default no E1 Key
e2_type
int
2
default no E2 type
e2_sid
string
64
default no E2 Scenario ID
e2_from
string
128
default no E2 From URI
e2_to
string
128
default no E2 To URI
e2_key
string
64
default no E2 Key
e3_type
int
2
default yes E3 type
e3_sid
string
64
default yes E3 Scenario ID
e3_from
string
128
default yes E3 From URI
e3_to
string
128
default yes E3 To URI
e3_key
string
64
default yes E3 Key
Table 5-4. Table "b2b_logic" indexes
name type links description b2b_logic_idx
unique si_key
Table 6-1. Table "cachedb"
name type size default null key extra attributes description keyname
string
255
default no The Key
value
text
512
default no The value
counter
int
10
0 no The value of the counter
expires
unsigned int
10
0 no The unix timestamp when the key will expires
Table 7-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 7-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 7-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 8-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 8-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 9-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 9-2. Table "cpl" indexes
name type links description account_idx
unique username, domain
Table 10-1. Table "dialog"
name type size default null key extra attributes description dlg_id
unsigned long
10
default no primary h_entry | h_id
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.
mangled_from_uri
string
64
NULL yes The mangled from URI, in case uac_replace_from
was called for this dialog.
mangled_to_uri
string
64
NULL yes The mangled to URI, in case uac_replace_to
was called for this dialog
caller_cseq
string
11
default no Last Cseq number on the caller side.
callee_cseq
string
11
default no Last Cseq number on the callee side.
caller_ping_cseq
unsigned int
11
default no Last Cseq number of pings generated on caller side.
callee_ping_cseq
unsigned int
11
default no Last Cseq number of pings generated on callee 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.
vars
text
512
NULL yes Variables attached to this dialog.
profiles
text
512
NULL yes Profiles this dialog belongs to.
script_flags
unsigned int
10
0 no Script flags for the dialog.
flags
unsigned int
10
0 no Internal flags used by the module.
Table 11-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_flags
int
11
default no Matching flags (0-case sensitive, 1-case insensitive).
subst_exp
string
64
default no Substitution expresion.
repl_exp
string
32
default no Replacement expresion (sed like).
disabled
int
11
0 no Specifies if the command can be used, or is disabled.
attrs
string
32
default no General attributes string to be returned in case of rule matching.
Table 12-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
socket
string
128
NULL yes Local Socket to be used when sending requests (traffic and probes)
to the destination - must be an listener configured in opensips.
flags
int
not specified
0 no Flags of destination SIP address
weight
int
not specified
1 no The weight of the destination
attrs
string
128
'' no Attribute string - custom, opaque string that
will be pushed into script when this destination will
be selected
description
string
64
'' no Description for this destination
Table 13-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 13-2. Table "domain" indexes
name type links description domain_idx
unique domain
Table 14-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 14-2. Table "domainpolicy" indexes
name type links description rav_idx
unique rule, att, val
rule_idx
default rule
Table 15-1. Table "dr_gateways"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Table primary key, not used by module
gwid
string
64
default no 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
probe_mode
unsigned int
11
0 no 0- No probing; 1-Probe on disable only ; 2-Always probe;
description
string
128
'' no Text description of the GW/destination
Table 15-2. Table "dr_gateways" indexes
name type links description dr_gw_idx
unique gwid
Table 15-3. 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
string
255
NULL yes 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.
attrs
string
255
NULL yes Generic string describing RULE attributes - this string is
to be interpreted from the script
description
string
128
'' no Text description of the rule
Table 15-4. Table "dr_carriers"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement Table key, not used by module
carrierid
string
64
default no Unique ID of the carrier
gwlist
string
255
default no Reference to the GWs/destinations from the list.
flags
unsigned int
11
0 no Flags (for different purposes) of the carriers
attrs
string
255
'' yes Attributes string for the carrier
description
string
128
'' no Text description of the GW list
Table 15-5. Table "dr_carriers" indexes
name type links description dr_carrier_idx
unique carrierid
Table 15-6. 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
unsigned int
11
0 no The ID of the routing group the user belongs to.
description
string
128
'' no Text description of the group/user
Table 17-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 17-2. Table "grp" indexes
name type links description account_group_idx
unique username, domain, grp
Table 17-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 17-4. Table "re_grp" indexes
name type links description group_idx
default group_id
Table 18-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 18-2. Table "imc_rooms" indexes
name type links description name_domain_idx
unique name, domain
Table 18-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 18-4. Table "imc_members" indexes
name type links description account_room_idx
unique username, domain, room
Table 19-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
probe_mode
unsigned int
11
0 no Probing mode (0-none, 1-if disabled, 2-all the time)
description
string
128
'' no Text description of the destination
Table 19-2. Table "load_balancer" indexes
name type links description dsturi_idx
default dst_uri
Table 20-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 20-2. Table "silo" indexes
name type links description account_idx
default username, domain
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 "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
string
50
default no IP address
mask
char
not specified
32 no Network mask
port
unsigned short
5
0 no Port
proto
string
4
'any' 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".
pattern
string
64
NULL yes Regular expression
context_info
string
32
NULL yes Extra context information
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
extra_hdrs
binary
not specified
'' 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
128
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
255
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 yes Etag
tuple_id
string
64
default yes Tuple ID
watcher_uri
string
128
default yes Watcher URI
to_uri
string
128
default yes URI
call_id
string
64
default yes Call ID
to_tag
string
64
default yes To tag
from_tag
string
64
default yes From tag
cseq
int
11
default yes
record_route
text
not specified
default yes Record route
contact
string
128
default yes Contact
remote_contact
string
128
default yes Remote contact
version
int
11
default yes
extra_headers
text
not specified
default yes Extra Headers
Table 24-1. Table "registrant"
name type size default null key extra attributes description id
unsigned int
10
default no primary autoincrement unique ID
registrar
string
128
'' no URI pointing to the remote registrar.
proxy
string
128
NULL yes URI pointing to the outbond proxy.
aor
string
128
'' no URI defining the address of record.
third_party_registrant
string
128
NULL yes URI defining the third party registrant.
username
string
64
NULL yes Username for authentication.
password
string
64
NULL yes Password for authentication.
binding_URI
string
128
'' no Contact URI in REGISTER.
binding_params
string
64
NULL yes Contact params in REGISTER.
expiry
unsigned int
1
NULL yes Expiration time.
forced_socket
string
64
NULL yes socket for sending the REGISTER.
Table 24-2. Table "registrant" indexes
name type links description aor_idx
unique aor
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/devel/registrar.html . Most people uses the dbaliases table with the alias_db module now.
Table 25-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.
sip_instance
string
255
NULL yes SIP Instance for this particular contact
Table 25-2. Table "aliases" indexes
name type links description alias_idx
unique username, domain, contact, callid
Table 26-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
255
default no Content type
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 26-2. Table "rls_presentity" indexes
name type links description rls_presentity_idx
unique rlsubs_did, resource_uri
updated_idx
default updated
Table 26-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 26-4. Table "rls_watchers" indexes
name type links description rls_watcher_idx
unique presentity_uri, callid, to_tag, from_tag
Table 27-1. Table "rtpproxy_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 28-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
NULL yes 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
NULL yes 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 28-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 29-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 29-2. Table "speed_dial" indexes
name type links description speed_dial_idx
unique username, domain, sd_domain, sd_username
Table 30-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 30-2. Table "version" indexes
name type links description t_name_idx
unique table_name
Table 31-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 31-2. Table "uri" indexes
name type links description account_idx
unique username, domain, uri_user
Table 32-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 32-2. Table "userblacklist" indexes
name type links description userblacklist_idx
default username, domain, prefix
Table 32-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 32-4. Table "globalblacklist" indexes
name type links description globalblacklist_idx
default prefix
Table 33-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
'' no 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.
sip_instance
string
255
NULL yes SIP Instance for this particular contact
Table 33-2. Table "location" indexes
name type links description account_contact_idx
unique username, domain, contact, callid
