--- scripts/radius.db.old Thu Jun 15 23:20:48 2000 +++ scripts/radius.db Wed Jan 17 13:05:15 2001 @@ -42,22 +42,23 @@ Realm varchar(30) DEFAULT '', NASIPAddress varchar(15) DEFAULT '' NOT NULL, NASPortId int(12), - NASPortType varchar(32), + NASPortType int(12), AcctStartTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, AcctStopTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, AcctSessionTime int(12), - AcctAuthentic varchar(32), - ConnectInfo varchar(32), + AcctAuthentic int(12), AcctInputOctets int(12), AcctOutputOctets int(12), - CalledStationId varchar(10) DEFAULT '' NOT NULL, - CallingStationId varchar(10) DEFAULT '' NOT NULL, - AcctTerminateCause varchar(32) DEFAULT '' NOT NULL, - ServiceType varchar(32), - FramedProtocol varchar(32), + CiscoDisconnectCause int(12), + ServiceType int(12), + FramedProtocol int(12), FramedIPAddress varchar(15) DEFAULT '' NOT NULL, AcctStartDelay int(12), AcctStopDelay int(12), + CiscoDataRate int(12), + CiscoXmitRate int(12), + CallingStationID varchar(30) DEFAULT '', + CalledStationID varchar(30) DEFAULT '', PRIMARY KEY (RadAcctId), KEY UserName (UserName), KEY FramedIPAddress (FramedIPAddress),