| ########################################################################### |
| # $Id: a7f4c3121ded2b6557294de8bcab832c5715d038 $ # |
| # # |
| # schema.sql rlm_sql - FreeRADIUS SQL Module # |
| # # |
| # Database schema for MySQL Cluster. # |
| # The only difference between this file and ../mysql/schema.sql # |
| # is the definition of the storage engine. # |
| # # |
| # 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) 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 acctstoptime (acctstoptime), |
| KEY nasipaddress (nasipaddress) |
| ) ENGINE=ndbcluster; |
| |
| # |
| # 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)) |
| ) ENGINE=ndbcluster; |
| |
| # |
| # 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)) |
| ) ENGINE=ndbcluster; |
| |
| # |
| # 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)) |
| ) ENGINE=ndbcluster; |
| |
| # |
| # 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)) |
| ) ENGINE=ndbcluster; |
| |
| |
| # |
| # 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)) |
| ) ENGINE=ndbcluster; |
| |
| # |
| # 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=ndbcluster; |