DB schema

Accounting

Table “acc”

This table is used by the ACC module to report on transactions - accounted calls. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/acc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
callid_idx	default	callid

Table “missed_calls”

This table is used by the ACC module for keeping track of missed calls. This table is similar to the ‘acc’ table. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/acc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
callid_idx	default	callid

alias db

Table “dbaliases”

This table us used by the alias_db module as an alternative for user aliases via userloc. More information about the alias_db module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/alias_db.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Indexes

name	type	links	description
alias_idx	unique	alias_username, alias_domain
target_idx	default	username, domain

Subscriber

Table “subscriber”

This table is used to provide authentication information. More information about the auth_db module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/auth_db.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
account_idx	unique	username, domain
username_idx	default	username

AVP Operations

Table “usr_preferences”

This table us used by the avpops module to implement Attribute Value Pairs (AVP’s). More information about the avpops module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/avpops.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
ua_idx	default	uuid, attribute
uda_idx	default	username, domain, attribute

carrierroute

Table “carrierroute”

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/docs/modules/devel/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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 “carrierfailureroute”

This table is used by the carrierroute module to provide failure routing capabilities. More information is available at: http://www.opensips.org/docs/modules/devel/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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 “route_tree”

This table is used by the carrierroute module to provides routing, balancing and blacklisting capabilities. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/carrierroute.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
carrier	string	64	NULL	yes	This column contains the carrier name.

Call-processing language

Table “cpl”

Table for the call processing language “cpl” module. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/cpl-c.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
username	string	64	default	no
domain	string	64	”	no
cpl_xml	text	not specified	default	yes
cpl_bin	text	not specified	default	yes

Indexes

name	type	links	description
account_idx	unique	username, domain

Dialog support

Table “dialog”

Persistent dialog information for the dialog module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/dialog.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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	string	512	default	yes	Route set on the caller side.
callee_route_set	string	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.

Indexes

name	type	links	description
hash_idx	default	hash_entry, hash_id

Matching and translation rules

Table “dialplan”

This table is used by the dialplan module for the translation rules. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/dialplan.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Dispatcher

Table “dispatcher”

This table is used by the dispatcher module. It contains the sets of destinations used for load balancing and dispatching. More information about the dispatcher module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/dispatcher.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Domain

Table “domain”

This table is used by the domain module to determine if a host part of a URI is “local” or not. More information about the domain module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/domain.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
domain_idx	unique	domain

Domainpolicy

Table “domainpolicy”

Table for the domainpolicy module. More information at http://www.opensips.org/html/docs/modules/1.4.x/domainpolicy.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Indexes

name	type	links	description
rav_idx	unique	rule, att, val
rule_idx	default	rule

Extensions

Group checking

Table “grp”

This table us used by the group module as a means of group membership checking. Used primarily for Access Control Lists (ACL’s). More information about the group module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/group.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
account_group_idx	unique	username, domain, grp

Table “re_grp”

This table is used by the group module to check membership based on regular expressions. More information about the group module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/group.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
reg_exp	string	128	”	no	Regular expression
group_id	int	11	0	no	Group ID

Indexes

name	type	links	description
group_idx	default	group_id

Instant Message Conference

Table “imc_rooms”

Room table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.4.x/imc.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
name	string	64	default	no	Name of the room
domain	string	64	default	no	Domain of the room
flag	int	11	default	no	Flags

Indexes

name	type	links	description
name_domain_idx	unique	name, domain

Table “imc_members”

Member table for the IMC module. More information at http://www.opensips.org/html/docs/modules/1.4.x/imc.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
username	string	64	default	no	Username
domain	string	64	default	no	Domain
room	string	64	default	no
flag	int	11	default	no	Flags

Indexes

name	type	links	description
account_room_idx	unique	username, domain, room

Least-cost Routing

Table “gw”

This table contains Least Cost Routing Gateway definitions for the LCR module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/lcr.html.

name	type	size	default	null	description	key	extra attributes
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

Indexes

name	type	links	description
gw_name_idx	unique	gw_name
grp_id_idx	default	grp_id

Table “lcr”

This table is used by the lcr (Least Cost Routing) rules. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/lcr.html.

name	type	size	default	null	description	key	extra attributes
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

Indexes

name	type	links	description
prefix_idx	default	prefix
from_uri_idx	default	from_uri
grp_id_idx	default	grp_id

Message Storage

Table “silo”

This table us used by the msilo module to provide offline message storage More information about the msilo module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/msilo.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Indexes

name	type	links	description
account_idx	default	username, domain

Prefix-Domain Translation

Table “pdt”

Prefix-Domain Translation means to change the host and port in R-URI, based on the prefix found in R-URI and source domain (that is domain in From-URI). More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/pdt.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
sdomain_prefix_idx	unique	sdomain, prefix

Permissions

Table “trusted”

This table is used by the permissions module to determine if a call has the appropriate permission to be established. More information about the permissions module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/permissions.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Indexes

name	type	links	description
peer_idx	default	src_ip

Table “address”

This table is used by the permissions module. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/permissions.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Presence

Table “presentity”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
presentity_idx	unique	username, domain, event, etag

Table “active_watchers”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
active_watchers_idx	unique	presentity_uri, callid, to_tag, from_tag

Table “watchers”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
watcher_idx	unique	presentity_uri, watcher_username, watcher_domain, event

Table “xcap”

Table for the presence module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/presence.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
account_doc_type_idx	unique	username, domain, doc_type, doc_uri
source_idx	default	source

Table “pua”

Table for the presence related pua module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/pua.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Registrar

Table “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.4.x/registrar.html. Most people uses the dbaliases table with the alias_db module now.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
alias_idx	default	username, domain, contact

RLS

Table “rls_presentity”

Table for the RLS module.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
rls_presentity_idx	unique	rlsubs_did, resource_uri
updated_idx	default	updated

Table “rls_watchers”

Table for RLS module used for storing resource lists subscribe information.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	Unique ID	primary	autoincrement
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

Indexes

name	type	links	description
rls_watcher_idx	unique	presentity_uri, callid, to_tag, from_tag

SIPtrace

Table “sip_trace”

This table is used to store incoming/outgoing SIP messages in database. More informations can be found in the siptrace module documentation at: http://www.opensips.org/html/docs/modules/1.4.x/siptrace.html.

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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	50	”	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

Indexes

name	type	links	description
traced_user_idx	default	traced_user
date_idx	default	time_stamp
fromip_idx	default	fromip
callid_idx	default	callid

Speed dial

Table “speed_dial”

This table is used by the speeddial module to provide on-server speed dial facilities. More information about the speeddial module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/speeddial.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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

Indexes

name	type	links	description
speed_dial_idx	unique	username, domain, sd_domain, sd_username

Version

Table “version”

name	type	size	default	null	description	key	extra attributes
table_name	string	32	default	no
table_version	unsigned int	not specified	0	no

SIP URI checks

Table “uri”

This table is used by uri_db module to implement various SIP URI checks. More information about the uri_db module can be found at: http://www.opensips.org/html/docs/modules/1.4.x/uri_db.html

name	type	size	default	null	description	key	extra attributes
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.

Indexes

name	type	links	description
account_idx	unique	username, domain, uri_user

User and global blacklists

Table “userblacklist”

This table is used by the userblacklist module for the user specific blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/userblacklist.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
userblacklist_idx	default	username, domain, prefix

Table “globalblacklist”

This table is used by the userblacklist module for the global blacklists. More information is available at: http://www.opensips.org/html/docs/modules/1.4.x/userblacklist.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
globalblacklist_idx	default	prefix

User location

Table “location”

Persistent user location information for the usrloc module. More information can be found at: http://www.opensips.org/html/docs/modules/1.4.x/usrloc.html

name	type	size	default	null	description	key	extra attributes
id	unsigned int	10	default	no	unique ID	primary	autoincrement
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.

Indexes

name	type	links	description
account_contact_idx	default	username, domain, contact