DB_MYSQL.SQL

Joel Eddy rjeddy at iowaconnect.com
Wed Jul 11 20:51:14 CEST 2007


For those that need it, like I did you can add this to the end of
http://wiki.freeradius.org/MySQL_DDL_script to get your database
to create the userinfo table also

#
# Table structure for table 'userinfo'
#
CREATE TABLE userinfo (
  id int(10) NOT NULL auto_increment,
  UserName varchar(30),
  Name varchar(200),
  Mail varchar(200),
  Department varchar(200),
  WorkPhone varchar(200),
  HomePhone varchar(200),
  Mobile varchar(200),
  PRIMARY KEY (id),
  KEY UserName (UserName),
  KEY Departmet (Department)
);






More information about the Freeradius-Users mailing list