Module: sip-router Branch: master Commit: 56802d2851a5574130f4681560306161ff96cf1e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=56802d2… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: Thu Jan 28 15:47:02 2010 +0100 uac(k): added table for remote user registration - xml files to generate db schema for uac module for remote server registrations --- lib/srdb1/schema/kamailio-uac.xml | 12 +++ lib/srdb1/schema/uacreg.xml | 113 +++++++++++++++++++++++++++++ utils/kamctl/db_berkeley/kamailio/version | 6 +- utils/kamctl/dbtext/kamailio/version | 3 +- 4 files changed, 131 insertions(+), 3 deletions(-) diff --git a/lib/srdb1/schema/kamailio-uac.xml b/lib/srdb1/schema/kamailio-uac.xml new file mode 100644 index 0000000..9971ffd --- /dev/null +++ b/lib/srdb1/schema/kamailio-uac.xml @@ -0,0 +1,12 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE database PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" + "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [ + + <!ENTITY % entities SYSTEM "entities.xml"> + %entities; +]> + +<database xmlns:xi="http://www.w3.org/2001/XInclude"> + <name>UAC remote registrations</name> + <xi:include href="uacreg.xml"/> +</database> diff --git a/lib/srdb1/schema/uacreg.xml b/lib/srdb1/schema/uacreg.xml new file mode 100644 index 0000000..7f690b6 --- /dev/null +++ b/lib/srdb1/schema/uacreg.xml @@ -0,0 +1,113 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE table PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" + "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [ + +<!ENTITY % entities SYSTEM "entities.xml"> +%entities; + +]> + +<table id="uacreg" xmlns:db="http://docbook.org/ns/docbook"> + <name>uacreg</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by theuac module to load user details for remote server registration: &KAMAILIO_MOD_DOC;uac.html + </db:para> + </description> + + <column id="id"> + <name>id</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Unique ID</description> + </column> + + <column id="l_uuid"> + <name>l_uuid</name> + <type>string</type> + <size>64</size> + <default/> + <description>Local unique id used to build and match contact addresses.</description> + </column> + + <column id="l_username"> + <name>l_username</name> + <type>string</type> + <size>64</size> + <default/> + <description>Local username</description> + </column> + + <column id="l_domain"> + <name>l_domain</name> + <type>string</type> + <size>128</size> + <default/> + <description>Local domain</description> + </column> + + <column id="r_username"> + <name>r_username</name> + <type>string</type> + <size>64</size> + <default/> + <description>Remote username</description> + </column> + + <column id="r_domain"> + <name>r_domain</name> + <type>string</type> + <size>128</size> + <default/> + <description>Remote domain</description> + </column> + + <column id="realm"> + <name>realm</name> + <type>string</type> + <size>64</size> + <default/> + <description>Remote username</description> + </column> + + <column id="auth_username"> + <name>auth_username</name> + <type>string</type> + <size>64</size> + <default/> + <description>Authentication username</description> + </column> + + <column id="auth_password"> + <name>auth_password</name> + <type>string</type> + <size>64</size> + <default/> + <description>Authentication password</description> + </column> + + <column id="auth_proxy"> + <name>auth_proxy</name> + <type>string</type> + <size>64</size> + <default/> + <description>Outbound proxy SIP address</description> + </column> + + <column id="expires"> + <name>expires</name> + <type>int</type> + <default>0</default> + <description>Expiration time (in seconds, 0 means disabled)</description> + </column> + + <index> + <name>l_uuid_idx</name> + <colref linkend="l_uuid"/> + <unique/> + </index> +</table> diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index 88278aa..539e2ff 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -16,10 +16,10 @@ address| address|3 aliases| aliases|1004 -carrier_name| -carrier_name|1 carrierfailureroute| carrierfailureroute|2 +carrier_name| +carrier_name|1 carrierroute| carrierroute|3 cpl| @@ -88,6 +88,8 @@ subscriber| subscriber|6 trusted| trusted|5 +uacreg| +uacreg|1 uri| uri|1 userblacklist| diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 685386f..788c7c0 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -3,8 +3,8 @@ acc:4 active_watchers:9 address:3 aliases:1004 -carrier_name:1 carrierfailureroute:2 +carrier_name:1 carrierroute:3 cpl:1 dbaliases:1 @@ -39,6 +39,7 @@ sip_trace:2 speed_dial:2 subscriber:6 trusted:5 +uacreg:1 uri:1 userblacklist:1 usr_preferences:2