[sr-dev] git:master:0df102bd: utils/kamctl/mysql: added sql creation definition for dialog_ng

[Jason Penton]

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 at 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 at gmail.com>
> > Committer: jaybeepee <jason.penton at 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
> > Patch: https://github.com/kamailio/kamailio/commit/
> 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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20150304/eef1e5e9/attachment.html>