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(a)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@yahoo.com]
Enviado el: Viernes, 29 de Julio de 2005 11:30
Para: Ricardo Martinez; serusers(a)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(a)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@yahoo.com]
> > Enviado el: Viernes, 29 de Julio de 2005 11:16
> > Para: serusers(a)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(a)lists.iptel.org
> >
http://lists.iptel.org/mailman/listinfo/serusers
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
____________________________________________________
Start your day with Yahoo! - make it your home page