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

[Dave]

Thanks Ricardo - Do I need to add these to "versions"
table in ser database? If yes, what is the version
number for these tables?
Dave

--- Ricardo Martinez <rmartinez at redvoiss.net> wrote:

> 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 
> > 
> 



		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs