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