4 Mar
2015
4 Mar
'15
11:51 a.m.
Module: kamailio
Branch: master
Commit: 0df102bdddab7080fb8be41764561c1e564390cd
URL: https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
Author: jaybeepee <jason.penton(a)gmail.com>
Committer: jaybeepee <jason.penton(a)gmail.com>
Date: 2015-03-04T11:51:47+02:00
utils/kamctl/mysql: added sql creation definition for dialog_ng
---
Added: utils/kamctl/mysql/dialog_ng-create.sql
---
Diff:
https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
Patch:
https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
---
diff --git a/utils/kamctl/mysql/dialog_ng-create.sql
b/utils/kamctl/mysql/dialog_ng-create.sql
new file mode 100644
index 0000000..8a8cbde
--- /dev/null
+++ b/utils/kamctl/mysql/dialog_ng-create.sql
@@ -0,0 +1,52 @@
+INSERT INTO version (table_name, table_version) values ('dialog_in', 7),
('dialog_out', 7), ('dialog_vars', 7);
+
+CREATE TABLE `dialog_in` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `callid` varchar(255) NOT NULL,
+ `from_uri` varchar(128) NOT NULL,
+ `from_tag` varchar(64) NOT NULL,
+ `caller_original_cseq` varchar(20) NOT NULL,
+ `req_uri` varchar(128) NOT NULL,
+ `caller_route_set` varchar(512) DEFAULT NULL,
+ `caller_contact` varchar(128) NOT NULL,
+ `caller_sock` varchar(64) NOT NULL,
+ `state` int(10) unsigned NOT NULL,
+ `start_time` int(10) unsigned NOT NULL,
+ `timeout` int(10) unsigned NOT NULL DEFAULT '0',
+ `sflags` int(10) unsigned NOT NULL DEFAULT '0',
+ `toroute_name` varchar(32) DEFAULT NULL,
+ `toroute_index` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+CREATE TABLE `dialog_out` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(11) NOT NULL,
+ `hash_id` int(11) NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `to_uri` varchar(128) NOT NULL,
+ `to_tag` varchar(64) NOT NULL,
+ `caller_cseq` varchar(20) NOT NULL,
+ `callee_cseq` varchar(20) NOT NULL,
+ `callee_contact` varchar(128) NOT NULL,
+ `callee_route_set` varchar(512) DEFAULT NULL,
+ `callee_sock` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+);
+
+CREATE TABLE `dialog_vars` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `dialog_key` varchar(128) NOT NULL,
+ `dialog_value` varchar(512) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+
+
4 Mar
4 Mar
1:51 p.m.
New subject: git:master:0df102bd: utils/kamctl/mysql: added sql creation definition for dialog_ng
Hello,
were the specs for the table added also as xml definition in
lib/srdb1/schema?
dialog_vars is created by dialog module, another name should be used to
avoid conflicts.
Cheers,
Daniel
On 04/03/15 10:51, jaybeepee wrote:
Module: kamailio
Branch: master
Commit: 0df102bdddab7080fb8be41764561c1e564390cd
URL:
https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
Author: jaybeepee <jason.penton(a)gmail.com>
Committer: jaybeepee <jason.penton(a)gmail.com>
Date: 2015-03-04T11:51:47+02:00
utils/kamctl/mysql: added sql creation definition for dialog_ng
---
Added: utils/kamctl/mysql/dialog_ng-create.sql
---
Diff:
https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
Patch:
https://github.com/kamailio/kamailio/commit/0df102bdddab7080fb8be41764561c1…
---
diff --git a/utils/kamctl/mysql/dialog_ng-create.sql
b/utils/kamctl/mysql/dialog_ng-create.sql
new file mode 100644
index 0000000..8a8cbde
--- /dev/null
+++ b/utils/kamctl/mysql/dialog_ng-create.sql
@@ -0,0 +1,52 @@
+INSERT INTO version (table_name, table_version) values ('dialog_in', 7),
('dialog_out', 7), ('dialog_vars', 7);
+
+CREATE TABLE `dialog_in` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `callid` varchar(255) NOT NULL,
+ `from_uri` varchar(128) NOT NULL,
+ `from_tag` varchar(64) NOT NULL,
+ `caller_original_cseq` varchar(20) NOT NULL,
+ `req_uri` varchar(128) NOT NULL,
+ `caller_route_set` varchar(512) DEFAULT NULL,
+ `caller_contact` varchar(128) NOT NULL,
+ `caller_sock` varchar(64) NOT NULL,
+ `state` int(10) unsigned NOT NULL,
+ `start_time` int(10) unsigned NOT NULL,
+ `timeout` int(10) unsigned NOT NULL DEFAULT '0',
+ `sflags` int(10) unsigned NOT NULL DEFAULT '0',
+ `toroute_name` varchar(32) DEFAULT NULL,
+ `toroute_index` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+CREATE TABLE `dialog_out` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(11) NOT NULL,
+ `hash_id` int(11) NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `to_uri` varchar(128) NOT NULL,
+ `to_tag` varchar(64) NOT NULL,
+ `caller_cseq` varchar(20) NOT NULL,
+ `callee_cseq` varchar(20) NOT NULL,
+ `callee_contact` varchar(128) NOT NULL,
+ `callee_route_set` varchar(512) DEFAULT NULL,
+ `callee_sock` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+);
+
+CREATE TABLE `dialog_vars` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `dialog_key` varchar(128) NOT NULL,
+ `dialog_value` varchar(512) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+
+
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com
2:13 p.m.
New subject: git:master:0df102bd: utils/kamctl/mysql: added sql creation definition for dialog_ng
Hey Daniel,
Ok I will change the table. Re. the XML definition in XML schema - I didn't
even know about it, I will update. Is there perhaps any docs on the
conventions used in building those XMLs, or we just use the others as
examples?
Cheers
Jason
On Wed, 4 Mar 2015 at 13:51 Daniel-Constantin Mierla <miconda(a)gmail.com>
wrote:
Hello,
were the specs for the table added also as xml definition in
lib/srdb1/schema?
dialog_vars is created by dialog module, another name should be used to
avoid conflicts.
Cheers,
Daniel
On 04/03/15 10:51, jaybeepee wrote:
Module: kamailio
Branch: master
Commit: 0df102bdddab7080fb8be41764561c1e564390cd
URL: https://github.com/kamailio/kamailio/commit/
0df102bdddab7080fb8be41764561c1e564390cd
Author: jaybeepee <jason.penton(a)gmail.com>
Committer: jaybeepee <jason.penton(a)gmail.com>
Date: 2015-03-04T11:51:47+02:00
utils/kamctl/mysql: added sql creation definition for dialog_ng
---
Added: utils/kamctl/mysql/dialog_ng-create.sql
---
Diff: https://github.com/kamailio/kamailio/commit/
0df102bdddab7080fb8be41764561c1e564390cd.diff
0df102bdddab7080fb8be41764561c1e564390cd.patch
---
diff --git a/utils/kamctl/mysql/dialog_ng-create.sql
b/utils/kamctl/mysql/dialog_ng-create.sql
new file mode 100644
index 0000000..8a8cbde
--- /dev/null
+++ b/utils/kamctl/mysql/dialog_ng-create.sql
@@ -0,0 +1,52 @@
+INSERT INTO version (table_name, table_version) values ('dialog_in',
7),
('dialog_out', 7), ('dialog_vars', 7);
+
+CREATE TABLE `dialog_in` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `callid` varchar(255) NOT NULL,
+ `from_uri` varchar(128) NOT NULL,
+ `from_tag` varchar(64) NOT NULL,
+ `caller_original_cseq` varchar(20) NOT NULL,
+ `req_uri` varchar(128) NOT NULL,
+ `caller_route_set` varchar(512) DEFAULT NULL,
+ `caller_contact` varchar(128) NOT NULL,
+ `caller_sock` varchar(64) NOT NULL,
+ `state` int(10) unsigned NOT NULL,
+ `start_time` int(10) unsigned NOT NULL,
+ `timeout` int(10) unsigned NOT NULL DEFAULT '0',
+ `sflags` int(10) unsigned NOT NULL DEFAULT '0',
+ `toroute_name` varchar(32) DEFAULT NULL,
+ `toroute_index` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+CREATE TABLE `dialog_out` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(11) NOT NULL,
+ `hash_id` int(11) NOT NULL,
+ `did` varchar(45) NOT NULL,
+ `to_uri` varchar(128) NOT NULL,
+ `to_tag` varchar(64) NOT NULL,
+ `caller_cseq` varchar(20) NOT NULL,
+ `callee_cseq` varchar(20) NOT NULL,
+ `callee_contact` varchar(128) NOT NULL,
+ `callee_route_set` varchar(512) DEFAULT NULL,
+ `callee_sock` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+);
+
+CREATE TABLE `dialog_vars` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `hash_entry` int(10) unsigned NOT NULL,
+ `hash_id` int(10) unsigned NOT NULL,
+ `dialog_key` varchar(128) NOT NULL,
+ `dialog_value` varchar(512) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `hash_idx` (`hash_entry`,`hash_id`)
+);
+
+
+
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, May 27-29, 2015
Berlin, Germany - http://www.kamailioworld.com
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
3555
days inactive
3555
days old
2 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Jason Penton -
jaybeepee