[sr-dev] git:kamailio_3.0: drouting: updated db schema from master
Daniel-Constantin Mierla
miconda at gmail.com
Mon Jan 4 14:36:21 CET 2010
Module: sip-router
Branch: kamailio_3.0
Commit: 700fb1a97a5c6c089fce85f547117286644872b5
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=700fb1a97a5c6c089fce85f547117286644872b5
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
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>
More information about the sr-dev
mailing list