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

[Dave]

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

None because I checked the database for creation of
these tables before using LCR module. And since no
tables were created I did not use LCR.

Could you please update the ser_mysql.sh on onsip.org
in the ser-0.9.3-gettingstarted for everyones benefit?
Thanks,


Dave


--- Juha Heinanen <jh at tutpro.com> wrote:

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



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