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

[Ricardo Martinez]

Hello Dave.
I was almost sure that the tables for LCR were defined there!, my mystake.
But, i have the table definitions (i can't rememeber where i found it).  You
can check with Juha if there is a mistake in the tables.

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


Regards
Ricardo.-

> -----Mensaje original-----
> De: Dave [mailto:ddx66 at yahoo.com]
> Enviado el: Viernes, 29 de Julio de 2005 11:30
> Para: Ricardo Martinez; serusers at lists.iptel.org
> Asunto: RE: [Serusers] LCR on onsip.org - No DB tables created?
> 
> 
> I used exactly that script. But It did not create any
> LCR related tables.!!! 
> 
> 
> --- Ricardo Martinez <rmartinez at redvoiss.net> wrote:
> 
> > Hello Dave.
> > 	If i'm not wrong, there is a shell script included
> > in the last SER
> > version to create all the DB tables related to SER. 
> > I think there is in :
> > /sip_router/scripts/ and is called "ser_mysql.sh"
> > You can try that!.
> > 
> > Regards,
> > Ricardo Martinez
> > 
> > 
> > 
> > > -----Mensaje original-----
> > > De: Dave [mailto:ddx66 at yahoo.com]
> > > Enviado el: Viernes, 29 de Julio de 2005 11:16
> > > Para: serusers at lists.iptel.org
> > > Asunto: [Serusers] LCR on onsip.org - No DB tables
> > created?
> > > 
> > > 
> > > Hi, I downloaded and installed the ser-0.9.3 from
> > > onsip.org with the intention of using LCR.
> > Although,
> > > the LCR module was complied, I do not see the
> > tables
> > > lcr, gw in the DB? How do I create them?
> > > Thanks
> > > 
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around 
> > > http://mail.yahoo.com 
> > > 
> > > _______________________________________________
> > > Serusers mailing list
> > > serusers at lists.iptel.org
> > > http://lists.iptel.org/mailman/listinfo/serusers
> > > 
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>