On Wed, Feb 10, 2010 at 4:00 PM, Juha Heinanen <jh@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