CVS log entries from 03.03.2006 (Fri) 09:00:02 - 04.03.2006 (Sat) 09:00:02 GMT ===================================================== Summary by authors ===================================================== Author: pnixon File: radiusd/doc/examples/postgresql.sql; Revisions: 1.2 File: radiusd/doc/examples/postgresql_update_radacct_group_trigger.sql; Revisions: 1.1 File: radiusd/doc/examples/oracle.sql; Revisions: 1.2 File: radiusd/doc/examples/mysql.sql; Revisions: 1.2 File: radiusd/doc/examples/mssql.sql; Revisions: 1.2 ===================================================== Combined list of identical log entries ===================================================== Description: This schema change and trigger updates fills in the groupname field (which doesnt come in Accounting packets) by querying the usergroup table. This makes it easier to do group summary reports, however note that it does add some extra database load to 50% of your SQL accounting queries. Note: Triggers to databases other than PostgreSQL still need to be written but I have updated all DB schemas for consistency Modified files: File: radiusd/doc/examples/mssql.sql; Revision: 1.2; Date: 2006/03/03 14:40:03; Author: pnixon; Lines: (+3 -0) File: radiusd/doc/examples/mysql.sql; Revision: 1.2; Date: 2006/03/03 14:40:04; Author: pnixon; Lines: (+3 -0) File: radiusd/doc/examples/oracle.sql; Revision: 1.2; Date: 2006/03/03 14:40:04; Author: pnixon; Lines: (+2 -1) File: radiusd/doc/examples/postgresql.sql; Revision: 1.2; Date: 2006/03/03 14:40:04; Author: pnixon; Lines: (+2 -1) File: radiusd/doc/examples/postgresql_update_radacct_group_trigger.sql; Revision: 1.1; Date: 2006/03/03 14:40:04; Author: pnixon; ===================================================== Log entries ===================================================== ===================================================== Summary of modified files ===================================================== File: radiusd/doc/examples/mssql.sql Revisions: 1.2 Authors: pnixon (+3 -0) ------------------------------- File: radiusd/doc/examples/mysql.sql Revisions: 1.2 Authors: pnixon (+3 -0) ------------------------------- File: radiusd/doc/examples/oracle.sql Revisions: 1.2 Authors: pnixon (+2 -1) ------------------------------- File: radiusd/doc/examples/postgresql.sql Revisions: 1.2 Authors: pnixon (+2 -1) ------------------------------- File: radiusd/doc/examples/postgresql_update_radacct_group_trigger.sql Revisions: 1.1 Authors: pnixon -- Automatic cron job from /web/pages/us.freeradius.org/bin/new_makelog.pl