Module: sip-router Branch: kamailio_3.0 Commit: 700fb1a97a5c6c089fce85f547117286644872b5 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=700fb1a… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Date: Mon Jan 4 14:32:19 2010 +0100 drouting: updated db schema from master --- lib/srdb1/schema/dr_gateways.xml | 11 +++++- lib/srdb1/schema/dr_groups.xml | 64 ++++++++++++++++++++++++++++++++ lib/srdb1/schema/dr_gw_lists.xml | 47 +++++++++++++++++++++++ lib/srdb1/schema/dr_rules.xml | 2 +- lib/srdb1/schema/kamailio-drouting.xml | 2 + 5 files changed, 124 insertions(+), 2 deletions(-) diff --git a/lib/srdb1/schema/dr_gateways.xml b/lib/srdb1/schema/dr_gateways.xml index e96773b..9763c4b 100644 --- a/lib/srdb1/schema/dr_gateways.xml +++ b/lib/srdb1/schema/dr_gateways.xml @@ -9,7 +9,7 @@ <table id="dr_gateways" xmlns:db="http://docbook.org/ns/docbook"> <name>dr_gateways</name> - <version>1</version> + <version>3</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>This table is used by the douting module - keeps the @@ -60,6 +60,15 @@ <description>What to prefix to dialed number</description> </column> + <column id="attrs"> + <name>attrs</name> + <type>string</type> + <size>255</size> + <null/> + <default><null/></default> + <description>Generic string to be returned in cfg script</description> + </column> + <column id="description"> <name>description</name> <type>string</type> diff --git a/lib/srdb1/schema/dr_groups.xml b/lib/srdb1/schema/dr_groups.xml new file mode 100644 index 0000000..92c2e5c --- /dev/null +++ b/lib/srdb1/schema/dr_groups.xml @@ -0,0 +1,64 @@ +<?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="dr_groups" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_groups</name> + <version>2</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the drouting module to store + information about the routing groups (users mapped over groups). + More information can be found at: &KAMAILIO_MOD_DOC;drouting.html. + </db:para> + </description> + + <column id="gwid"> + <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="username"> + <name>username</name> + <type>string</type> + <size>64</size> + <description>Username part of user</description> + </column> + + <column id="domain"> + <name>domain</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Domain part of user</description> + </column> + + <column id="groupid"> + <name>groupid</name> + <type>unsigned int</type> + <size>11</size> + <default>0</default> + <description>The ID of the routing group the user belongs to. + </description> + </column> + + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Text description of the group/user</description> + </column> + +</table> diff --git a/lib/srdb1/schema/dr_gw_lists.xml b/lib/srdb1/schema/dr_gw_lists.xml new file mode 100644 index 0000000..6375c0d --- /dev/null +++ b/lib/srdb1/schema/dr_gw_lists.xml @@ -0,0 +1,47 @@ +<?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="dr_gw_lists" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_gw_lists</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the drouting module to define + lists of gateways to be used in rule definitions. + More information can be found at: &KAMAILIO_MOD_DOC;drouting.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="gwlist"> + <name>gwlist</name> + <type>string</type> + <size>255</size> + <description>List of GW ids. + </description> + </column> + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Text description of the GW list</description> + </column> + +</table> diff --git a/lib/srdb1/schema/dr_rules.xml b/lib/srdb1/schema/dr_rules.xml index 213332a..a469a77 100644 --- a/lib/srdb1/schema/dr_rules.xml +++ b/lib/srdb1/schema/dr_rules.xml @@ -9,7 +9,7 @@ <table id="dr_rules" xmlns:db="http://docbook.org/ns/docbook"> <name>dr_rules</name> - <version>1</version> + <version>3</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>This table is used by the drouting module - keeps the diff --git a/lib/srdb1/schema/kamailio-drouting.xml b/lib/srdb1/schema/kamailio-drouting.xml index 183c87b..7a95020 100644 --- a/lib/srdb1/schema/kamailio-drouting.xml +++ b/lib/srdb1/schema/kamailio-drouting.xml @@ -11,4 +11,6 @@ <name>DRouting</name> <xi:include href="dr_gateways.xml"/> <xi:include href="dr_rules.xml"/> + <xi:include href="dr_gw_lists.xml"/> + <xi:include href="dr_groups.xml"/> </database>