"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "raddb/mods-config/sql/main/postgresql/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: 28ec0c8df420aac129e40c80caa14895bd8663b6 $ * $Id: 73b059f26bd08eda209ecb2ba1b8d5ccbfdebc09 $
* *
* Postgresql schema for FreeRADIUS * Postgresql schema for FreeRADIUS
* *
* All field lengths need checking as some are still suboptimal. -pnixon 2003-07 -13 * All field lengths need checking as some are still suboptimal. -pnixon 2003-07 -13
* *
*/ */
/* /*
* Table structure for table 'radacct' * Table structure for table 'radacct'
* *
skipping to change at line 68 skipping to change at line 68
-- For use by onoff- -- For use by onoff-
CREATE INDEX radacct_bulk_close ON radacct (NASIPAddress, AcctStartTime) WHERE A cctStopTime IS NULL; CREATE INDEX radacct_bulk_close ON radacct (NASIPAddress, AcctStartTime) WHERE A cctStopTime IS NULL;
-- and for common statistic queries: -- and for common statistic queries:
CREATE INDEX radacct_start_user_idx ON radacct (AcctStartTime, UserName); CREATE INDEX radacct_start_user_idx ON radacct (AcctStartTime, UserName);
-- and, optionally -- and, optionally
-- CREATE INDEX radacct_stop_user_idx ON radacct (acctStopTime, UserName); -- CREATE INDEX radacct_stop_user_idx ON radacct (acctStopTime, UserName);
/* -- and for Class
* There was WAAAY too many indexes previously. This combo index CREATE INDEX radacct_calss_idx ON radacct (Class);
* should take care of the most common searches.
* I have commented out all the old indexes, but left them in case
* someone wants them. I don't recomend anywone use them all at once
* as they will slow down your DB too much.
* - pnixon 2003-07-13
*/
/*
* create index radacct_UserName on radacct (UserName);
* create index radacct_AcctSessionId on radacct (AcctSessionId);
* create index radacct_AcctUniqueId on radacct (AcctUniqueId);
* create index radacct_FramedIPAddress on radacct (FramedIPAddress);
* create index radacct_NASIPAddress on radacct (NASIPAddress);
* create index radacct_AcctStartTime on radacct (AcctStartTime);
* create index radacct_AcctStopTime on radacct (AcctStopTime);
*/
/* /*
* Table structure for table 'radcheck' * Table structure for table 'radcheck'
*/ */
CREATE TABLE IF NOT EXISTS radcheck ( CREATE TABLE IF NOT EXISTS radcheck (
id serial PRIMARY KEY, id serial PRIMARY KEY,
UserName text NOT NULL DEFAULT '', UserName text NOT NULL DEFAULT '',
Attribute text NOT NULL DEFAULT '', Attribute text NOT NULL DEFAULT '',
op VARCHAR(2) NOT NULL DEFAULT '==', op VARCHAR(2) NOT NULL DEFAULT '==',
Value text NOT NULL DEFAULT '' Value text NOT NULL DEFAULT ''
skipping to change at line 169 skipping to change at line 153
-- Table structure for table 'radpostauth' -- Table structure for table 'radpostauth'
-- --
CREATE TABLE IF NOT EXISTS radpostauth ( CREATE TABLE IF NOT EXISTS radpostauth (
id bigserial PRIMARY KEY, id bigserial PRIMARY KEY,
username text NOT NULL, username text NOT NULL,
pass text, pass text,
reply text, reply text,
CalledStationId text, CalledStationId text,
CallingStationId text, CallingStationId text,
authdate timestamp with time zone NOT NULL default now() authdate timestamp with time zone NOT NULL default now(),
Class text
); );
CREATE INDEX radpostauth_username_idx ON radpostauth (username);
CREATE INDEX radpostauth_class_idx 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 serial PRIMARY KEY, id serial PRIMARY KEY,
nasname text NOT NULL, nasname text NOT NULL,
shortname text NOT NULL, shortname text NOT NULL,
type text NOT NULL DEFAULT 'other', type text NOT NULL DEFAULT 'other',
ports integer, ports integer,
 End of changes. 4 change blocks. 
20 lines changed or deleted 7 lines changed or added

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