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

Ricardo Martinez rmartinez at redvoiss.net
Wed Mar 9 21:18:45 CET 2005


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




More information about the sr-users mailing list