[Serusers] LCR on onsip.org - No DB tables created?

[Juha Heinanen]

Dave writes:

 > I used exactly that script. But It did not create any
 > LCR related tables.!!! 

ser cvs HEAD has in scripts/ser_mysql.sh:

#
# Table structure for table 'gw'
#

CREATE TABLE gw (
  gw_name VARCHAR(128) NOT NULL,
  ip_addr INT UNSIGNED NOT NULL,
  port SMALLINT UNSIGNED,
  uri_scheme TINYINT UNSIGNED,
  transport TINYINT UNSIGNED,
  grp_id INT UNSIGNED NOT NULL,
  PRIMARY KEY (gw_name),
  KEY (grp_id)
) $TABLE_TYPE;

#
# Table structure for table 'gw_grp'
#

CREATE TABLE gw_grp (
  grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  grp_name VARCHAR(64) NOT NULL
) $TABLE_TYPE;

#
# Table structure for table 'lcr'
#

CREATE TABLE lcr (
  prefix varchar(16) NOT NULL,
  from_uri varchar(128) NOT NULL DEFAULT '%',
  grp_id INT UNSIGNED NOT NULL,
  priority TINYINT UNSIGNED NOT NULL,
  KEY (prefix),
  KEY (from_uri),
  KEY (grp_id)
) $TABLE_TYPE;

if the tables were not created, what error message you got?

-- juha