"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "raddb/mods-config/sql/main/sqlite/schema.sql" between
freeradius-server-3.0.22.tar.bz2 and freeradius-server-3.0.23.tar.bz2

About: FreeRADIUS Server Project - a high performance and highly configurable RADIUS server.

schema.sql  (freeradius-server-3.0.22.tar.bz2):schema.sql  (freeradius-server-3.0.23.tar.bz2)
----------------------------------------------------------------------------- -----------------------------------------------------------------------------
-- $Id: 9bdaf71f34013de79504b9bf6e090c8cf0e38979 $ --
-- -- -- --
-- schema.sql rlm_sql - FreeRADIUS SQLite Module -- -- schema.sql rlm_sql - FreeRADIUS SQLite Module --
-- -- -- --
-- Database schema for SQLite rlm_sql module -- -- Database schema for SQLite rlm_sql module --
-- -- -- --
----------------------------------------------------------------------------- -----------------------------------------------------------------------------
-- --
-- Table structure for table 'radacct' -- Table structure for table 'radacct'
-- --
skipping to change at line 45 skipping to change at line 45
servicetype varchar(32) default NULL, servicetype varchar(32) default NULL,
framedprotocol varchar(32) default NULL, framedprotocol varchar(32) default NULL,
framedipaddress varchar(15) NOT NULL default '', framedipaddress varchar(15) NOT NULL default '',
framedipv6address varchar(45) NOT NULL default '', framedipv6address varchar(45) NOT NULL default '',
framedipv6prefix varchar(45) NOT NULL default '', framedipv6prefix varchar(45) NOT NULL default '',
framedinterfaceid varchar(44) NOT NULL default '', framedinterfaceid varchar(44) NOT NULL default '',
delegatedipv6prefix varchar(45) NOT NULL default '', delegatedipv6prefix varchar(45) NOT NULL default '',
class varchar(64) default NULL class varchar(64) default NULL
); );
--
-- You might not need all of these indexes. It should be safe to
-- delete indexes you do not use. For example, if you're not using
-- IPv6, you can delete the indexes on IPv6 attributes.
--
-- You MUST however leave the indexes needed by the server, which
-- include username, acctstoptime, nasipaddress, acctstarttime, and
-- acctuniqueid.
--
CREATE UNIQUE INDEX acctuniqueid ON radacct(acctuniqueid); CREATE UNIQUE INDEX acctuniqueid ON radacct(acctuniqueid);
CREATE INDEX username ON radacct(username); CREATE INDEX username ON radacct(username);
CREATE INDEX framedipaddress ON radacct (framedipaddress); CREATE INDEX framedipaddress ON radacct (framedipaddress);
CREATE INDEX framedipv6address ON radacct (framedipv6address); CREATE INDEX framedipv6address ON radacct (framedipv6address);
CREATE INDEX framedipv6prefix ON radacct (framedipv6prefix); CREATE INDEX framedipv6prefix ON radacct (framedipv6prefix);
CREATE INDEX framedinterfaceid ON radacct (framedinterfaceid); CREATE INDEX framedinterfaceid ON radacct (framedinterfaceid);
CREATE INDEX delegatedipv6prefix ON radacct (delegatedipv6prefix); CREATE INDEX delegatedipv6prefix ON radacct (delegatedipv6prefix);
CREATE INDEX acctsessionid ON radacct(acctsessionid); CREATE INDEX acctsessionid ON radacct(acctsessionid);
CREATE INDEX acctsessiontime ON radacct(acctsessiontime); CREATE INDEX acctsessiontime ON radacct(acctsessiontime);
CREATE INDEX acctstarttime ON radacct(acctstarttime); CREATE INDEX acctstarttime ON radacct(acctstarttime);
CREATE INDEX acctinterval ON radacct(acctinterval); CREATE INDEX acctinterval ON radacct(acctinterval);
CREATE INDEX acctstoptime ON radacct(acctstoptime); CREATE INDEX acctstoptime ON radacct(acctstoptime);
CREATE INDEX nasipaddress ON radacct(nasipaddress); CREATE INDEX nasipaddress ON radacct(nasipaddress);
CREATE INDEX class ON radacct(class);
-- --
-- Table structure for table 'radcheck' -- Table structure for table 'radcheck'
-- --
CREATE TABLE IF NOT EXISTS radcheck ( CREATE TABLE IF NOT EXISTS radcheck (
id INTEGER PRIMARY KEY AUTOINCREMENT, id INTEGER PRIMARY KEY AUTOINCREMENT,
username varchar(64) NOT NULL default '', username varchar(64) NOT NULL default '',
attribute varchar(64) NOT NULL default '', attribute varchar(64) NOT NULL default '',
op char(2) NOT NULL DEFAULT '==', op char(2) NOT NULL DEFAULT '==',
value varchar(253) NOT NULL default '' value varchar(253) NOT NULL default ''
skipping to change at line 126 skipping to change at line 136
CREATE INDEX usergroup_username ON radusergroup(username); CREATE INDEX usergroup_username ON radusergroup(username);
-- --
-- Table structure for table 'radpostauth' -- Table structure for table 'radpostauth'
-- --
CREATE TABLE IF NOT EXISTS radpostauth ( CREATE TABLE IF NOT EXISTS radpostauth (
id INTEGER PRIMARY KEY AUTOINCREMENT, id INTEGER PRIMARY KEY AUTOINCREMENT,
username varchar(64) NOT NULL default '', username varchar(64) NOT NULL default '',
pass varchar(64) NOT NULL default '', pass varchar(64) NOT NULL default '',
reply varchar(32) NOT NULL default '', reply varchar(32) NOT NULL default '',
authdate timestamp NOT NULL authdate timestamp NOT NULL,
class varchar(64) default NULL
); );
CREATE INDEX radpostauth_username ON radpostauth(username);
CREATE INDEX radpostauth_class ON radpostauth(class);
-- --
-- Table structure for table 'nas' -- Table structure for table 'nas'
-- --
CREATE TABLE IF NOT EXISTS nas ( CREATE TABLE IF NOT EXISTS nas (
id INTEGER PRIMARY KEY AUTOINCREMENT, id INTEGER PRIMARY KEY AUTOINCREMENT,
nasname varchar(128) NOT NULL, nasname varchar(128) NOT NULL,
shortname varchar(32), shortname varchar(32),
type varchar(30) DEFAULT 'other', type varchar(30) DEFAULT 'other',
ports int(5), ports int(5),
 End of changes. 5 change blocks. 
1 lines changed or deleted 15 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)