###########################################################################
# $Id$ #
# #
-# db_mysql.sql rlm_sql - FreeRADIUS SQL Module #
+# schema.sql rlm_sql - FreeRADIUS SQL Module #
# #
# Database schema for MySQL rlm_sql module #
# #
# To load: #
-# mysql -uroot -prootpass radius < db_mysql.sql #
+# mysql -uroot -prootpass radius < schema.sql #
# #
# Mike Machado <mike@innercite.com> #
###########################################################################
#
CREATE TABLE radacct (
- RadAcctId bigint(21) NOT NULL auto_increment,
- AcctSessionId varchar(32) 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 NOT NULL default '0000-00-00 00:00:00',
- AcctStopTime datetime NOT NULL default '0000-00-00 00:00:00',
- 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 '',
- AcctStartDelay int(12) default NULL,
- AcctStopDelay int(12) default NULL,
- XAscendSessionSvrKey varchar(10) default NULL,
- PRIMARY KEY (RadAcctId),
- KEY UserName (UserName),
- KEY FramedIPAddress (FramedIPAddress),
- KEY AcctSessionId (AcctSessionId),
- KEY AcctUniqueId (AcctUniqueId),
- KEY AcctStartTime (AcctStartTime),
- KEY AcctStopTime (AcctStopTime),
- KEY NASIPAddress (NASIPAddress)
+ 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,
+ acctstoptime datetime NULL 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 '',
+ acctstartdelay int(12) default NULL,
+ acctstopdelay int(12) default NULL,
+ xascendsessionsvrkey varchar(10) default NULL,
+ PRIMARY KEY (radacctid),
+ KEY username (username),
+ KEY framedipaddress (framedipaddress),
+ KEY acctsessionid (acctsessionid),
+ KEY acctsessiontime (acctsessiontime),
+ KEY acctuniqueid (acctuniqueid),
+ KEY acctstarttime (acctstarttime),
+ KEY acctstoptime (acctstoptime),
+ KEY nasipaddress (nasipaddress)
) ;
#
CREATE TABLE radcheck (
id int(11) unsigned NOT NULL auto_increment,
- UserName varchar(64) NOT NULL default '',
- Attribute varchar(32) NOT NULL default '',
+ username varchar(64) NOT NULL default '',
+ attribute varchar(64) NOT NULL default '',
op char(2) NOT NULL DEFAULT '==',
- Value varchar(253) NOT NULL default '',
+ value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
- KEY UserName (UserName(32))
+ KEY username (username(32))
) ;
#
CREATE TABLE radgroupcheck (
id int(11) unsigned NOT NULL auto_increment,
- GroupName varchar(64) NOT NULL default '',
- Attribute varchar(32) NOT NULL default '',
+ groupname varchar(64) NOT NULL default '',
+ attribute varchar(64) NOT NULL default '',
op char(2) NOT NULL DEFAULT '==',
- Value varchar(253) NOT NULL default '',
+ value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
- KEY GroupName (GroupName(32))
+ KEY groupname (groupname(32))
) ;
#
CREATE TABLE radgroupreply (
id int(11) unsigned NOT NULL auto_increment,
- GroupName varchar(64) NOT NULL default '',
- Attribute varchar(32) NOT NULL default '',
+ groupname varchar(64) NOT NULL default '',
+ attribute varchar(64) NOT NULL default '',
op char(2) NOT NULL DEFAULT '=',
- Value varchar(253) NOT NULL default '',
+ value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
- KEY GroupName (GroupName(32))
+ KEY groupname (groupname(32))
) ;
#
CREATE TABLE radreply (
id int(11) unsigned NOT NULL auto_increment,
- UserName varchar(64) NOT NULL default '',
- Attribute varchar(32) NOT NULL default '',
+ username varchar(64) NOT NULL default '',
+ attribute varchar(64) NOT NULL default '',
op char(2) NOT NULL DEFAULT '=',
- Value varchar(253) NOT NULL default '',
+ value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
- KEY UserName (UserName(32))
+ KEY username (username(32))
) ;
#
CREATE TABLE radusergroup (
- UserName varchar(64) NOT NULL default '',
- GroupName varchar(64) NOT NULL default '',
+ username varchar(64) NOT NULL default '',
+ groupname varchar(64) NOT NULL default '',
priority int(11) NOT NULL default '1',
- KEY UserName (UserName(32))
+ KEY username (username(32))
) ;
#
CREATE TABLE radpostauth (
id int(11) NOT NULL auto_increment,
- user varchar(64) NOT NULL default '',
+ username varchar(64) NOT NULL default '',
pass varchar(64) NOT NULL default '',
reply varchar(32) NOT NULL default '',
- date timestamp(14) NOT NULL,
+ authdate timestamp NOT NULL,
PRIMARY KEY (id)
) ;
-
-#
-# 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,
- community varchar(50),
- description varchar(200) DEFAULT 'RADIUS Client',
- PRIMARY KEY (id),
- KEY nasname (nasname)
-);