[Kamailio-Users] kamctl and lcr table

[Kris Amy]

On Wed, Feb 10, 2010 at 4:00 PM, Juha Heinanen <jh at tutpro.com> wrote:

> Kris Amy writes:
>
>  > Could we get the lcr-create.sql updated to have the ping field?
>
> i just checked and kamailio/branches/1.5/scripts/mysql/lcr-create.sql
> does have ping field:
>
> INSERT INTO version (table_name, table_version) values ('gw','9');
> CREATE TABLE gw (
>    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
>    gw_name VARCHAR(128) NOT NULL,
>    grp_id INT UNSIGNED NOT NULL,
>    ip_addr VARCHAR(15) NOT NULL,
>    hostname VARCHAR(64),
>    port SMALLINT UNSIGNED,
>    uri_scheme TINYINT UNSIGNED,
>    transport TINYINT UNSIGNED,
>    strip TINYINT UNSIGNED,
>    tag VARCHAR(16) DEFAULT NULL,
>    weight INT UNSIGNED,
>    ping TINYINT UNSIGNED DEFAULT 0 NOT NULL,
>    flags INT UNSIGNED DEFAULT 0 NOT NULL,
>    CONSTRAINT gw_name_idx UNIQUE (gw_name)
> ) ENGINE=MyISAM;
>
> -- juha
>

Hi Juha,

Seems not to be in the kam 3.0.0 file.

Cheers
K
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100210/bb2d1fe5/attachment.htm>