OpenSIPS database tables

OpenSIPS Development Team

http://www.opensips.org/

Table of Contents
1. Accounting
2. alias db
3. Subscriber
4. AVP Operations
5. B2BUA
6. CacheDB_SQL
7. carrierroute
8. Accounting
9. Call-processing language
10. Dialog support
11. Matching and translation rules
12. Dispatcher
13. Domain
14. Domainpolicy
15. Dynamic Routing
16. Extensions
17. Group checking
18. Instant Message Conference
19. Load Balancer
20. Message Storage
21. Prefix-Domain Translation
22. Permissions
23. Presence
24. Registrant support
25. Registrar
26. RLS
27. RTPProxy
28. SIPtrace
29. Speed dial
30. Version
31. SIP URI checks
32. User and global blacklists
33. 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 "b2b_entities"
5-2. Table "b2b_entities" indexes
5-3. Table "b2b_logic"
5-4. Table "b2b_logic" indexes
6-1. Table "cachedb"
7-1. Table "carrierroute"
7-2. Table "carrierfailureroute"
7-3. Table "route_tree"
8-1. Table "closeddial"
8-2. Table "closeddial" indexes
9-1. Table "cpl"
9-2. Table "cpl" indexes
10-1. Table "dialog"
11-1. Table "dialplan"
12-1. Table "dispatcher"
13-1. Table "domain"
13-2. Table "domain" indexes
14-1. Table "domainpolicy"
14-2. Table "domainpolicy" indexes
15-1. Table "dr_gateways"
15-2. Table "dr_gateways" indexes
15-3. Table "dr_rules"
15-4. Table "dr_carriers"
15-5. Table "dr_carriers" indexes
15-6. Table "dr_groups"
17-1. Table "grp"
17-2. Table "grp" indexes
17-3. Table "re_grp"
17-4. Table "re_grp" indexes
18-1. Table "imc_rooms"
18-2. Table "imc_rooms" indexes
18-3. Table "imc_members"
18-4. Table "imc_members" indexes
19-1. Table "load_balancer"
19-2. Table "load_balancer" indexes
20-1. Table "silo"
20-2. Table "silo" indexes
21-1. Table "pdt"
21-2. Table "pdt" indexes
22-1. Table "address"
23-1. Table "presentity"
23-2. Table "presentity" indexes
23-3. Table "active_watchers"
23-4. Table "active_watchers" indexes
23-5. Table "watchers"
23-6. Table "watchers" indexes
23-7. Table "xcap"
23-8. Table "xcap" indexes
23-9. Table "pua"
24-1. Table "registrant"
24-2. Table "registrant" indexes
25-1. Table "aliases"
25-2. Table "aliases" indexes
26-1. Table "rls_presentity"
26-2. Table "rls_presentity" indexes
26-3. Table "rls_watchers"
26-4. Table "rls_watchers" indexes
27-1. Table "rtpproxy_sockets"
28-1. Table "sip_trace"
28-2. Table "sip_trace" indexes
29-1. Table "speed_dial"
29-2. Table "speed_dial" indexes
30-1. Table "version"
30-2. Table "version" indexes
31-1. Table "uri"
31-2. Table "uri" indexes
32-1. Table "userblacklist"
32-2. Table "userblacklist" indexes
32-3. Table "globalblacklist"
32-4. Table "globalblacklist" indexes
33-1. Table "location"
33-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.opensips.org/html/docs/modules/1.9.x/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.opensips.org/html/docs/modules/1.9.x/acc.html

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

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.opensips.org/html/docs/modules/1.9.x/alias_db.html

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

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.opensips.org/html/docs/modules/1.9.x/auth_db.html

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

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.opensips.org/html/docs/modules/1.9.x/avpops.html

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
`ua_idx`	default	uuid, attribute
`uda_idx`	default	username, domain, attribute
`value_idx`	default	value

Chapter 5. B2BUA

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

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

Chapter 6. CacheDB_SQL

cachedb: DB implementation of the CacheDB interface: http://www.opensips.org/html/docs/modules/1.9.x/cachedb_sql.html

Table 6-1. Table "cachedb"

name	type	size	default	null	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

Chapter 7. carrierroute

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
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
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.9.x/carrierroute.html

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.

Chapter 8. Accounting

closeddial: This table is used by the closeddial module to provide closed dial functionality for groups of usernames; This is a functionality similar to a Centrex. More information about the closeddial module can be found at: http://www.opensips.org/html/docs/modules/1.9.x/closeddial.html

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

Chapter 9. Call-processing language

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

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

Chapter 10. Dialog support

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

Table 10-1. Table "dialog"

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

Chapter 11. Matching and translation rules

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.9.x/dialplan.html

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.

Chapter 12. 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.opensips.org/html/docs/modules/1.9.x/dispatcher.html

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

Chapter 13. 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.opensips.org/html/docs/modules/1.9.x/domain.html

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

Chapter 14. Domainpolicy

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

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

Chapter 15. Dynamic Routing

dr_gateways: This table is used by the Dynamic Routing module to store information about the destinations/gateways where to route calls. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.
dr_rules: This table is used by the Dynamic Routing module to store information about the routing rules. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.
dr_carriers: This table is used by the Dynamic Routing module to define carriers (a carrier is defined by a list of gateways and an ordering rule). More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.
dr_groups: This table is used by the Dynamic Routing module to store information about the routing groups (users mapped over groups). More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/drouting.html.

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

Chapter 16. Extensions

Chapter 17. 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.opensips.org/html/docs/modules/1.9.x/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.opensips.org/html/docs/modules/1.9.x/group.html

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

Chapter 18. Instant Message Conference

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

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

Chapter 19. Load Balancer

load_balancer: This table is used by the Load-Balancer module to store information about the destinations the balance the calls between. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/load_balancer.html.

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

Chapter 20. 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.opensips.org/html/docs/modules/1.9.x/msilo.html

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

Chapter 21. 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.opensips.org/html/docs/modules/1.9.x/pdt.html

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

Chapter 22. Permissions

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

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

Chapter 23. Presence

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

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

Chapter 24. Registrant support

registrant: Registrant information for the uac_registrant module. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/uac_registrant.html

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

Chapter 25. 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.opensips.org/html/docs/modules/1.9.x/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

Chapter 26. RLS

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

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

Chapter 27. RTPProxy

rtpproxy_sockets: This table is used by the NAT Helper module to store definitions of socket(s) used to connect to (a set) RTPProxy. More information can be found at: http://www.opensips.org/html/docs/modules/1.9.x/nathelper.html.

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.

Chapter 28. 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.opensips.org/html/docs/modules/1.9.x/siptrace.html.

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
`traced_user_idx`	default	traced_user
`date_idx`	default	time_stamp
`fromip_idx`	default	fromip
`callid_idx`	default	callid

Chapter 29. 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.opensips.org/html/docs/modules/1.9.x/speeddial.html

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

Chapter 30. Version

version

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

Chapter 31. 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.opensips.org/html/docs/modules/1.9.x/uri_db.html

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

Chapter 32. User and global blacklists

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.9.x/userblacklist.html
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.9.x/userblacklist.html

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

Chapter 33. User location

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

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