| ########################################################################### |
| # $Id: c5185bee856646733a6bd9b341109cde0688b8f1 $ # |
| # # |
| # schema.sql rlm_sql - FreeRADIUS SQL Module # |
| # # |
| # Database schema for MySQL rlm_sql module # |
| # # |
| # To load: # |
| # mysql -uroot -prootpass radius < schema.sql # |
| # # |
| # Mike Machado <mike@innercite.com> # |
| ########################################################################### |
| # |
| # Table structure for table 'radacct' |
| # |
| |
| CREATE TABLE radacct ( |
| radacctid bigint(21) NOT NULL auto_increment, |
| acctsessionid varchar(64) NOT NULL default '', |
| acctuniqueid varchar(32) NOT NULL default '', |
| username varchar(64) NOT NULL default '', |
| groupname varchar(64) NOT NULL default '', |
| realm varchar(64) default '', |
| nasipaddress varchar(15) NOT NULL default '', |
| nasportid varchar(15) default NULL, |
| nasporttype varchar(32) default NULL, |
| acctstarttime datetime NULL default NULL, |
| acctupdatetime datetime NULL default NULL, |
| acctstoptime datetime NULL default NULL, |
| acctinterval int(12) default NULL, |
| acctsessiontime int(12) unsigned default NULL, |
| acctauthentic varchar(32) default NULL, |
| connectinfo_start varchar(50) default NULL, |
| connectinfo_stop varchar(50) default NULL, |
| acctinputoctets bigint(20) default NULL, |
| acctoutputoctets bigint(20) default NULL, |
| calledstationid varchar(50) NOT NULL default '', |
| callingstationid varchar(50) NOT NULL default '', |
| acctterminatecause varchar(32) NOT NULL default '', |
| servicetype varchar(32) default NULL, |
| framedprotocol varchar(32) default NULL, |
| framedipaddress varchar(15) NOT NULL default '', |
| PRIMARY KEY (radacctid), |
| UNIQUE KEY acctuniqueid (acctuniqueid), |
| KEY username (username), |
| KEY framedipaddress (framedipaddress), |
| KEY acctsessionid (acctsessionid), |
| KEY acctsessiontime (acctsessiontime), |
| KEY acctstarttime (acctstarttime), |
| KEY acctinterval (acctinterval), |
| KEY acctstoptime (acctstoptime), |
| KEY nasipaddress (nasipaddress) |
| ) ENGINE = INNODB; |
| |
| # |
| # Table structure for table 'radcheck' |
| # |
| |
| CREATE TABLE radcheck ( |
| id int(11) unsigned NOT NULL auto_increment, |
| username varchar(64) NOT NULL default '', |
| attribute varchar(64) NOT NULL default '', |
| op char(2) NOT NULL DEFAULT '==', |
| value varchar(253) NOT NULL default '', |
| PRIMARY KEY (id), |
| KEY username (username(32)) |
| ); |
| |
| # |
| # Table structure for table 'radgroupcheck' |
| # |
| |
| CREATE TABLE radgroupcheck ( |
| id int(11) unsigned NOT NULL auto_increment, |
| groupname varchar(64) NOT NULL default '', |
| attribute varchar(64) NOT NULL default '', |
| op char(2) NOT NULL DEFAULT '==', |
| value varchar(253) NOT NULL default '', |
| PRIMARY KEY (id), |
| KEY groupname (groupname(32)) |
| ); |
| |
| # |
| # Table structure for table 'radgroupreply' |
| # |
| |
| CREATE TABLE radgroupreply ( |
| id int(11) unsigned NOT NULL auto_increment, |
| groupname varchar(64) NOT NULL default '', |
| attribute varchar(64) NOT NULL default '', |
| op char(2) NOT NULL DEFAULT '=', |
| value varchar(253) NOT NULL default '', |
| PRIMARY KEY (id), |
| KEY groupname (groupname(32)) |
| ); |
| |
| # |
| # Table structure for table 'radreply' |
| # |
| |
| CREATE TABLE radreply ( |
| id int(11) unsigned NOT NULL auto_increment, |
| username varchar(64) NOT NULL default '', |
| attribute varchar(64) NOT NULL default '', |
| op char(2) NOT NULL DEFAULT '=', |
| value varchar(253) NOT NULL default '', |
| PRIMARY KEY (id), |
| KEY username (username(32)) |
| ); |
| |
| |
| # |
| # Table structure for table 'radusergroup' |
| # |
| |
| CREATE TABLE radusergroup ( |
| username varchar(64) NOT NULL default '', |
| groupname varchar(64) NOT NULL default '', |
| priority int(11) NOT NULL default '1', |
| KEY username (username(32)) |
| ); |
| |
| # |
| # Table structure for table 'radpostauth' |
| # |
| CREATE TABLE radpostauth ( |
| id int(11) NOT NULL auto_increment, |
| username varchar(64) NOT NULL default '', |
| pass varchar(64) NOT NULL default '', |
| reply varchar(32) NOT NULL default '', |
| authdate timestamp NOT NULL, |
| PRIMARY KEY (id) |
| ) ENGINE = INNODB; |
| |
| # |
| # Table structure for table 'nas' |
| # |
| CREATE TABLE nas ( |
| id int(10) NOT NULL auto_increment, |
| nasname varchar(128) NOT NULL, |
| shortname varchar(32), |
| type varchar(30) DEFAULT 'other', |
| ports int(5), |
| secret varchar(60) DEFAULT 'secret' NOT NULL, |
| server varchar(64), |
| community varchar(50), |
| description varchar(200) DEFAULT 'RADIUS Client', |
| PRIMARY KEY (id), |
| KEY nasname (nasname) |
| ); |