[sr-dev] git:kamailio_3.0: dialog: new column to hold request uri
Daniel-Constantin Mierla
miconda at gmail.com
Sat Dec 19 23:28:19 CET 2009
Module: sip-router
Branch: kamailio_3.0
Commit: 1f64908ea0e6ad14ad6d209ba0eeb7b11c6b1e18
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1f64908ea0e6ad14ad6d209ba0eeb7b11c6b1e18
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: Sat Dec 19 23:02:32 2009 +0100
dialog: new column to hold request uri
- table version set to 4
- regenerated db creation scripts
---
lib/srdb1/schema/dialog.xml | 9 ++++++++-
utils/kamctl/db_berkeley/kamailio/dialog | 4 ++--
utils/kamctl/db_berkeley/kamailio/version | 2 +-
utils/kamctl/dbtext/kamailio/dialog | 2 +-
utils/kamctl/dbtext/kamailio/version | 2 +-
utils/kamctl/mysql/dialog-create.sql | 5 +++--
utils/kamctl/oracle/dialog-create.sql | 5 +++--
utils/kamctl/postgres/dialog-create.sql | 5 +++--
8 files changed, 22 insertions(+), 12 deletions(-)
diff --git a/lib/srdb1/schema/dialog.xml b/lib/srdb1/schema/dialog.xml
index cb0f931..9e69cf7 100644
--- a/lib/srdb1/schema/dialog.xml
+++ b/lib/srdb1/schema/dialog.xml
@@ -9,7 +9,7 @@
<table id="dialog" xmlns:db="http://docbook.org/ns/docbook">
<name>dialog</name>
- <version>3</version>
+ <version>4</version>
<type db="mysql">&MYSQL_TABLE_TYPE;</type>
<description>
<db:para>Persistent dialog information for the dialog module. More
@@ -185,6 +185,13 @@
</description>
</column>
+ <column>
+ <name>req_uri</name>
+ <type>string</type>
+ <size>&uri_len;</size>
+ <description>The URI of initial request in dialog</description>
+ </column>
+
<index>
<name>hash_idx</name>
<colref linkend="hash_entry"/>
diff --git a/utils/kamctl/db_berkeley/kamailio/dialog b/utils/kamctl/db_berkeley/kamailio/dialog
index afce2f1..0a1420c 100644
--- a/utils/kamctl/db_berkeley/kamailio/dialog
+++ b/utils/kamctl/db_berkeley/kamailio/dialog
@@ -1,5 +1,5 @@
METADATA_COLUMNS
-id(int) hash_entry(int) hash_id(int) callid(str) from_uri(str) from_tag(str) to_uri(str) to_tag(str) caller_cseq(str) callee_cseq(str) caller_route_set(str) callee_route_set(str) caller_contact(str) callee_contact(str) caller_sock(str) callee_sock(str) state(int) start_time(int) timeout(int) sflags(int) toroute(int)
+id(int) hash_entry(int) hash_id(int) callid(str) from_uri(str) from_tag(str) to_uri(str) to_tag(str) caller_cseq(str) callee_cseq(str) caller_route_set(str) callee_route_set(str) caller_contact(str) callee_contact(str) caller_sock(str) callee_sock(str) state(int) start_time(int) timeout(int) sflags(int) toroute(int) req_uri(str)
METADATA_KEY
1 2
METADATA_READONLY
@@ -7,4 +7,4 @@ METADATA_READONLY
METADATA_LOGFLAGS
0
METADATA_DEFAULTS
-NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|0|0|0
+NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|0|0|0|NIL
diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index e03028f..de51b44 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -27,7 +27,7 @@ cpl|1
dbaliases|
dbaliases|1
dialog|
-dialog|3
+dialog|4
dialplan|
dialplan|1
dispatcher|
diff --git a/utils/kamctl/dbtext/kamailio/dialog b/utils/kamctl/dbtext/kamailio/dialog
index d6e80be..0b852ca 100644
--- a/utils/kamctl/dbtext/kamailio/dialog
+++ b/utils/kamctl/dbtext/kamailio/dialog
@@ -1 +1 @@
-id(int,auto) hash_entry(int) hash_id(int) callid(string) from_uri(string) from_tag(string) to_uri(string) to_tag(string) caller_cseq(string) callee_cseq(string) caller_route_set(string,null) callee_route_set(string,null) caller_contact(string) callee_contact(string) caller_sock(string) callee_sock(string) state(int) start_time(int) timeout(int) sflags(int) toroute(int)
+id(int,auto) hash_entry(int) hash_id(int) callid(string) from_uri(string) from_tag(string) to_uri(string) to_tag(string) caller_cseq(string) callee_cseq(string) caller_route_set(string,null) callee_route_set(string,null) caller_contact(string) callee_contact(string) caller_sock(string) callee_sock(string) state(int) start_time(int) timeout(int) sflags(int) toroute(int) req_uri(string)
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 5b9b49d..09afa74 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -8,7 +8,7 @@ carrier_name:1
carrierroute:3
cpl:1
dbaliases:1
-dialog:3
+dialog:4
dialplan:1
dispatcher:3
domain:1
diff --git a/utils/kamctl/mysql/dialog-create.sql b/utils/kamctl/mysql/dialog-create.sql
index 1eb934d..b89f3a3 100644
--- a/utils/kamctl/mysql/dialog-create.sql
+++ b/utils/kamctl/mysql/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','3');
+INSERT INTO version (table_name, table_version) values ('dialog','4');
CREATE TABLE dialog (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
hash_entry INT(10) UNSIGNED NOT NULL,
@@ -20,7 +20,8 @@ CREATE TABLE dialog (
start_time INT(10) UNSIGNED NOT NULL,
timeout INT(10) UNSIGNED DEFAULT 0 NOT NULL,
sflags INT(10) UNSIGNED DEFAULT 0 NOT NULL,
- toroute INT(10) UNSIGNED DEFAULT 0 NOT NULL
+ toroute INT(10) UNSIGNED DEFAULT 0 NOT NULL,
+ req_uri VARCHAR(128) NOT NULL
) ENGINE=MyISAM;
CREATE INDEX hash_idx ON dialog (hash_entry, hash_id);
diff --git a/utils/kamctl/oracle/dialog-create.sql b/utils/kamctl/oracle/dialog-create.sql
index 029b26e..4911fa1 100644
--- a/utils/kamctl/oracle/dialog-create.sql
+++ b/utils/kamctl/oracle/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','3');
+INSERT INTO version (table_name, table_version) values ('dialog','4');
CREATE TABLE dialog (
id NUMBER(10) PRIMARY KEY,
hash_entry NUMBER(10),
@@ -20,7 +20,8 @@ CREATE TABLE dialog (
start_time NUMBER(10),
timeout NUMBER(10) DEFAULT 0 NOT NULL,
sflags NUMBER(10) DEFAULT 0 NOT NULL,
- toroute NUMBER(10) DEFAULT 0 NOT NULL
+ toroute NUMBER(10) DEFAULT 0 NOT NULL,
+ req_uri VARCHAR2(128)
);
CREATE OR REPLACE TRIGGER dialog_tr
diff --git a/utils/kamctl/postgres/dialog-create.sql b/utils/kamctl/postgres/dialog-create.sql
index 9486ebd..90faadf 100644
--- a/utils/kamctl/postgres/dialog-create.sql
+++ b/utils/kamctl/postgres/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','3');
+INSERT INTO version (table_name, table_version) values ('dialog','4');
CREATE TABLE dialog (
id SERIAL PRIMARY KEY NOT NULL,
hash_entry INTEGER NOT NULL,
@@ -20,7 +20,8 @@ CREATE TABLE dialog (
start_time INTEGER NOT NULL,
timeout INTEGER DEFAULT 0 NOT NULL,
sflags INTEGER DEFAULT 0 NOT NULL,
- toroute INTEGER DEFAULT 0 NOT NULL
+ toroute INTEGER DEFAULT 0 NOT NULL,
+ req_uri VARCHAR(128) NOT NULL
);
CREATE INDEX dialog_hash_idx ON dialog (hash_entry, hash_id);
More information about the sr-dev
mailing list