[Serusers] LCR Module : How to create the mySQL tables?

[Ricardo Martinez]

In this same topic.
	Is there a default database where to store this tables? o i can
create a database of my own?.
	Thanks!

Ricardo.-

> -----Mensaje original-----
> De: Ricardo Martinez [mailto:rmartinez at redvoiss.net]
> Enviado el: Miércoles, 09 de Marzo de 2005 16:19
> Para: 'serusers at lists.iptel.org'
> Asunto: [Serusers] LCR Module : How to create the mySQL tables?
> 
> 
> Hello List.
> 	I'm trying to use the LCR module submitted by Juha.  I 
> have a basic
> question.  In the README file appears a description of the 
> tables for the
> LCR module.  How can i define this tables in my  mysql 
> database? i mean
> which is the type (VARCHAR?, INT?, etc. )for each column? I 
> only found this
> in the mailing list : 
> 
> #
> # 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_TYPE;
> 
> 
> But how is the format for the lcr and gw_grp tables?
> 
> I appreciate any help,
> 
> Thanks
> 
> Ricardo
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>