====== OpenSER 1.2.x Database Table Structure ======


<code>
Authors of initial tutorial:
  Norman Brandinger
</code>
<hi #eeeeee> **//last updated//**: ~~LASTMOD~~ </hi>

For initial database structure you can also use the script
openser_mysql.sh create
which comes with the package. You can edit the script and modify e.g. database, user, password to your needs.
Usually it's located in /usr/local/sbin after installation of openser (src distribution).

===== Accounting =====

This table is used by the ACC module to report on transactions - accounted calls.

More information is available at: http://www.openser-project.org/docs/modules/1.2.x/acc.html


** Accounting (//acc//) Table **

^ Field ^ Type ^ Attributes ^ Description ^
| id | int(10) | UNSIGNED auto_increment | Unique ID per record |
| method	 | varchar(16) | | A method is the primary function that a request is meant to invoke on a server |
| from_tag | varchar(64) | | 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 | varchar(64) | | 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 | varchar(128) | | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. |
|s ip_code | char(3) | | SIP reply code  |
| sip_reason | varchar(32) | | SIP reply reason |
| time | datetime | | Date / Time this record was written. |

** Accounting (//acc//) Table Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| acc_callid | Index | callid |

===== Active Sessions =====

This table is used by SERWeb. It is not used by OpenSER.
** Active Sessions (//active_sessions// ) Table **

^ Field ^ Type ^ Default ^ Description ^
|sid | varchar(32) | | SERWeb session id | 
|name | varchar(32) |  |
|val | text  | NULL | Serialized value of web session | 
|changed | varchar(14)| | | 

** Active Sessions (//active_sessions//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | name, sid |
| changed | Index | changed |

===== Address =====

This table is used by permissions module. 

** Address (//address//) Table Indexes **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
| id           | bigint(20)  | auto_increment | | |
| grp          | smallint(5) | UNSIGNED | 0 | |
| ip_addr      | varchar(15) | | | |
| mask         | tinyint(4)  | | 32 | |
| port         | smallint(5) | UNSIGNED | 0 | |

** Address (//address//) Table Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |

===== Administrative Privileges  =====

Multi-domain SERWeb Access Control List (ACL). It is not used by OpenSER.

** Administrative Privileges (//admin_privileges//) Table **

It is used for multidomain serweb ACL control
^ Field ^ Type ^ Description ^
|username     | varchar(64)  | Username / Phone Number|
|domain	      | varchar(128) | Domain part of user's SIP URI | 
|priv_name    | varchar(64)  | Privilege name | 
|priv_value   | varchar(64)  | Privilege value |

** Administrative Privileges (//admin_privileges//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, priv_name, priv_value, domain |

===== Aliases =====

This table is similar to the "location" table.

More information is available at: http://www.openser-project.org/docs/modules/1.2.x/registrar.html

** Aliases (//aliases//) Table **
^ Field ^ Type ^ Default ^ Description ^
|username     | varchar(64)      | | Alias Username / Phone Number |
|domain	      | varchar(128)     | | Domain Name |
|contact      | varchar(255)     | | Contact header field value provides a URI whoses meaning depends on the type of request or response it is in.|
|received     | varchar(255)     | NULL | Received IP:PORT in the format SIP:IP:PORT |
|path	      | varchar(255)     | NULL | Path Header(s) per RFC 3327 |
|expires      | datetime         | 2020-05-28 21:32:15 | Date/Time that this entry expires. |
|q            | float(10,2)	 | 1.00 | Value used for preferential routing.|
|callid	      | varchar(255)     | Default-Call-ID | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. |
|cseq	      | int(11)	         | 13 | CSeq header field contains a single decimal sequence number and the request method. |
|last_modified | datetime	 | 1900-01-01 00:00:00 | Date/Time this entry was last changed. |
|flags	      | int(11)	         | | Flags |
|user_agent   | varchar(255)	 | | User-Agent header field contains information about the UAC originating the request. |
|socket	      | varchar(128)	 | NULL | Socket used to connect to OpenSER. For example: UDP:IP:PORT |
|methods      | int(11)	         | NULL | Flags that indicate the SIP Methods this contact will accept.|

** Aliases (//aliases//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, domain, contact |
| aliases_contact | Index | contact |

===== Database Aliases =====
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-project.org/docs/modules/1.2.x/alias_db.html

** Database Aliases (//dbaliases//) Table **

^ Field ^ Type ^ Description ^
|alias_username | varchar(64)    | Alias Username / Phone Number|
|alias_domain	| varchar(128)   | Alias Domain Name|
|username	| varchar(64)    | Username / Phone Number|
|domain	        | varchar(128)	 | Domain Name|

** Database Aliases (//dbaliases//) Indexes**

^ Keyname ^ Type ^ Field ^
| alias_key | Unique | alias_username, alias_domain |
| alias_user | Index | username, domain |

===== Domains =====
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-project.org/docs/modules/1.2.x/domain.html

** Domains (//domain//) Table **
^ Field ^ Type ^ Default ^ Description ^
|domain	      | varchar(128)     | | Domain Name       |
|last_modified| datetime         | 0000-00-00 00:00:00 | Date/Time this record was last modified |

** Domains (//domain//) Indexes**

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | domain |

===== Domain Policy =====

More information about the domainpolicy module can be found at: http://www.openser-project.org/docs/modules/1.2.x/domainpolicy.html

** Domain Policy (//domainpolicy//) Table **
^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id     | int(11) | auto_increment | | Unique ID per record |
|rule   | varchar(255) | | | Domain policy rule name which is equal to the URI as published in the domain policy NAPTRs. |
|type  | varchar(255) | | | 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   | varchar(255)  | | NULL | 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   | varchar(255) | | NULL | It contains the values for AVPs created by dp_can_connect(). Default value is "val". |
|comment | varchar(255) | | NULL | Comments about the rule |

** Domain Policy Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id, rule |
| rule | Unique | rule, att, val |
| rule_idx | Index | rule |

===== Groups =====

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-project.org/docs/modules/1.2.x/group.html

** Groups (//grp//) Table **

^ Field ^ Type ^ Default ^ Description ^
|username     | varchar(64)    |  | Username / Phone Number |
|domain	      | varchar(128)   |  | Domain Name |
|grp	      | varchar(50)    |  | Group Name |
|last_modified| datetime       | 0000-00-00 00:00:00 | Date/Time this record was last modified |

** Groups (//grp//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, domain, grp |

===== Gateways =====
This table contains Least Cost Routing Gateway definitions

More information can be found at: http://www.openser-project.org/docs/modules/1.2.x/lcr.html

** Gateways (//gw//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|gw_name      | varchar(128) | | | Gateway Name |
|grp_id	      | int(10)      | UNSIGNED | | Gateway ID |
|ip_addr      | int(10)      | UNSIGNED | | IP Address of the gateway |
|port	      | smallint(5)  | UNSIGNED | NULL | Port of the gateway |
|uri_scheme   | tinyint(3)   | UNSIGNED | NULL | URI scheme of the gateway |
|transport    | tinyint(3)   | UNSIGNED | NULL | Transport type to be used for the gateway |
|strip	      | tinyint(3)   | UNSIGNED | NULL | The number of digits to strip from the RURI before applying the prefix. |
|prefix	      | varchar(16)  | | NULL | The R-URI(destination) prefix |

** Gateways (//gw//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | gw_name |
| grp_id | Index | grp_id |

===== Gateway Groups =====
This table is used for administrative purposes only to associate names with gateway group ids

More information can be found at: http://www.openser-project.org/docs/modules/1.2.x/lcr.html

** Gateway Groups (//gw_grp//) Table **

^ Field ^ Type ^ Attributes ^ Description ^
|grp_id	      | int(10) | UNSIGNED auto_increment| Group ID |
|grp_name     | varchar(64) |	 | Group Name |

** Gateway Groups (//gw_grp//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | grp_id |

===== Least Cost Routing =====
This table is used by the lcr (Least Cost Routing) rules

More information about the lcr module can be found at: http://www.openser-project.org/docs/modules/1.2.x/lcr.html

** Least Cost Routing (//lcr//) Table **
^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|prefix	      | varchar(16)  |          |      | The Request-URI (destination) prefix |
|from_uri     | varchar(128) |          | NULL | The FROM (source) URI |
|grp_id	      | int(10       | UNSIGNED |      | Group ID |
|priority     | tinyint(3)   | UNSIGNED |      | Priority |

** Least Cost Routing (//lcr//) Indexes **

^ Keyname ^ Type ^ Field ^
| prefix   | Index | prefix   |
| from_uri | Index | from_uri |
| grp_id   | Index | grp_id   |

===== User Locations =====
Persistent user location information

More information can be found at: http://www.openser-project.org/docs/modules/1.2.x/usrloc.html

** User Locations (//location//) Table **
^Field ^ Type ^ Default ^ Description ^
|username     | varchar(64)      | | Username / Phone Number |
|domain	      | varchar(128)	 | | Domain Name |
|contact      | varchar(255)	 | | Contact header field value provides a URI whose meaning depends on the type of request or response it is in |
|received     | varchar(255)	 | NULL | Received IP:PORT in the format SIP:IP:PORT|
|path	      | varchar(255)	 | NULL | Path Header(s) per RFC 3327 |
|expires      | datetime         | 2020-05-28 21:32:15 | Expires header field gives the relative time after which the message (or content) expires |
|q	      | float(10,2)	 | 1.00 | Value used for preferential routing |
|callid	      | varchar(255)	 | Default-Call-ID | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. |
|cseq	      | int(11)	         | 13 | CSeq header field contains a single decimal sequence number and the request method. |
|last_modified| datetime	 | 1900-01-01 00:00:00 | Date/Time this record was last modified|
|flags	      | int(11)	         | 0 | Internal Flags |
|user_agent   | varchar(255)	 |  | User-Agent header field contains information about the UAC originating the request.|
|socket	      | varchar(128)     | NULL | Socket used to connect to OpenSER. For example: UDP:IP:PORT. |
|methods      | int(11)          | NULL | Methods accepted. |

** User Locations (//location//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, domain, contact |

===== Missed Calls =====
acc like table for keeping track of missed calls

**Missed Calls (//missed_calls//) Table**

^ Field ^ Type ^ Attributes ^ Description ^
|id           | int(10)       | UNSIGNED auto_increment | Unique ID per record |
|method	      | varchar(16)	|  | A method is the primary function that a request is meant to invoke on a server. |
|from_tag      | varchar(64)	|  | 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	      | varchar(64)	|  | 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       | varchar(128)    |  | Call-ID header field uniquely identifies a particular invitation or all registrations of a particular client. |
|sip_code     | char(3)         |  | Code of the SIP reply |
|sip_reason   | varchar(32)     |  | Reason phrase of the SIP reply | 
|time	      | datetime	|  | Date / Time this record was written. |

** Missed Calls (//missed_calls//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| acc_callid | Index | callid |

===== Prefix-Domain Translation =====

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-project.org/docs/modules/1.2.x/pdt.html

** Prefix-Domain Translation (//pdt//) Table **

^ Field ^ Type ^ Description ^
|sdomain      | varchar(255)     | Source Domain. |
|prefix       | varchar(32)      | Prefix found in the username part of R-URI. |
|domain       | varchar(255)     | Domain corresponding to (sdomain, prefix) pair where the message must be sent.|


** Prefix-Domain Translation (//pdt//) Table Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | sdomain, prefix |

===== Pending =====
SerWEB - Not used by OpenSER -- should have same structure as table **subscriber**.

Unconfirmed subscription requests

** Pending (//pending//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id           | int(10)       | UNSIGNED auto_increment | | Unique ID per record |
|phplib_id    | varchar(32)   | | | Unique ID |
|username     | varchar(64)   | | | Username / Phone Number |
|domain	      | varchar(128)  | | | Domain Name |
|password     | varchar(25)   | | | Password |
|first_name   | varchar(25)   | | | First Name |
|last_name    | varchar(45)   | | | Last Name |
|phone	      | varchar(15)   | | | Phone Number |
|email_address|	varchar(50)   | | | Email Address |
|datetime_created| datetime   | | 0000-00-00 00:00:00 | Date / Time this record was created |
|datetime_modified| datetime  | | 0000-00-00 00:00:00 | Date / Time this record was last modified |
|confirmation | varchar(64)   | | | |
|flag	      | char(1)       | | o | |
|sendnotification| varchar(50) | | | |	 
|greeting     | varchar(50)   | | | |
|ha1	      | varchar(128)  | | | md5(username:realm:password) |
|ha1b	      | varchar(128)  | | | md5(username@domain:realm:password) |
|allow_find   | char(1)       | | 0 | | 
|timezone     | varchar(128)  | | NULL | |
|rpid	      | varchar(128)  | | NULL | 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.|

** Pending (//pending//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| user_id | Unique | username, domain |
| phplib_id | Unique | phplib_id |
| username_id | Index | username |

===== Phone Book =====
SERWeb - Not used by OpenSER. User's Phonebook

** Phone Book (//phonebook//) Table **

^ Field ^ Type ^ Attributes ^ Description ^
|id	      | int(10)	         | UNSIGNED auto_increment | ID of this record  |
|username     | varchar(64)      | | Username / Phone Number |
|domain	      | varchar(128)	 | | Domain Name |
|fname	      | varchar(32)	 | | First Name  |
|lname	      | varchar(32)	 | | Last Name   |
|sip_uri      | varchar(128)     | | SIP URI associated with this record |

** Phone Book (//phonebook//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |

===== Regular Expression Group =====
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-project.org/docs/modules/1.2.x/group.html

** Regular Expression Group (//re_grp//) Table **

^ Field ^ Type ^ Default ^ Description ^
|reg_exp      | varchar(128)   | 0 | Regular Expression |
|group_id     | int(11)        |   | Group ID           |

** Regular Expression Group (//re_grp//) Indexes **

^ Keyname ^ Type ^ Field ^
| reg_exp | UNIQUE | reg_exp |

===== Server Monitoring =====
SERWeb - Not used by OpenSER

** Server Monitoring (//server_monitoring//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|time	      | datetime    |          | 0000-00-00 00:00:00 | |	 
|id	      | int(10)	    | UNSIGNED |                     | |
|param	      | varchar(32) |          |                     | |	 
|value	      | int(10)	    |          | 0                   | |
|increment    | int(10)     |          | 0                   | |	

** Server Monitoring (//server_monitoring//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id, param |

===== Server Monitoring =====
SERWeb - Not used by OpenSER

** Server Monitoring (//server_monitoring_agg//) Table**
^ Field ^ Type ^ Default ^ Description ^
|param	      | varchar(32)      |   | |	 
|s_value      | int(10)	         | 0 | | 
|s_increment  | int(10)          | 0 | |
|last_aggregated_increment| int(10) | 0 | |	 
|av	      | float  | 0 | |	 
|mv	      | int(10)| 0 | |	 
|ad	      | float  | 0 | | 
|lv	      | int(10)| 0 | |	 
|min_val      | int(10)| 0 | |	 
|max_val      | int(10)| 0 | |	 
|min_inc      | int(10)| 0 | |	 
|max_inc      | int(10)| 0 | |	 
|lastupdate   | datetime | 0000-00-00 00:00:00 | Date/Time this record was last modified. |

** Server Monitoring (//server_monitoring_agg//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | param |

===== SIP Trace =====
This table is used to store incoming/outgoing SIP messages in database. How this can be done you find out reading http://www.openser-project.org/docs/modules/1.2.x/siptrace.html.

** SIP Trace (//sip_trace//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id           | bigint(20)       | auto_increment | | unique auto increment ID per message |
|date         | datetime         | | 0000-00-00 00:00:00 | recording date | 
|callid       | varchar(254)     | | | call id from SIP message |
|traced_user  | varchar(128)     | | | SIP URI of the user being traced |
|msg          | text             | | | full SIP message |
|method       | varchar(50)      | | | SIP method name |
|status       | varchar(254)     | | | SIP reply status |
|fromip       | varchar(50)      | | | source IP address |
|toip         | varchar(50)      | | | destination IP address |
|fromtag      | varchar(64)      | | | From tag |
|direction    | varchar(4)       | | | direction of the SIP message (in, out) |

** SIP Trace (//sip_trace//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| user_idx | Index | traced_user |
| date_id | Index | date |
| ip_idx | Index | fromip |
| call_id | Index | callid |



===== Offline Message Storage =====
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-project.org/docs/modules/1.2.x/msilo.html

** Offline Message Storage (//silo//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|mid	      | int(11)	      | auto_increment | | Unique ID per message |
|src_addr     | varchar(255)  | | | Source address - From URI |
|dst_addr     | varchar(255)  | | | Destination address - To URI |
|username     | varchar(64)   | | | Username / Phone Number of target user |
|domain	      | varchar(128)  | | | SIP domain of target user |
|inc_time     | int(11)       | | 0 | Incoming time |
|exp_time     | int(11)       | | 0 | Expiration time |
|snd_time     | int(11)       | | 0 | Reminder send time |
|ctype	      | varchar(32)   | | text/plain | Content type |
|body	      | blob          | BINARY | | Body of the message |

** Offline Message Storage (//silo//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | mid |
| username | Index | username, domain |

===== 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-project.org/docs/modules/1.2.x/speeddial.html

** Speed Dial (//speed_dial//) Table**

^ Field ^ Type ^ Description ^
|uuid	        | varchar(64)	   | Unique User ID    | 
|username	| varchar(64)	   | Username / Phone Number |
|domain	        | varchar(128)	   | Domain Name |
|sd_username	| varchar(64)	   | Speed Dial Username |
|sd_domain	| varchar(128)	   | Speed Dial Domain |
|new_uri	| varchar(192)	   | New URI |
|fname	        | varchar(128)	   | First Name |
|lname	        | varchar(128)	   |Last Name |
|description	| varchar(64)	   | Description |

** Speed Dial (//speed_dial//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, domain, sd_domain, sd_username |

===== Subscriber =====
This table is used to provide authentication information

More information about the auth_db module can be found at: http://www.openser-project.org/docs/modules/1.2.x/auth_db.html

** Subscriber (//subscriber//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id	         | int(10)	| UNSIGNED auto_increment | | Unique ID per record |
|username	 | varchar(64)	| | | Username / Phone Number |
|domain	         | varchar(128)	| | | Domain Name |
|password	 | varchar(25)	| | | Password |
|first_name	 | varchar(25)  | | | First Name |
|last_name	 | varchar(45)  | | | Last Name |
|email_address	 | varchar(50)  | | | Email Address |
|datetime_created| datetime     | | 0000-00-00 00:00:00 | Date / Time this record was created |
|ha1	         | varchar(128)	| | | md5(username:realm:password)|
|ha1b	         | varchar(128) | | | md5(username@domain:realm:password) |
|timezone	 | varchar(128) | | NULL | user's time zone |
|rpid	         | varchar(128) | | NULL | 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. |
^^^^^--- serweb specific columns ---^^^^^
|phplib_id	 | varchar(32)  | | | Unique ID (used by SERWeb) |
|phone	         | varchar(15)  | | | Phone Number |
|datetime_modified| datetime    | | 0000-00-00 00:00:00 | Date / Time this record was last modified |
|confirmation    | varchar(64)	| | | |
|flag	         | char(1)	| | o | Flags per user |
|sendnotification| varchar(50)	| | | |
|greeting	 | varchar(50)	| | | |
|allow_find	 | char(1)	| | 0 | Flag to allow others to find the SIP address when searching using the name |


** Subscriber (//subscriber//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| user_id | Unique | username, domain |
| phplib_id | Unique | phplib_id |
| username_id | Index | username |

===== 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-project.org/docs/modules/1.2.x/permissions.html

** Trusted (//trusted//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id              | bigint(20)          | auto_increment | | Unique ID per record |
|src_ip	         | varchar(39)         | | | Source address is equal to source address of request |
|proto	         | varchar(4)	       | | | 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	 | varchar(64)         | | NULL | Regular expression matches From URI of request. |
|tag             | varchar(32)         | | NULL | |

** Trusted (//trusted//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| Key1 | Index | src_ip |

===== URI =====

This table is used by uri_db module to implement various SIP URI checks.

A configuration parm: modparam("uri_db", "use_uri_table", 1) means that the (uri) table should be checked instead of the (subscriber) table.

More information about the uri_db module can be found at: http://www.openser-project.org/docs/modules/1.2.x/uri_db.html

** URI (//uri//) Table **

^ Field ^ Type ^ Default ^ Description ^
|username	 | varchar(64)	        | | Username / Phone Number |
|domain	         | varchar(128)	        | | Domain Name |
|uri_user	 | varchar(50)	        | | Username / Phone Number |
|last_modified	 | datetime	        | 0000-00-00 00:00:00 | Date/Time this record was last modified |

** URI (//uri//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | username, domain, uri_user |

===== User 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-project.org/docs/modules/1.2.x/avpops.html

** User Preferences (//usr_preferences//) Table **

^ Field ^ Type ^ Attributes ^ Default ^ Description ^
|id              | bigint(20)         | auto_increment | | Unique ID per record | 
|uuid	         | varchar(64)	      | | | Unique User ID |
|username	 | varchar(100)	      | | 0| Username / Phone Number |
|domain	         | varchar(128)	      | | | Domain Name |
|attribute	 | varchar(32)	      | | | AVP Attribute |
|type	         | int(11)	      | | 0 | AVP Type |
|value	         | varchar(128)	      | | | AVP Value |
|last_modified	 | timestamp(14)      | ON UPDATE CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | Date/Time this record was last modified |

** User Preferences (//usr_preferences//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | id |
| ua_idx | Index | uuid, attribute |
| ida_idx | Index | username, domain, attribute |

===== User Preference Types =====
** User Preference Types (//usr_preferences_types//) Table **

^ Field ^ Type ^ Default ^ Description ^
|att_name	 | varchar(32)          |        | | 
|att_rich_type	 | varchar(32)	        | string | |
|att_raw_type	 | int(11)              | 2      | |
|att_type_spec	 | text	                | NULL   | |
|default_value	 | varchar(100)	        |        | |

** User Preference Types (//usr_preferences_types//) Indexes **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | att_name |

===== Table Versions =====
This table contains OpenSER table names and version numbers. It is used by various OpenSER routines to ensure that the correct version of a particular table is being used.

** Table Versions (//version//) Table **

^ Field ^ Type ^ Default ^ Description ^
|table_name	 | varchar(64)	        | | Table Name |
|table_version	 | smallint(5)	        | 0 |Table Version |

** Table Versions (//version//) Indeses **

^ Keyname ^ Type ^ Field ^
| PRIMARY | Primary | table_name |


===== Database Structure Stuff =====

{{indexmenu>database|js}}