"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "raddb/mods-config/sql/main/mysql/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: f1ad9afd34fbed766ecbb513927c4f1dd89d9015 $ # # $Id: 41fcccad1c012226d12cc721518fe91e311e55e2 $ #
# # # #
# schema.sql rlm_sql - FreeRADIUS SQL Module # # schema.sql rlm_sql - FreeRADIUS SQL Module #
# # # #
# Database schema for MySQL rlm_sql module # # Database schema for MySQL rlm_sql module #
# # # #
# To load: # # To load: #
# mysql -uroot -prootpass radius < schema.sql # # mysql -uroot -prootpass radius < schema.sql #
# # # #
# Mike Machado <mike@innercite.com> # # Mike Machado <mike@innercite.com> #
########################################################################### ###########################################################################
skipping to change at line 60 skipping to change at line 60
KEY framedipaddress (framedipaddress), KEY framedipaddress (framedipaddress),
KEY framedipv6address (framedipv6address), KEY framedipv6address (framedipv6address),
KEY framedipv6prefix (framedipv6prefix), KEY framedipv6prefix (framedipv6prefix),
KEY framedinterfaceid (framedinterfaceid), KEY framedinterfaceid (framedinterfaceid),
KEY delegatedipv6prefix (delegatedipv6prefix), KEY delegatedipv6prefix (delegatedipv6prefix),
KEY acctsessionid (acctsessionid), KEY acctsessionid (acctsessionid),
KEY acctsessiontime (acctsessiontime), KEY acctsessiontime (acctsessiontime),
KEY acctstarttime (acctstarttime), KEY acctstarttime (acctstarttime),
KEY acctinterval (acctinterval), KEY acctinterval (acctinterval),
KEY acctstoptime (acctstoptime), KEY acctstoptime (acctstoptime),
KEY nasipaddress (nasipaddress) KEY nasipaddress (nasipaddress),
KEY class (class)
) ENGINE = INNODB; ) ENGINE = INNODB;
# #
# Table structure for table 'radcheck' # Table structure for table 'radcheck'
# #
CREATE TABLE IF NOT EXISTS radcheck ( CREATE TABLE IF NOT EXISTS radcheck (
id int(11) unsigned NOT NULL auto_increment, id int(11) unsigned NOT NULL auto_increment,
username varchar(64) NOT NULL default '', username varchar(64) NOT NULL default '',
attribute varchar(64) NOT NULL default '', attribute varchar(64) NOT NULL default '',
skipping to change at line 147 skipping to change at line 148
# if your software is too old: # if your software is too old:
# #
# authdate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIME STAMP # authdate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIME STAMP
# #
CREATE TABLE IF NOT EXISTS radpostauth ( CREATE TABLE IF NOT EXISTS radpostauth (
id int(11) NOT NULL auto_increment, id int(11) NOT NULL auto_increment,
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(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_ TIMESTAMP(6), authdate timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_ TIMESTAMP(6),
class varchar(64) default NULL,
PRIMARY KEY (id), PRIMARY KEY (id),
KEY username (username(32)) KEY username (username),
KEY class (class)
) ENGINE = INNODB; ) ENGINE = INNODB;
# #
# Table structure for table 'nas' # Table structure for table 'nas'
# #
CREATE TABLE IF NOT EXISTS nas ( CREATE TABLE IF NOT EXISTS nas (
id int(10) NOT NULL auto_increment, id int(10) NOT NULL auto_increment,
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',
 End of changes. 4 change blocks. 
3 lines changed or deleted 6 lines changed or added

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