[Serdev] LCR module sql script

[Ricardo Martinez]

Hi.
	You can search in the mailing list.. anyway.. I don't know if the
table structure is the same for the last SER release, but this is what i
have:

#
# Table structure for table 'gw'
#

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

#
# 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 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)
);


Cheers.

Ricardo Javier Martinez Ogalde
VOISS NET S.A.


> -----Mensaje original-----
> De: mike at globalsystek.com [mailto:mike at globalsystek.com]
> Enviado el: Jueves, 13 de Abril de 2006 14:30
> Para: serdev at lists.iptel.org
> Asunto: [Serdev] LCR module sql script
> 
> 
> Group,
> 
> I'm trying to install the LCR module, does anyone have a SQL 
> script or at
> least the fields types and lengths for the various tables?
> 
> I've been looking for this for awhile to test the HA LCR 
> module, I have
> the patch for the SQL to modify the table structure, however 
> I can't find
> the initial table structures.
> 
> Thanks in advance,
> 
> Mike
> mike at globalsystek.com
> 
> _______________________________________________
> Serdev mailing list
> serdev at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serdev
>