sr-dev

sr-dev@lists.kamailio.org

15 participants
44240 discussions

git:master: modules_k/drouting: DB schema files for Drouting module

by Raul Alexis Betancor Santana

Module: sip-router Branch: master Commit: 1c1555b1ac761b20314d7411ee9dc7e6f401ca64 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1c1555b… Author: Raul Alexis Betancor Santana <rabs(a)dimension-virtual.com> Committer: Raul Alexis Betancor Santana <rabs(a)dimension-virtual.com> Date: Sun Jan 3 12:41:01 2010 +0000 modules_k/drouting: DB schema files for Drouting module - DB schema files for Drouting module, synced with latest OpenSIPS version --- lib/srdb1/schema/dr_gateways.xml | 84 ++++++++++++++++++++++++++++++++++++ lib/srdb1/schema/dr_groups.xml | 64 +++++++++++++++++++++++++++ lib/srdb1/schema/dr_gw_lists.xml | 47 ++++++++++++++++++++ lib/srdb1/schema/dr_rules.xml | 88 ++++++++++++++++++++++++++++++++++++++ 4 files changed, 283 insertions(+), 0 deletions(-) diff --git a/lib/srdb1/schema/dr_gateways.xml b/lib/srdb1/schema/dr_gateways.xml new file mode 100644 index 0000000..5c81815 --- /dev/null +++ b/lib/srdb1/schema/dr_gateways.xml @@ -0,0 +1,84 @@ +<?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_gateways" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_gateways</name> + <version>3</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>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: &OPENSIPS_MOD_DOC;drouting.html. + </db:para> + </description> + + <column id="gwid"> + <name>gwid</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>GW unique ID - used to link the GW from + the routing rules + </description> + </column> + + <column id="type"> + <name>type</name> + <type>unsigned int</type> + <size>11</size> + <default>0</default> + <description>Type/class of the GW (user defined)</description> + </column> + + <column id="address"> + <name>address</name> + <type>string</type> + <size>128</size> + <description>GW/destination address as name/IP[:port]</description> + </column> + + <column id="strip"> + <name>strip</name> + <type>unsigned int</type> + <size>11</size> + <default>0</default> + <description>Number of digits to be striped out for the begining + of the username when using this GW/destination</description> + </column> + + <column id="pri_prefix"> + <name>pri_prefix</name> + <type>string</type> + <size>16</size> + <null/> + <default><null/></default> + <description>String to prefix the username of RURI when using + this GW/destination</description> + </column> + + <column id="attrs"> + <name>attrs</name> + <type>string</type> + <size>255</size> + <null/> + <default><null/></default> + <description>Generic string describing GW attributes - this string is + to be interpreted from the script</description> + </column> + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Text description of the GW/destination</description> + </column> +</table> diff --git a/lib/srdb1/schema/dr_groups.xml b/lib/srdb1/schema/dr_groups.xml new file mode 100644 index 0000000..03549e0 --- /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 Dynamic Routing module to store + information about the routing groups (users mapped over groups). + More information can be found at: &OPENSIPS_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..e8110e7 --- /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 Dynamic Routing module to define + lists of gateways to be used in rule definitions. + More information can be found at: &OPENSIPS_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>Reference to the GWs/destinations from the list. + </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 new file mode 100644 index 0000000..b87b2fe --- /dev/null +++ b/lib/srdb1/schema/dr_rules.xml @@ -0,0 +1,88 @@ +<?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_rules" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_rules</name> + <version>3</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the Dynamic Routing module to store + information about the routing rules. + More information can be found at: &OPENSIPS_MOD_DOC;drouting.html. + </db:para> + </description> + + <column id="ruleid"> + <name>ruleid</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Rule unique ID + </description> + </column> + + <column id="groupid"> + <name>groupid</name> + <type>string</type> + <size>255</size> + <description>The ID(s) of the routing group(s) this rule is to be + used for - comma separeted list of numerical Ids + </description> + </column> + + <column id="prefix"> + <name>prefix</name> + <type>string</type> + <size>64</size> + <description>Numerical prefix to match this rule</description> + </column> + + <column id="timerec"> + <name>timerec</name> + <type>string</type> + <size>255</size> + <description>Time recurrence used for matching this rule.</description> + </column> + + <column id="priority"> + <name>priority</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>Priority of this rule (among rules with same prefix + and timerec).</description> + </column> + + <column id="routeid"> + <name>routeid</name> + <type>string</type> + <size>255</size> + <description>Route block (from cfg script) to be called when rule + matches.</description> + </column> + + <column id="gwlist"> + <name>gwlist</name> + <type>string</type> + <size>255</size> + <description>Reference to the GWs/destinations to be used when + rule matches.</description> + </column> + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Text description of the rule</description> + </column> + +</table>

15 years

[tracker] Comment added: Module drouting, address routeid as string

by sip-router

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY. The following task has a new comment added: FS#24 - Module drouting, address routeid as string User who did this - Daniel-Constantin Mierla (miconda) ---------- I added in master and kamailio_3.0 the definition of the tables as per README. However, checking a bit the sources, seems that the modules uses a different db tables structures than in documentation. Please add/update the xml files in lib/srdb1/schema/ and then do 'make dbschema' to regenerate the sql scripts. Also, another update I did: when the route id is '0' the module ignores it, since with integer id that was the behavior. Thanks. ---------- More information can be found at the following URL: http://sip-router.org/tracker/index.php?do=details&task_id=24#comment23 You are receiving this message because you have requested it from the Flyspray bugtracking system. If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.

15 years

git:master: Merge branch 'master' of ssh://daniel@git.sip-router.org/ sip-router

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 356aa80ebc749d736dda5e861f85cbfc7aa6b1ec URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=356aa80… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 11:37:49 2010 +0100 Merge branch 'master' of ssh://daniel@git.sip-router.org/sip-router * 'master' of ssh://daniel@git.sip-router.org/sip-router: (159 commits) modules_k/drouting: Merging changes with recent OpenSIPS module modules/privacy: Privacy module, for handling RFC3325 modules/privacy: Privacy module, for handling RFC3325 topoh: updated README topoh: update Replaces header topoh: code to update Refer-to URI topoh: callid prefix can be set via param topoh: add prefix to encoded callid db scheme(k): update lcr tables scripts after index addition in scheme doc: change commit requirements according the discussion on ml core: added id to every field of gw table schema tcp: use the forced socket ip as source tmx: pv_t_copy_msg: copy also the send flags textops(k): msg_apply_changes: preserve the send flags seas: use set_force_socket() rr(k): use set_force_socket() registrar(k): use set_force_socket() pv: use set_force_socket() kex: use set_force_socket() domainpolicy: use set_force_socket() ... ---

15 years

git:master: drouting: lookup route block by name

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 8e298ed9462ccd639d054cd7639278fdd3932ee9 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8e298ed… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 12:38:48 2010 +0100 drouting: lookup route block by name - routes are identified in 3.0 by string name - if name is "0", do not execute the route (this is the main one) for backward compatibility - based on patch by Andrey 'Krieger' Utkin, FS#24 --- modules_k/drouting/dr_load.c | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/modules_k/drouting/dr_load.c b/modules_k/drouting/dr_load.c index a8b6f05..bea5b29 100644 --- a/modules_k/drouting/dr_load.c +++ b/modules_k/drouting/dr_load.c @@ -522,7 +522,7 @@ rt_data_t* dr_load_routing_info( db_func_t *dr_dbf, db1_con_t* db_hdl, continue; } /* lookup for the script route ID */ - if (str_vals[3][0]) { + if (str_vals[3][0] && str_vals[3][0]!='0') { int_vals[3] = route_lookup(&main_rt, str_vals[3]); if (int_vals[3]==-1) { LM_WARN("route <%s> does not exist\n",str_vals[3]);

15 years

git:master: drouting: regenerate readme

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 510489a0fb51f00141d24859bad031af9550b163 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=510489a… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 13:25:51 2010 +0100 drouting: regenerate readme - it was out of sync with docbook sources - use entity for application name and corrected db url (cherry picked from commit 0d88fc527d5ddb90e3d52ca8f369bdcfaab63ed4) --- modules_k/drouting/README | 160 ++++++++++++----------------- modules_k/drouting/doc/drouting_admin.xml | 8 +- 2 files changed, 72 insertions(+), 96 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=510…

15 years

git:master: Merge branch 'sr_3.0' of ssh://daniel@git.sip-router.org/ sip-router

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 3d581a35990ba889337dfbdc844888e4aa1884b3 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3d581a3… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue Oct 13 22:53:06 2009 +0200 Merge branch 'sr_3.0' of ssh://daniel@git.sip-router.org/sip-router * 'sr_3.0' of ssh://daniel@git.sip-router.org/sip-router: makefile: support self-installing utils, extra cfgs a.s.o. core: fix memleak in fixup_free* core: fix cfg_update() on config error 2nd try userblacklist(k): gcc 2.95 compile fixes statistics(k): minor warning in printf fmt siputils(k): gcc 2.95 compile fixes registrar(k): gcc 2.95 compile fixes pua_mi: gcc 2.95 compile fixes cfgutils(k): gcc 2.95 compile fixes lcr: compile & warning fixes for gcc 2.95 db_postgres: compile fixes for gcc 2.95 db_mysql: compile fix for gcc 2.95 compile: don't warn on old gcc versions utils/sercmd: Fixed include paths also in sr_3.0 branch. ---

15 years

git:master: kamctl: added new db table definitions

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: faffb276892843e26ba5aba1454d7c97d833b575 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=faffb27… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 13:31:23 2010 +0100 kamctl: added new db table definitions - sql to create drouting tables for mysql, postgres and oracle (cherry picked from commit 0292a4b5f2cb0564649699c592e51a06edbd91a4) --- utils/kamctl/mysql/drouting-create.sql | 22 ++++++++++++++++ utils/kamctl/oracle/drouting-create.sql | 38 +++++++++++++++++++++++++++++ utils/kamctl/postgres/drouting-create.sql | 22 ++++++++++++++++ 3 files changed, 82 insertions(+), 0 deletions(-) diff --git a/utils/kamctl/mysql/drouting-create.sql b/utils/kamctl/mysql/drouting-create.sql new file mode 100644 index 0000000..9b4388f --- /dev/null +++ b/utils/kamctl/mysql/drouting-create.sql @@ -0,0 +1,22 @@ +INSERT INTO version (table_name, table_version) values ('dr_gateways','1'); +CREATE TABLE dr_gateways ( + gwid INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + type INT(11) UNSIGNED DEFAULT 0 NOT NULL, + address VARCHAR(128) NOT NULL, + strip INT(11) UNSIGNED DEFAULT 0 NOT NULL, + pri_prefix VARCHAR(64) DEFAULT NULL, + description VARCHAR(128) DEFAULT '' NOT NULL +) ENGINE=MyISAM; + +INSERT INTO version (table_name, table_version) values ('dr_rules','1'); +CREATE TABLE dr_rules ( + ruleid INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + groupid VARCHAR(255) NOT NULL, + prefix VARCHAR(64) NOT NULL, + timerec VARCHAR(255) NOT NULL, + priority INT(11) DEFAULT 0 NOT NULL, + routeid VARCHAR(64) NOT NULL, + gwlist VARCHAR(255) NOT NULL, + description VARCHAR(128) DEFAULT '' NOT NULL +) ENGINE=MyISAM; + diff --git a/utils/kamctl/oracle/drouting-create.sql b/utils/kamctl/oracle/drouting-create.sql new file mode 100644 index 0000000..a5dde37 --- /dev/null +++ b/utils/kamctl/oracle/drouting-create.sql @@ -0,0 +1,38 @@ +INSERT INTO version (table_name, table_version) values ('dr_gateways','1'); +CREATE TABLE dr_gateways ( + gwid NUMBER(10) PRIMARY KEY, + type NUMBER(10) DEFAULT 0 NOT NULL, + address VARCHAR2(128), + strip NUMBER(10) DEFAULT 0 NOT NULL, + pri_prefix VARCHAR2(64) DEFAULT NULL, + description VARCHAR2(128) DEFAULT '' +); + +CREATE OR REPLACE TRIGGER dr_gateways_tr +before insert on dr_gateways FOR EACH ROW +BEGIN + auto_id(:NEW.id); +END dr_gateways_tr; +/ +BEGIN map2users('dr_gateways'); END; +/ +INSERT INTO version (table_name, table_version) values ('dr_rules','1'); +CREATE TABLE dr_rules ( + ruleid NUMBER(10) PRIMARY KEY, + groupid VARCHAR2(255), + prefix VARCHAR2(64), + timerec VARCHAR2(255), + priority NUMBER(10) DEFAULT 0 NOT NULL, + routeid VARCHAR2(64), + gwlist VARCHAR2(255), + description VARCHAR2(128) DEFAULT '' +); + +CREATE OR REPLACE TRIGGER dr_rules_tr +before insert on dr_rules FOR EACH ROW +BEGIN + auto_id(:NEW.id); +END dr_rules_tr; +/ +BEGIN map2users('dr_rules'); END; +/ diff --git a/utils/kamctl/postgres/drouting-create.sql b/utils/kamctl/postgres/drouting-create.sql new file mode 100644 index 0000000..4defbfe --- /dev/null +++ b/utils/kamctl/postgres/drouting-create.sql @@ -0,0 +1,22 @@ +INSERT INTO version (table_name, table_version) values ('dr_gateways','1'); +CREATE TABLE dr_gateways ( + gwid SERIAL PRIMARY KEY NOT NULL, + type INTEGER DEFAULT 0 NOT NULL, + address VARCHAR(128) NOT NULL, + strip INTEGER DEFAULT 0 NOT NULL, + pri_prefix VARCHAR(64) DEFAULT NULL, + description VARCHAR(128) DEFAULT '' NOT NULL +); + +INSERT INTO version (table_name, table_version) values ('dr_rules','1'); +CREATE TABLE dr_rules ( + ruleid SERIAL PRIMARY KEY NOT NULL, + groupid VARCHAR(255) NOT NULL, + prefix VARCHAR(64) NOT NULL, + timerec VARCHAR(255) NOT NULL, + priority INTEGER DEFAULT 0 NOT NULL, + routeid VARCHAR(64) NOT NULL, + gwlist VARCHAR(255) NOT NULL, + description VARCHAR(128) DEFAULT '' NOT NULL +); +

15 years

git:master: drouting: adding db table definitions

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: fb2df84aa150d7f0f8b96e7c5035d2b74c9a3fa9 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=fb2df84… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 13:27:57 2010 +0100 drouting: adding db table definitions - built based on readme - needs further updates as the code is ahead of documentation with what tables are used and their structure (cherry picked from commit 53a25f097d127eea7fef3c3c32f7f24421aaad15) --- lib/srdb1/schema/dr_gateways.xml | 71 ++++++++++++++++++++++++++ lib/srdb1/schema/dr_rules.xml | 86 ++++++++++++++++++++++++++++++++ lib/srdb1/schema/kamailio-drouting.xml | 14 +++++ 3 files changed, 171 insertions(+), 0 deletions(-) diff --git a/lib/srdb1/schema/dr_gateways.xml b/lib/srdb1/schema/dr_gateways.xml new file mode 100644 index 0000000..e96773b --- /dev/null +++ b/lib/srdb1/schema/dr_gateways.xml @@ -0,0 +1,71 @@ +<?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_gateways" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_gateways</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the douting module - keeps the + gateways data. + </db:para> + </description> + + <column id="gwid"> + <name>gwid</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Unique ID per gateway + </description> + </column> + + <column id="type"> + <name>type</name> + <type>unsigned int</type> + <size>11</size> + <default>0</default> + <description>Type of gateway</description> + </column> + + <column id="address"> + <name>address</name> + <type>string</type> + <size>128</size> + <description>Address of gateway (hostname or ip and port)</description> + </column> + + <column id="strip"> + <name>strip</name> + <type>unsigned int</type> + <size>11</size> + <default>0</default> + <description>Number of digits to strip from dialed number</description> + </column> + + <column id="pri_prefix"> + <name>pri_prefix</name> + <type>string</type> + <size>64</size> + <null/> + <default><null/></default> + <description>What to prefix to dialed number</description> + </column> + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Short description of gateway</description> + </column> +</table> + diff --git a/lib/srdb1/schema/dr_rules.xml b/lib/srdb1/schema/dr_rules.xml new file mode 100644 index 0000000..213332a --- /dev/null +++ b/lib/srdb1/schema/dr_rules.xml @@ -0,0 +1,86 @@ +<?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_rules" xmlns:db="http://docbook.org/ns/docbook"> + <name>dr_rules</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the drouting module - keeps the + routing rules data. + </db:para> + </description> + + <column id="ruleid"> + <name>ruleid</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Rule unique ID + </description> + </column> + + <column id="groupid"> + <name>groupid</name> + <type>string</type> + <size>255</size> + <description>list of routing group IDs + </description> + </column> + + <column id="prefix"> + <name>prefix</name> + <type>string</type> + <size>64</size> + <description>Destination prefix for this rule</description> + </column> + + <column id="timerec"> + <name>timerec</name> + <type>string</type> + <size>255</size> + <description>Time recurrence for this rule.</description> + </column> + + <column id="priority"> + <name>priority</name> + <type>int</type> + <size>11</size> + <default>0</default> + <description>Priority of the rule.</description> + </column> + + <column id="routeid"> + <name>routeid</name> + <type>string</type> + <size>64</size> + <description>Name of route block (from cfg script) to be + executed when matching this rule.</description> + </column> + + <column id="gwlist"> + <name>gwlist</name> + <type>string</type> + <size>255</size> + <description>The list of destinations (gws) to be used when + matching this rule.</description> + </column> + + <column id="description"> + <name>description</name> + <type>string</type> + <size>128</size> + <default></default> + <description>Short description of the rule</description> + </column> + +</table> + diff --git a/lib/srdb1/schema/kamailio-drouting.xml b/lib/srdb1/schema/kamailio-drouting.xml new file mode 100644 index 0000000..183c87b --- /dev/null +++ b/lib/srdb1/schema/kamailio-drouting.xml @@ -0,0 +1,14 @@ +<?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>DRouting</name> + <xi:include href="dr_gateways.xml"/> + <xi:include href="dr_rules.xml"/> +</database>

15 years

git:kamailio_3.0: drouting: regenerate readme

by Daniel-Constantin Mierla

Module: sip-router Branch: kamailio_3.0 Commit: 0d88fc527d5ddb90e3d52ca8f369bdcfaab63ed4 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=0d88fc5… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 13:25:51 2010 +0100 drouting: regenerate readme - it was out of sync with docbook sources - use entity for application name and corrected db url --- modules_k/drouting/README | 160 ++++++++++++----------------- modules_k/drouting/doc/drouting_admin.xml | 8 +- 2 files changed, 72 insertions(+), 96 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=0d8…

15 years

git:kamailio_3.0: srdb1: version table updated

by Daniel-Constantin Mierla

Module: sip-router Branch: kamailio_3.0 Commit: df46a824d87dfcf839c175c77addda9eed533c03 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=df46a82… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Sun Jan 3 13:29:58 2010 +0100 srdb1: version table updated --- utils/kamctl/db_berkeley/kamailio/version | 4 ++-- utils/kamctl/dbtext/kamailio/version | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index de51b44..cd6c6dc 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 -carrierfailureroute| -carrierfailureroute|2 carrier_name| carrier_name|1 +carrierfailureroute| +carrierfailureroute|2 carrierroute| carrierroute|3 cpl| diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 09afa74..abd03a6 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 -carrierfailureroute:2 carrier_name:1 +carrierfailureroute:2 carrierroute:3 cpl:1 dbaliases:1

15 years

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev