OpenSER database tables

OpenSER Development Team

http://www.openser-project.org/

Edited by

Henning Westerholt

Norman Brandinger

Table of Contents
1. Accounting
2. alias db
3. Subscriber
4. AVP Operations
5. carrierroute
6. Call-processing language
7. Dialog support
8. Dispatcher
9. Domain
10. Domainpolicy
11. Extensions
12. Group checking
13. Instant Message Conference
14. Least-cost Routing
15. Message Storage
16. Prefix-Domain Translation
17. Permissions
18. Presence
19. Registrar
20. RLS
21. SERWeb
22. SIPtrace
23. Speed dial
24. Version
25. SIP URI checks
26. User location

List of Tables
1-1. Table "acc"
1-2. Table "acc" indexes
1-3. Table "missed_calls"
1-4. Table "missed_calls" indexes
2-1. Table "dbaliases"
2-2. Table "dbaliases" indexes
3-1. Table "subscriber"
3-2. Table "subscriber" indexes
4-1. Table "usr_preferences"
4-2. Table "usr_preferences" indexes
5-1. Table "carrierroute"
5-2. Table "route_tree"
6-1. Table "cpl"
6-2. Table "cpl" indexes
7-1. Table "dialog"
7-2. Table "dialog" indexes
8-1. Table "dispatcher"
9-1. Table "domain"
9-2. Table "domain" indexes
10-1. Table "domainpolicy"
10-2. Table "domainpolicy" indexes
12-1. Table "grp"
12-2. Table "grp" indexes
12-3. Table "re_grp"
12-4. Table "re_grp" indexes
13-1. Table "imc_rooms"
13-2. Table "imc_rooms" indexes
13-3. Table "imc_members"
13-4. Table "imc_members" indexes
14-1. Table "gw"
14-2. Table "gw" indexes
14-3. Table "gw_grp"
14-4. Table "lcr"
14-5. Table "lcr" indexes
15-1. Table "silo"
15-2. Table "silo" indexes
16-1. Table "pdt"
16-2. Table "pdt" indexes
17-1. Table "trusted"
17-2. Table "trusted" indexes
17-3. Table "address"
18-1. Table "presentity"
18-2. Table "presentity" indexes
18-3. Table "active_watchers"
18-4. Table "active_watchers" indexes
18-5. Table "watchers"
18-6. Table "watchers" indexes
18-7. Table "xcap"
18-8. Table "xcap" indexes
18-9. Table "pua"
19-1. Table "aliases"
19-2. Table "aliases" indexes
20-1. Table "rls_presentity"
20-2. Table "rls_presentity" indexes
20-3. Table "rls_watchers"
20-4. Table "rls_watchers" indexes
21-1. Table "active_sessions"
21-2. Table "active_sessions" indexes
21-3. Table "pending"
21-4. Table "pending" indexes
21-5. Table "phonebook"
21-6. Table "usr_preferences_types"
21-7. Table "server_monitoring"
21-8. Table "server_monitoring" indexes
21-9. Table "server_monitoring_agg"
21-10. Table "admin_privileges"
21-11. Table "admin_privileges" indexes
22-1. Table "sip_trace"
22-2. Table "sip_trace" indexes
23-1. Table "speed_dial"
23-2. Table "speed_dial" indexes
24-1. Table "version"
25-1. Table "uri"
25-2. Table "uri" indexes
26-1. Table "location"
26-2. Table "location" indexes

Chapter 1. Accounting

acc: This table is used by the ACC module to report on transactions - accounted calls. More information is available at: http://www.openser.org/docs/modules/devel/acc.html
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.openser.org/docs/modules/devel/acc.html

Table 1-1. Table "acc"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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`		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`		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`		no			Date and time when this record was written.

Table 1-4. Table "missed_calls" indexes

name	type	links	description
`callid_idx`	default	callid

Chapter 2. alias db

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.openser.org/docs/modules/devel/alias_db.html

Table 2-1. Table "dbaliases"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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

Chapter 3. Subscriber

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

Table 3-1. Table "subscriber"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`username`	`string`	`64`	''	no			Username / phone number
`domain`	`string`	`64`	''	no			Domain name
`password`	`string`	`25`	''	no			Password
`first_name`	`string`	`64`	''	no			First name
`last_name`	`string`	`64`	''	no			Last name
`email_address`	`string`	`64`	''	no			Email address
`datetime_created`	`datetime`	`not specified`	'1900-01-01 00:00:01'	no			Date and time when this record was created
`ha1`	`string`	`64`	''	no			md5(username:realm:password)
`ha1b`	`string`	`64`	''	no			md5(username@domain:realm:password)
`timezone`	`string`	`64`	NULL	yes			User's time zone
`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

Chapter 4. AVP Operations

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.openser.org/docs/modules/devel/avpops.html

Table 4-1. Table "usr_preferences"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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

Chapter 5. carrierroute

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

Table 5-1. Table "carrierroute"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	unique ID
`carrier`	`unsigned int`	`10`	'0'	no			This column contains the carrier id.
`scan_prefix`	`string`	`64`	''	no			This column contains the scan prefix, which define the matching portion of a phone number.
`domain`	`string`	`64`	''	no			This column contains the route domain. Additional domains could be used for example as fallback.
`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.
`comment`	`string`	`255`	NULL	yes			A comment for the route entry, useful for larger routing tables.

Table 5-2. Table "route_tree"

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

Chapter 6. Call-processing language

cpl: Table for the call processing language "cpl" module. More information is available at: http://www.openser.org/docs/modules/devel/cpl-c.html

Table 6-1. Table "cpl"

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

Table 6-2. Table "cpl" indexes

name	type	links	description
`account_idx`	unique	username, domain

Chapter 7. Dialog support

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

Table 7-1. Table "dialog"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	unique ID
`hash_entry`	`unsigned int`	`10`	no			Number of the hash entry in the dialog hash table
`hash_id`	`unsigned int`	`10`	no			The ID on the hash entry
`callid`	`string`	`255`	no			Call-ID of the dialog
`from_uri`	`string`	`128`	no			The URI of the FROM header (as per INVITE)
`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_uri`	`string`	`128`	no			The URI of the TO header (as per INVITE)
`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.
`caller_cseq`	`string`	`7`	no			Last Cseq number on the caller side.
`callee_cseq`	`string`	`7`	no			Last Cseq number on the caller side.
`caller_route_set`	`string`	`512`	yes			Route set on the caller side.
`callee_route_set`	`string`	`512`	yes			Route set on on the caller side.
`caller_contact`	`string`	`128`	no			Caller's contact uri.
`callee_contact`	`string`	`128`	no			Callee's contact uri.
`caller_sock`	`string`	`64`	no			Local socket used to communicate with caller
`callee_sock`	`string`	`64`	no			Local socket used to communicate with callee
`state`	`unsigned int`	`10`	no			The state of the dialog.
`start_time`	`unsigned int`	`10`	no			The timestamp (unix time) when the dialog was confirmed.
`timeout`	`unsigned int`	`10`	no			The timestamp (unix time) when the dialog will expire.

Table 7-2. Table "dialog" indexes

name	type	links	description
`hash_idx`	default	hash_entry, hash_id

Chapter 8. Dispatcher

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.openser.org/docs/modules/devel/dispatcher.html

Table 8-1. Table "dispatcher"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	unique ID
`setid`	`int`	`not specified`	'0'	no			Destination set id
`destination`	`string`	`192`	''	no			Destination SIP address
`description`	`string`	`64`	''	no			Description for this destination

Chapter 9. Domain

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.openser.org/docs/modules/devel/domain.html

Table 9-1. Table "domain"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 9-2. Table "domain" indexes

name	type	links	description
`domain_idx`	unique	domain

Chapter 10. Domainpolicy

domainpolicy: Table for the domainpolicy module. More information at http://www.openser.org/docs/modules/devel/domainpolicy.html.

Table 10-1. Table "domainpolicy"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	unique ID
`rule`	`string`	`255`	no			Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs.
`type`	`string`	`255`	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`	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`	yes			It contains the values for AVPs created by dp_can_connect(). Default value is "val"
`comment`	`string`	`255`	no			Comment about the rule

Table 10-2. Table "domainpolicy" indexes

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

Chapter 11. Extensions

Chapter 12. Group checking

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.openser.org/docs/modules/devel/group.html
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.openser.org/docs/modules/devel/group.html

Table 12-1. Table "grp"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 12-2. Table "grp" indexes

name	type	links	description
`account_group_idx`	unique	username, domain, grp

Table 12-3. Table "re_grp"

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

Table 12-4. Table "re_grp" indexes

name	type	links	description
`group_idx`	default	group_id

Chapter 13. Instant Message Conference

imc_rooms: Room table for the IMC module. More information at http://www.openser.org/docs/modules/devel/imc.html.
imc_members: Member table for the IMC module. More information at http://www.openser.org/docs/modules/devel/imc.html.

Table 13-1. Table "imc_rooms"

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

Table 13-2. Table "imc_rooms" indexes

name	type	links	description
`name_domain_idx`	unique	name, domain

Table 13-3. Table "imc_members"

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

Table 13-4. Table "imc_members" indexes

name	type	links	description
`account_room_idx`	unique	username, domain, room

Chapter 14. Least-cost Routing

gw: This table contains Least Cost Routing Gateway definitions for the LCR module. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.
gw_grp: This table is used from the lcr module for administrative purposes only to associate names with gateway group ids. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.
lcr: This table is used by the lcr (Least Cost Routing) rules. More information can be found at: http://www.openser.org/docs/modules/devel/lcr.html.

Table 14-1. Table "gw"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement
`gw_name`	`string`	`128`		no			Gateway Name
`grp_id`	`unsigned int`	`not specified`		no			Gateway ID
`ip_addr`	`string`	`15`		no			IP Address of the gateway
`port`	`unsigned short`	`not specified`		yes			Port of the gateway
`uri_scheme`	`unsigned char`	`not specified`		yes			URI scheme of the gateway
`transport`	`unsigned char`	`not specified`		yes			Transport type to be used for the gateway
`strip`	`unsigned char`	`not specified`		yes			The number of digits to strip from the RURI before applying the prefix.
`prefix`	`string`	`16`	NULL	yes			The R-URI(destination) prefix
`dm`	`unsigned char`	`not specified`	'1'	no			Does gateway support directed media (0 = no, 1 = yes)

Table 14-2. Table "gw" indexes

name	type	links	description
`gw_name_idx`	unique	gw_name
`grp_id_idx`	default	grp_id

Table 14-3. Table "gw_grp"

name	type	size	default	null	key	extra attributes	description
`grp_id`	`unsigned int`	`not specified`		no	primary	autoincrement	Group ID
`grp_name`	`string`	`64`		no			Group name

Table 14-4. Table "lcr"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement
`prefix`	`string`	`16`	NULL	yes			The Request-URI (destination) prefix.
`from_uri`	`string`	`64`	NULL	yes			The FROM (source) URI.
`grp_id`	`unsigned int`	`not specified`		no			Group ID
`priority`	`unsigned char`	`not specified`		no			Priority

Table 14-5. Table "lcr" indexes

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

Chapter 15. Message Storage

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.openser.org/docs/modules/devel/msilo.html

Table 15-1. Table "silo"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 15-2. Table "silo" indexes

name	type	links	description
`account_idx`	default	username, domain

Chapter 16. Prefix-Domain Translation

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.openser.org/docs/modules/devel/pdt.html

Table 16-1. Table "pdt"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`sdomain`	`string`	`128`		no			Source domain
`prefix`	`string`	`32`		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 16-2. Table "pdt" indexes

name	type	links	description
`sdomain_prefix_idx`	unique	sdomain, prefix

Chapter 17. Permissions

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.openser.org/docs/modules/devel/permissions.html
address: This table is used by the permissions module. More information is available at: http://www.openser.org/docs/modules/devel/permissions.html

Table 17-1. Table "trusted"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	unique ID
`src_ip`	`string`	`50`		no			Source address is equal to source address of request
`proto`	`string`	`4`		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`		yes			Tag

Table 17-2. Table "trusted" indexes

name	type	links	description
`peer_idx`	default	src_ip

Table 17-3. Table "address"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	unique ID
`grp`	`unsigned short`	`5`	'0'	no			Group
`ip_addr`	`string`	`15`		no			IP address
`mask`	`char`	`not specified`	'32'	no			Network mask
`port`	`unsigned short`	`5`	'0'	no			Port

Chapter 18. Presence

presentity: Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html
active_watchers: Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html
watchers: Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html
xcap: Table for the presence module. More information can be found at: http://www.openser.org/docs/modules/devel/presence.html
pua: Table for the presence related pua module. More information can be found at: http://www.openser.org/docs/modules/devel/pua.html

Table 18-1. Table "presentity"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	Unique ID
`username`	`string`	`64`	no			User name
`domain`	`string`	`64`	no			Domain
`event`	`string`	`64`	no			Event
`etag`	`string`	`64`	no			User name
`expires`	`int`	`11`	no			Expires
`received_time`	`int`	`11`	no			Reveived time
`body`	`binary`	`not specified`	no

Table 18-2. Table "presentity" indexes

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

Table 18-3. Table "active_watchers"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`presentity_uri`	`string`	`128`		no			Presence URI
`watcher_username`	`string`	`64`		no			From User
`watcher_domain`	`string`	`64`		no			From Domain
`to_user`	`string`	`64`		no			To User
`to_domain`	`string`	`64`		no			To Domain
`event`	`string`	`64`	'presence'	no			Event description
`event_id`	`string`	`64`		yes			Event ID
`to_tag`	`string`	`64`		no			TO tag
`from_tag`	`string`	`64`		no			From tag
`callid`	`string`	`64`		no			Call ID
`local_cseq`	`int`	`11`		no			Local cseq
`remote_cseq`	`int`	`11`		no			Remote cseq
`contact`	`string`	`64`		no			Contact
`record_route`	`text`	`not specified`		yes			Record route
`expires`	`int`	`11`		no			Expires
`status`	`int`	`11`	'2'	no			Status
`reason`	`string`	`64`		no			Reason
`version`	`int`	`11`	'0'	no			Version
`socket_info`	`string`	`64`		no			Socket info
`local_contact`	`string`	`128`		no			Local contact

Table 18-4. Table "active_watchers" indexes

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

Table 18-5. Table "watchers"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`presentity_uri`	`string`	`128`		no			Presentity Uri
`watcher_username`	`string`	`64`		no			Watcher User
`watcher_domain`	`string`	`64`		no			Watcher Domain
`event`	`string`	`64`	'presence'	no			Event description
`status`	`int`	`11`		no			Status
`reason`	`string`	`64`		yes			Reason
`inserted_time`	`int`	`11`		no

Table 18-6. Table "watchers" indexes

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

Table 18-7. Table "xcap"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	Unique ID
`username`	`string`	`64`	no			User name
`domain`	`string`	`64`	no			Domain
`doc`	`binary`	`not specified`	no			doc
`doc_type`	`int`	`11`	no			Document type
`etag`	`string`	`64`	no			Document Etag
`source`	`int`	`11`	no			Entity inserting the record
`doc_uri`	`string`	`128`	no			Document uri
`port`	`int`	`11`	no			XCAP server port

Table 18-8. Table "xcap" indexes

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

Table 18-9. Table "pua"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	Unique ID
`pres_uri`	`string`	`128`	no			URI
`pres_id`	`string`	`64`	no			ID
`event`	`int`	`11`	no			Event
`expires`	`int`	`11`	no			Expires
`desired_expires`	`int`	`11`	no			Desired Expires
`flag`	`int`	`11`	no			Flags
`etag`	`string`	`64`	no			Etag
`tuple_id`	`string`	`64`	yes			Tuple ID
`watcher_uri`	`string`	`128`	no			Watcher URI
`call_id`	`string`	`64`	no			Call ID
`to_tag`	`string`	`64`	no			To tag
`from_tag`	`string`	`64`	no			To tag
`cseq`	`int`	`11`	no
`record_route`	`text`	`not specified`	yes			Record route
`contact`	`string`	`128`	no			Contact
`version`	`int`	`11`	no
`extra_headers`	`text`	`not specified`	no			Extra Headers

Chapter 19. Registrar

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.openser.org/docs/modules/devel/registrar.html. Most people uses the dbaliases table with the alias_db module now.

Table 19-1. Table "aliases"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 OpenSER. For example: UDP:IP:PORT
`methods`	`int`	`11`	NULL	yes			Flags that indicate the SIP Methods this contact will accept.

Table 19-2. Table "aliases" indexes

name	type	links	description
`alias_idx`	default	username, domain, contact

Chapter 20. RLS

rls_presentity: Table for the RLS module.
rls_watchers: Table for RLS module used for storing resource lists subscribe information.

Table 20-1. Table "rls_presentity"

name	type	size	null	key	extra attributes	description
`id`	`unsigned int`	`10`	no	primary	autoincrement	Unique ID
`rlsubs_did`	`string`	`512`	no			Resource list subscribe dialog id
`resource_uri`	`string`	`128`	no			List Uri
`content_type`	`string`	`64`	no			Event
`presence_state`	`binary`	`not specified`	no
`expires`	`int`	`11`	no			Expires
`updated`	`int`	`11`	no			Update flag
`auth_state`	`int`	`11`	no			Watcher authorization state
`reason`	`string`	`64`	no			reason for watcher authorization state

Table 20-2. Table "rls_presentity" indexes

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

Table 20-3. Table "rls_watchers"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`presentity_uri`	`string`	`128`		no			Presence URI
`to_user`	`string`	`64`		no			To user
`to_domain`	`string`	`64`		no			To domain
`watcher_username`	`string`	`64`		no			From user
`watcher_domain`	`string`	`64`		no			From domain
`event`	`string`	`64`	'presence'	no			Event description
`event_id`	`string`	`64`		yes			Event ID
`to_tag`	`string`	`64`		no			To tag
`from_tag`	`string`	`64`		no			From tag
`callid`	`string`	`64`		no			Call ID
`local_cseq`	`int`	`11`		no			Local cseq
`remote_cseq`	`int`	`11`		no			Remote cseq
`contact`	`string`	`64`		no			Contact
`record_route`	`text`	`not specified`		yes			Record route
`expires`	`int`	`11`		no			Expires
`status`	`int`	`11`	'2'	no			Status
`reason`	`string`	`64`		no			Reason
`version`	`int`	`11`	'0'	no			Version
`socket_info`	`string`	`64`		no			Socket info
`local_contact`	`string`	`128`		no			Local contact

Table 20-4. Table "rls_watchers" indexes

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

Chapter 21. SERWeb

active_sessions: This table is used by SERWeb to maintain active sessions. It is not used by OpenSER.
pending: SerWEB specific table - Not used by OpenSER. It should have same structure as table subscriber and contains unconfirmed subscription requests.
phonebook: Users Phonebook table used from SERWeb.
usr_preferences_types: User preferences table for SERWeb.
server_monitoring: Server monitoring table used from SERWeb.
server_monitoring_agg: Server monitoring table used from SERWeb.
admin_privileges: Admin privileges table for SERWeb for multidomain ACL control.

Table 21-1. Table "active_sessions"

name	type	size	default	null	description
`sid`	`string`	`32`	''	no	Session ID
`name`	`string`	`32`	''	no	Session Name
`val`	`text`	`not specified`		yes	Val
`changed`	`string`	`14`	''	no	Domain corresponding to (sdomain, prefix) pair where the message must be sent.

Table 21-2. Table "active_sessions" indexes

name	type	links	description
`sw_as_idx`	primary	name, sid
`changed`	default	changed

Table 21-3. Table "pending"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`phplib_id`	`string`	`32`	''	no			PHP Library ID
`username`	`string`	`64`	''	no			Username / Phone Number
`domain`	`string`	`64`	''	no			Domain name
`password`	`string`	`25`	''	no			Password
`firstname`	`string`	`25`	''	no			First name
`lastname`	`string`	`45`	''	no			Last name
`phone`	`string`	`15`	''	no
`email_address`	`string`	`50`	''	no			Email Address
`datetime_created`	`datetime`	`not specified`	'1900-01-01 00:00:01'	no			Date / Time this record was created
`datetime_modified`	`datetime`	`not specified`	'1900-01-01 00:00:01'	no			Date / Time this record was modified
`confirmation`	`string`	`64`	''	no			Confirmation
`flag`	`string`	`1`	'o'	no			Flag
`sendnotification`	`string`	`50`	''	no			Send notification
`greeting`	`string`	`50`	''	no			Greeting
`ha1`	`string`	`64`	''	no			md5(username:realm:password)
`ha1b`	`string`	`64`	''	no			md5(username@domain:realm:password)
`allow_find`	`string`	`1`	'0'	no			Allow find Flag
`timezone`	`string`	`64`	NULL	yes			Users time zone
`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 21-4. Table "pending" indexes

name	type	links
`sw_user_id`	unique	username, domain
`phplib_id`	unique	phplib_id
`username_id`	default	username

Table 21-5. Table "phonebook"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		no	primary	autoincrement	Unique ID
`username`	`string`	`64`	''	no			Username / Phonenumber
`domain`	`string`	`64`	''	no			Domain Name
`fname`	`string`	`32`	''	no			First Nname
`lname`	`string`	`32`	''	no			Last Name
`sip_uri`	`string`	`64`	''	no			SIP URI associated with this record

Table 21-6. Table "usr_preferences_types"

name	type	size	default	null	key	description
`att_name`	`string`	`32`	''	no	primary	att_name
`att_rich`	`string`	`32`	'string'	no		att_rich
`att_raw_type`	`int`	`not specified`	'2'	no		att_raw
`att_type_spec`	`text`	`not specified`		no		att_type_spec
`default_value`	`string`	`100`	''	no		Default Value

Table 21-7. Table "server_monitoring"

name	type	size	default	null	description
`id`	`unsigned int`	`10`	'0'	no	Unique ID
`time`	`datetime`	`not specified`	'1900-01-01 00:00:01'	no	Time
`param`	`string`	`32`	''	no	Param
`value`	`int`	`10`	'0'	no	Value
`increment`	`int`	`10`	'0'	no	Increment

Table 21-8. Table "server_monitoring" indexes

name	type	links	description
`sw_sm_idx`	primary	id, param

Table 21-9. Table "server_monitoring_agg"

name	type	size	default	null	key	description
`param`	`string`	`32`	''	no	primary	Param
`s_value`	`int`	`10`	'0'	no		s_value
`s_increment`	`int`	`10`	'0'	no		s_increment
`last_aggregated_increment`	`int`	`10`	'0'	no		last aggregated increment
`av`	`float`	`not specified`	'0'	no		av
`mv`	`int`	`10`	'0'	no		mv
`ad`	`float`	`not specified`	'0'	no		ad
`lv`	`int`	`10`	'0'	no		lv
`min_val`	`int`	`10`	'0'	no		minimum value
`max_val`	`int`	`10`	'0'	no		maximum value
`min_inc`	`int`	`10`	'0'	no		minimal increment
`max_inc`	`int`	`10`	'0'	no		maximal increment
`lastupdate`	`datetime`	`not specified`	'1900-01-01 00:00:01'	no		last update time and date

Table 21-10. Table "admin_privileges"

name	type	size	default	null	description
`username`	`string`	`64`	''	no	Username
`domain`	`string`	`64`	''	no	Domain
`priv_name`	`string`	`64`	''	no	priv_name
`priv_value`	`string`	`64`	''	no	priv_value

Table 21-11. Table "admin_privileges" indexes

name	type	links	description
`sw_ap_idx`	primary	username, priv_name, priv_value, domain

Chapter 22. SIPtrace

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.openser.org/docs/modules/devel/siptrace.html.

Table 22-1. Table "sip_trace"

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

Table 22-2. Table "sip_trace" indexes

name	type	links
`traced_user_idx`	default	traced_user
`date_idx`	default	date
`fromip_idx`	default	fromip
`callid_idx`	default	callid

Chapter 23. Speed dial

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.openser.org/docs/modules/devel/speeddial.html

Table 23-1. Table "speed_dial"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 23-2. Table "speed_dial" indexes

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

Chapter 24. Version

version

Table 24-1. Table "version"

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

Chapter 25. SIP URI checks

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.openser.org/docs/modules/devel/uri_db.html

Table 25-1. Table "uri"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 25-2. Table "uri" indexes

name	type	links	description
`account_idx`	unique	username, domain, uri_user

Chapter 26. User location

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

Table 26-1. Table "location"

name	type	size	default	null	key	extra attributes	description
`id`	`unsigned int`	`10`		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 OpenSER. For example: UDP:IP:PORT
`methods`	`int`	`11`	NULL	yes			Flags that indicate the SIP Methods this contact will accept.

Table 26-2. Table "location" indexes

name	type	links	description
`account_contact_idx`	default	username, domain, contact